Search results

Is there a way I can tell if a form is in "Create" mode v. "Update" mode"? I want to send an email when a form is being Created, but not when a form is being Updated. Currently I'm sending an email everytime the form is saved...this is nonsense. Any help is appreciated.

I have a form with fields "Assigned To" and "Assigned Date". When "Assigned To" receives a value, i.e. Not=Null, I want to auto-populate the "Assigned Date" field with the current date and time. How can I do this? Any help is appreciated.

I need to mine the Proper Name of the current user and automatically populate a field on a form. I've tried default value = currentname() and all I get returned is Admin. How can I retrieve the Proper Name of the network username and auto populate a field? Any help is appreciated.

I'm new to Access and need some help. I'm trying to duplicate a Lotus Notes view using Access. That is, I want to display multiple records of the database, similar to the datasheet view, but only certain fields of the database and filtered. When the user clicks on the record they want to...