Search results

@isladogs, same here with Access 2010-365, 32/64 bit, Win7/Win10, Cel 2GB/i7 16GB. An additional challenge is the frequent updates with new reports and uploads to portals - mine is a payroll app. Can I see a demo of your school app?

Thanks Isladogs, so vba cannot change that setting. Remove the ribbon completely - I invested too much time in it to throw it away, and my users like it. This morning I checked 5 computers and found that by default that box is unticked, so the problem may be much smaller than I thought it was...

in Access 2010: Options > Client Settings > General > Show add-in user interface errors

Application.SetOption "Show Add-In User Interface Errors", False returned an 'invalid name' error. The list of DBguy deals with the Current Database tab, while the option I'm looking for is in the Client Settings tab. However, in his May 2018 blog (https://thedbguy.blogspot.com/2018/05/) DBguy...

Thanks! Application.SetOption "show add-in user interface", False returns 'invalid name' CurrentDb.Properties. <- what to write here?

Hi, I finally managed to get the ribbon's File menu to work by removing all of Microsoft's options and adding my own. I just found out that I have to turn off the setting "show add-in user interface" for all of my 300+ users, to avoid a "Custom UI Runtime Error". This error gets triggered by...

Very sorry, moderator, I thought I could delete it before anyone saw it. I had searched all over the forum in vain. After I posted my question, the links appeared below it, so I removed my question as it had clearly been answered before.

Hi, a year ago or so I found a list of function declarations for 64-bit. I didn't bookmark it and can't find it again - does anybody know where I can find it? I'd like to verify this bit of code: #If VBA7 Then Public Declare PtrSafe Function GetKeyState Lib "User32" (ByVal nVirtKey As...

I just had a go at it but haven't been able to capture the Print Preview Close button yet. I may have to redo the XML code that I'm using for the Print Preview button. Now I'm using this as the second record of the UsysRibbons table: <customUI...

Thanks Micron, I have to do something about the flashing indeed. You mean the OnAction of the Print Preview's Close button, right? Thanks, I'm going to try that!

Hi, below the code that I use. Here's a demo clip if you want to see it in action: https://www.dropbox.com/s/rhoqgmtcxmnmxle/DemoReturnToTab.mp4?dl=0 ' in USysRibbons add keytips to each tab, for example <tab id="tabPayments" label="Payments" keytip = "H3"> <tab id="tabStatutory"...

Re the need to have a particular tab opened on the main ribbon: My main ribbon has 9 tabs. Four of these with tabs Payments, Statutory, Summaries, HRM have reports. So after running a report it is good to return to the particular report tab, so that a similar report can be selected. Rather...

I found a solution - there's probably a better way but this works for now. When closing the report, it opens a form that uses its ontime property to wait half a second, and then runs the fSetRibbonTab function. Have to add this to 130+ reports, but hey, it is weekend and it is raining.

Thanks, when you close the report the Preview ribbon is still open, so you cannot yet select a tab in the main ribbon. I read Avelino's notes, he doesn't explain from where to fire his function Public Function fncSetFocusTab()

Eight years later and I can't find a single solution for this anywhere! I can get the tabId, I can open that tab, but cannot find a way to trigger that event. I guess it is so simple that nobody bothered to answer...

Thanks for looking into this, I found the problem. When running the callback code global variable gstrLevel had been set in accdb, and apparently not in yet in accde. After setting it at the very beginning there are no more errors.

Hello arnelgp, I put in your code and got the same result: ok in accdb, errors in accde. It looks like a timing issue.

In the meantime i have found out that replacing the dlookup with a global variable will work. This means that i have to set about 50 global variables before loading the ribbon.

Enabled = varValue?

Hi Arnelgp, 'replace the Enabled from your Select Case with varValue.' You mean I should use