If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
creating a log file with MS Access
"snipersix" wrote in message
ups.com... where do you place this code INSERT INTO TableName (UserNameField, LoginTimeField) VALUES(CurrentUser, Now()) That's not code. It's the SQL of an APPEND query. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#12
|
|||
|
|||
creating a log file with MS Access
ok thank you very much for your help
Rick Brandt wrote: "snipersix" wrote in message ups.com... where do you place this code INSERT INTO TableName (UserNameField, LoginTimeField) VALUES(CurrentUser, Now()) That's not code. It's the SQL of an APPEND query. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#13
|
|||
|
|||
creating a log file with MS Access
i notice that this code
CurrentDB.Execute "QueryName", dbFailOnError doesnt seem to work. I placed it in the VBA code of my splash screen, it doesnt run the append query automatically. But my append query is working fine if i do it manually. why is that so? Rick Brandt wrote: "snipersix" wrote in message ups.com... where do you place this code INSERT INTO TableName (UserNameField, LoginTimeField) VALUES(CurrentUser, Now()) That's not code. It's the SQL of an APPEND query. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#14
|
|||
|
|||
creating a log file with MS Access
"snipersix" wrote in message
ups.com... i notice that this code CurrentDB.Execute "QueryName", dbFailOnError doesnt seem to work. I placed it in the VBA code of my splash screen, it doesnt run the append query automatically. But my append query is working fine if i do it manually. why is that so? What event did you use? It is not enough to just add code to a module. You need an event handler that runs it. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#15
|
|||
|
|||
creating a log file with MS Access
i used on load and pluged the code in. It gave me an error.
Rick Brandt wrote: "snipersix" wrote in message ups.com... i notice that this code CurrentDB.Execute "QueryName", dbFailOnError doesnt seem to work. I placed it in the VBA code of my splash screen, it doesnt run the append query automatically. But my append query is working fine if i do it manually. why is that so? What event did you use? It is not enough to just add code to a module. You need an event handler that runs it. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#16
|
|||
|
|||
creating a log file with MS Access
"snipersix" wrote in message
oups.com... i used on load and pluged the code in. It gave me an error. And the error was? You did create a separate append query right? You did replace "QueryName" in the code with the actual name of your append query right? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#17
|
|||
|
|||
creating a log file with MS Access
yes i did. But everytime i run the splash screen, which contains the
code, the debugger shows up, highlighting CurrentDB.Execute "QueryName", dbFailOnError It gives a Run-time error '3078' The Microsoft Jet database engine cannot find the input table or query 'QueryName'. Make sure it exists and that its name is spelled correctly. Rick Brandt wrote: "snipersix" wrote in message oups.com... i used on load and pluged the code in. It gave me an error. And the error was? You did create a separate append query right? You did replace "QueryName" in the code with the actual name of your append query right? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#18
|
|||
|
|||
creating a log file with MS Access
"snipersix" wrote in message
oups.com... yes i did. But everytime i run the splash screen, which contains the code, the debugger shows up, highlighting CurrentDB.Execute "QueryName", dbFailOnError It gives a Run-time error '3078' The Microsoft Jet database engine cannot find the input table or query 'QueryName'. Make sure it exists and that its name is spelled correctly. And you are quite sure that the query you made is named "QueryName"? That error means pretty much exactly what it sounds like. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#19
|
|||
|
|||
creating a log file with MS Access
im sorry i made a mistake the error was
Run-time Error '3061' too few parameters. expected1 snipersix wrote: yes i did. But everytime i run the splash screen, which contains the code, the debugger shows up, highlighting CurrentDB.Execute "QueryName", dbFailOnError It gives a Run-time error '3078' The Microsoft Jet database engine cannot find the input table or query 'QueryName'. Make sure it exists and that its name is spelled correctly. Rick Brandt wrote: "snipersix" wrote in message oups.com... i used on load and pluged the code in. It gave me an error. And the error was? You did create a separate append query right? You did replace "QueryName" in the code with the actual name of your append query right? -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#20
|
|||
|
|||
creating a log file with MS Access
"snipersix" wrote in message
oups.com... im sorry i made a mistake the error was Run-time Error '3061' too few parameters. expected1 Post the SQL of your query. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|