Search results

What criteria would I need to enter that would include all the records?

So I have a simple query to get sales results based on properties and then a grand total: This is my SQL: SELECT tblReservations.PropertyName, Sum(tblReservations.ResAmount) AS SumOfResAmount, DSum("ResAmount","tblreservations") AS Expr1 FROM tblReservations GROUP BY...

...shameless bump to see if anyone has a suggestion... mafhobb

I have now added some data to the underlaying table so that the query that populates the subreport that txtReservationsSubtotals is calculated upon would have a value different than zero. When I do that, the Extended total field shows the correct result, that is, the error goes away. So, I...

My Rowsource for that field (txtReservationsSubtotal) in the subreport (rptReservationsDoneSubrpt) is now: =Round(Sum([Comission]),2) The value shown on the screen is 0.00, which is correct. The rowsource for the extended total on the report is...

OK, so I have been investigating a bit further and this is what I have found: If I enter this as a source for the report field, the field shows the addition of the two subreports correctly...

Anyone?

Does anyone have a suggestion? I have my report almost done and the subreports are all working perfectly. How do I add the subtotals in those subreports so the total shows up on my report? Can textboxes be manipulated like that on a report? mafhobb

I figured it out! =[Forms]![frmDocumentParameters]![cmbCleanerSelected] Or [Forms]![frmDocumentParameters]![cmbCleanerSelected] Is Null

Hi. I have a simple query with the criteria based on a value in a field: =[Forms]![frmDocumentParameters]![cmbCleanerSelected] This works fine when I have data in the combobox. However, what I need is for the query to return all records if the combobox is empty. How do I do this? mafhobb

I have entered the rowsource: =Nz([rptMaterialsDoneSubrpt]![txtMaterialsSubtotal] , 0) + Nz( [rptCleaningsDoneSubrpt]![txtCleaningsSubtotal], 0) + Nz( [rptMaintenanceDoneSubrpt]![txtMaintenanceSubtotal], 0) + Nz( [rptReservationsDoneSubrpt]![txtReservationsSubtotal], 0) But the output in my box...

I have a report (rptInvoice) with a number of subreports (MaterialsDoneSubrpt, MaintenanceDoneSubrpt, CleaningsDoneSubrpt). Each of these subreports has a subtotal text field where all the costs associated with that subreport are added (Sum([....]) Now I need to add up all these subtotals into a...

I understand. Unfortunately, after adding the function, and while in some cases the link is changed, the hyperlink errors are the same. How about my theory about how fast the servers respond? Maybe they are slow and the code is simply expecting a response too quickly? mafhobb

Wow! I though that I was asking a newbie/dumb question, but I see that there is extended debate. Thanks bob fitz

Hi arnelgp. Just so I understand, what would be the purpose of the decoder? Is it trying to get rid of some possibly conflicting characters? mafhobb

This is just so strange... Using the same code: This returns "Run-time error 5. Cannot locate the Internet server or proxy server" https://www.tramuntanapm.es/portfolio/son-bota/?portfolioCats=60%2C59 This returns "Run-time error 8. Cannot download the information you requested"...

Hi Doc Man. Unfortunately, unless I am not understanding your reply, adding the correct "http" or "https" does not seem to have anything to do with the issue. The links in the db are copied directly from the sites that I want to open and are all https. Some open fine some do not. However, it...

I have noticed that sometimes is certain parts of the VBA code, a "." is used and others a "!". Is there any difference between these two? Is there a rule about their use? Example: Me.PropertyName.SetFocus vs Me!PropertyName.SetFocus or Forms!frmPropertyHistory![Cleanings...

Got it. Many thanks! Mafhobb

Hi. This is probably really simple but I am struggling. I have a combobox on a form that has the following RowSource: SELECT [qryCleaningCostPerProperty].[PropertyName], [qryCleaningCostPerProperty].[CleaningType], [qryCleaningCostPerProperty].[CleaningCost] FROM...