Search results

  1. E

    Importing a text file into Access Tables

    I have a text file that has 37 lines in it with two columns of information. I would like to be able to import certain rows into the table. The way the file is created it has the would be column names in what would be column 1 instead of on the first row. a few of the 37 lines has the item name...
  2. E

    way to search for an item in a field and remove it

    I have a database with a zipcode field some have the full zip+4 like 90036-1234 some only have 90036- is there a way to create a routine to strip out that - when there arent numbers after it? thanks
  3. E

    Copying data from one form to another

    I have one form that had a button to copy the data from one table to another. The code on click is the following: Private Sub CopyToFlActive_Click() DoCmd.OpenForm "frmFLActive", acNormal, , , acFormAdd Forms![frmFlActive]!ENAME.Value = Me![ENAME].Value Forms![frmFlActive]!EADR1.Value =...
  4. E

    newbie needs some help

    I am starting to play around with access 2007. I am trying to create a combo box search on a form. I get the list that I want, but when I click on it, I would like that action to cause the data on the form to go to that record? can someone give me some tips on how to do that? thanks
Back
Top Bottom