Recent content by cstanley

Another option you can try is setting the Access user-level security privleges on the front & back ends to allow everyone Admin level access for the whole dbase. Give it a shot! Chris

Steve, It was the security of the network folder where the back end was stored - people needed to have read/write access to it. It was a simple fix. Check the "Properties" section for the folder on the person's computer that isn't working to see if they have the correct access. If they don't...

Hello all, I have the following code for a button: Private Sub Command16_Click() On Error GoTo Err_Command16_Click Dim varItem As Variant, strSQL As String DoCmd.SetWarnings False If MsgBox("Are you sure you want to append " & Me.[lstRequirements].ItemsSelected.Count & " records?", vbYesNo +...

Help! I've split my database and posted the back-end on the network, and rolled out the front-end to other users. It works great on my machine, but other users, when they open the front end, get a message that the database is read-only, and cannot make any alterations to the back-end (even some...

Tried that... but how do you get it back into the FE and then link the two? The linked table manager only lists the tables that were in the original split...

Hello all, I am using MS Access security, and it works fine, but I have an asthetic problem... I would like to integrate the login screen/password prompt into my startup form, rather than having someone enter their password to get into the database. Is this possible? Thanks, Chris

Hello all, There is a lot of info about the database splitting process, for which I am duly thankful as I am about to take the plunge. However, I can't seem to find the answer to a simple question - if I (as the developer) want to add a new table or modify the structure of an existing table...

Here's the answer: I made a query to select the individual systems in the table and count the components: SELECT DISTINCT tblComponentCriticality.SystemNumber, tblSystemIdentification.SystemName, Count(tblComponentCriticality.Tagnumber) AS CountOfTagnumber...

Hello all, I have a table (tblComponentCriticality) with the following fields: SystemNumber Tagnumber compclass The SystemNumber and Tagnumber fields make up a concatenated PK. SystemNumber is also an FK for another table, which lists all systems by number and name. The field complcass can...

Thanks, but I'm still getting the same error... any suggestions? Chris

I put the code in the module for the subform, not the main form... does this make a difference? 'Private Sub ckQ1_AfterUpdate(Cancel As Integer) 'If Value.ckQ1 = 1 Then 'compcode.Value = "Critical" 'End If 'End Sub

Hi all, I have put an If statement into a subform in the AfterUpdate property of a checkbox, telling it to update a combo box field if it is checked. All very simple. However, since it is in the subform, whenever it runs the code, it gives me an Active X error. I've looked through the posts...

Wait a second - no it didn't. I'm sorry to say that I don't quite get it - could you explain a little further? Thanks, Chris

Thanks so much! This worked when I removed the iif in your example from the criteria field. Chris

Sorry - it's way too big. Chris