Search results

I have a call to LoadNav in Private Sub Form_Load(). Should I put this call in Form_Open()? And it is username/password authentication, so it will always be one of those users.

I have looked everywhere for a solution to this and I always get that same answer, set the RecordSource property of the form with FormName.RecordSource = "RecordSource", however, when I do this, I get nothing from my form. Here is some background. I created a form using the wizard and...

Alright that got it figured out...The column used to be named "Name" in tblEAD, but I changed it to Permittee because the "reserved access word" reason. However, somewhere in my code it is still referencing this, so I just changed it back to name and everything works fine.

I have a subform that will change what it contains based on which user logs in to the database. This is done by changing the record source of the subform. It worked at one point and now it is having problems. Here is my code: Private Sub LoadNav() If currentUser = "AC" Then...

I have a dashboard program with a "navigation" menu on the left. This "navigation" menu has labels that are filled in at runtime with one field of a recordset. I want each label that is filled in to then link back to the record it represents. Is this possible to do, and if so, what is the...

Here is my problem... I have a form (frmWelcome), which contains a subform (frmNavigation). My goal is to read a bunch of values from a record source into an array. Then I want to list each of these values in the subform, but list each one in a separate label so that it can be hyperlinked...

I am designing a dashboard for our Access database that we use at work. The goal of this dashboard is to provide a more graphical view of the information in the database and make it less likely for a user to intentionally/unintentionally change values in error. The approach I am taking to...

Re: Tables and Queries Not Showing Up (Really Important) - SOLVED! Alright, this thread can be marked as solved or whatever, because it was an issue of performing a compact/repair action on the databse. Doing this brought everything back, and I now have it set up to perform this action on...

Thanks alot, I have managed to pull up the tables and the queries in the database. I did this by taking the shortcut that I mentioned earlier and modifying the code for it to shortcut to each object(table, query, etc..), but still can't get them to show up in the listings. We did go to IT and...

Thanks for your reply. I am using the 2003 version btw, and I did already try showing hidden object to no avail. I have zipped the database and attached it, please take a look at it and let me know if you have any ideas.

I have an access database that has 3 tables, about 12 queries, and 1 form. The database is stored on the network at my job, and me and the other engineers use it throughout the day. Every night, the entire server is backed up by IT. Yesterday, before leaving work, the file was fine and...

Security isn't really an issue in this case. It is a group of 6 or 7 people and everybody is allowed to edit all fields (all trusted users). The problem with forms is that you either have to scroll through the records to find the one you want to change, or add some find/lookup procedure to...

This is how it is set up. There is a main table with all of the information. Then there are 10-12 queries, each specific to the user that is using the database. There is a form, but it is only used for putting in new entries. Typically, a user will go into the database, pull their query, and...

I have an access database set up with a main table and several queries. This database is on a server at my work and all of the employees constantly update the status of certain things in it. I want to write some type of VBA that will automatically send me a report whenever something is...