range in a criteria getting from a textbox of a form

  • Thread starter Thread starter thread
  • Start date Start date
T

thread

hi all,
im trying to send a criteria of a range to a query from som reason its
not working
the criteria is :
[Forms]![Form1]![Text0]
the range for example is
="A1" And <="A6"
Click to expand...

the range is little bit twisted here so try to figure but it suppose to
be bigger and equal to A1 and smaller and equal to A6
for transfer the "im using chr(34)

maybe someone have an idea?
 
Post the SQL for your query by opening the query in design view and then
clicking on menu VIEW - SQL View. Hightligh, copy and paste in a post.

thread said:
hi all,
im trying to send a criteria of a range to a query from som reason its
not working
the criteria is :
[Forms]![Form1]![Text0]
the range for example is
="A1" And <="A6"
Click to expand...

the range is little bit twisted here so try to figure but it suppose to
be bigger and equal to A1 and smaller and equal to A6
for transfer the "im using chr(34)

maybe someone have an idea?
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Query Criteria: evaluating criteria as a group 3
Filling a text box on a form with VBA code 4
Query criteria from form entry 1
2 independent criteria in a query 2
Excel Macro to use cells as a autofilter 0
Linking Top x Query to a form 3
random range of cells via cell names 3

Back
Top