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

    Linked table showing #Deleted

    I have come across the most bizarre thing I've ever seen in decades of programming in Access and I'm totally stumped! I am using Access 2013 as a FE to a SQL Server 2012 BE. I have numerous linked tables in the FE to views on the BE and have created Access queries on those linked tables. The...
  2. CdnRissa

    sum next n values

    I need to get the sum of the next 12 months worth of revenue from an amortization table and instead of getting one value per grouped row, I'm getting one row for each row in the table. The actual table is more complicated than this example and is pushing 23 million rows, but this is...
  3. CdnRissa

    'As at Month End' reporting on history tables

    I have a database that tracks inventory movement. The main tables are Orders, Shipments, ShippedItems and Items. The relationships are: a Shipment may or may not have an Order, Shipments will have 1 or more Items and Items can be attached to 1 or more Shipments. The ShippedItems table is a...
  4. CdnRissa

    macro getting timeout error from SQL Server

    We are running Accpac 500 ERP V5.5a with SQL Server 2005. All users log on to the server via Remote Desktop Connection and run Accpac there. I have a macro which has been in production since Dec 2007 that ports A/R data from an external billing system to accpac and vice versa. Recently (April...
  5. CdnRissa

    Update a calculated field from another table

    I know there is a simple answer to this, but I can't seem to get to it today. I have an Assets table that contains (among other things) the original cost, Accumulated depreciation, and net book value. I need to update the accumulated depreciation & NBV based on the sum of posted records in the...
  6. CdnRissa

    Accpac ERP 5.5a Web application

    I have a client moving from: ERP 5.4a running on Windows 2003 & MSSQL 2000 to: ERP 5.5a running on Windows 2008 & MSSQL 2005 on a completely new server. They also have several macros built with VBA using COMAPI. The users connect via Remote Desktop Connection & LANPak licences. The...
  7. CdnRissa

    Multi-user trigger

    I've searched for an answer to this and I've not found any specifics. I have a table for which I want to keep a history of changes. I've created a history table that includes all the fields in the base table, as well as HistId (identity), HistCreateDt (default GetDate()), and Action fields...

Part and Inventory Search

Back
Top