I'm afraid that the problem I was having with the closing, etc.. above was not solvable by something simple like you suggested (though a variation on what you have posted did represent part of the solution - the problem was, if I remember correctly myself, that when you clicked on Close, as...
I've got to say, is does take quite a chunk of time to get this hiding Access thing working exactly as you'd like it. I only came across the FAQ that you mentioned a month or two ago, and tried implementing it. While it looks at first like it should be really easy, once you get down to it there...
Ah.. I think I may have made a mistake in the advice I gave to you. Would you try using
fAccessWindow "Minimize"
instead of "Hide" and see if that improves matters (using Hide rather than minimize can cause weird things like the toolbars disappearing when Access becomes visible again).
Let me...
No, you use the fAccessWindow calls exactly the same as the macros that you were using before - include one call to it when the switchboard (or whatever the first form is) opens and not in the other forms.
I was just having a play around with this to check out what you mean, and at first I...
One option would be to call a sub each time you want to refresh (ie. based on the timer) which will refresh all controls except for the current one.
eg. create a module and include this code -
Public Sub RefreshForm(Form As Form)
Dim ctrl As Control
For Each ctrl In Form.Controls
If...
I think I understand what it is you want to do. You should be able to do what you want if you change the code a bit. Replace the module suggested in the FAQ with the following (based on that code) -
Private Declare Function IsWindowVisible Lib "user32" _
(ByVal hWnd As Long) As Long...
Thanks for your interest, but in the end it turned out that I had quite a complex problem that couldn't be solved with any one small fix as hoped above. I won't go into it here 'cos I'm sure I'd only bore everyone.
Thanks anyway, again.
Would you then give me some pointers where I might be able to find out more about the solutions you're talking about? I'm quite willing to at least have a bit of a delve into these API's, although my experience is a little limited in these areas.
On the subject of give and take - I have to...
Introduction
In Access, command buttons are generally restricted to the old generic Windows style - even in XP we still have to deal with those dull, grey, square controls. I've come across many questions and answers while I was trying to find what I thought would be the best way to implement...
Is it possible to hide the taskbar entry for an application that is already running (MS Access in this case)? I don't want to hide the whole application (I still want it visible on-screen), but I don't want it to be visible in the taskbar. Come to think of it, ideally I'd like it to be hidden...
I've just read through that thread, but haven't been able to come up with any answers. There was an entry from Stevehewitt which said that he will not only "4. Hide DB window" but also "2. Hide windows in taskbar", which is want I think I want to do.
There is one aside to note here - at the...
In a database at the moment I'm using the code found in the FAQ
FAQ705-2562
which allows Access to operate without displaying it's own window - ie. the grey background is not visible and the forms appear straight against onto the desktop's background.
After implementing this, I decided I...
Update: Just in case anyone cares, I'm nearly there now. I've got this code in a module which allows any form to have it's own button in the Taskbar -
Private Const GWL_EXSTYLE = (-20)
Private Const WS_EX_APPWINDOW = &H40000
Private Const WS_EX_TOOLWINDOW = &H80
Private Declare Function...
I've got Office 2003, so I actually found this in Tools -> Options -> View, but it was already checked. I'm using Windows XP, but have the "Group Similar Taskbar Items" option unchecked.
Although I have the option you suggested checked, it doesn't actually seem to result in seperate taskbar...
I've been experimenting with the code found in the FAQ
faq705-2562
which allows Access to operate without displaying it's own window - ie. the grey background is not visible and the forms appear straight against onto the desktop's background.
Which is great.
But if I've got a database which...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.