Forms Queries

Hi

Is it possible to use the Query to view saved transactions on a table by using a form NOT a report? Sorry people my question sound a bit weird, if this was possible I will be happy. We have the business rule as below:
(1)      All transactions must be approved by a senior official direct in the system, example the captured or saved data by clerks can be deleted anytime if not approved and once the transactions are approved it impossible to delete them
(2)      The approving form is only seen by a senior official, and so the lower staff have no chance of seeing it at all
(3)      Only approved transactions can finally reflect in the general ledger

The approving form is the one which I want to fit the query so that the managers approving the documents do not only rely on the printed journal but can as well see the transactions on the form like a min report.

All is working well and everyone is happy about it, but if the above can work then that can be a good thing
If Dsum, ComboBox & Dlookup are able to bring figures on a form which are regarded as min queries why the actual query can’t do the same???
LVL 3
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You can use a Query to create a form. That's fairly common.

If Dsum, ComboBox & Dlookup are able to bring figures on a form which are regarded as min queries why the actual query can’t do the same???
A query can use similar features. You can't refer to the Column value of a Combo from a query, but it's easy enough to get around that. Otherwise, DSUM is the same as the SUM operator in a query, and DLOOKUP is the same as a WHERE clause in a query. You often use JOINS to bring together different tables/queries for use like that.

However, remember that using multiple tables as the source for a form can easily result in the form not being updateable. If your goal is to have the manager review and authorize expenditures on the form, be careful how you build the query - include all relevant Primary Keys, and use only the bare minimum fields needed (i.e. no "SELECT * FROM SomeTable")
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.