Search results

  1. M

    Filter by date on form open

    Hello All- I have a form that contains a subform. On the 'on open' event of the subform I have the following code: Private Sub Form_Open(Cancel As Integer) On Error GoTo Failure Me.Filter = "lngAgentID=" & lngSessionAgentID Me.FilterOn = True ExitRoutine: Exit Sub Failure...
  2. M

    Identity in Multi User Setting???

    @@Identity in Multi User Setting??? I have the following code attached to a submit button on a form. When clicked it updates the entered information to tblContacts. It then returns the primary key, lngContactID, to the text field txtCID. I am having trouble finding out if this will work in a...
  3. M

    Edit Command Button w/ SQL

    I have an edit button that when clicked should edit the values in my tblContacts. The code attached to the button is: Private Sub cmdEdit_Click() On Error GoTo Err_cmdEdit_Click Dim strSQL As String strSQL = "UPDATE tblContacts SET" strSQL = strSQL & "chrFirstName = " &...
  4. M

    Enter Parameter Value???

    I'm trying to design some cascading combo boxes for a form. The tables I'm using are as follows. tblProdType lngProdTypeID.........primary key chrProdType tblProductInfo lngProdID.........primary key chrProductName chrProdTypeCR......this is for commission purposes chrState...
  5. M

    Simple Query Question

    Simple Query Question (I'm admittedly a newbie) I have been looking for an answer to what I think is a simple question, but since I'm knew to this I don't think I've found an answer. I have a table (tblZipCode) that I imported that contains some 74,000 entries. This table has five fields...
  6. M

    Newdie Data Validation Question

    Hello- I'm new to access and VBA, but I'm catching on quickly. I have what I think is i simple question, but I haven't been able to find an answer to it yet. I have multiple bound fields on a form that I would like to validate when the user attempts to move to the next field. I've tried...
Back
Top Bottom