Re: OpenForm Action

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 11/05/04 

Date: Thu, 4 Nov 2004 23:06:37 -0500

"McBride" <McBride@discussions.microsoft.com> wrote in message
news:48A999AA-2DF4-44F4-8342-1FD81B54C144@microsoft.com
> I am using an Access Database that I did not create. Up to a certain
> point, I can put in from date and to date and get combined
> information. My delimma is, now, all of a sudden I put in a date
> range, lets say 10/1/04 to 10/11/04 and I get a message that says
> "The OpenForm Action was Canceled". It works in September, and even
> in November for the first two days. Why am I getting this message
> for October. If I enter a date range of 10/1 to 10/9 it works. It
> appears that whatever happened, happened on the 10th. It will not
> let me put the date range higher than 10/10/04. HELP ME!!!
>
> I should let you know that I am an intermediate user of Access. Have
> not taken any classes higher than this. But I am familiar with VBAs
> and how they work.

Tina's advice on how to track this down is good, one additional thought
occurs to me. Are the dates you gave as examples above the actual dates
that are involved in this problem? If not, please post the exact dates
that provoke the transition from "working" to "not working". Could it
be that you start having problems when you enter a date where the day of
the month is greater than 12? 

-- 
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)

Relevant Pages

  • Re: Database Listing and Sorting
    ... I am a rookie and just filling in) ... > I was wondering if someone could give some quick advice on how to modify the ... > This is coming from an Access database using ODBC so the 'GetRecord' ... > shorten the display. ...
    (microsoft.public.vc.database)
  • Re: Change Log On account in MS FW service - error 11004
    ... > These are W3C format on local drive, would like to configure it to SQL DB. ... > Please advice. ... Thx. ... Or in Access database? ...
    (microsoft.public.isa.configuration)
  • Re: How to secure an Access database.
    ... To learn how to secure an Access database, check out the Access Security FAQ ... My advice is to read the entire document thoroughly several times, ...
    (microsoft.public.vb.database.ado)
  • decimal places of numeric value from data base
    ... when RS is a recordset from an Access database and the column in question ... Any advice would be highly appreciated. ... Prev by Date: ...
    (microsoft.public.scripting.vbscript)
  • OpenForm Action
    ... I am using an Access Database that I did not create. ... put the date range higher than 10/10/04. ... taken any classes higher than this. ... But I am familiar with VBAs and how they ...
    (microsoft.public.access.formscoding)