D
Dan
I created an application linked via OBDC to Oracle
tables. The application automatically refeshes data at
pre-set times; I use the Form's timer function to compare
the current time to times I want the application to refesh
itself. The application is a reporting tool where I want
multiple users to be able to run reports on the refeshed
data. The application runs on a network shared drive.
In order for the application to run this way, I need to
have it running at the pre-set times. What I would like
to do is run the application minimized on my machine in
the system tray. All other users would then be able to
run shortcuts to the front end of the application
(modified from my version which performs the updates) such
that they only have reporting capabilities. I think I
want to run the application as a Split application with 2
versions of the front end; mine having update capabilities
and other users not having those capabilities (not
involved in periodic refeshes of the data).
Everything in the application runs on Macros keyed to
events. I do not have any coded modules nor do I know how
to use or create VB code. A solution using macros would
be the preferred solution unless you are able to provide
good instructions on how to cut/paste your suggeested code
into my application.
Can you provide a hint as to what I need to do to have an
Access Application run minimized in the system tray. I
can handle the rest of the implementation.
Thanks
tables. The application automatically refeshes data at
pre-set times; I use the Form's timer function to compare
the current time to times I want the application to refesh
itself. The application is a reporting tool where I want
multiple users to be able to run reports on the refeshed
data. The application runs on a network shared drive.
In order for the application to run this way, I need to
have it running at the pre-set times. What I would like
to do is run the application minimized on my machine in
the system tray. All other users would then be able to
run shortcuts to the front end of the application
(modified from my version which performs the updates) such
that they only have reporting capabilities. I think I
want to run the application as a Split application with 2
versions of the front end; mine having update capabilities
and other users not having those capabilities (not
involved in periodic refeshes of the data).
Everything in the application runs on Macros keyed to
events. I do not have any coded modules nor do I know how
to use or create VB code. A solution using macros would
be the preferred solution unless you are able to provide
good instructions on how to cut/paste your suggeested code
into my application.
Can you provide a hint as to what I need to do to have an
Access Application run minimized in the system tray. I
can handle the rest of the implementation.
Thanks