Search results

My aim is to count the data in various queries and then transfer the data into a Pie Chart. Once there is an entry the query works ok, but if there is no entry then the whole query returns blank cells.

If a query comes back with a blank, can you use tell the query to display a Zero instead?? Thanks

Nope, nothing is running in the background My code thus far is Sub Button1_Click() 'BEGIN CODE Dim strDBName As String Set appAccess = CreateObject("Access.Application") strDBName = "E:\Customer Satisfaction Database\CustomerSatisfactionDatabaseMK2.accdb" appAccess.OpenCurrentDatabase...

Hi Thanks for replying The code now fires up Access but only briefly then shutsdown.

Hi All, I am led to believe that we can run various Access forms and queries etc from Excel! I have used the code below, but when it runs it doesn't error but it doesn't do anything. I am running Access and Excel 2007. Can anyone enlighten me. Thanks 'BEGIN CODE Dim strDBName As...

There is already existing data in the tblUser table, I have to add 1500 new records that have come in from an Excel Sheet, just thought appending would be easier.

If I have two tables tblMobileDevice and tblUser If the IMEI field in tblMobileDevice matches the IMEI field in tblUser then put the UserName from tblUser in tblMobileDevice. Is this possible?? Thanks GW

I have the following dilemma 3 Forms MasterForm With A Sub Form called 'MasterSubForm' 'MasterSubForm' has a sub form 'MasterSubSubForm' MasterForm MasterSubForm MasterSubSubForm I need to get a value in the MasterSubSubForm from a Value in the MasterForm Have tried...

When one of my forms opens, the user has 4 options via a combo box. If they select HV for example the form then opens up the relevant form linked with HV. My problem is, the next time they open the form I am trying to get Access to default to the Form already selected eg HV. Presently if the...

Yes, I am currently trying to figure out if I can display a label reading 'No data applicable' , rather than just a blank page. I've been trying the 'On No data' to print a different report, when no data has been detected. You got any tips?

My main report consists of 8 sub reports. But if one of the reports does not contain any data, it will not print anything. (Just a blank sheet) I want that particulaly sub report still to print, even though it will not show any data. I need the empty report to print. I just read what I put...

I have a multi report that prints of 8 reports. If one report contains no data, a blank page is produced. Is there a way I can actually print the report showing the Printed report but thus showing blank fields. Thanks Gareth

Thanks both for responding Along the same lines my text box in the main needs more info from the sub form, the last revision number of a Contract number I am using this =MAX([tblRevisions].[Form]![RevisionNumber]) But i get the dreaded 'Error!' Taking the =MAX away gives me a figure but not...

Gemma Thanks, that did it Dropping the 'forms!' at the beginning

Hi Everyone If I have a main form called frmTest and within that form I have a subform called frmTestSubForm, which are linked correctly. If frmTestSubForm has a text box called txtIssuedby how can I display that on the main frmTest. I have tried Forms!frmTestSubForm!txtIssuedby but just...

Bob, You are a Saint. Many Many thanks vbInet, also many thanks Best Regards Gareth

Thanks for the responses Still not happening. I get the little window telling me it is starting, then the Run Time window comes up I believe it is the way in which 'PDFLink' gets it value. If I change the line to DoCmd.OutputTo acOutputReport, "rptMAINREPORT", acFormatPDF...

Thanks for responding So I have amended to thus DoCmd.OutputTo acOutputReport, "rptMAINREPORT", acFormatPDF, "C:/Transfer/" & PDFLink _ & ".pdf", False Getting 'Run Time Error 2501' The Output to action was cancelled????

Try to get a report to save to PDF with Access 2007 Using the code below but it is erroring DoCmd.OutputTo acOutputReport, "rptMAINREPORT", "PDF Format (*.pdf)", "C:/Transfer/" & PDFLink _ & ".pdf", False The report I am trying to save as PDF is rptMAINREPORT and within that report is...

Hi Everyone, Could do with yet more help of anyone please I am trying to print off 6 Reports as 1 report. Started using page breaks on the Main Report inserting Sub reports etc but could only get 3 on. I take it there is an easier way to accomplish this? Thanks Gareth