I used this from another post as a suggestion to bypass the Outlook email
warning message as a module in my database-

Set outl = CreateObject("Outlook.Application")

I have a form called fProjectReview and a subform called fWarranty with a
sub-subform called fWarrantyDetails.
If a user fills out any of the fields in the sub-subform before they enter
data into the "required field" called WarrantyPCT in the subform, they

I'm struggling trying to design an appropriate relationship for some data. I
want to create a database of batch recipes. Each batch can include one or
more ingedients, and each ingredient can have one or more supplier.  Ideally,
the form would have the batch number, then a ...

I'm using MS Access 2003 and doing homework about Pivottable.
When I select Query that I would like to create Pivottable.
There is a message shows" The connection with the OLE server was lost, or
the OLE server encountered an error while you were using it. Restart the OLE

I have a VB6 apps that use an old MDB (Access 2.0 [1993]) with DAO 3.51
With XP all run perfect, but with Vista I have this problem:
when I insert many records in a table with a recordset opne in "Table" mode,
just after I call "AddNew" method into the fields I find yet the value I

I need to create a matrix and I'm not sure where to begin.  I would like to
have the job duties listed with check boxes under each employees names; they
would be checked if the employee has that job duty.
Example:

Hi Group,
Hope someone can point me in right direction.
I have an address table which uses a custom number to define an
address location. It is based on location and is not auto

To distribute Access 2003 runtime, what software should I buy ? Please
suggest several sites which I can buy the tools from there.
Thanks.
Chlaris

This is what I'm trying to do:
One field which is a File Id # which contains numbers and letters
When I save the record I get the error "File Number Must Only Contain Digits."
This is the setup:

I need to query fields matching the date the query is ran by the user. I
tried [date()] in the filed's criteria but since my dates are stored with
time i get no results. I need to keep the time in the field but also would
like to query by current date.

I have data that I imported into a table from our main accounting system.  
The file gives me line data as follows
location, item, year
and column data of Qty Month 1, Qty Month 2, Qty Month 3......

Is this possible?
I'm building a contact details database and one of the tables details
correspondence between our organisation and stakeholders. In an ideal
world I'd like to be able to click on a document name in one field box

I am looking for any and all advice. I would like to design a line chart but
would like to use excel since the charting options seem much more robust then
access. Ideally what I would like to do is export data (or a table) to excel
and then have a separate graph somewhere on a ...

Hi again,
I have a query with criteria base on a control from a form.
WHERE ColumnName=[Forms]![FormMain].[ControlName]
It works perfectly fine but for some reason I have to make a duplicate copy

Thanks for looking at this and let me explain
I have inherited a home brew database that contains password and
machine information. The database is running on a MS SQL Server 2000
instance and the users have an Access front end that can be used to