 |
|
|
|
Next: Printing date parameters on a report
|
| Author |
Message |
External
Since: Nov 12, 2008
Posts: 61
|
(Msg. 1) Posted: Thu Jan 01, 2009 7:08 pm
Post subject: Access Run Time
Archived from groups: microsoft>public>access (more info?)
|
|
|
I configured Access run time to run my database on other systems. It works
fine, but when I run a command which opens a query, the query stays open and
can't be closed. I believe this is an intended part of runtime to prevent
users from doing any damage, but how can I get around that? I guess one
possibility is to close the query when the mouse focus changes, but I'm not
sure it that's a VBA recognized event and maybe there is another/better idea.
Any suggestions are appreciated. |
|
| Back to top |
|
 | |
External
Since: Nov 16, 2007
Posts: 1727
|
(Msg. 2) Posted: Thu Jan 01, 2009 9:38 pm
Post subject: Re: Access Run Time [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Thu, 1 Jan 2009 19:08:00 -0800, dhstein
wrote:
>I configured Access run time to run my database on other systems. It works
>fine, but when I run a command which opens a query, the query stays open and
>can't be closed. I believe this is an intended part of runtime to prevent
>users from doing any damage, but how can I get around that? I guess one
>possibility is to close the query when the mouse focus changes, but I'm not
>sure it that's a VBA recognized event and maybe there is another/better idea.
> Any suggestions are appreciated.
One suggestion would be... don't open query datasheets *at all*!
Instead base a Form on the query, and open the Form. That gives you a lot more
control over the user interaction.
--
John W. Vinson [MVP] |
|
| Back to top |
|
| |
External
Since: Nov 12, 2008
Posts: 61
|
(Msg. 3) Posted: Thu Jan 01, 2009 10:15 pm
Post subject: Re: Access Run Time [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"John W. Vinson" wrote:
> On Thu, 1 Jan 2009 19:08:00 -0800, dhstein
> wrote:
>
> >I configured Access run time to run my database on other systems. It works
> >fine, but when I run a command which opens a query, the query stays open and
> >can't be closed. I believe this is an intended part of runtime to prevent
> >users from doing any damage, but how can I get around that? I guess one
> >possibility is to close the query when the mouse focus changes, but I'm not
> >sure it that's a VBA recognized event and maybe there is another/better idea.
> > Any suggestions are appreciated.
>
> One suggestion would be... don't open query datasheets *at all*!
>
> Instead base a Form on the query, and open the Form. That gives you a lot more
> control over the user interaction.
> --
>
> John W. Vinson [MVP]
> John,
I'll try to base a form on the query. I would have liked to keep the
number of forms down, but maybe that's a better way. I'll have to play with
it and see what happens. Any directions on what I need to do to base a form
on a query? Create a form and run the query on a form load event ? I would
appreciate any additional help. Thanks. >> Stay informed about: Access Run Time |
|
| Back to top |
|
| |
External
Since: Nov 17, 2008
Posts: 66
|
(Msg. 4) Posted: Thu Jan 01, 2009 10:25 pm
Post subject: Re: Access Run Time [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On Thu, 01 Jan 2009 19:08:00 -0800, dhstein wrote:
> I configured Access run time to run my database on other systems. It
> works fine, but when I run a command which opens a query, the query
> stays open and can't be closed. I believe this is an intended part of
> runtime to prevent users from doing any damage, but how can I get around
> that? I guess one possibility is to close the query when the mouse
> focus changes, but I'm not sure it that's a VBA recognized event and
> maybe there is another/better idea.
> Any suggestions are appreciated.
There is nothing about the runtime that should prevent closing a query.
What happens when they press the red [X] in the corner, nothing?
--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com >> Stay informed about: Access Run Time |
|
| Back to top |
|
| |
External
Since: Nov 12, 2008
Posts: 61
|
(Msg. 5) Posted: Thu Jan 01, 2009 10:25 pm
Post subject: Re: Access Run Time [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
"Rick Brandt" wrote:
> On Thu, 01 Jan 2009 19:08:00 -0800, dhstein wrote:
>
> > I configured Access run time to run my database on other systems. It
> > works fine, but when I run a command which opens a query, the query
> > stays open and can't be closed. I believe this is an intended part of
> > runtime to prevent users from doing any damage, but how can I get around
> > that? I guess one possibility is to close the query when the mouse
> > focus changes, but I'm not sure it that's a VBA recognized event and
> > maybe there is another/better idea.
> > Any suggestions are appreciated.
>
> There is nothing about the runtime that should prevent closing a query.
> What happens when they press the red [X] in the corner, nothing?
>
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
> Rick,
My code is like this:
Private Sub btnChoice1_Click()
' Some code here
DoCmd.OpenQuery "qryEvent1", acViewNormal, acEdit
' More code here
End Sub
So I don't get a red X in the corner. >> Stay informed about: Access Run Time |
|
| Back to top |
|
| |
| Related Topics: | Time in access - I have a simple form that will gather it's information from a card reader. The form has 3 fields SSN which is gathered from the card swipe. Can I make access automaticly hit enter when it hits the last digit in this field, it will always be 11 digits..
back to access after a long time - Ok folks... I apologize now if I'm covering territory already discussed. I'm sick as a dog right now and have got to get some work done on this datbase. Let me explain what I'm trying to do. I work as email tech support fo a computer manufacturer...
Play a sound at a certain time in access - I am looking to play a certain sound in Access every three minutes, then a minute after that (so play a sound after 3 minutes, then 4 minutes, then 7 minutes, then 8 minutes, etc). I know about the "Timer" Function, but I think you can only us...
Limiting User Access by Time - I have a networked database that is used by my department (about 20 users). Each user has a copy of the front-end on their local machines that is linked to the data of the back-end on the network. The problem is that I need to backup the back-end..
access 2007 run time - Does anyone knows when will be available. My app are in Acc 2002, and they don't work on Vista unless I convert them to 2007. |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
