Search results

Here is the rest of the post: Once the xml code is in the table, set which section of code to use in the ribbon either in the properties of a form (On Open) or in the Form_Open section in your code. For example, add to Form_Open: Me.RibbonName = "PrcPreview" DoCmd.ShowToolbar "Ribbon"...

billgyrotech: Once the xml code is in the table, set which section of code to use in the ribbon either in the properties of a form (On Open) or in the Form_Open section in your code. For example, add to Form_Open: Me.RibbonName = "PrcPreview" DoCmd.ShowToolbar "Ribbon", acToolbarYes to...

You will need to create a table that is auto-hidden to change the Ribbon. I suggest searching on Gunter Avenius for Access Ribbons. This is XML code in a table: Name it: USysRibbons There are three fields: ID (Long, Autonumber), RibbonName (t, 255) and RibbonXLM (memo) While this site may...

I've seen these undocumented break points in code since Access 2003 and continue through Access 2010. The only success I have had is to stop on the code line producing the stop and remove breakpoints (Debug menu, Clear all breakpoints) but then force an empty line in place of that location by...

David: Access does not handle Sendkeys well. The most often problem is it shuts off the numlock key. Other quirky behavior is the cursor will drop to the bottom, top or be hidden. In short, stay away from sendkeys. EWC

This is an undocumented tip I found: (Add once at start up and add this after every attach / link to external tables) ' hide the navigvation bar DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand acCmdWindowHide ------- The above works because it points directly to the navigation...

Access 2010 Tips I learned with the help of others. Some excellent websites to manage the ribbon: accessribbon.de/en/?Access_-_Ribbons allenbrowne.com/tips.html Also, the Access Web and Dev Ashish provide great API support that was written for prior versions, but is still very usable and...

DDE commands are particularly difficult. Registry is used to control the launching of programs and I have found an error with no cause. I did research and found a solution. The error that might appear in Access, Excel, or Word is: "There was a problem sending the command to the program". It is...

For billable hours, I use the following. Replace both "15's" to any other time (30, 60 etc) for other rounding schemes. You also need to edit the half-time to add (7.49) if you use a different round up number (30 would use 14.99 as a half time (roundnumber/2 - .01)). - ActivityTotal is the...

While I never did figure out why the error occurred, the error most likely is caused by a hidden admin login in a Workgroup Admin account (without you even setting one up). The fix for me was to create a new blank database and import all objects from the damaged database. Rename your old DB...

From the Microsoft site, follow the following: On the Tools menu, click Options. Click the Edit/Find tab. Under Default find/replace behavior, do one of the following: Select Fast Search to search the current field and match the whole field. Select General Search to search all fields and match...