Ever since I installed Microsoft Access 2003 Service Pack 2 on 03.13.06 on
Windows XP Professional, compacting any of my database files after doing any
kind of editing in Visual Basic Editor closes Access with the following
message:

I'm going to try to explain this the best I can...
I have a report that has a sub-report embedded in it which has a sub-report
embedded in it.
With the main report, I filter the report with user input. The report looks

Is there any way to add a time to a form header that updates automatically?  
In essence, replicate the system time into the header.

I have a form with a date field in it with a macro that calls a form with a
calendar control when clicked on. My problem is getting the date form the
calendar control to populate the date field on the form so I can then update
the file. has anyone been able to do this?

Hi NG,
How can i create a new regexp object in an Access VBA project?
Thank you,
Zz7

I have an access 2003 database with a SQL Server backend. I’m trying
to run a query to get a record count. It will either return 1 row or
0. I need to know which it is.
Here is the query:

How do I setup account to send/receive mail?

All -
I have a situation where a user clicks on a button to copy the current
record to a new one.  My question is...is there a way to get the new record
number and display it with a message box (i.e. "The new record number is X")

I have two tables. The master table us a long list of plant data collected
for various sites. There are over 500 different sites and each site may have
several records of different plant species. On a separate table I have a list
of 175 sites that I am concerned with. Therefore I ...

New to Access here, and have a question. I’m trying to make an Access DB that
will draw data from a table in the database, I’m not sure how to link the
form and table together. The data that is being pull was given to me in a row
by row format. What I want to do is withdraw data ...

We have sales employees in a table. The table has a field called
SalesHireDate which is a date field. I have a query and a formula on a
form that calculates their commissions. We have a ramp up commission
scheme which means they have to meet or exceed the following sales

I have a main form with a list of items and qty in stock. User clicks on the
item type user who took it leaving qty minus 1. I want the main form to
subtract the number from the qty left of other form

My company upgraded us from Windows2000 to WindowsXP:  Also upgraded
Microsoft Office 2000 to 2003.  I had a working Access database and Excel
Macro that now will not work.  I get the error message "can't find excel
file".  I have made sure the paths are correct, but not getting ...

I have a database that I work with on a flash drive. In the process of
saving a report, there is a message saying that there is bot enough space on
the flash drive and my database cecome corrupt. I can open the file and see
all the rerports. When I try to Compact and Repair, I ...

All -
I have a document (PDF) that is store in a MOSS 2007 document library.  The
question is...how can I send that document in an e-mail as an attachment?
Thanks...