Recent content by Bears84

Thanks I have recieved the information. hopfully there is a step by step section.

To All Is there someone out there that can give me step by step instructions on setting the securty on my data base? I am lost as a goose on this one. When I run the wizard it created a workgroup in the folder with the db. The db will let me in but will not allow anyone else to enter even after...

All or Anyone At this time working on securing my data base. I have run the wizard and filled in all the information. And said finish. It has and now will ask me for my name and password at start up. This part works well. The problem begins when I try and add people to the user list using the...

I have a form that is populated by the following SQL Statement attached to a form with drop down boxes Public Function Makefilter() As String Dim UnitStore As String Dim checkbox As Boolean If Me.cbxUnit = "" Or IsNull(Me.cbxUnit) Then UnitStore = "*" Else UnitStore = Me.cbxUnit Dim...

I have a form that is populated by the following SQL Statement attached to a form with drop down boxes Public Function Makefilter() As String Dim UnitStore As String Dim checkbox As Boolean If Me.cbxUnit = "" Or IsNull(Me.cbxUnit) Then UnitStore = "*" Else UnitStore = Me.cbxUnit Dim...

Thank all who have helped me with this effort

Why is this telling me it can not find the form? Private Sub booleanInScope_Click() [booleanInScope] = Forms![subfrmCoordinatorApproval]![txtID] End Sub The form is in the forms and I can open it in form view

To begin let me think all who have help me in the past!!! As of now I am trying to go back and secure many of my data bases for one reason or another. The first is due to individuals authorizing work to be done and not have the authority to do so. I have a database that many people use to...

I am very confused so far. I have not been able to understand how I am to get the other mdb's associated and linked via hyperlinks with my primary mdb to relize I do have the permission to use them. Can someone help me to understand what needs to be done.

"C:\Program Files\Microsoft Office\Office11\MSACCESS.EXE" /wrkgrp "C:\Test\MyWorkgroupFile.mdw" "C:\Test\MyTestDBFrontEnd.mdb" /user UserName "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "S:\QCPublic\Welding Data Base\Welding Data Base.mdb" /WRKGRP "S:\QCPublic\Welding Data...

I did rename the text box to Txt prefix as suggested. I can make this a yes/no box if needed no problem. But I still can not get the No to fill in on all the records that have no Coordinators Int. on the continuous form. Named (frmissue). I can type it in each one. Just no auto update. And...

I have used the shift key to open the database and it allows me to do what will with the main database. The problem is when I try to open the linked databases I am unable to do so. What do I need to do to correct this problem. All of the databases are on a server with regular backup. Did I...

I have locked down my welding data base and had some problems arise mabe someone eles has had this problem. All of the tables in other data base that are linked to the welding data base now will not allow me to utilize them I get the error message that I do not have rights too that information...

Is Approval a (True/False or Yes/No Field?) or Text Field? I have changed it to a text field. The one thing that I have not mentioned is this table is in another data base and is linked to the one that I'm trying to make the chances in. I am intending on securing that data base so that only...

Run time error You can't assign a value to this object. Me.Approval ="No" (Hightlighted) Private Sub Form_Open(Cancel As Integer) If IsNull(Me.[coordinator name]) Then Me.Approval = "No" Else Me.Approval = "Yes" End If End Sub