Search results

Hi All I am using the following code to generate a series of reports based on a query (qryRptS). This is quite intensive on the Jet database engine as after producing reports for the first 9 records an error appears declaring that Access “cannot open any more tables”. Dim qdf As QueryDef...

Hi there, I am trying to create a module with VBA to output approx 500 access reports into a folder. The access report is linked to a query called “qryRptS” with each record in the query responsible for one report. The problem is that qryRptS is a parameterised query based on 2 date fields...

Hi All, I am trying to create a macro to export a report to pdf multiple times for a whole series of different records. The report (rptQryS) is essentially a template which contains different information depending on which record of a form (frmCompany) is selected. I've had a go with the...

Hi All, I've been designing my Access DB on a common drive (my reasoning is that this drive is backed up automatically every 24 hrs). Recently one of our IT guys was making some changes to our server and this coincided with certain queries, which were previously working, producing errors...

Hi All, I am currently designing a report with lots of calculated controls in the 'detail' section of the reports. An example would be as follows: ="For this period " & [Trading Name] & " has made cost savings of approximately: £" & Round([SumOfCOST SAVING],0) I have found it easier to...

Background I have 3 tables: tblCompanies, tblTrading and tblProducts. TblCompanies contains a list of client companies (and associated info), tblProducts contains a list of the different products we offer (and associated info) and tblTrading contains information about all of the transactions...

This might be quite a simplistic problem but I still haven't found a solution yet. I have 3 tables: Companies, Trading and Products. The Companies table contains a list of our client companies (and associated info), the Product table contains a list of the different products we offer (and...

Hi all, I have a quick question about filtering the items on a form by a control in a subform. I am attempting to use a macro (represented by a button on the form) to achieve this but keep getting an error message which states that the "action requires a valid control name that corresponds to...

Hi All, I am using Access 2007 and have a question. I have a large number of business clients (other companies) and would like to develop a system which allows me to produce a monthly sales report for each company. I was thinking that I would create a table with each company having a...

Hi there, I'm am relatively new to Access and this forum so don't really know what I'm talking about. I have records for about 500 companies that all make orders (of say apples) at random. For any given company I would like to develop a system which allows me to input the order date and...