NOW() Function not updating into table

**joycesolomon** · 08-13-2014, 02:59 PM

Hi all,

Can you please help. The below is not working.

The Now() function is not passing the timestamp back to the table

HEre is the code...

Code:

 DoCmd.RunSQL "UPDATE [Approve_Close]" _
                    & "SET [PR-PL] = '" & Me.PRPL & "' ,[PR-PL_DATE] =  Now()" _
                    & "Where [Project Number] = '" & Me.Project_Number & "';"

**pbaldy** · 08-13-2014, 03:08 PM

You have a problem with spaces that may be the problem. See if this helps:

http://www.baldyweb.com/ImmediateWindow.htm

**joycesolomon** · 08-13-2014, 03:19 PM

It says

Expression --->PR-PL_DATE
Value ---> <Expression not defined in context>

Type ---> Empty

**pbaldy** · 08-13-2014, 03:21 PM

Did you fix the spaces and test? What is the finished SQL?

**joycesolomon** · 08-13-2014, 03:30 PM

there was no space issue, this was the result of the finished SQL

**pbaldy** · 08-13-2014, 03:35 PM

Okay, sorry to have wasted your time.

**joycesolomon** · 08-13-2014, 03:43 PM

no , not at all.

Maybe you can give me a better idea and resolution.

I need to be able to update PR_PL_DATE field at table with current timestamp and [Project Status] field with the word 'review' when the button is clicked

How do i write the sql? the table has other fields that has value that will not be changing.

**pbaldy** · 08-13-2014, 06:17 PM

Did you try the debugging technique to see how the SQL you're building ends up? If so, what is that SQL? If not, why not?

NOW() Function not updating into table

Thread Tools

NOW() Function not updating into table

Similar Threads

Updating a field after updating another field - function name not found

Updating data in table B based off table A - Duplicates

Updating main table from temp table AND form value

Updating the field in the master table depending on changes in a weekly table

Help with Update query: updating one table based on data selected from another table?

Posting Permissions