Macro Processing

B

Bunky

I have a database 'A' that the user works in normally. When he presses a
button that is on a form in 'A', I want to jump to database 'B' and do some
processing, generate a report, then return to database 'A'. Is this a doable
and if so, how do you accomplish it?

Thanks for your help.
 
S

Steve Schapel

Bunky,

Yes. You can use a RunApp action in your macro to open Database B.

However, I would suggest another approach. Is there any reason not to
link to the Database B tables from Database A, and then you can do the
processing and report directly from within Database A?
 
B

Bunky

Thank you, Steve, for the idea.
I love your other approach as it is exactly what I am doing currently. You
see, we have a sequel Database in a location several states away from us.
Normally, not a big deal. However, when we try to run a macro that takes
data from an AS-400 Query linked to the sequel Database, delete the old 60K
records, then append the new 60K records from the AS-400, the operator gets
old and gray waiting for it to end. I was thinking of taking sequel out of
the equation to see if I can speed it up. If you have any ideas on the
subject, I would be happy to hear them.
 
Top