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

    How to suppress an error message

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

    SELECT query from linked tables

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

    Query on linked tables

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

    "Timeout Expired" when restore a database using EM

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

    Running Totals

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

    report from multiple queries

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

    Accpac Macro error

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

    Accpac VBA

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

Part and Inventory Search

Back
Top