Search results for query: *

Hi Ettienne; Thank you for the quick response. Do you know the dll I need to add to the Macro so I can get the connection object working? Thanks Stephen

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...

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...

Hi Ettienne; Do you know how to look inside the OELBL.DLL? I am thinking of writing my own front end. The OELABEL.RPT uses table OELBL.DLL. Is this a DLL that I use in Visual Basic or a macro? I don't know if this question even makes senses as I am new to VB Programming and ACCPAC VB...

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...

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

One more quick question. Do you know how to get the different values that can be assigned to the PaperSize and PaperSource parameters for the printer setup? Thanks

Hi Jay and Ettienne; I managed to get it working by adding in the PATH, EXT and SYSPATH parameters. Weird. Thanks for your prompt responses. Stephen

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...

Ok.

Thanks Jay; Do I create my own program in a separate programming language like VB? Stephen

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

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