Search results

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

Yes, I tried that, but it gives me an error message that "this is an invalid string larger than 255 characters" if it is just a ,, and if it replaces that portion of the code with ,", it says "This statement is too complex to be evaluated" Other ideas? Chris

A simple query question (for someone else). I have an option box on a form with three choices. The query I have written takes the numerical option box value and uses it to filter values. The first two choices are specific, but for the third one I want the query to return all the values in the...

Hello all, I have a question for everyone. I am deep into programming a database, with many forms, queries, tables, etc. I was a good boy and drew out an Entity Relationship Diagram for my database, so I know the relationship between the tables. However, I didn't keep good track of what fields...

I've done that, and the compiler picks up nothing... any suggestions? Chris

So close, I think! The data type mismatch error went away, but with this new code, I get a syntax error (missing operator) referencing the Where portion - is there something I need to add? Thanks! Chris