I am not sure if i am going the correct route, but I have a form that
creates a text string based upon what the user selects so that it
opens a report. The issue is that I have 4 checkboxes in the table
that the report is reporting on and I need to be able to allow the

   The error "Record is deleted. (Error 3167)" appears to users
always,every week or 10 days,i can easily solve the problem by compacting and
repairing the database...,I'm sure that the form from which users edit the
records is set to lock the edited records to avoid any ...

Is it possible to create a calculated field in a Table?  For example, in the
table their are 2 fields, one for cost and another for quantity.  Is it
possible for the 3rd field be a calculated field with the answer being the
default, through use of a formula; possibly as a default ...

I have a continuous form that is based off of a table, each record has
12 fields, 10 of which I wish the user to be able to filter on.
The form has 10 combo boxes in the form header which are unbound and
have Row Sources like this;

I have one tblContacts that has "Home" and "Work" address included within it,
I also have an option button 1="Work" and 2="Home". I need to prepare a
mailling report but only for the defaut address. Can anyone show me how I can
go about doing this?

I am trying to calculate the average sales for each SKU while removing
the x% of the sales as outliers.
So from 30k rows in the sales table with about 2,000 SKUs, this is the
query that I currently have. It works correctly; however, it takes too

We have an access 2000 database with a password set.  We also just updated
one of the pc's that uses it to Access 2007.  Now on that pc we get "you do
not have permission p:\path_to_database  for database object"  I can open the
database from my pc which is still access 2000.  ...

How to deploy an access application on windows 98 Machine

I have a table(A) wich contains following f.e.  records:
1
2
3

In access 2007, I have a combo box (cboAgencyStatus) on frmConsumers
that when the word discharge is selected it would make the hidden
checkbox (chkDischarge) Yes.
How can I do this?

I am trying to put together an invoice.  My report already contains a field
that calculates the total invoice.  I would like to add to this report a list
of payments made, by date.  I would then like to subtract the sum of the
payments from the total invoice sum.

I've automated a table import to create "MyTable".  It works fine, and it
also causes the creation of an "MyTable_ImportErrors" table with any import
problems.
I want to delete "MyTable_ImportErrors" (if it exists) before I execute the

I have the below code to send an email from within MS Access using Outlook.
What would be the late binding version of this code?
Many Thanks
Regards

I have a query that has two date fields, a period recieved field and a period
paid field.  I want to be able to prompt the user once to enter in a date.  
That one date will set the criteria for both the period received and the
period paid fields.  How can this be done?  I don't ...

Access 2003
I have a calculated field in my form that i want to go into my table but it
doesn't. My question is, how do i get the results of the calculated column
into my table.