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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.