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 2
Hankwembo Christopher,FCCA,FZICA,CIA,MAAT,B.A.ScDirectorAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.