Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Beard36
  • Order by date
  1. Beard36

    Form: Exit without saving?

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

    Form Pop up control

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

    Form Pop up control

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

    Form Pop up control

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

    Refresh Question

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

    Form Pop up control

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

    Hide Taskbar entry

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

    Forms in the Taskbar

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

    Custom Command Buttons

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

    Hide Taskbar entry

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

    Forms in the Taskbar

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

    Forms in the Taskbar

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

    Forms as Taskbar entries

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

    Forms as Taskbar entries

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

    Forms as Taskbar entries

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

    Form: Exit without saving?

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

    Form: Exit without saving?

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

    Form: Exit without saving?

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

    Form: Exit without saving?

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

    Form: Exit without saving?

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

Part and Inventory Search

Back
Top