Recent content by mlr

Stupid Question of the day... On Form Load = DoCmd.ShowToolbar "Ribbon", acToolbarNo (Removes Ribbon) But Can one still have a Customised Quick Access Toolbar showing? Kind Regards Mark

Found the solution, thanks to vbaInet's post: Kind Regards Mark

On Command Button [Update] = Requery + unhide Form1 then Close Form2: How to I set the focus of form1 [FA003].Field to match that of form2’s [FA004].field? Please see attached. Thank you Mark

Spikepl, I just passed what’s fishing, moving on to what’s water stage…:D

Steve, Thanks, removed the zero & moved the End If

How can I disable the unnecessary Message Prompts when not needed? The form works if the user enters the password correctly, but if a user enters the password incorrectly, ...then enters it correctly, the other Message Prompts (intLogonAttempts-2 & 3) comes up before moving on to where it’s...

I got these Errors 2950 (Access 2007) & 3270 (Access 2010) when trying to open a Print Preview of an Active Form. Did a search and most sites suggest to check the Macro Security, add a Folder as safe in the Trust Centre or to change the setting of the Sandbox Mode in your Registry from 3 to...

Thanks Bob, feeling quite stupid now for leaving the quotes in.

Is it possible to replace the FormName in the DoCmd.OpenForm with a Form Value? I have a table with form names & codes, I’ve made a Main [Continuous Form] Menu listing Sub Menus… x1 | MFN | x2 ------------------------ 1 | FA001| Company 2 | FA002| Employees With Add & Modify Buttons...

Boblarson, Works :D , Thanks also to Marcin & Spikepl

spikepl, I'm not using a command to open a Form, using the Navigation Pane as the selector to Forms & Reports. Thanks

Marcin, The Control Box is No and NavPane still shows, which is fine I just want to block access to it while a Form is open. Once the Form is close the NavPane to be accessible again to choose another Form. ...So can only have one tab/form open at any given time. Sorry should have stated...

Hi, hope someone can help... Is there a way to ‘Deactivate’ the Navigation Pane while a Form is open? I have a Custom Navigation Pane that I want to deactivate while a Form is open, so for the duration of the active Form one can’t click on any other selection on the Navigation Pane then on...

Thank you, got it now

Sorry, maybe I was a vague on what I wanted… On clicking the ‘Add Street’ button, it opens the PopUp Form, then clicking on he PopUp Form Update Button it will close the PopUp & move back New Account Form - here I want it to set focus on Physical Street Name Combo Field. Thanks