Group:
I need to write a sub to delete all of the queries in the current database.
I am hoping that someone can steer me in the right direction. I know that
the statement to delete a query is db.QueryDefs.Delete (QueryName). But how

I have not been able to figure out the correct VBA code to hide or unhide a
table.  I would appreciate a little help here.
Thanks.

I have a main form combo box that I would like to set the After Update event
to change all the records in the subform to match this value.
Dim rst As Object
Set rst = WHAT DO I TYPE HERE???

I have a problem using the forms collection in vb.
I have statement like this
myvalue = Forms(str1).Controls(str2).Value
where str1 is a formname of a loaded form and str2 is the name of a control

Does anyone have any VBA code they could share that opens a document - with
the correct program based on extension - like Windows does?  i.e., open a
.DOC with MS Word, open a .pdf with Acrobat, etc.
Thanks, Stuart

Help!
(I am using Access 2003.)
I am having problems passing a 2-dimensional array to a subroutine. The
array is "redimed", as the number of elements is not known. The array fills

I am trying to build a UNION query. It consists of 4 SELECT statements. If I
try everyone apart or I use any combination of 2 out of 4 SELECT statements,
they work. The problem is that when I use more than 2 SELECTstatements I get
the following message:

I'm attempting to have a Word document print out duplexed (double-sided) but
I'm not having much luck.  I have a function that creates a reference to a
file using GetObject(fileName) command then uses the .PrintOut command to
print the document, but the command does not offer ...

Hi I'm using MS Access 97. I have a continous form to give a progress
summary. An item can have many parts and therefore has 10 checkboxes
which can represent on time, late or very late. The checkboxes table
contains all the checkboxes related to an item and is linked to the

I'm looking to deploy an MDB which contains queries and reports to my clients
users. The queries are setup to use linked tables on an SQL 2005 Server
database and I also use passthrough queries to execute stored procedures.
Since I can't be sure they all have the same DSN setup ...

First, sorry for a lengthy post - am trying to provide as much info as I can.
Am getting an error message in a new application I am trying to deploy -
"cannot open any more tables." Error code 3014 is displayed by the help
button, but the only reference to 3014 I have been able to ...

I am looking to produce bar codes from access is this possible?

Can someone direct me to a discussion of how to share queries and reports
with users and be able to update them and redistribute after adding or making
changes? I'm using SQL Server 2005 as the back end with mostly stored
procedures and pass through queries.

I need to open Excel from Access and place various values in various cells in
an existing Excel spreadsheet.  My code below does not work.  I commented off
my attempts.  Can you help me correct what I am doing wrong.  Thanks so much.
-Beverly

I have an application which uses Format functions in text boxes on forms. It
is used by approximately 90 users at this location, but users at another
location see the "#Name?" error rather than the data in the textbox. We are
on the same version of MSOffice, MSAccess and Windows ...