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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pvted
  • Order by date
  1. pvted

    ODBC Import

    In response to Greg's question from the 16th: "Do I have to register Client Access to get this to work?" If you're asking if you have to purchase IBM's Client Access product in order to connect to the AS/400 via ODBC, the answer is no. There are other products from companies such as...
  2. pvted

    ODBC Import

    The most often used PC application used to connect to the AS/400 is IBM's Client Access (or the somewhat newer Client Access Express). This program includes an ODBC driver which I use quite frequently to retrieve data from the AS/400. Tables linked using the Client Access ODBC driver can be...
  3. pvted

    How to use DTS from SQL Sever to AS400 DB"

    Thanks leveyp! I just looked in on this forum for the first time and found this info that will be really helpful for me. Ted
  4. pvted

    Is Classic really part of OS X?

    We have 2 G4s that are about 2-3 years old. I want to do a clean OS X install on them. If I use the Disk Utility on the OS X install disk to partition and format the disk drives on these machines then then proceed with the OS X install, will the Classic environment be available for use? We do...
  5. pvted

    Point of Sale Cash Drawers with Bar Code

    Romh, The easiest way to handle the input of data from barcode scanners is to utilize scanners that plug into into the keyboard port of the PC. In addition, the scanners should be of the type that handles the "decoding" of the barcode data into ASCII characters (the alternative is a...
  6. pvted

    Exporting to Excel

    See Microsoft Knowledge Base Article - 294410 This doesn't seem to exactly describe your problem, but it is suspiciously similar. Their prescribed solution is to install Jet 4.0 Service Pack 6. It does not appear that Office XP Service Pack 2 updates the Jet database engine. Please give my...
  7. pvted

    Text box with trailing spaces

    Try this.. InvNo: String(15-Len([InvoiceNo]),"0") & [InvoiceNo]
  8. pvted

    Text box with trailing spaces

    To pad your field with trailing zeros use the string function instead of the space function: county = "county" & String(30 - Len("county"), "0") Ted
  9. pvted

    Some data may not be displayed...?

    I marked pdldavis's suggestion as helpful. The method does work except that the syntax is: before print: DoCmd.SetWarnings False ... after print: DoCmd.SetWarnings True (No equal signs) Thanks though - it helped me too.
  10. pvted

    Problems with multiple Exchange Server sites

    We have 9 Exchange Server 5.5 sites in our organization. Our problem is that certain types of e-mail seems to end up on the wrong server. Our arrangement consists of one server at the parent company headquarters and one server at 8 subsidiary companies. I am the administrator at one of the...
  11. pvted

    Requesting data from MS Exchange server

    We are also having this problem with Outlook 2002 clients (and Exchange Server 5.5). We use Symantec Antivirus Corporate Edition. Any suggestions about how to set scanning options to avoid this problem would be much appreciated. Another strange thing that we've observed is that administrative...
  12. pvted

    When to Use Macros, When to use VBA ?

    Another reason to use VBA rather than macros is that macros do not work in the Access Runtime environment. The Access Runtime environment is great way to deploy an Access program to users who do not have (or need) the full program installed on their computer.

Part and Inventory Search

Back
Top