General :: Navigate Pane Of Database Is Disabled
Dec 6, 2012I need to modify the access 2010 database. But when I open it the navigate pane of that database is disabled. How to make it enable?
View Replies
ADVERTISEMENT
General :: Locked Database - Hiding Navigation Pane
Sep 3, 2013I've got a database that is locked down for all users with forms so they can navigate the system and the navigation pane is hidden. On a couple of the forms there are buttons to print the form and when that button is clicked it unhides the navigation pane...???
View 2 Replies View RelatedGeneral :: Error Using A Subform To Navigate
Dec 30, 2014Basically what I am doing is duplicating a split form. I am not using a split form because I want to be able to have better control over the bottom half, and I am giving the end user a slightly different view of the same information in the bottom pane.
I've created a form with a subform. When the user moves through the records in the subform, I want the parent form to navigate with it. Note the parent child relationship does not apply here.
I've almost got it working fine, but there is a bug. It seems to originate when the user clicks on the subform ID field while the cursor is the cross, like the Excel fill symbol. Now if the focus is on the subform where ID=2, when the user moves to the parent, the parent navigates away from the record for some reason.
I've noticed that the GotFocus event is firing multiple times, and some of the events are nested. I've tried to set a flag to prevent the nested events from firing, but the bug persists.
Ability To Use Arrows To Navigate Between Records In Database
Dec 8, 2014I had set Data Entry to True in order to always default to a blank record. However that locked up my ability to use the arrows to navigate between records in the database. Is there a work around?
View 9 Replies View RelatedOpen Database With Macros Disabled.
Jul 2, 2007Hello,
I have a 'legacy' Access DB which I need to get into.
Unfortunately there is a problem, whenever I try to open it (using MS Access 2003) there is an error (Disc/Network error 3043) and the database closes immediately.
How can you open an MS Access db with all macros/vba etc disabled, so that the code causing the error does not execute and I can find out what is going on ?
I have not been able to find any such options in the MS Access 2003 open dialog or menus.
Thanks,
Andrew
General :: Use Buttons To Navigate And Open Current Attachment
Apr 3, 2013Is it possible to use buttons to navigate/open attachment? I have two tables (itemTbl and ItemcomponentTbl) and a form.
Inside formare itemtbl field names (w/c include the attachment) and a componenttbl subform.
Here is my DB.
Modules & VBA :: Allow A User To Navigate To A Text File And Import It To A Database
Aug 19, 2013We have a function that will allow a user to navigate to a text file and import it to a database. I've been asked to make it import ALL the text files from all sub-directories in the directory IF they've never been imported before (based on FileName and LastModifiedDate). I've set up a table to track what's getting imported (tbl_ImportHistory). I'm thinking what I need to do is use the previous coder's GetFileName function in a recursive loop removing the navigation request and adding the comparison and then, if it imports the file, the name and date need to be added to the tbl_ImportHistory table. But I'm completely unsure of how to do it.
I'm posting the GetFileName function below. I believe once I've got it modified the rest of the code can be left intact as it just parse's and loads whatever file is selected in the GetFileName function.
<code>
Function GetFileName() As String
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.AllowMultiSelect = False
Dim vrtSelectedItem As Variant
[code]....
General :: User-based Security Disabled
Sep 24, 2012I have an Access 2003 db being used through Access 2007 in order to use user-based security.It is a spit db with the be being on a shared server.For some reason, the security login has been deactivated after working fine for over a year. The user goes right to the autoexec macro file without having to log in.
They are also getting a "Read-Only" message at the top about only being able change table in linked tables.The DB is configured to utilize the logon as a parameter in some queries.
General :: Can't Run Make Table Because Mode Is Disabled
May 17, 2013How do you establish the Mode. I can't run a Make Table because the Mode is Disabled and blocking the action
View 1 Replies View RelatedGeneral :: How To Make Previous Rows Disabled In Subform
May 26, 2013I want to disable the previous row in the subform the moment I do a new row to prevent the user from editing information other users put before. Is it possible.
View 4 Replies View RelatedGeneral :: Create MDE With All Menus And Shift Key Access Disabled
Jul 18, 2014How I can create an MDE with all options disabled including shift key bypass.
I want to remove all options in Tools>Startup except for the status bar.
I have tried using this code but am not getting anywhere with it
CurrentDb.Properties("AllowByPassKey") = 0
Switching Between Navigation Pane And Content Pane
Apr 20, 2013I'm building a web application that mimics the keyboard navigation of Microsoft Access.
What is the keyboard shortcut that will move the focus from the navigation pane on the left to the content area on the right? I can't figure out how to do this in MS Access without using the mouse.
General :: How To Put All 3 Tables Into One Navigation Pane
Jan 1, 2014I have three access 2010 tables, each standing alone with their own navigation pane, etc. Is there a way that I can put all 3 tables into one navigation pane? What I need is to build a Switchboard where each of the 3 tables are my choices .
View 2 Replies View RelatedGeneral :: Navigation Pane Is Grayed Out
Dec 9, 2012I tried to modified access 2010 database. But I open it the Navigation Pane is grey out (disable) and I cannot to see any database object. How to make the Navigation Pane active?
View 1 Replies View RelatedGeneral :: Lock The Open Navigation Pane?
Jan 9, 2014I want to keep the navigation pane open for use by the users, but I want it locked so that the users can't click on the top menu and change the pane's display from All Access objects to any of the other choices.
LockNavigationPane set to Yes is not the solution as this only prevents people adding, deleting and moving objects (such as tables/querys/forms).
General :: Programmatically Hide Navigation Pane
Aug 20, 2012Is there a way to programmatically HIDE the Navigation pane?
Something in the line of :
Application.Currentdb.Options("NavPane").Display = False
General :: New Objects Created Don't Appear In Navigation Pane
Oct 30, 2013I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new database container, decompiled, compact & repair, and nothing works until the I delete some objects (forms, reports, queries, etc).
New objects created don't appear in the navigation pane until I close and re-open. Also, changing a query type from select to append doesn't result in the icon changing in the navigation pane.Code seems to run fine and everything else appears OK, but I really can't continue development until this issue is resolved. I fear continued development may lead to further corruption.after 20 years, this application has grown, I use a variety of techniques to get the size of the application. Currently:
1. 201,200 lines of code in 910 modules, reports and forms.
2. 544 forms
3. 328 reports
4. 3,617 queries (yes, I know, but it's so much work)
5. 450 tables (about half are linked)
I always thought, without thinking too deeply, that the number of objects in the spec refers to the number of reports, forms, modules, etc. But, now I'm wondering, do they also mean all the controls on the forms, and or the fields in the tables? What do they mean by objects.
I used Point Limited's translation modules recently to extract all the label and caption text for a French language translation project and it pulled out something like 21,000 individual controls, and, combined with this issue, I'm beginning to wonder...
General :: How To Auto Hide Navigation Pane
Jun 27, 2012Can the navigation pane be set so it is automatically hidden?
View 1 Replies View RelatedGeneral :: Locking Navigation Pane In 2013
Aug 12, 2015I need to lock down my DB so that the users cannot open the navigation pane. The DB opens with an AutoExec that puts them on a Swithboard form.
View 3 Replies View RelatedGeneral :: Minimize Navigation Pane And Upper Tabs
Jun 25, 2012Is there a way to minimize the navigation pane and the upper tabs on start up? I have several big forms that don't seem to fit unless these are minimized.
View 5 Replies View RelatedGeneral :: Navigation Pane Hides New Queries And Reports
Nov 29, 2012Whenever I create a new query or report, it automatically becomes Hidden, and the only way that I can see it (still as hidden) is to close out of Access and then go back in.
View 2 Replies View RelatedGeneral :: Renaming Tables / Queries Using Navigation Pane
Feb 6, 2014I understand the principle of renaming the above of using the navigation pane and selecting the object but what is happening in my case is that when I select the specific table/query I wish to rename, the text is highlighted as per normal but the instant I move the cursor onto that cell that whole panel highlights in red and then reverts back to the original state of just the text in that panel (now highlighted).
I do not know if this is related to the problem but I have a text box with the "code" =Count([tblEntries].[CageNo]).
This was working perfectly okay but both this and the renaming appeared to happen about the same time. I have opened other Access files and the same re the renaming occurs. I have secure security running and do not think this could be the problem but anything is possible.
General :: Objects Not Visible In Navigation Pane For Power Users
May 29, 2015We are encountering a problem that started with Access 2007 and continues in 2010 and 2013. We are using a network system.mdw file with mdb databases and the security seems to be working with one exception while running in Access 2007, 2010 and 2013 but runs fine in Access 2003. We have some power users who are allowed to create/modify objects. The power users and Admins have a unhide command button that displays the database window in Access 2003 and displays the Navigation pane in 2007-13. The problem is that when the Navigation pane is shown there are no objects displayed. These are not hidden or system objects and display in Access 2003 database window properly for the power users.
View 1 Replies View RelatedGeneral :: Rearrange / Move Custom Categories In Navigation Pane
Oct 15, 2014I use custom categories in the navigation pane to make finding the right objects easier (duh) but now I have quite a lot of custom categories and they are stuck in the order they were created in.
I would like to rearrange them into some logical order (maybe alphabetical, maybe custom) so i can find the categories quicker.
General :: Modules Not Appearing As Object Types In Navigation Pane
Apr 19, 2013I am now working on this new database. I would like to make a calculation so that I could derive a value called eGFR from a patient's serum creatinine. This is a test of kidney function.I am having the following problems.
a. Modules are not appearing in the Navigation Pane of the Access 2007. When I press 'Object Types' in the Navigation Pane I get all object types such as tables, queries, forms, reports, macros but not modules. I know there are modules as I have written lots of vba code.
b. I have written the following code within this Function. The following is the code.
Public Function eGFR(creatinine, Gender, Age) As Single
If IsNull(Age) Or IsNull(creatinine) Then
eGFR = 0
Else
[code]....
This code is working fine in another database, however when I try to upload a query in the current database that has this function in one of the fields, I get an error saying the the function eGFR does not exit.
I have inserted the function into one of the modules that I have managed to enter.
Do I need to deposit the code elsewhere? How do I access Modules from the Navigation Pane?
General :: Hide Table Pane Navigation Ribbon And Main Form Tab
Jun 2, 2015i have built an application , all i have is one main form and every action take place inside it. Before making it as .accde file for code protection, i want to hide table pane, navigation ribbon, the Main form Tab. i.e only Main form should open like a applicaiton and not inside access as a tab.
View 1 Replies View Related