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 |
#1
|
|||
|
|||
help
I am SQL DBA and want to design a form that will update the database ona LAN
environment can someone guide me where can i begin and steps basically I want to substitute the INSERT INTO Command through the use of aceess form froma client |
#2
|
|||
|
|||
help
You can do this with an Access update query object or
attach the SQL to the form through AccessVB. Either way, you need to know a little about creating Access forms that execute actions. In the first method, use Access to help you create your query and then add a button to the form that runs that query. In the second method, create a button on the form and select [Event Procedure] in the Properties box after the On Click event. Then create a string that has your SQL command and use the command DoCmd.RunSQL strSQL where strSQL is your string. You may also want to use the command DoCmd.SetWarnings False/True to turn messages on and off. -----Original Message----- I am SQL DBA and want to design a form that will update the database ona LAN environment can someone guide me where can i begin and steps basically I want to substitute the INSERT INTO Command through the use of aceess form froma client . |
Thread Tools | |
Display Modes | |
|
|