is there anything wrong with my following VBA code?  If I take off the last
two queries, then it works by opening the form.  But I can't open the form
with those two queries on my code.  Any suggestions???
Private Sub CmdMatch_Click()

I need to have a query that finds a range of numbers within a range of dates.
When I enter between [start date] and [end date] for the date field and
between $50 and $250 for the amount field it says it's too complex.  How can
I accomplish this?

Between all these "deep" queries and solutions, my problem may be a little to
easy for the most of you to spent time on it, but I hope that someone out
there can help this access beginner not to loose his passion with his first
step.

please help me!!
I have field containing rows like this:
hamburger, S 31-41
S, 191-210

I am using Access 2003 with Jet 4.0. And Jet 4.0 supports Stored
Queries, something I have not paid any attention to until now.
http://msdn2.microsoft.com/en-us/library/aa140021(office.10).aspx
It seems that if I use the ADO syntax correctly, I can define a stored

I am trying to figure out my next route to obtain my desired outcome.
I have started a database, and have a table with associate information, a
table with training data (associate id, training code, date) and a table with
certificate information(certificate code,certificate name, ...

I am trying to use the below query to access another Access database
that is password protected.  When I run the query as-is it says the
passowrd is invalid.  How can I incorporate the password into the
below query??  Thanks in advance.

I have a table with columns Date and Price. With
"SELECT table.date, table.price
FROM table
WHERE (((table.date)>#4/3/2007# And (table.date)<#4/30/2007#))

I want to delete the zeros in a Text field which was input with numbers
(numbers was in a Text Field, not number),
e.g. 000253878, 000253999, 000250007
there are hundreds of records, all prefixed with 000

I have an Access database with about 20,000 dogs in it and would like to
make a query that returns lineage information.
Here is a query that shows the basic structure:
The system is providing the primary key but the DOG_ID is unique.

I would like to split my databse into a front and back end. I do not
know where the database will reside and would therefore like to set a
relative pathto the backend.  I understand CurrentProject.Path  will
give the front-end's curent path, but not sure how to then link the

In additiion to my previous post, I need to display the previous month
and year to the current month.  e.g. for March 2007, I want to show
February 2007, for January 2007, show December 2006 etc.
Can anyone please point out how to do this?

I'm looking to create a query that shows all data within a table up
until the end of the previous month.  e.g. for this month (March
2007), I want to see all data up to and including February 2007.
Can anyone asist?

I know it must be easy but for the life of me I can't seem to write the
expression properly.  How would I write an expression that would look at a
text field and if it has NJ entered, calculate the subtotal *7%?

I am trying to create a string variable from an SQL query that
contains a quoted space.  The query is as follows:
INSERT INTO tblBirthday ( CustID, WholeName, Address, City, Statee,
Zip, Birthdate )