insanewillem
Computer
Hi,
I made an VBA app. so I can extract data from a access table through SQL.
But I need to read the tables from the database, but I don't really know the command for this...
can anybody help me?
AND...
If I do something like this:
query = "Select name from tablename where LIKE 'test*'"
Set MyRS = MyDB.OpenRecordset(query)
FormSelect.ListBoxMatches.AddItem MyRS.Fields(0)
And the RS = empty I get a Error message...
Is it possible to catch it an just clear the listbox?
I made an VBA app. so I can extract data from a access table through SQL.
But I need to read the tables from the database, but I don't really know the command for this...
can anybody help me?
AND...
If I do something like this:
query = "Select name from tablename where LIKE 'test*'"
Set MyRS = MyDB.OpenRecordset(query)
FormSelect.ListBoxMatches.AddItem MyRS.Fields(0)
And the RS = empty I get a Error message...
Is it possible to catch it an just clear the listbox?