Prev: Hyperlinks to pdfs and word documents are not working
Next: Object dependencies in Access 2007
From: Mike Painter on 5 Mar 2010 14:49
RedHeadedMonster via AccessMonster.com wrote:
> Im afraid Im not understanding what you are saying.
>
> Mike Painter wrote:
>>> I have a login form that will login who is using the database and
>>> the date. It has the following code connected to the onClick event
>>> of an
>> [quoted text clipped - 6 lines]
>>> DoCmd.SetWarnings (0)
>>> DoCmd.RunSQL rosterSQL
>>
>> run msgbox rosterSQL
>> I suspect you will see ' & Me.rosterID &
>>
>> "Insert into tblLOGIN([rosterID], [loginDate]) Values '" &
>> Me.rosterID & "', Now() );"

If I have problems with a SQL statement I put a message box in place of the
actual execution phrase.
Then I can look at it. If instead of
DoCmd.RunSQL rosterSQL
you place
msgbox rosterSQL

You will see your problem.
The last line is a corrected version of what you posted.


First  |  Prev  | 
Pages: 1 2
Prev: Hyperlinks to pdfs and word documents are not working
Next: Object dependencies in Access 2007