Search results

  1. E

    Importing a text file into Access Tables

    Here is the sample. Some items are on the same line some are on the next line I want to import source, first/lastname, etc. the content after "notes" I would like in just one text/comment field. From: Sent: To: Subject: New Lead Source : LZ First Name : JON Last Name ...
  2. 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...
  3. E

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

    I tried using the above code. I changed the YourTextField to the Field I want to search (called CZIP). I get a compile error Expected = ? thanks.
  4. E

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

    on the prior example in the if then... Is there a way to have it check to see if the space after the - is blank? If it is then I know that record doesn't have the additional 4 digits (that need to stay) and the - can be removed? thanks. ed
  5. E

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

    yes: I have a table with a list of zip codes that look like either of the following: 33401-1234 90036-2353 33407- 48910- I would like to be able to remove the - on the entries like 33407 and 48910( that don't have four characters/numbers after the - like the first two above) thanks.
  6. E

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

    thanks for the link. I dont get how to use the replace with what i want to do since the numbers are all different I'd like to be able to do a wildcard for first 5 digits the 6 character would be - i would also need to determine if there are any characters after the - (four more numbers) and...
  7. 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
  8. 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 =...
  9. 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