Search results

  1. L

    Display Table on Form

    I have a form where a user enters a bunch of client info into a database. I also have a form that I want to use if a user wants to view the table. What control do I use to display the data? I want it to be in tabular form so they can browse the list. Thanks! :confused:
  2. L

    Retrieve AutoNumber Problem

    Can someone please tell me what I'm doing wrong here. I have just added a record to a table. I would now like to get the record number (FamilyID), which as an AutoNumber field, and pass it to another form. My query is giving me an error that says, "A RunSQL action requires an argument...
  3. L

    Update table with listbox values

    I am trying to update a record using textbox values. Why won't this work? DoCmd.RunSQL "UPDATE Families SET & _ "[Reason] = '" & txtReason.Value & _ "', [RentAmt] = '" & txtRent.Value & _ "', [Utilities] = '" & txtUtilities.Value & _ "', [PantSize] = '" &...
  4. L

    Recordset Open Problem

    Someone please tell me what is wrong with this code? (I have already defined db_file earlier in the sub.) ' Open a connection. Set conn = New ADODB.Connection conn.ConnectionString = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=" & db_file & ";" & _ "Persist Security Info=False"...
Back
Top Bottom