Results 1 to 2 of 2
Thread: Application window (2003)
2006-08-24, 03:38 #1
- Join Date
- Jul 2006
- Colorado, USA
- Thanked 0 Times in 0 Posts
Application window (2003)
I have a time tracking database that I threw together for my team. It can be added to their startup folder. It consists mainly of two forms: one form that stays open all the time, but is minimized. It is there only to have an OnTimer trigger to open the other form every minute. The other form has a list box and a few other controls. What the database does is this: Every minute the one dialog box will open with a list of tasks in the list box. When one of them is selected, an entry is made into a table with the task and time. If no entry is selected within a minute, a warning is popped up and the computer beeps. If no entry is selected within a minute of that, a notice is popped up that an email is being sent to the boss, and an email is sent. There is a button to input time outs for meetings, breaks, etc. that will suspend the reporting for the time specified. Reports can be pulled detailing what was being done at any time of the day and totals can be obtained. Now for the questions:
I don't have VB, otherwise this would be easy, but, Access is just one big MDI window that the forms fit in. Ideally, it would be nice to have the main window stay minimized the whole time and just the one form open every minute. Is there a way to do this without API calls? Or should I just maximize the application window and await input and then minimize the application window? Any other suggestions?
Oh, by the way, I won't tell them it is a joke until after training them on their new time tracker. <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
2006-08-24, 05:11 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 Posts
Re: Application window (2003)
I don't think you can show a form while keeping the application window hidden or miniized without using API functions.
I wouldn't want to be near when the database is launched. I don't think it'll survive longer than 5 minutes...