I have a query to delete a tbl, an query to create a new table and a append
query that I currently run manually.
Is is possible to run these in sequential order on the click of a command
button?

Please can someone let me have some example code for querying an Access
database via a VB script.
I would like to be able to return a count of rows in a table in an Access
database via a VB script.

Please help!
I have been trying to get the 2 tables to combine into one by a query. Here
are sample of my table1 and table2.
Table1

I have a calculated field in a query say Qry1 based on a linked table say Tbl1:
Month: Format([submit_date],"mmmm") & " " & Format([submit_date],"yyyy")
whose output is like: September 2005. submit_date is a date/time type field
in Tbl1. I am writing another query say Qry2 based on ...

Can there ever be a difference between results produced by <> and those
produced by not whenever they can be used in the same place in a query

i would like to be able to write a make table query which should build 10
different tables.  i have tried to do this all in one make table query but
it gives an error after the first make table query.  the sql view ends the
first query with a ;  after that the query doesnt ...

I have three queries that specify people who will receive a personalized
fundraiser letter. Is there an easy way to ask a query (generated for those
to receive a general newsletter) NOT to include these people?

I need to pull random records (non-inclusive membership numbers) from a query.
What criteria do I need in the query so that I can run the query from a form
that allows me to get records for example:  memnumbers 1121,1243,1344,2172
etc?

Please help with a query that will provide a list of delinquent entries.  
I have an “INDICATOR” table with a field named “Indicator#” and a “DETAIL
RECORDS” table that also has a field with the “Indicator#” and a field named
“DateOfData” – along with many other fields.  I need a ...

Lemme know if I am going at this the wrong way!
I have a field [extcost] that I want a running sum created from. The query
is sorted by [extcost] descending. (A report will do this, but I need
running sum info in a query.) I need to find which items make up the top 80%

I apologize if this type of question has been posted before, but I had
difficulty finding it in the threads.
My database has a tblAddr in which county information is stored using
CountyID using a lookup from tblAddrCounty. I would like to update this table

I am developing a small CMMS database. I have a table named PM SCHEDUAL, it
has one field for Equipment ID and 52 fields for work weeks i.e. (WW01,WW02,
WW03ect.). Under each work week field I have listed the inspection type for
that week on each unit. I am trying to create a single ...

I need a help on my query.  I tried to concatenate the records which have
the same ID.  The following is the data in my table (Table1):
ID        Value
1        a

Hi.  I'm frustrated!  I can't figure out why this won't work.  Must be user
error!  Here's the setup: both Contacts and SignificantOthers (these spouses
are themselves Contacts, hence the self join) can earn, use and lose bucks.
Ultimately, I'm trying to calculate how many bucks ...

I am trying to run a query that will choose specific info based on a criteria
I have on one field. The field is "PhoneType" and the selection criteria is
currently "Home" for home phone number. How do I list everyone that has
either a Home, Work, or Other phone type? If I word is ...