Search results

  1. W

    Linked Reports

    thanks ajetrumpet, the issue is not that we've got millions of customers, but that if all goes well that we may have something in the hundreds... it seems a cluttered way of having to do things if we need to deploy reports that don't apply to all customers, even if they are hidden when not...
  2. W

    Linked Reports

    Hi everyone, I have an Access XP application which ships with generic reporting that we sell to all new clients. The time has come that our generic reports no longer suit the needs of all of our customers and we're being asked to develop custom reports. In order to keep our application generic...
  3. W

    Runtime error 429: ActiveX can’t create Object

    Hello, Runtime error 429: ActiveX can’t create Object All of a sudden my laptop has started to give this error message everytime I try to run the linked tables manager. Another example of when the error is occurring is when this code is executed: RecordsetClone.RecordCount This problem does...
  4. W

    Setting Report Width In Code

    Hello, I've built a report based on a crosstab query that may display anything upto 21 columns. A landscape A4 page will display 15 nicely, anything more than that and the report will have to be 2 pages wide. I have a lot of code in the OnOpen event which moves controls around and hides/shows...
  5. W

    Continuous Subform Unbound Control Problem

    See quote below from UtterAccess.com forum - many thanks to KenSnell... "The method that I use for such form setups is to use a temporary table as the form's RecordSource. When I open the form to fill it with data, I have the VBA code create the table, fill it with data from a query that gets...
  6. W

    Continuous Subform Unbound Control Problem

    Hello, Please see the attached images (screen shots from my db). I'll start by explaining the function of this form. Invoices are raised through a different area of the system - they then appear in the outstanding invoice list in my payment processing screen while awaiting payment. When a...
  7. W

    Payment Processing ERD Help

    Hello, I'm designing a contract and payment processing database for a friends construction company. I've made an attempt at designing the data model, but wondered if anyone out there had ever come accross a similar scenario and could be of any help. I have attached a copy of my initial ERD...
Back
Top Bottom