Search results

Still no luck, lagbolt. I used your code example as suggested, but received "#Name?" in the RequesterName field on the form.

One more thing. Now I have a ProjectStatus combo box with several entries (UnAssigned, Assigned, InProcess, etc.) that I want to set to "Assigned" when I assign the project. Using your code above, I added: Me.ProjectStatus = "Assigned" ...this does not work. Do I need to use the zero...

Thanks, Pat, you've been a big help.

I need a little more help with the syntax. I tried =currentuser(environ("UserName")) with no success. I tried =environ("UserName") with no success. I am adding this code to the Default Value property of a field on a form. Should I be handling this another way? This seems like a very simple...

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.

Thanks, works like a charm. Is there a way to add a button to the datasheet view to close the form and return to the switchboard? I tried adding this to the form header but can't seem to get it to display.

Oliver, What would the code look like if you wanted to display the selected detail record on a separate form. I am trying to accomplish the same thing, but using a separate main form for the list box and a separate main form to display the detail. I need my list box to be filtered, as I will...

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...