Search results for query: *

Thank you all the quick response. Will check the error handler. I am modifying someone's code temporarily. I just needed a quick fix.

Hi all, In Access 2002, how to use program code to suppress the following error message: "Error #2448 with message: You can’t assign a value to this object." Thank you.

It works. Thank you very much.

We have an off-shelf program package and it has two tables ARSIA and ARSIAO. The simplified tables are shown here. ARSIA: GROUPID IDCUST AMTDUE RENT 340943 120 PARKING 340943 30 RENT 450001 175 RENT 841190 290 PARKING 841190 40 RENT 950100...

Additional information. For PO module which still on version 5.3B using Crystal 8.5 that I have no problem previewing reports. For all other 5.4 modules, the preview of a crystal report shows a black screen.

I have the same problem. Accpac 5.4a on TS 2000.

Thank you PHV. It works.

Hi, I need help to select data from 2 linked tables. The two tables have the following format: Table 1 ID Name Status 01 Adam 1 02 Bob 1 03 Coby 1 ... Table 2 ID Skill Level 01 Code A 01 Word 2 01 Excel 1 01 Access 1 02 Code A 02 Excel 2...

I have a SQL 2000 server. I use enterprise manager to restore database. I'm able to restore databases from SQL backup files when the backup file is small. However when I try to restore large databases (I have 3 databases with files size above 1 Gb) I get this "Timeout Expired" msg. The msg...

I'm using CR8.5. I need some help on running totals. I'm trying to modify an existing Crystal report from a off the shelf software. The report uses data from 3 linked tables. The 3 linked table contents are generated on the fly as you run the report. The 3 tables are: Customer: IDCUST, Name...

Thank you for the reply. The two tables are linked by a customer ID field. I thought about using sub-report. At the bottom of the report I would like to add all the query results together. I don't know how. I was also thinking put all the 11 queries in a function at the report "On...

Hi, I would like to create a summary report from the results of 11 queries (based on 2 tables). All the queries have the same format and return 3 numbers ( Count, Current Year Bal, Last Year Bal.) under different conditions. When I use the Report Wizard to select multiple queries to be...

Try this: Download and install Novell Client v4.83 SP2. Novell Client 4.83 for Windows NT/2000/XP http://support.novell.com/filefinder/14232/index.html Gordon.

I have a macro which prints budget reports. It had worked for the past 3 years. Since yesterday, it doesn't work anymore. The macro has not been modified or changed. The macro is run within Accpac. The error is an Accpac pop up window. The title of the window is Accpac. The msg says...

Thank you zemp! With ARCUSTOMER .init .Order=0 .browse "IDGRP = " & chr(34) & "ADM & chr(34) & "", true do while .fetch debug.print .fields("IDCUST").value debug.print .Fields("IDGROUP").value...

Hi, I'm writing a macro to read customer database info. I don't know how to loop through the database and list or print all the fields IDCUST, IDGRP, NAMECUST for IDGRP="ADM". Can someone please help? Thanks. Dim Session As ACCPACXAPILib.xapiSession Dim ARCUSTOMER As...