Search results

Hi Minty, Thanks for your reply. I will try to answer your questions: Yes, the database is split. The backend is on our computer network. The front end is local. I don't have much more information than that --it's just a normal LAN connection. I am not dealing with huge recordsets at all...

Hello, I am using the following code I found to hide and show my subforms as the tab control pages are changed: Private Sub TabControlMain_Change() 'Set the source object for the subforms as the tab control pages change. This should help to decrease load times on open Dim pgn As...

I figured out how to unhide the navigation panel after some searching. This code assumes you are using hide/unhide buttons on a form: Private Sub btnHide_Click() 'hide the navigation panel DoCmd.NavigateTo "acNavigationCategoryObjectType" DoCmd.RunCommand acCmdWindowHide End Sub Private...

Otherwise my guess is that perhaps the computer is unable navigate to a hidden object type and therefore cannot execute the code unhide it? So I am referring to this line of code: DoCmd.NavigateTo "acNavigationCategoryObjectType" If you want to be able to hide an unhide at will you may have...

Have you considered having your users access the database using Runtime instead? This would hide the navigation bar (and users will not be able to see forms in design view) but everything has to be accessible through a switchboard form.

Ha ha, you never know :D The code had nothing to do with the form mode and I am kind of surprised it caused the problem but seeing as removing it worked, I am not going to analyze exactly what happened just keep moving forward hoping the problem is solved for real. This was the code: Public...

I mean going into the code window (Alt + f11) going up to Debug and choosing "Compile".

So I did that instead but forgot to remove the offending code from some of my forms :o

Yes, I always compile it :) For the record, there was nothing technically *wrong* with the code that the compile would find. Because it looped through the active objects, I think it was causing the error to occur. I wrote the code to put into my forms' On Close event. It checks if any forms...

Ok, so in the process of doing what you suggested I found a line of code to a module function I had written that should have been deleted. I deleted it and now the pop up appears to be working properly. I am fairly sure that is what was causing the problem. Thanks again for your help!

Ok, that works. So what does this mean? It is something else in the form causing the problem?

No, good idea! Will try that and report back.

Yes, I put the "acDialog" part of the code in after the problem cropped up hoping it would help. It is also happening when a new record needs to be created using the "List items edit form" property which does not rely on code to open the form. This is actually when the situation is most...

Hello, I am experiencing an issue with my forms that seems to have cropped up out of nowhere: the forms are not opening in modal/dialog mode when they should be. The forms' pop-up and modal properties are set to "yes" The code specifies to open Dialog so, for example: DoCmd.OpenForm...

I finally fixed this. I had a sneaking suspicion that something with Office 2010 was conflicting with Access 2007 since I checked my coworker's computer (Office 2013) and the export to Excel was functioning properly. Besides the export to Excel issue, I also started getting other weird...

Point taken but Windows is just going to reinstall them when I reboot anyway so it is not a huge deal. I wanted to see if it would make a difference since the timing of the updates coincides with the report to Excel function not working but it didn't. I don't want to reinstall Access for...

Nope I was mistaken. I am going to give up now. It's not worth it...

I uninstalled most of the updates and it is now working. So I am getting closer....

I just checked my Windows update history and there were dozens of updates that were installed on 7/11/2014 both for Access 2007 and for Office 2010. I am thinking one of these--or some combination of several updates--may be causing this sudden issue.

Yes, my thoughts exactly. Thanks for all your help :)