Re: How to enter a processing date into a Form

From: Dirk Goldgar (dg_at_NOdataSPAMgnostics.com)
Date: 07/17/04 

Date: Sat, 17 Jul 2004 00:21:16 -0400

<anonymous@discussions.microsoft.com> wrote in message
news:2e85701c46ba8$162333a0$a401280a@phx.gbl
> Your assumption was correct. I added your code but the
> message box does't open. Why???

I can only think of three reasons. Either txtProcessingDate is not
Null -- does it have a default value? -- or the form's BeforeUpdate
event didn't fire at all -- did you modify a bound control on the form,
so that the record needed to be saved? -- or there's an error in the
code such that it didn't even compile -- did you create the field
"DateProcessed" and the control "txtProcessingDate" as I described them?
If you click Debug -> Compile, do you get any errors?

You could set a breakpoint at the top of the event procedure, trigger it
by modifying and saving a record, and step through the code examining
values and observing the path it takes. That might tell you something
about why you're not getting the message box when you expect to. 

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

Relevant Pages

  • Re: Event Procedures Stopped Working
    ... Open a code window, ... If that still does not solve the problem, the database is partially corrupt. ... Compile the application. ... Now every>> time I do something which will start an event procedure I get this message:>> "Procedure declaration does not match description of event or procedure ...
    (microsoft.public.access.formscoding)
  • Re: Does Not Support...
    ... only a remark as a placeholder...same error message. ... the property can not contain VBA code as your post seems to ... When you select [Event Procedure] for the property, ... - Compile menu option to compile your code and check for ...
    (microsoft.public.access.formscoding)
  • Re: A Field To Record Exactly When A Record Was Updated
    ... Do you have a field in your table named "timestamp"? ... I've just tried to modify the event procedure and it ... >used in several forms in the same database. ...
    (microsoft.public.access.formscoding)
  • Re: Whats the position of pointers
    ... couldn't have made if you'd bothered to compile your code before ... It's not possible for the value of a to become 20 unless you modify ... problems which cann;t be solved without using the pointers. ... can be a solution without using call by reference here. ...
    (comp.lang.c)
  • Re: What do most people compile pac-man code with?
    ... problem is jump tables embedded in the code. ... and after that you could modify to your heats content. ... I also set up batch files so that it will compile and place the object file ... in the right area for MAME and run MAME in debug mode. ...
    (rec.games.video.arcade.collecting)