running queries/forms in the background

[sha7jpm]

I have 10 queries and 10 forms which populate a final form.

as the user does not need to see these queries/forms. (a macro opens and closes them) is there a way to have the forms and queries running in the background so the user sees nothing but the final form.
I can open and then use the minimise command in a macro but the user still sees all the queries/forms popup and then minimise.

ta

john

 

[bradcccs]

John,

I can't really help you with the macro part of your system, as I use coding in preference.

I find that macros leave you with issues that you are currently experiencing, and the lack of error handling can prove to be a drama.

You could however look at using:

forms!formname.visible = false

on the Command button that opens your forms (after the docmd.openform statement). This will prevent the form from being displayed, but it will be open.

As for the Queries, you do not need to display them in order to retrieve information.

HTH

Brad.

 

[sha7jpm]

many thanks!

cheers brad,

I agree coding would be better, still finding my feet though so dont want to bite off more than I can chew!

thanks for the syntax and tip about the queries.

J

 

[sha7jpm]

good question!

mainly because I could not find a way of linking a form to a query.

I have an email code which I need to declare the txt boxes with the syntax so the email can run off the form

therefore the forms run off the query, I can the final form will pick up the data from the form which runs off each query.

I did try to find a way of linking the form to the query, but considering that the use may be emailing anything from 1 to 10 records from the database it seemed impossible to declare the forms fields within the coding, (well I could not find a way...)

so that is why it is clanky! mainly time is not on my side so needed to find a way quickly.

any tips on a different approach or some coding which would pick up anything from 4 txtfields to 40 and still send an email would be gratefully received.

J

 

[Rich]

Why not use a report?

 

[sha7jpm]

how would the syntax for the email pick up the report?

would it be as an attachment?

one of the requirements is that the resulting email has the data within the message section not as an attachment.

J

 

[EFCoins]

Many possibilities
Make the form hidden or invisible or 1 x 1 pixel, or put another form on top of them.