Search results

Here's the problem. I have a piece of code that runs through a master table and based on specific criteria writes results out to tables. (i.e. Glasgow - 123A321, Glasgow - 123A112, Glasgow - 321B159, Perth - 987A65, etc). In total there are 34,000 tables. I need to export these tables from...

Background: I have 26 tables relating to different areas of the country. Each table contains various name and address information, each record on the table also has a COLLID (eg 123A321). The COLLID is issued to anywhere between 5 and 200 records. The problem: I need to produce a separate...

Having a bit of a brain melt here. (Well it is Friday !!) I am trying to run the following calculation, but ot no avail. =Sum(5-([Payment])) And instead of getting the results of 5 minus the value in the payment field (which is £1, £2 or £4) I get £36.00 Any clues

Is it possible to use the visible function to show or hide a none existant control source on a form?

visible function a form Is it possible to use the existence of a '#Name' error on a form as criteria for a visible command?

Is it possible to create a crosstab table and then add an extra field which can be amended to specify whether the record can or cannot be printed?

Is it possible to show crosstab records in a form bearing in mind that the columns for the crosstab will increase each week

Various posts on here seem to have flirted with the answer I am looking ofr but I can't seem to find anything specific. Any help would be appreciated. I am looking to export a paramatised query to excel with a variable file name. i.e. H:\Projects\CrosstabExport - [paramater value].xls The...

This mail will probably make more sense if you download the attachment. (Ignore the errors on the first form, these have been removed to minimise size) After updating the Search By Postcode combo box the Postcode District and Territory ID fields are updated with the related information. I am...

Does anyone know how to create a table from the results of a crosstab query? When I try to run a make table the pc crashes. I select add table and point to my crosstab query, at which point the pc hangs and access shows as Not Responding. What is the maximum number of records that Access can...

Download the sample database and print off the table before reading this question. ------------ Is it possible to do this. 1 In cboSURNAME the only options available to select are Edwards Smith Stimpson Todd After entering Edwards 2 In cboFIRST the only options available select are...

I have a subform which contains clients claim details. Occasionally these claims have queries (underpayment, re-issue, etc) the query information is held in a seperate table with a one to many join between claim details and query details. I want to have a button that will open the queries form...

I have a form based on a table which contains name and address information. Each record in the table is issued with a KeyID. Each record in the table can have upto 7 claim references against it. I have created a one to many join between the name and address table and the claim reference table...