Search results

My database is split (front end; back end). The back end is on a server with a password. The front end cannot be accessed with Ctl Shift and the toolbars and navigation is turned off. How do I prevent someone from opening a new db and simply importing the files from the front end named above?

Let me try this a different way. I have a table (I get from another data source as an Excel spreadsheet). The spreadsheet lists all our customers (SSN, Name, Email, Office, and Supervisor SSN). Before I import the data into our database, I would like to replace the Supervisor SSN with the...

I hear you; however, table 2 isn't a permanent data set. It's a linked table that changes every week. It's more or less a look-up table, which transfers data into the table I'm working. Thanks

In table#1 I have a field (SSN). I want to match SSN, in table#1, with the same SSN in table#2, then extract the email (field) associated with SSN in table#2 and place in table#1. Can you tell me or point me in the right direction? Thanks.

Thanks ... you got me thinking. The solution is to create two groups. Thank you very much!!

I'm building a report where I want to show all the MissingItem (tblMissingItems) on for each person in tbleOutbounds (see atch relationships). I don't know how to link the report and subreport. I tried ReloID from tblOutbounds with ReloID in tblMissingJunction, which works but if there are 5...

I have a form with an option that runs queries to filter the view. Case 3 asks for information from the user [TechnicianName]. If the tech's name is provided everything works fine. However, if the user cancels the msgbox then I get a 2101 error. I tried trapping the error but this too was...

The table has a many to many relationship with the primary table. Will the data have the relationship if added directly to the table?

I want to add several records to the subform. This works until line 4 (error 2105; can't go to specified record. Can't I keep adding records? Me.frmMissingItems_Subform.SetFocus DoCmd.GoToRecord , , acNewRec Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "1"...

Got it to work ... thanks Minty Me.frmMissingItems_Subform.SetFocus DoCmd.GoToRecord , , acNewRec Forms!frmPCSTracker!frmMissingItems_Subform!MissingID = "21"

Thanks for the reference Me.frmMissingItems_Subform.SetFocus DoCmd.GoToRecord , , acNewRec Me!frmMissingItems_Subform.frmPCSTracker!MissingID = "21" I modified the code but now I'm getting Error 438 (Object doesn't support this property or method)

I want to go to the subform, add a record then place data in a field (MissingID). First two lines are okay but I'm getting an error on the third line (data member not found). Am I referring to the field incorrectly? Me.frmMissingItems_Subform.SetFocus DoCmd.GoToRecord , , acNewRec...

Attached is a snapshot of the relationships. Any help would be appreciated.

Any help would be appreciated.

Pics 1 and 2 show design of UnitID in the primary table. While bound to col1 (number), the unit name appears to user (Pic 3), col2. Excel spreadsheet data is imported into a table (Pic 4). The name of the unit is imported (text data). I would like to copy the info from Pic 4 to the Pic 1...

Sorry ... Primary Table (tblPCSTracker) has a field UnitID (number), which has a one-to-many relationship to a unit table which stores unit information. The Primary Table (UnitID) is combo box which is bound to UnitID but displays only the unit name (col width 0";1"). So, the number is...

Yes. I posted code in #7

I continue to struggle with this. Any suggestions or "work arounds?"

Error on this line: Forms!frmPCSTracker.UnitID = VarZ Runtime Error 440: The value you entered isn't valid for this field. Dim VarX As Variant VarX = Forms!frmAlphaRoster.AAC Dim VarY As Variant VarY = Forms!frmAlphaRoster.ALC Dim VarZ As Variant VarZ =...

Maybe my explanation is bad. In the primary form, I have UnitID, a number field (used to look up unit information in another table ... (UnitID, UnitName, UnitPhone, UnitPOC, etc.). In my secondary form, I have a text field. The UnitName matches the unit name in the look up table above. I...