Afternoon all,
I've an MS Access application that's been running for ever (5 or 6 years)
without any problems until recently when I had a persistent DB crash. The DB
crash I solved with a full reinstall of Access 03.

I have some code that I am trying to switch to late binding. It is code that
saves the result of a query as an Excel file, then sends this file as an
attaqchment to an Outlook email then deletes the file.
It used to work before I made both changes to the the code dealing with

I am wrting some VB in an Access 2003 database, and I want to get a COUNT to
display in a msgbox.  Here is a portion of my code:
'Loop through recordset
 Do Until rst1.EOF

A pass through query that runs a stored procedure on a SQL Server db takes
several minutes to run. The first time through it gets an ODBC timeout
error, then it runs fine.
Is there a setting that can be changed to eliminate or bypass the error?

When records are read into a record set, and used to be inserted via SQL to
another table, if the Date field is blank, the Date is appended as
30/12/1899. This corrupts the data for the user, as I need the blank date to
be maintained in the table being appended, how can a blank ...

I have a pass through query that runs a stored procedure in a SQLServer db.
The sp can take several minutes to run on a large db.
Is there a way to display a progress meter while the sp is running?

I have a three combo boxes.  Two run as a cascade: "Advocate" selection
limits "Reviewer" selection in subform.  What I am trying to accomplish
within the third combo box is a "reverse" lookup: By selecting a "Reviewer"
it will pull up the "Advocate" main form.  I got this ...

I have a form that has unbound data that is used with query data for
calculations.  I do not want the unbound data saved.  How can I pass unbound
parameters as well as the query to the report.  I don't want my users to have
to rekey the unbound data in an unbound parameter form. ...

Is it possible to do access scripting with out using VB code?. If yes, Could
i have some useful links about this..
Thank you all in advance.

Ok! this is somting defrant, i want to be able to transfer a value from one
record to the next with some vb. Here is what i have, in table1: ID
(AutoNumber) data1 (Currency) data2 (Currency) datatotal (Currency)
The hole idea is to transfer forward the value of the field datatotal ...

i am receiving an error database engine could not lock b/c in use by another
person or process. the application resides only on my c:\drive. i am unsure
of the cause or how to debug. any help would be appreciated

I bought this book used and it didn't ship witht he CD.  the company where I
just started working usese Access 97.  Is there any way to get the practice
files from the CD?   Help me, Help Me!!!!

Is there a way to list Table field names and properties so they could be
printed out.  
thank for any and all help

I do not understand I am new to 07 and a wondering if they have changed the
way things work?
I am trying to get a simple message box to come up after pressing a button
on a form.

I have two forms.  One form is called (Main) which is where all of my data is
entered and stored.  The other one is called (Seeker) which is used to search
for information from a mainframe.  My question is this.  How do I write a
code to capture (or copy) the data I typed in  ...