Search results

Thanks ... now I'm "cooking with butter"

I have a form which displays current record information. I don't want people viewing other records on the form. How do I lock the information (allow editing of current record but not have access to the other records)?

I tried the references without success. I know you're trying to teach me. I have tried different combinations. I'm reeealllly trying. Do I reference the form with the recordset? The table? Another failed attempt ... On Error GoTo Err_Command294_Click DoCmd.Close Dim...

I'm getting "cannot find field SGLI_ID in your expression. Both forms are open, SGLI_ID field (unique) is in both forms. I don't know what next to try. Dim stDocName As String DoCmd.OpenForm "frmCustomerInput1A", acPreview, , "[SGLI_ID] =" & Forms!frmCustomerInput1!SGLI_ID With...

I'm so sorry but I don't understand. I don't see a Me. reference. Not sure what to do

I'm still having difficulties. I used the following code but I'm getting a blank record vs. the last record. Any suggestions? Private Sub Command294_Click() On Error GoTo Err_Command294_Click DoCmd.Close Dim stDocName As String Dim stLinkCriteria As String stDocName =...

Records are sorted. The member will always be working on the last record. Each record is uniquely identified with an autonumber field (SGLI_ID).

Actually, no, I want only the last record to be available (other records have personal info).

No. I imported data, using an Append Query. I want the user to add additional data.

After appending data in a table, I open a particular form. I want to display only the last record. I've added the code (DoCmd.GoToRecord , , acLast) to the On Load and On Open properties without success (opens first record). What am I doing wrong?

Still no luck. I'm not getting any errors. Instead it's not recognizing a valid SSN. I receive the not found message. Thinking it may have something to do with the format of the field (Format([SSN],"000-00-0000")), I tried adding the format to the code (no luck). Next, I tried using the...

I'm still struggling with this one. I'm trying the Doc Man approach. I want to retrieve one record. I have a text box (txtToGo). I placed the following code After Update. I'm getting a variable not defined error. Private Sub txtToGo_AfterUpdate() If (txtToGo & vbNullString) =...

Yes, SSNInput is the text box name; [SSN] is the field name and customerinput1 is the form name. DoCmd.OpenQuery "qrySGLICheck" SELECT * FROM tblAlphaRoster1 WHERE ([SSN] = Forms!customerinput1!SSNInput) I'm getting a compile error (syntax error).

Receiving compile error (expected: case). What am I doing wrong? DoCmd.OpenQuery "qrySGLICheck" SELECT * FROM tblAlphaRoster1; WHERE (([SSN] = Forms!customerinput1!SSNInput))

Thanks for the reply. Still having a little trouble. In the query, in criteria, I wrote... =[forms]![frmCustomerInput1]![SSNinput] but it's not pulling the data. Did I miss something?

I have a form with a text box (SSNInput). I want the user to enter his or her SSN then click an icon to bring up data on that person. Note: The form data is not accessible to the user. I want the SSNInput to pull up the record with the SSN that's already in the table. I'm trying to write a...

In one table (Alpha1) I have a person's general information (e.g., name, SSN, address, phone number, etc.). I have a person enter his or her SSN and the general information is populated. I want the person to click on an icon and all the Alpha1 information is transferred to a new table (same...

The recordsource for the subform is a query. Yes, there are 4,000+ records in the recordsource. The SSN in the form is linked to the SSN in the subform. When I place the SSN is the form, the SSN appears in the subform (appears linked); however, none of the other fields have data. When I open...

Yes, the subform includes other fields I want to see. The subform is a form object. The form and the subform have the SSN as the shared field. When I enter the SSN on the form the subform isn't populated. Only the SSN appears in the subform, which suggests to me the form and subform are...

I have two forms. The first form has individual data to include the person's Social Security Number (SSN). I have another form (subform) that has other data to include the person's SSN. I added the subform to the form (linked the SSN). Unfortunately, only the SSN field appears in the...