Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by tomf

  1. tomf

    Printing e-mail addresses

    Hi, When printing a contact list in Outlook 2000 it does not print out the actual e-mail address only the display name. I have tried customizing my view by adding other e-mail fields, but still only the display name appears. How can I get the e-mail address to print instead of the display...
  2. tomf

    using a substring in a join

    Hi, I am using access 2000 for a simple shipment tracking database. I need to setup a join in a query that links the SHIPMENTS table with a STYLE MASTER table. An example is that we ship part number 123-45678-90abcd. The style number is the second segment (45678). This style has more...
  3. tomf

    SQL syntax error

    Sorry about the double post.<br><br>Tom F.
  4. tomf

    SQL syntax error

    Hi,<br><br>I am using Access 97 to create a simple shipping database.&nbsp;&nbsp;I have a macro with a RunSQL command with the following statement.&nbsp;&nbsp;<br><br><b>INSERT INTO [tblShipping][Part Number] VALUES ('ABC123')</b><br><br>I am receiving a syntax error when this is...
  5. tomf

    SQL syntax error

    Hi,<br><br>I am using Access 97 to create a simple shipping database.&nbsp;&nbsp;I have a macro with a RunSQL command with the following statement.&nbsp;&nbsp;<br><br><b>INSERT INTO [tblShipping][Part Number] VALUES ('ABC123')</b><br><br>I am receiving a syntax error when this is...
  6. tomf

    Personal Address Book

    I removed a personal address book from an Outlook 2000 client that is connected to an Exchange server (ver 5.5).&nbsp;&nbsp;When I try to re-add the personal address book using Tools-&gt;Services-&gt;Add, I do not have the option for Personal Address Book.&nbsp;&nbsp;<br><br>This all came about...
  7. tomf

    combo box in query

    I am developing a small application for internal project tracking. I designed a query that I use when generating reports. In this query I prompt the user to enter the project engineer, using the following for the criteria:<br> <br> [Enter Engineer]<br> <br> Instead of having the user enter the...
  8. tomf

    Moving records from one table to another

    Jim & Elizabeth,<br> <br> Thanks for the tips. I tried the tip from Jim and it work great.<br> <br> Thanks again,<br> Tom F
  9. tomf

    Moving records from one table to another

    What is the best way to move records from one table to another? I have created a simple database that tracks projects. I have a status flag in the project master table. This field is set to either “1” for open or “2” for closed. I would like to take all closed records and move them to...
See more

Part and Inventory Search

Back
Top