I'm using the code below to print a list of all the queries in a database,
along with their fields, and it works fine.  However, I would like to add
some code that would also display the table(s) which contain those fields.
In addition, it would also be great if I could also include ...

I have a MsgBox coded as follows:
Dim intAnswer As Integer
intAnswer = MsgBox ("Would you also like to apply rules from the BizRules
Manager?", vbYesNoCancel + vbQuestion, "Apply BizRules")

Hi Eric,
You kindly responded to a previous post of mine regarding RunSQL on Jan
12/05. You mentioned writing a function to confirm if the record got added or
not. You also offered details if I needed.

When referencing currentdb in Access I get the following error:
This started happening around Christmas time.  Is this caused by a Patch?  
ActiveX Component can't create object.  
Thanks.

I wish to change the background bitmap of all my forms.
Is there an easy way to automate this or do I have to go to each form one at
a time and do it (ugh)?
Jonathan Blitz

I feel like this is a really dumb question, but its driving me nuts....
I have a form that contains a combo box that syncs the rest of the controls
on the form to the row selected in the combo box - works great.  However, I
need to call another (child) form that adds new rows to the ...

I have a pop-up form which I am trying to get to open from either a subform
or another form.  Once this form is open I then want to have it populate 2
fields from either the subform or another form.  Both have the same field
names.  I can get it to work with the other form.  ...

I have a continuous form that lists items on a Sales
Quote.  The users would like every other line to be gray-
scaled so that it is easier to follow across the form.  I
do this in the printed report by using a little VBA

I used to be able to type a date in shortest possible form and Access would
translate with no problem -- e.g. typing "12/1/4" upon hitting enter would
change into "12/4/2004."  Now it changes into "12/1/2002."  Other attempts at
single digit dates produce wierder results.

We have received a request from the 'owners' of the database to change a
field name in a clinical trial patient database that already has some
patients entered into it (thankfully, we dealing w/ 'test' data!).  
Unfortunately, this field is a 'header' field, and thus appears in ...

I have a form where if I go into a text control and enter 'AA' and then
delete those two characters, upon exit of the form I get the following
message:
"The database name component of the object qualifier must be the name of the

I have an Access FE tied to a SQL back end. If I have a required field set
in SQL server and try to leave it blank, you get an error message:
"You tried to assign the null value to a variable that is not a variant data
type"

I have a button in a form thatI want to run a query. The problem is,in the
button wizard it shows every append select...blah blah query except for the
delete query I want the button to run.
Any help reatly apprreciated!!!!

I have a form where the user inputs a series of figures into a number of
controls. After they've input the total (they don't want the program to
create the total) there is a check to make sure the total of the controls
equals the totals they've input. Here is the code in the Before ...

I am trying to open a recordset of a query that has some Criteria. I am
using the following code:
Set rsTot = db.OpenRecordset("qryTotal", dbOpenDynaset)
The qryTotal has criteria so it opens to a specific record.  In the criteria