Search results

I changed the resolution of my monitors to try to match their resolution. In the process I tried the Ctrl Alt Right and then when it didn't seem to work, I changed the resolution of my primary monitor back to its higher original resolution. When I did, I saw the errant menu ribbon floating...

I am not using a tablet, in fact its on off button is grayed out in the windows sidebar. I use a desktop with 2 monitors. This problem has never happened before and it is surely strange.

Just tried Ctrl+Alt + Right and my desktop computer did not respond at all. Tried it with the VBA window in each monitor one at a time and nothing.

2 Wow, that never crossed my mind. Why??

Did the reset and it did nothing. As I do not have the actual "File" menu to reset that is not unexpected.

Yes that is true, but I NEED it in the code window while I was there.

I saw that and was hesitant about clicking on it. Ill try it. Can't be worse than what I have now I guess.

I just did a screenshot of the code window WITHOUT the file menu ribbon. There used to be 3 ribbons and now there are only two.

While going over some code in the VBA for Applications Window I noticed that the File menu is missing. How do I turn the "File Edit View Insert Debug Run Tools Addins Debug Help" Ribbon back on. Thanks for any help. I am using Access 2016.

That i That is correct. It was the Macro settings in the Options section.

That was it? Everything is back working correctly? Thanks for your help.

They are set to disable all macros with no notifications. What should they be set at?

When I tried the DoCmdSetWarnings in the immediate window, it says the Macros have been disabled. Perhaps this is the problem. How do I enable the macros? From within the Options setting?

I actually went out and bought another version (Office Professional Pro 2016) and totally uninstalled Office 365 and then tried the action query again and the Red Run icon again did not function at all. So that is why I believe there is something within my computers settings that has been...

NO. I clicked that on entering the db.

I have been using Office 365 and have not been able to get any Access Action Queries (append, update, delete)etc to work. The regular query works fine, but the "action" ones do not respond to the Red Run Icon at all. When I click on the Red Run icon after having chosen a field to add to for...

Thanks, I got it. It has been a long and interesting ride. Your help has been fantastic. Thanks.

Do you mean by "force it manually" to just place the =Sum[CD1] expression in the footer in a txtbox?

Yes, Sum is available to me in the one you sent to me. In mine originally Sum was grayed out. From what I can see, you just changed the query to add the CD1 and CD2 fields with the code you had sent to me. Then you placed CD1 and CD2 on the report. Is that all that was done. If so, I...

So it seems we have come to the end. I tried to use the Sigma icon and everything was grayed out but Count Records. You used the same icon and Sum was not grayed out. Is there any explanation that you can think of to explain why that might be? I knew about the Sigma icon to sum a field, but...