Time based events in Access on hidden form

[adamcbest]

I'm trying to write some code that will run a query every 15 minutes and dsiplay the results. I want this time based code to run and have no one see. I tried the idea of using a hidden form with a time based event, however, the form still shows in the start bar. i want to have absolutely no sign that this code is running. No forms except the hidden one is open at all times. so putting the code in one of the forms the user sees is not possible. Any ideas? Is there any way to add events just to the database itself, rather than to a form or button? Or is there a way that i can keep from having the hidden form show in the start bar? Thanks a lot guys..

 

[PHV]

keep from having the hidden form show in the start bar?
menu Tools -> Options -> first tab: untick windows in task bar.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[adamcbest]

no way to just make the one form not show up rather than all forms??

 

[CautionMP]

adamcbest,
Out of curiosity, in Access 2k if I open a form Hidden with a macro or change the forms [tt]Visible[/tt] property to [navy]False[/navy] in VBA the form no longer appears in the start bar or task bar.

I even tested it with a timer event and had the same results.

Hmmm,
CMP

[small]For the best results do what I'm thinking, not what I'm saying.[/small]
(GMT-07:00) Mountain Time (US & Canada)

 

[adamcbest]

You know. I thought i had it working where the hidden forms wouldn't show. I was like 99% sure it didn't show in the start bar. However, the next day after i was sure of that, it started showing up. Then I started questioning whether or not it actually ever did hide it. As of now it still shows at the bottom. Even when opened hidden. Also tried the Form.Visible=false property and got same results.

Now i do have the .mdb on a shared server drive and multiple people use it. I have no idea why that would make a difference, but the only thing i did in between it working correctly and not working correctly was put the new database live on the server. That's when i noticed the changed. Any ideas?

 

[rubbernilly]

Adam -

I have a hidden form running in a database on a shared server used by multiple people, and that form does not show up in my Taskbar.

Can you make a new form, open it hidden, and see if that one shows up or not?

 

[adamcbest]

ok i just create a random button on one of my working forms that opens a form called "test" that is a totally blank form and has no events attached. This form opens hidden and does not show in the start bar. So i'm guessing that my time based event form has a property or one of the events is making the form show up??

 

[adamcbest]

ok now i put another docmd.openform "test",,,,,achidden in the same place where i have the one that opens the form to perform time events. Now form "Test" does show up in the start bar, but it didn't when I added the button that just opened the test form. I have a splash form that runs code necessary to open forms based on what the windows user login is. the event to open the forms runs in the splash form "load" event procedure. Could putting the code here maybe not allow a true hidden opening of a form??

 

[adamcbest]

ok guys.. i think i got it. for some reason when you opened a form hidden in a "Form Load" event, it would show in the start bar. If i did a splash screen that opened and ran the code to open the hidden form after a second of being open, then it didn't show. Very strange, but oh well.

Thanks for your thoughts, everyone