473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Query by Form

I have spent more time than I am willing to admit trying to figure
this out...

I'm trying to use a form to manage the criteria in a query. This one
query feeds to numerous other append queries as part of a monthly
maintenance process. The query that I'm updating basically needs to
be changed each month to reflect the current month. I'm not looking
for the query to show me the results, I just want to use a form to
enter the criteria rather than open the query and change the criteriat
manually. If I use a parameter query, it asks me for the information
as soon as every append query loads.

HELP!
Jan 25 '08 #1
4 1527
Is it as simple as putting [Forms]![YourForm]![FormFieldName] in the
criteria section of the query or am I missing something?
Jan 26 '08 #2
On Jan 26, 5:53*am, anthony <anthony.marr...@gmail.comwrote:
Is it as simple as putting [Forms]![YourForm]![FormFieldName] in the
criteria section of the query or am I missing something?
I did try [Forms]![YourForm]![FormFieldName]

but whenever I used the drop down on that form, selected my criteria -
Other queries that I was running using that criteria weren't working.
It seemed like it would just show me results where as I actually
wanted to hardcode that criteria in the appropriate query. Does that
make sense?

All I am doing is going into this query each month an changing the
current month from 12 to 01 or 02 or whatever. I want to get this
database over to a group in another state who have never used access
before and I am trying to simplify how they will update these month
codes w/out having to go into any tables, queries, etc.
Jan 27 '08 #3
Sorry, should really have been [Forms]![YourForm]![FormControlName]

I'm having difficulty understanding why this isn't working. If all the
relevant fields are formatted as the same date format, then asking the
query to look at a form for its criteria shouldn't present any
problems. You mention that other queries stop working. Is this because
they are looking at the same control and expecting a different value
to the one you are using for your main query? If so, create a new
control specially for this purpose
Jan 29 '08 #4
anthony wrote:
Sorry, should really have been [Forms]![YourForm]![FormControlName]

I'm having difficulty understanding why this isn't working. If all the
relevant fields are formatted as the same date format, then asking the
query to look at a form for its criteria shouldn't present any
problems. You mention that other queries stop working. Is this because
they are looking at the same control and expecting a different value
to the one you are using for your main query? If so, create a new
control specially for this purpose
Could it be possible that one or more of your forms has its own Filter
Property set? I would check into this if your queries work outside of
form, but don't work when run with code in your form.
Feb 2 '08 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Harvey | last post by:
Hi, I try to write an asp query form that lets client search any text-string and display all pages in my web server that contain the text. I have IIS 6.0 on a server 2003. The MSDN site says...
3
by: MX1 | last post by:
I have a query written in MS Access that has a few calculated fields. Is it possible to refer to that query in a form field. I'd like the form field to show the sum of one of the columns from the...
3
by: Steve | last post by:
Form FrmRestock's recordsource is QryFrmRestock. The TransactionDate field's criteria is set ats: Forms!FrmRestock!LastXDays. LastXDays on the form is a combobox where the selections are 30, 60...
1
by: Nicolae Fieraru | last post by:
Hi All, I want to find if there is a different way than the way I am working now. Lets say I have a table, tblCustomers containing address details. I want a report with all the customers from...
6
by: Brian | last post by:
Hello, Basically, I'm running a query on a form's activation, and I'd like to have the results of the query be placed into other fields on the same form automatically. Does anybody know how...
13
by: Lee | last post by:
Hello All, First of all I would like to say thank you for all of the help I have received here. I have been teaching myself Access for about 4 years now and I've always been able to find a...
3
by: rhobson2 | last post by:
Hello, I wrote a database applicaiton using Access XP (2002) and everything has been working good for the client until they purchased a couple of new computers with Access 2003. The meetings...
1
by: bgreenspan | last post by:
Hi Everyone, I'm back for some more expert help. Here's what I am doing and what I tried. My database has entries with Contract Names and Expiry Dates, among other fields. I have a form...
3
by: pbd22 | last post by:
Hi. I need some help with structuring my query strings. I have a form with a search bar and some links. Each link is a search type (such as "community"). The HREF for the link's anchor looks...
2
by: lindabaldwin | last post by:
Hello everyone, I am fairly new to VBA. I have a worksheet in Excel, named "Data Sheet" from which I am trying to query data. This worksheet contains the following data: unit (column A), date...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.