I've always used something like below as standard practice in the Before
Update event of forms:
Dim Response As Integer
Response = MsgBox("Save record changes - Confirm?", vbYesNoCancel +

I am using 2007 and the queries that I run contain several blank columns.  I
have tried to delete these columns in design view but they still appear when
the query is run.  How can I get my query to just show the info I need and
not these extra blank columns?  

When I attempt to open my database, I get the message:
"There isn't enough memory to perform this operation.  Close unneeded
programs and try the operation again."
1.    I have been able to access the program before.

Dear Sirs
I have a VB code which is executing appen-,deletequeries and is printing a
report.
To run this code I have to check upfront a checkbox – either yearlypayment

I built this query from 3 tables. I set the Where conditions to return “293V”
from CUSTOMER_GROUP, >-99999999 from QUANTITY_FROM, “GENERAL” from ITEM_GROUP
and “4/3/2007”  From EFFECTIVE_DATE. It pulls everything except the 293V and
the 4/3/2007 here it give me all the data. I ...

Does anyone know how to write code so that if a box is checked, it will pull
information from another table?

I have a question that relates to setting up a database for a laboratory
chemicals list.  I've managed to import all the values from an Excel
spreadsheet but when I go to sort them I find that the program takes me too
literally as some of the chemical names start with a bracket ...

I have a table that is tracking completion of certain tasks and upon
completion of particular tasks I want to update the same field in a different
table.  The structure for my tracking table is as follows:
Review_1

I am using the function indicated below (which I found on one of these
threads), but I'm getting small pop-up window with two dates on it and an OK
button.  I click OK and the function continues to run, but then it happens
again and again and again.  I think it might be because ...

I need advice on displaying the date in a 05/07/2007 format and not like
5/7/2007, in both Forms and Tables.

Dear Sirs
I have a Macro running perfect and it is executing the following:
- billyearlyhelpappendquery
- billhalfyearhelpappendquery

I'm trying to open a database with two client computers and it doesn't
works.
It's the first time !
Is anybody can help me to understand why it's not possible to open the

I have mutliple fields as check boxes in my access database.  When I try to
make labels of these records these fields show up as 0s and -1s on the label.
I would like to know whow to create a label where the data comes across as
yes and no.

Is there a way to set up conditional formatting where if a name is entered
that is on a list on a seperate workssheet that cell will shade to a selected
color?  For example, on worksheet #1 I have a list of 200 names, one which is
Jeff Restad.  If I enter that name in worksheet ...

I am securing a database.  I removed the admin user from the admins
group, after creating another user for the admins group, and giving
that user a password.  Then in the startup options I removed some of
the toolbars, so my users couldn't try to change any options.  The