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 Rhinorhino 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: sherlick
  • Content: Threads
  • Order by date
  1. sherlick

    Writing to an SQL File in ACCPAC Macro

    Hi All; I have written a macro to read data from ACCPAC and write it out to a text file. I would like to change this macro to write to an SQL table. I have not found a way to connect to an SQL database within an ACCPAC macro. Is this possible? Do I need to add in a reference to the ACCPAC...
  2. sherlick

    Writing to text file using ACCPAC Macro

    Hi Do anyone know how to write to a text file or for that matter an SQL table that is not part of the core ACCPAC tables using a macro. I would like to extract data from an SQL database and save the data in either an non ACCPAC table that is part of the SQL database or a text file. Thanks...
  3. sherlick

    Shipping labels

    Hi All; In ACCPAC 5.3 when we print shipping labels by order or by shipment number, they come out pretty quickly. When we print by Invoice number, they take about 15 minutes to print even 1 label. I ran DBSpy on the system. The log seems to make sense when an Order number or Shipment number...
  4. sherlick

    A4W 5.3, SQL 2005 and TEMPDB

    Hi All; We have found that ACCPAC 5.3 on SQL 2005 uses the TEMPDB quite frequently. Does anyone know if you can change how ACCPAC and SQL uses this database? Thanks Stephen
  5. sherlick

    Passing Parameters to ACCPAC for Record Selection

    Hi All; I have written a macro in ACCPAC 5.3 to call a Crystal Report from ACCPAC. The macro seems to be working and called the report. However, I cannot seem to pass in the record selection parameters. When the report runs, it pops up the Crystal Record selection screen. Is it possible to...
  6. sherlick

    Performance of A4W v 5.3a with SQL 2005

    Hi All; We have recently upgraded to A4W v5.3a with SQL 2005. We have new servers. The system is running fine and for report generation is faster. However, saving an order takes is much slower then our old v4.2 with Pervasive database. Any suggestions on how to tune SQL. Thanks Stephen
  7. sherlick

    Auto running a macro to set a field value

    Hi All; I was wondering if it is possible for A4W v5.3a to automatically run a macro when the customer number is entered in the Order Entry screen. We would like the location to default to a specific value based on where the customer's location. Any help would be appreciated. Stephen

Part and Inventory Search

Back
Top