Search results for query: *

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...

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...

Are you trying to get acPrompt to work to ask if you're sure you want to Exit and Discard changes, etc..? If so, I think the easiest thing to do would be to use a msgbox in the code that's called when the button is pressed. You could just ask every time they press Discard whether they're sure...

Well maybe I'll be able to share some of my experience here then! The first problem is that the save options with DoCmd.CloseForm only refer to (so I understand) design changes on the form - not the actual data. Can you give a little more clarification re: what isn't working with the buttons...

Sorry I've taken so long to get back to you on this. I've been mad busy this week. I have been able to try what you've written above, and had a play around with it. It has given me some ideas that I might be able to experiment with in the future, but with the current workload I don't know if I...

The form does not have subforms and the table doesn't have a primary key.

I'd be interested to see how I'd go about setting it up. I think I'm mostly happy with the current set up, but if there is a better way I'd certainly like to consider it. (ie. I don't want you to have to go crazily out of your way, but if you could give me some pointers on how I would manage...