All of a sudden all of the drop down fields in the Look Up won't stay updated when I change them. Any ideas?
I have tried making changes to the Roster table, where the data comes from and the form.
If you have an existing query, you simply right click its name, select 'copy', then right click again on top of it and select 'Paste'. If that won't work, you can open the query in SQL design view (the one with nothing but code), copy all the code, create a new query, go into SQL design view on it and paste the code there.
Hi, Plog. Some how I found a post in the query thread where you answered on how to create a new query from an existing one. Now of course I can't find it again and I wanted to ask you about the 'copy and paste' option you detailed in your answer. You speak to 'copy the existing query and then paste it giving it a new name, open that new query......' but for the life of me I can't find where to paste it. I also get an error that Access can get the data off of the clipboard and the query is itty bitty---Just one criteria. Think you can help me? Thanking you in advance, IM4GLTR
Hey Plog help me if u could please. I have one problem in querying,
Here it is,
In my query form I have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are stored in the number format, for example Adair = 109, Alfalfa = 126 etc.
So if I select Adair while performing query operation, it will go and check for the value "Adair" in County field and its throwing an error since the value is stored in number format. So I am struck with this. can you please help me on this. Thanks in advance.