Search results

Thank you for that explanation. Looks like I have some work to do. In answer to the question regarding data, I am creating this for our quality department to use to manage the root causes of things that require an investigation. For instance, the first level "cause" in this case isn't really a...

Some 3rd level records have 4th level options, some don't. A self referencing table is a new one for me, I'll have to study that.

I've built my first attempt at this idea. I have a 4 level cascade set up and its working as intended, but one issue I have is some 3rd level options don't require a set of 4th level options, and some do. My table structure is tblFirstLevel FirstLevelID FirstLevelName tblSecondLevel...

Yeah a couple of us (we're a pretty small outfit) have been after the boss to do this for a while. Neither of us are any great shakes in the IT department, though we are all we've got, but figure we could sort out setting one up.

The shared folder we use is a solid State Hard Drive connected via USB to a Netgear router. Setting permissions, and consistent access to this thing has been an issue from the day we installed it. By way of experimentation, I recreated the entire database setup within a shared folder on a PC...

Yes. See attached.

When attempting to open lock file with Notepad, I get "Access denied".

I'm testing with one user who has Access, (His installation is set to Shared, no locks), a second with just the Runtime, and my own PC with Access (Shared, no locks). Yes, each user has their own copy of the FE. I've set the permissions on the BE folder to "Full Control" and allowed that to...

The db opens in the runtime environment. Still won't allow multi user.

FE created after setting accdb file to "Shared". Forgot to mention, I also tried the Default Record Locking option of "Edited Record" to no avail.

Access 2010 Split DB with the BE on a shared drive Runtime file created by copying and renaming accdb file after splitting. All FEs are accdr. Each user has their own copy of the FE Each FE works. BE Client Settings Default Open Mode 'Shared' Default Record Locking 'No Locks' Client Settings...

Thank you. I need to stop relying on macros and start forcing myself to use vba.

In the past I've successfully used this technique to control locking of combo boxes, but can't seem to get it to work for enabling or disabling a button. Scenario: 2 forms frmLogin, and frmMainNavigation The login form has a combo box that includes a column for Access level, with a value of 1...

Maybe I'm not conversant enough in this data type, but this type of field seems to make using it in forms and reports cumbersome. I often create databases that are to be used by folks that are much more familiar with the look and feel of Excel, and they love their Y/N or Yes/No columns. They...

Stumbled upon this, and it seems to work. Am I on the right track? Forms!frmSomeFormName!cboListOfThings OR Forms!frmSomeName!cboListOfThings Is Null

I'm in the process of building a record filtering query tied to a search form. I've only done this once before, and I used the actual text (aka Name) rather than the Primary key for the search criteria, so I was able to get away with using a combo box and this in the query criteria Like "*" &...

You have given me some food for thought. If you have time can you expand and explain this passage a bit?

I added the update query because without it, the table field values wouldn't update if changes were made after the first time they were populated. EDIT/ I took out the code to run the update queries and now the values are all updating, and the warning is gone as well. /EDIT Lord have mercy, I...

Its a bit of a mess as I'm early on in this, but here's the whole thing. EDIT/ Focus on the form ExistingInvReportF /EDIT Sorry, should have pointed that out.

Yes I have. It breaks the cascading combo boxes as well.