VB question

prose7777

New member
Local time
Today, 14:20
Joined
Dec 15, 2003
Messages
9
I need to run a query from a access vb code.
i also need to know the command to open a form .

Access 2000
 
DoCmd.OpenForm "FormName"

DoCmd.OpenQuery "QueryName"
 
DoCmd.RunSQL "UPDATE Employees " & _
"SET Employees.Title = 'Regional Sales Manager' " & _
"WHERE Employees.Title = 'Sales Manager';"

DoCmd.OpenForm "Employees", , , "LastName = 'King'"

Both of these examples are taken from Access Help. Its the first place I'd look ;)
 

Users who are viewing this thread

Back
Top Bottom