Search results

  1. B

    Code library database

    I have been considering how to re-use my generic VBA code and Access objects across multiple applications. These are for such standard things as : closing all forms, error reporting, connecting to SQL Server, startup routines, etc. I am thinking of creating a code and object library database...
  2. B

    VBA class modules & factory design

    I have developed a 2-tier application for my own use for budgeting. It was originally an Access front-end and an Access back-end, and I am currently upgrading the back-end to MS SQL Server. As part of this upgrade I want to make as much use as possible of VBA class modules. To this end, I have...
  3. B

    Access subform - Current event does not fire on first record selected

    I have an annoying little problem with the following setup. I have a SQL Server back-end database with a Microsoft Access (2019) front-end. One of the Access forms contains a subform which has as its recordsource a pass-through query reading data from the SQL Server back-end. What I want to be...
  4. B

    VBA to read foreign keys in table

    I have written some VBA to create a basic data model in Excel from an Access database. It’s nearly there, but I have found an issue with finding the Foreign keys in tables. Here is the relationship: And here are the indexes in table tblSubHeading: When I use the Relation object the VBA...
  5. B

    VBA to add Totals to subform

    I have built a procedure to dynamically rebuild a subform and underlying table based on a crosstab query. This is so that it can show various combinations of categories (rows) and monthly totals (columns). I would like to have a total row appearing on the form and to use VBA to achieve this. The...
  6. B

    Solved Custom Ribbon images type mismatch error

    I have created an accdb (Access 365 64-bit) for Holiday planning and budgeting, and it has a couple of ribbons with some custom images. To make the application more self-contained I have created a table USysRibbonImages to store them within the database itself. This has 3 fields – ControlID...
  7. B

    VBA to create dynamic table - slow to run

    I hope someone can help me with a performance issue in creating dynamic tables using VBA. I have a generic procedure which rebuilds a table to store the contents of a crosstab query. This table is then used to populate a subform. On one particular table the code takes around 4 seconds to run –...
Back
Top Bottom