P prose7777 New member Local time Today, 23:05 Joined Dec 15, 2003 Messages 9 Dec 17, 2003 #1 I need to run a query from a access vb code. i also need to know the command to open a form . Access 2000
I need to run a query from a access vb code. i also need to know the command to open a form . Access 2000
Cosmos75 Registered User. Local time Today, 17:05 Joined Apr 22, 2002 Messages 1,281 Dec 17, 2003 #2 DoCmd.OpenForm "FormName" DoCmd.OpenQuery "QueryName"
RayH Registered User. Local time Today, 15:05 Joined Jun 24, 2003 Messages 132 Dec 17, 2003 #3 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
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