Search results

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

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

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.

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

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

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

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

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

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

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

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

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?