Recent content by Prufrock

I have a situation where there is a range of key indicators that I need to have users select. They may be from different departments and the indicators differ per department, some overlap some don't. I plan a combo box to select their department and then I suspect a list box that gets populated...

I have created a number of ribbons to match specific areas in Access 2007 and want them to appear across the top as tabs like in Office 2007. They are all in the UsysRibbon table I created and working well being applied to appear with particular forms and reports. Now I simply want them to sit...

Thanks for that. Achieves the goal.

Thanks for that. Will be fine up to a point. I am using Access 2007 and have tabbed forms in place for a range of reasons. Currently they can right click on the tab and select Close even if the close button is No as you suggest. Therefore I need to ensure they can't right click close as...

I have a form that is central to my database. Don't want to allow any way to close it (thus stopping accidental closures) except when a user clicks on a close database button. I have the following code in the form unload which works fine. Private Sub Form_Unload(Cancel As Integer) If...

Thanks very much for that. We get there in the end. Double click works fine. Thanks for your persistence.

Many Thanks Ken worked like a charm. Well done.

Thanks for that worked like a charm and saved a lot of wasted time. Array formulas are very cool but take a while to work out. Thanks Again.

Thanks for your assistance but I think you missed putting the formula in?

I have a registration form which allows people to tick whether they prefer to be contacted on home, work or mobile phone number and they list the number in a field. Their preference is a tick box. Fields are: Home Preferred(Yes/No) Home Number(text) Work Preferred(Yes/No) Work Number(text)...

I tried the Frame Approach and it simply locked me out of ticking at all. I just need to allow them to remove the tick if they make a mistake. I want however the idea that you have to have an option if intentionally click in there and choose 1,or,2,or3. Thanks

Hi a quick query I hope. I have an option group because I only want one of 3 choices selected. However if someone clicks in there by mistake and then does not want to make any choice they can't remove the tick by clicking again. Is there a way to remove the tick when accidentally selected...

I have data that exports out of a Govt database into Excel. The problem is that it exports a complete record for each person for each time they have a vaccination in a set of 3. So if they have had Vaccination 1 and 2 you get two duplicate row records except for the Vaccination column. This...

Thanks for your help.

I have used the following Private Sub Form_Open(Cancel As Integer) DoCmd.GoToRecord , , acNewRec End Sub for quite a while to get a form to open to a new record or they can navigate back through records. I am using Access 2007 and find it no longer works. Have tried it in On Open, On...