Breaking News

Tuesday, June 26, 2012

Ex17: VBA - Delete a parameter/action query using ADOX


Function DeleteProcedureAdox()
'Purpose: Delete a parameter/action query using ADOX.
Dim cat As New ADOX.Catalog
Dim cmd As ADODB.Command
Dim lngCount As Long

'Initialize.
cat.ActiveConnection = CurrentProject.Connection
cat.Procedures.Delete "qryAdoxDeleteBooking"
Set cat = Nothing
End Function

No comments:

Post a Comment

Designed By Published.. Blogger Templates