I know you can open a form in hidden mode, can you do the same when opening a
query?
i need a query to run so a report can grab datafrom it, but i dont want to
view the query itself.

We are trying to design an Account History Query where the Debits are stored
in one Table and the Credits are stored in another table...
We want a chronological listing of Debits & Credits with a running total.
Not sure what type of query to use. We have used Union Queries in the ...

I am convering a Access 2K project that will now be using SQL tables for
storing the back end data.
I just read info about the upsizing wizard which had some info on how to
design new queiries using "Where" so that this runs on the sql server.

Hello. Thanks for your attention.
My description is as follow:
I have many tables: Invoices, Invoices Details(where I stored th
details of the invoice like ProducId,Name, Price, Quantity,etc). Eac

I HAVE A TABLE FOR APPLICANT AND ONE FOR A CHILD.  THE PRIMARY KEY IS
APPLICANT'S SS#.  HOW CAN I HAVE THE CHILD ACCOUNT# AUTOMATICALLY ENTER
THE APPLICANTS SS# PLUS 01 FOR FIRST CHILD, 02 FOR SECOND CHILD, ETC.
I HAVE THE FORMS SETUP, APPLICANT IS MAIN FORM, CHILD IS SUBFORM.  I

Haven't had much success on my own so I hope this makes sense...
The Row Heading is a Part Number and the Column Heading is a Type. The Type
column is my PIVOT column.  Each Part can be Type "1" or Type "7".
To simplify, this is the current example of the query.

I added wrongly spelt words to the default dictionary before I found the
correct spelling and the custom dictionaries. Now when I spell check old
files to fix them it doesn't seem to find the errors. I need to delete the
incorrectly spelt words and I can't seem to access the ...

I've tried to solve this problem a number of different ways, but am just not
getting it.  Please help.
I have a report grouped by ID number.  The detail of the group has fields
txtDonation (=[Donation]),

I have a MS access database which has entries (each of which has a name
field)  and uses a form to make new entries. I would like to put
together code that will run when a new entry's name is entered that
does the following:

my emails vanishes and i dont know how to retrieve them

I have a table with data for different months of the year, eg.:
JanDebit, JanCredit, JanAdvance, JanTotal,
FebDebit, FebCredit, FebAdvance, FebTotal,
MarDebit, MarCredit, MarAdvance, MarTotal, and so on...

I want running balance of each item through query or any other source.
The Table contian following fields:
Date
Invoice_No        (for sales only)

Could you tell me where is the mistake? I got an error "Invalid Operation"
when I try to run it.
[Forms]![frmSupplierInvoice]![txtIDInvoice] is a string
[Forms]![frmSupplierInvoice]![PurchaseOrderID] is a Integer

I have been asked to handle the office football bowl pool. I was given an
excel spreadsheet that I imported and is formatted as follows:
John       Ed            Paul.......
Ark         S Miss    Ark

To put it simpily I have a form (test) with 2 comboboxes (cboReviewBy and
cboReview) both are populated from (tblHazinventory). I am trying to make the
following SELECT statement work.
SELECT *