Prev: how to get address of source of copy (range with marquee a.k.a. "marching ants")
Next: No print settings in Excel HTML files
From: Bre-x on 1 Feb 2010 13:35
Hi,
On MS Excell using VBA, I would like to send a sql command to and MS Access
database

"delete * from mytable where id=89"

Thank you all!!!!


From: goshute on 1 Feb 2010 15:09
Try This:

Create two objects in Access.
1. A Query that deletes the records from the table.
2. A Macro that runs the query.

In Excel VBA Editor:
1. add a reference to your version of Access.
2. Inset this code that will start a new instance of Access and run
the macro

Sub RunAccessQuery()
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess.Visible = True
appAccess.DoCmd.SetWarnings False
appAccess.OpenAccessProject ("C:\Test.mdb")
appAccess.DoCmd.RunMacro ("MacroToDeleteRecordsWith89")
appAccess.DoCmd.SetWarnings True
appAccess.Quit
Set appAccess = Nothing
End Sub

I did not test code, so be sure to test on a test application.

Goshute
From: Bre-x on 1 Feb 2010 15:28
Thank you!!


 | 
Pages: 1
Prev: how to get address of source of copy (range with marquee a.k.a. "marching ants")
Next: No print settings in Excel HTML files