Search results for query: *

Thanks guys for this help. Unfortuntly for me I have yet to learn how to code...but I might just have to. I am going to have to try the wizard to see how that works. Which leads me to building forms. BTW do I need Visual Basic for coding.

While testing the database I been asking about I found out that I dont like having the queries on the same form that handles data entery. It just leads to user mistakes. In mind the best way to do this is to have a form come up that simply has a com buttons that give the user a choice "Data...

Well I solved my problem it was data entery error. Lesson learned keep your data entery forms seperate from your queries at all possible. Now to see if I can do that.

I am new to this but I think the answer to your question is...I am a select query tied to a report. I have not learned how to use update queries. You tell me this is what I need and I ll learn quickly. Thanks

I have run into a problem. I have a tracking number for items and every time I run a report/query after the first time it is posting and printing the new number to the old number. example 1st time tracking number 123 reports 123 is item xyz 2nd time tracking number 456 reports 456 is xyz and...

I had to switch from pointing the comdbox from the query to the report to get it to print. But ran into a query problem so I have posted in the query threads. I want to tell you you helped me out big time.

Thank you Pampers. Though it took me a few minutes to figure out what Comboxes are this seems to be the direction I need to go in. I am assuming at this point once I set up each combox to query its field then my staff just has to enter info and the query will run. Next step after this will be...

Thanks for the help. As I thought this over, I have conculded that I should start with the form and so moved my question over to the forms forum.

How do I create a form that can make queries? I need a front in form for staff to use, that allows them to run several different pre arranged queries, off the same table. Note: not at the same time. For example it can query by part number, by date ordered, by cost etc; based on my staff needs...

I am working on a project that will allow my staff to track ILL infomation. I have a single table, and I can create select queries and have them reported. However, I want an option to do more the one query at a time from something that looks like a form so my front end staff can use it. I am...