On my form, I need to put a button to run a query. When using the toolbox in
the Design View, I use the Command Button Toolbar, then use MIscellaneous,
then Run Query. I select the correct one, and save it to the form. When I try
to use it, I get an error message, and it will not ...

i have a form with a command button on it that runs a query.  currently the
user can modify the data that is displayed when the query is run which
modifies the underlying table.  how can i prevent the user from modifying
data that is displayed in the query.

I have a Date field for my records. The date field is formated as a date.
I have a separate table that has start and end dates so people can specify
what range the want to look up records in. The Month Start and Month End
fields are both formatted as dates as well. They are ...

I have a table with countless records of customers. There are about 15
fields, that I need to search individually. When needing to search for
customers, I need to be able to put in as little information as possible to
bring up their record. I have the queries set up for each ...

I have a sub that is supposed to transfer the SQL string to a query.  But the
string is over 255 characters and so it cuts off the last part.  How can I
transfer a string to an SQL statement from VBA that is longer than 255
characters?

I am using Access 2003
I have a machine maintenance Db.  This is a one to many db.  One machine
number and many operations and maintenance dates.  I need to create a field
that looks for the last maintenance date and adds the frequency in days for

I have a database which lists employee details including there start dates.
I'm trying to produce a report/query which return employees that have been
with us for more than 6 months.
The database has a StartDate field where we have entered the date they

OK here's the deal...In my query I have colmuns as follows...
Column 1 is for Zone
Column 2 is for Block Number
Column 3 is for GPM (gallons per minute)

In the critera i am using "Month(Now())" the field is date/time with no
format or input mask.
But it returns no records???
thanks Arlend

I have a report that has records that must be ignored for a certain time
period from when project starts.  Meanwhile, from this report records need to
be printed when projects starts.  I have in my query's criteria a field for
the records to be ignored set to Is Null.

i inherited database. this query has me baffled.
TRANSFORM Sum([po qty]-[last rct qty]) AS [OO Qty]
SELECT [Description Table].Style, [Description Table].[Long Style], [On
Order].PO, [On Order].[New Req Date]

I am trying to write a query that will return the last four dates a customer
has visited me.  The database I am working with does not assign trip numbers
so all I have to work with are the actual dates of the visits.  How can I get
it to return the last four trips for all of my ...

To the Best of the Best (yes I am sucking-up early),
Ok here it is:
I am trying to figure out a method that does the following.  I have an
employee who works 5 days a week M-F.  If they call in sick on Monday or

I accidently hid like 3 queries and now I dont know how to go back and find
them to use them. I have searched everywhere and I am so lost on what to do.
Does anyone know what to do?