In Access 2003 I was able to place the "exclamation point" RUN button on my
Access toolbar so that I could easily re-run a query that I already had open
(rather than try to find it in a list of a few hundred queries).  The queries
I run usually ask for user input, so by ...

a combo box value is used to a pop-up new open Form. Where in that
form a list box row source used that combo box value in query builder
as a creteria using LIKE Clause and is not working, anyone can point
out what should be a correct way to do it?

I need to display the structure of a table in an MS Access database.
I'm using dotnet framework 2.0.
Thanks.

I am trying to do a Dlookup as one of the expressions in my query but not
working.
Tables Source:  PPO
Field to Return:  Type

Hello all,
I am a bit new to queries so any help here would be appreciated.  Have a
table with the following col data:
Name Month Results

Suppose i have 46 tables , now when i want to, run a query it ask me, which
table i need from the over all 46 tables, and once i have selected the tables
it ask for fields, now the quetion is i want access to only ask for those
fields in the dropdown menu in which some data has ...

I am attempting to use Duane Hookom’s concatenate function without any
success.  I’ve read many threads, relating to Duane’s function, yet none seem
to fit my situation.
I am working with multiple tables, with a M:M ‘Joining’ table in the middle

I have this query and I want to be able get a stop count.
SELECT tblInvoiceHistALL.[Customer Number], tblInvoiceHistALL.[Ship Date],
Count(tblInvoiceHistALL.[Customer Number]) AS Stops
FROM tblInvoiceHistALL

In my Access 2000 database, I have a form for entering data on people who
register for an event.  Key fields are "First Name", "Last Name", "Event
Code".  I am tracking multiple events.  
When I enter a registrant's information, I want to click on a "Submit"

I hope that this makes sense, but as an example:
I have 2 databases.  The first one (db1) contains Product Name &
Serial Number.  The second (db2) contains Serial Number and Price (but
does not contain all of the records in db1).  I want to see ALL

Good afternoon,
I have a table that shows the following text fields -
Date - Associate - Status - StatusCode - Method -
each of these fields are text fields (except for date is Date field)

I have a table that has the following data in it.
Production Date     Size     Break Type     Location
2/1/07                  11oz    Other              Pre-Filler
2/1/07                  11oz    Impact            Capper

I have filtered a query to exclude a particular product, however, I have been
asked to make an exception based on a customer name.  I tried an IIF
statement, but I get the "too complex" error.  Anyone know how to achieve
this feat?

Access 2003
I want to print label based on select query. The query pull out, for
example, 10 records. I want to use a form for user to check which of these
10 records to print label. My table does not have Yes/No field and I cannot

I have Two tables with the same information. Table Two has a column called
Errors with data.
How can I update table one Error column with the same info in table two
errror column.