Search results

I also meant to thank ypma for giving me this coding tip. Thank you!... If Not CommandBars.GetPressedMso("MinimizeRibbon") Then CommandBars.ExecuteMso "MinimizeRibbon" End If

nschroeder - SUCCESS at last (more or less)! To get the program to do what I wanted I did the following two things... First, I went into the Customize Ribbon Options as per your suggestion and I hid ALL of the Ribbon Main tabs except the ‘Print Preview’ tab. (Again, my rationale for doing...

nschroeder - Thanks again for the tip, I will certainly give it a try, however hiding the ribbons through the Office Menu options will probably be an 'all or none' fix. My problem is that there are times when I want to hide the ribbon and other times when I want to show the ribbon. Don't know...

nschroeder - Thanks but the thing is I don't want my users to see the ribbon at all for fear they will just start pressing the icons to see what happens. The only time I want to display the ribbon is on the 'Print Preview' screen so they can close the window. In Access 2000 I could use the...

ypma - Thx for the tip, works great. I have another question though, how can I Maximize the Ribbon as CommandBars.ExecuteMso ("MaximizeRibbon") does not seem to work. The reason I ask is that I use a 'Print Preview' function on one of my screens but the ribbon always comes up minimized and...

Hello, we just upgraded to Access 2010 from Access 2000. Most of my users are volunteers who know nothing about Access or databases and so I like to restrict them to as few options as I can - including MenuBars and ToolBars. In Access 2000 I coded the following to hide (and show) MenuBars...

Paul - Good morning, I added the Microsoft DAO 3.6 object library to the References library list and things worked fine (I did not even have to change the code to 'DAO.Database'). Thank you! However I do have one other problem. I normally hide all of the Toolbars and Menubars because I don't...

Paul - Thanks so much for your prompt reply and the tips. I will try them first thing Thursday and let you know how it goes. Thx again.

Hello, we recently upgraded Access from Access 2000 to Access 2010 (please forgive us for not upgrading intermediate versions of Access but we are a non-profit organization with limited funds) and I am encountering some problems which I am hoping you can help me with. I was getting a ‘missing...

JLCantara - Thanks for the tip, worked like a charm.

Hello, I’m not sure if this is an appropriate question for this forum but I downloaded the ‘Access 2007 Runtime’ program from Microsoft’s Download Center onto a PC which does not have Access. I then installed one of my Access applications but when I try to run this application I get the...

Beetle - Sorry for not getting back to you sooner but I just wanted to let you know that the 'cancel' statement in the BeforeUpdate event worked perfectly. Thanks again for your help!

Beetle - I did not cancel the event, I will try again first thing Monday. Thx!

Beetle - Thanks, but if I remove the SetFocus command in the BeforeUpdate event I am back to square one - the cursor tabs to the next field (JPGC) in the event I find an error.

Bob - Good morning, when I use the BeforeUpdate event I get the following error message.. "Run-time error: '2108' You must save the field before you execute the GoToControl function or the SetFocus method." Looks like a Catch-22 - any other ideas? Thx.

I will give it a try first thing Friday morning. Thx!

Hello, I have a Form with the following four fields - JPGA, JPGB, JPGC and JPGD. The tab sequence for these four fields is 1, 2, 3 and 4 respectively. I use the ‘AfterUpdate’ event procedure to do some data validation and when I find an error I want to be able to focus the cursor back to the...

I will try this on Monday as it would be nice to get the SELECT statement working for future use. My Tables are not SQL tables, will that make a difference? I used to write programs in the ancient language of COBOL and we had two simple statements to read a file (table). One was a 'MOVE'...

Kiwiman - AWESOME tip! The Dlookup works like a charm. Forget the SELECT statement, thanks again!

Thanks but this did not work, there was no debug error but the Family name was not retrieved. For what its worth the following code works perfectly... Sciflat.MoveFirst Do Until Sciflat.EOF If Sciflat![Genus] = Me.LAGE Then If Sciflat![Species] = Me.LASP Then...