Search results

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...

Thanks very much that did the job. Is it possible to use the OnChange function on a combo box as I need to add the Requery command when the combo box changes to update the postcode list?

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...

I have just done a very similar task. Can you zip down and post your database and I'll apply the same logic to it.

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...

:D :D Thanks matey I posted the same question on UtterAccess.com and the reply that came back was pretty much the same as yours and it worked a treat. thanks for the help :)

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...