Search results

  1. W

    playing with commandbars

    GHudson posted a redone db a while back [AnthemNPI] sorry can't remember name of the thread, but it had a button to restore default toolbars. AnthemNPI-Code to Hide/Restore Toolbars - GHudson ====================== Private Sub btnRestoreToolbars_Click() 'ghudson 5/12/2006 'unhide all menu...
  2. W

    Many-many: change to 1-many?

    Fuga, you're right. The relationship never stops being many-many in this situation. Would be one thing for storing historical info on a person but would be awful for keeping track of their membership info in general. Thanks very much for another perspective and for the help!:D
  3. W

    Drag and Drop works great but how do I open a reports based on what I selected?

    don't know if it's any help, our network just got locked down a couple months ago to disallow downloads, ActiveX etc., so downloads are useless but SaveAs/SaveTargetAs still seems to work. Your setup might be different, though.
  4. W

    Many-many: change to 1-many?

    Good point - we thought we would just re-use the name in different groups, but it may mean we need to set up a new application for that person each time. I'll test these & check what happens. thanks very much
  5. W

    Many-many: change to 1-many?

    Hi, hope someone knows the answer to this one...:p We started a new business and built a db for expecting our work to happen a certain way, but now find it's very different and need to change the structure before it's too late to fix. Can someone please take a quick look at this idea & tell me...
  6. W

    Simple Open/Close Audit Trail

    If you've opened the database you can use Alt+F11 to reveal the code. If you still can't see it, make sure the View>Project Explorer taskpane is selected and you can double click any object there to show the code. Least that's what I've been using lately...
  7. W

    Access2000 won't open as a multisuer database

    Hi, I can't offer any help on the coding part, but there is also a weird situation (& posts on the web) where the "open" dialog box of Access automatically keeps opening the same way you last told it to. If someone opens the db by going into Access & clickin on the file they last used, and if...
  8. W

    Phone Number Format problem with Mail Merge

    Hi, We had a similar problem in our Access/Word merge docs with phone/fax numbers and also Canadian postal codes losing their spaces (that one I still haven't found a workaround for). It's pretty easy to correct using MS Word switches in the formatting behind the field codes...
  9. W

    Bound Cascading Combo Boxes in continous forms

    If it's any use, I have come across 2 solutions to this. One is a really interesting workaround by Pat Hartman, where he sets a bound textbox over the cbo (leaving the drop arrow visible) and so it displays the value of the cbo. (FixCascadingCombosWithLabel) The only actual solution of the...
  10. W

    Entering multiple new records (nearly identical)

    Hi, Julie123's post in the Forms section is similar and has examples, if it helps at all. http://www.access-programmers.co.uk/forums/showthread.php?t=110467
  11. W

    Duplicating several fields with 1 click

    Wow - that does it nicely. Thanks again, John!
  12. W

    Duplicating several fields with 1 click

    Ability to copy but not default If you didn't want that as the default, but rather wanted the ability to copy selected fields from previous record when necessary, would you put the code from the above example in a "Copy" button instead?
Back
Top Bottom