Access table updating time stamp

I have a table that I will be using with "Collect and Update Data via E-mail" (Infopath option) to ask a population of about 500 employees what class offerings they prefer (they get to select from a list.list appears 5 times to get 5 choices from each employee). Define an empty query in your db and name it "qry General". Dim dbs Current As Database Dim qry_General As Query Def Dim SQL_Str As String, str_DTSamp As String, str_email ID As String Set dbs Current = Current Db Set qry_General = dbs Current. ' *** Update the table str DTSamp = Now() SQL_Str = " UPDATE Table1 SET Date Time Stamp = #" & str_DTSamp & "# " & _ " WHERE email ID = '" & str_email ID & "';" qry_General. in your code, but this should get you started either way.

I am using one table with email ID as PK and it has the five additional fields I need to collect data for. this field gets the date/time of when it was added....

My apologies, I am a bit of a novice in access and I can't seem to find the solution for the below: I have a simple access database for monitoring the number of hours spent on a task.

The difference being that the On Dirty will tag the record when you first started to edit the record; while the Before Update will tag the record just before it gets committed to the database.

Define an empty query in your db and name it "qry General". Dim dbs Current As Database Dim qry_General As Query Def Dim SQL_Str As String, str_DTSamp As String, str_email ID As String Set dbs Current = Current Db Set qry_General = dbs Current. ' *** Update the table str DTSamp = Now() SQL_Str = "UPDATE Table1 SET Date Time Stamp = #" & str_DTSamp & "# " & _ " WHERE email ID = '" & str_email ID & "';" qry_General. in your code, but this should get you started either way. After going through a wizard Access and Outlook and Exchange server communicate and send out the emails. As I get the replies in my inbox the table in the Access database automatically updates But I am not sure how exactly it is automatically updating.

Sometimes people use update and mean inserting new records. And here is some code that shows how to do an inline SQL statement in VBA. Of course you may have more fields, variables, etc. If I new the event that triggers the update in this case I could then do something like OASys1 suggested.VBA. @ Bob-- I am not sure how I could build the event myself. To send out the emails I right click on the table and select "Collect and Update Data via E-mail" (infopath option) 2.

Clearly, I am doing something wrong and would be grateful for your help - only be gentle with me, I'm a newcomer to Access, so please keep your instructions simple.... William - thanks for the reply but I'm afraid it doesn't take me forward.

That's what I did, following articles i already found. It sounds like instead of a single date/timestamp for each row, you want a date/timestamp for each column.

aka OASys1" id="ctl00_m_m_i_ctl00_gr_ctl05_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4603080" /existing records? I posted a reply a couple of days ago but I just noticed it didn't appear. When response come via info path form in Outlook email they automatically update the table. or write a macro that contains what OASys1 included in his sql that you can set to run during the "Collect and Update Data via E-mail" ? The users are selecting their top 5 course preferences.

You must have an account to comment. Please register or login here!