I have a group of querys which run one after the other and some VB code to
get around a timeout issue. As it takes awhile to run I would like to put a
message box on the screen to say where it is up to.
Thanks

I'm trying to use a sql statement to select the Dept and Branch from a table
for a specific customer number and where the groups does not start with 000.  
I have tried writing the statement as follows:
vSQL = "SELECT [DEPT],[BR] from [Data] WHERE [CUST_NO] = '" & CSTMR & "'AND

I read this article... apparently I didn't understand it as well as I
thought I did...
http://www.mvps.org/access/queries/qry0013.htm
What I'm doing... (in case it helps).

i am trying to create an audit report of only changed fields and i've looked
at the code provided here http://support.microsoft.com/default.aspx/kb/197592
but instead of returning just the changes i am getting all the fields on the
form those whose values have changed and those ...

I am trying to make BOM report with recursive function that returns array of
elements of the BOM.
Each element in a record corresponding to a few controls in a form/report.
This way I can create a form/report that displays my BOM in Form/Report

When you use a filter in Access, and the filter will result in no matches (0
records) the default behavior of Access to go into record Add mode (if you
have add rights), or just display a blank form (if you do not have add
rights).  For my application either of these options are ...

Descprition of situation:
As you can see here we have a loop (While not ... Wend) which contains
2 'case conditions'.
What is my problem. At the end of this piece of code there is more

WAMY Series: On Islam No.9.Introduction
God's Attributes
The Oneness of God
The Believer's Attitude

I have a form with diaries each diairy is a record and each record has a
combo box that pulls from a table with three records indicating whethor or
not the diary entry is critical or a daily task.  If the diary is a dialy
task I need to set the background color of the diary to ...

Can you programatically check a database to see if a specific table exists in
your database?  
I have a number of cost centers and there are several different versions
existing, depending when they came on-line.

Help, I must be missing something basic (pardon the pun)
Windows XP Pro, Access 2002
Created a new form, with some unbound text boxes in the form header,
and a couple of buttons.

I'm working on a dataset which numbers each entry by number (1, 2, 3, etc.)
for one group and by letter for another group (A, B, C, ... AA, BB, CC, ...
AAA, BBB, CCC, etc.).  I'd like to have the system figure out the last record
entered and detect the letters and know what ...

Is it possible to change the properties of a field in a table
programmatically?  For instance, I want to update the "Instruction" field in
the "Data" table by changing the size from 50 to 250.
I have a macro that will cycle through a number of folders and I want to add

I have a report that the user can e-mail to a general folder. I am using the
command button wizard and everything works fine, the only thing I would like
to change is the report is being picked up by outlook secturity saying
information is being automatically started. They then ...

I am getting the error msg "method 'range' of object'_global' failed "
sporadically in my code. I read elsewhere not to use "With ObjXL", but
there's no explanation of why.
I get it off and on with this line: