If I open a database window and select "Queries” then scroll down to a query
called qContacts. Then right click on the query and select export, I change
the Save as type to: Microsoft Excel 97-2000 Its exactly what I need. How can
I reproduce this behind a command button?

As part of a research project I am looking at a database of approximately 33
000 people in microsoft access 2003. One of the columns is a 9 digit code
(all numbers). I need to select all people (rows) where the penultimate digit
in the code is the number 3. I have tried a query ...

Can someone help me with a query that would give me the name and number of
records for all tables in a database?
THANKS!!!!!!!!

I have a report that I will like the default values in some of the fields to
be 0. Please help

I am trying to set up a field in access that is dependent on another
field.
current field in my table are "Amt" and "D/C"
I will like to add a field that say if D/C = "C" then Amt * -1

I downloaded an Access Database for Inventory.  I want to add the cost of
each item, total $ we have in item on stock, total resale value.  Help.

I'd like to know which condition in where part of sql will be considered
first. I'd like to optimize sqls.
For example: select * from table t where condition1 and condition2 and
condition3

I have a table of names and addresses that I send out yearly for apartment
inspections.  I update it according to when they pay,when its sent out, when
its inspected, if it passes inspection, # of units, owners name and address
and site address.  I am now going into my second ...

I work on a site on daily basis. I want to create a button on the desk top to
open the website. I know by shortcut I can go to the site but I need one
Button
Khusro

Is it possible to close a form with fields bound to a table, without saving
any data that is in the fields on the Form?
I've tried using acSaveNo but the data still gets saved.

I put this into the AfterUpdate event of the EmployeeIDfk combobox on
the continuous subform.
(I have Date and Event on the mainform, and then select Employees on
the subform. Since Event and Employees are in different tables, I

I downloaded an Access Database for Inventory.  I want to add the cost of
each item, total $ we have in item on stock, total resale value.  Help.  
http://office.microsoft.com/en-us/templates/TC102068821033.aspx?pid=CT101428241033

I need to resend letters according to the date they were originally sent
out.  They are all in a database under "date mailed"  How do I sort them so I
get only October?
Thank you.

I have a Color picker to lookup color numbers to be kept in
fields - I give access to the Color Picker via a button, whn
the user has selected a button I would like to be able to
place him back in the field he came from (the one the color

I have designed a Data Base, which opens to the MAIN MENU.  When any of the
controls are clicked from the main menu, the following message appears:
"The expression On Click you entered as the Event Property Setting produced
the following error - Return with Go Sub, the expression ...