I am trying to insert a time stamp of when a form was last updated. I added a DateModified field to my table and added that field to my form. Here is a copy of my code
Private Sub DateModified_BeforeUpdate(Cancel As Integer)
On Error GoTo BeforeUpdate_Err
'set bound controls to...
Guys you were right. It was difinitly more appropriate to use a Dlookup in this situation.
I am posting the code I used to do this because while it works great for some reason when i use the dropdown menu to chose the ID number for the manager the Name and Phone Number Fields do not update...
Is there a way to have a combo box that has two fields in it save to two seprate fields in a table
For example my combo box will have the name of a manager and the managers phone number. Is there a way to save the name to the manger name field in my table and the phone number to managers phone...
I have an excell spreadsheet with member names
the member names are duplicated up to 6 times each depending on how many months from october - march they have been members.
The excellspreadsheet looks like this
Member name Member number October care level November care...
I Need to run a query that will not show duplicate records.
For example if joe smith is listed five times i only want the most recent date of membership.
Does anyone have any ideas?
I Have a combo box i want to list a name in one column and a number in the other
I want the number to transfer from the combo box to another field that i figured out fine. but how do i get the first column with the name to save to a certain table?
thank you for the help
When I open up my database i get a securoty warning that says
opening"filr name"
this file may not be safe if it contains code that was intended to harm your computer. would you like to continue?
Is there anyway of getting rid of that warning. It's not a huge deal but its one extra step at...