Please Help!!

[amin]

Hi All,
I am relatively very new to the Access environment. What I am trying is I am accessing a number through a barcode reader and then want to display details of that corresponding number in a form .

In the form which has opened , I want to have a tick box option and after editing the record when I click on to the command button update I want to hve auto date stamp to occur in my table.

I am confused thinking should i go for a simplified design , or I Hve to go for event driven programming. Using barcode reader, all I want is that after I update the record with a auto datestamp ,I want the application to start again so that I can scan a new number.

Thanks Heaps,
Amin

 

[SQL_Hell]

Is this time stamp to occur when you are entering new records or updating records.

 

[The_Doc_Man]

In the OnClick event of your chosen action marker (check box, command button, etc.) you can do a DoCmd to save the current form, then clear it through code and initialize your device and other variables again, I think.

 

[amin]

Time stamp

The time stamp should be entered each time only when the record is updated.

Thanks
Amin

 

[Crilen007]

Make a "DateMod" field on your table. Format it as "Date/Time" and default it for todays date.



on the on click event of your checkbox, or the afterupdate of the text box (whatever you are using)

tell it to put todays date into that field, and then set focus back to your search box or whatever you use.