Re: OpenForm Action

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: McBride (McBride_at_discussions.microsoft.com)
Date: 11/05/04 

Date: Fri, 5 Nov 2004 06:24:01 -0800

The dates in the sample are the actual dates where I begin to experience
problems. One other thing I should mention, This form also feeds off another
database where the actual data is entered. All the data entered in the main
database are numbers.

"Dirk Goldgar" wrote:

> "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: When typing stops, record saves automatically
    ... >> record to the database and clears the form for the next entry. ... > this control? ... Is there a Timer event firing ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.formscoding)
  • Re: I get the error msg: Error accessing File. Network Connection
    ... I make my database and work ... this KB article describes a nasty bug that may have bitten you: ... > Office 2000 SP3 fixes the bug, but that won't repair your corrupted ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Need Help Understanding This
    ... If so, please compact it and zip it to reduce the download time, and send it to the address derived by removing NO SPAM and ".invalid" from the reply address of this message. ... Do *not* post my real address in the newsgroup -- I don't want to be buried in spam and viruses. ... Upon examination of the database, it turns out that the problem was that the subform's Data Entry property was set to Yes, preventing it from showing any existing records. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: VBA - Form Progress
    ... loops. ... standard basic code along with database code. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Problem with database path (Folder Name contains a Space)
    ... I am having trouble with starting a database of which the path is ... permission to change the name of the folder on the network. ... option that Microsoft Office Access doesn't recognize. ... Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)