Search results

Thanks Neil...no the fields will never all be blank - just one at the most. Thanks for that. I will give it a go.

Hi I have a query resulting from several other querys. There is a potential problem in that I am multipling 3 query fields together. If there is data in each field then the query produces the desired result. If however one of the fields is blank/null the calculation of the other 2 fields does...

Hi I have a monthly job to send out 200 + graphs to our internal cutomers. The graphs are produced by me running a query that uses 3 variables - an id, a start date and an end date. I copy and paste the graph to an excel spreadsheet and send to the relevant customer. As you can imagine - its a...

Suppressing Query Hi Thanks for reply and bear with me as I haven't used access for over a year. Tried the following code: Dim vInvNo As Variant Dim VPayee As Variant Dim Count1 As Long Dim Count2 As Long vInvNo = [Forms]![frmInvoiceInput]![Text60].Value VPayee = Me.[Combo52].Value Count1...

Hi I have a query that uses 2 variables from a form. All the query is doing is checking whether the 2 variables exist in a table. 99% of the time there will not be a match. Does anybody know how you supress the query from being displayed when no results are found? Thanks Andrew

Hi I have created graphs via the chart wizard when creating a new form within a database application. I have many graphs that are created via the user inputing various dates and codes. I would like to create a monthly report for my dept and instead of tediously copying and pasting 15 graphs...

the transfer of graphs to excel Thanks for your help and will do. The thing is, its not a standard form I want to transfer. I have created graphs via the chart wizard when creating a new form. I have many graphs that are created via the user inputing various dates and codes. I would like to...

Hi Can anyone tell me if it ispossible to export a form from Access to a file in excel?