Search results

So I have a query that has criteria based on the value of a textbox: [Forms]![frmPropertyHistory]![txtPropertyName]. This query is the record source of a continuous form. If I run the query in design view, it picks the criteria from the textbox or if the form is closed, it asks for the value...

Hi Doc man. So in short, even though the website works and the vba code is correct, on occasion, because of some certificate, I will simply get this error and that's it? If there any way to get around this? Changing browser or access settings? Any help is very much appreciated... mafhobb

So, simple code: Dim WebLocation As String WebLocation = Me.VrBoWebLink.Value Application.FollowHyperlink [WebLocation] Why your this hyperlink open fine: https://www.airbnb.com/rooms/46075415 ...but this one give me the error above?: https://www.vrbo.com/en-gb/p10764142 Both pages exist...

Here is a simplified version of the database I followed your steps and suggestions and I think that it now works as it should. I wonder if you'd mind taking a look at the attached db as it is now to confirm. One question though: My access expertise is obviously very limited and while I see the...

Really? Which fields should I relate? I tried to relate the "PropertyName" fields on both table and I get a relationship error. Please see image attached

I manage a few properties that need occasional cleanings. Each property can have a few different types of cleanings (full, half, 1 room,...) and the price for each of these services is different for each property. So I have a main table with the property name (tblProperties), then a second table...

I see, and adding the grouping added two more sections, with the new section footer being used for the sum. Thank you. It would have take me a long time to figure this out! mafhobb

I've just uploaded it here. Can you please check it to see if you can find what is happening? I am really at a loss....Hold shift to open it.

Do I need to somehow group the query results so they can be added?

If I change the control source to this: =[TimeSpent]*[ActualCost] and I change the field's Running Sum to "Over Groups" or "Over All", the output in this field not a sum of all the query results, but the value of the last line of the query. If I do the same but with the control source set as...

I have left the original subtotal control and created a new one with the same control source =Sum(Subtotal) I have set this control to "running sum" over group and over all. Still #Error...

Still; I get #Error

I am working on a subreport with shows the data from a query (qryMaintenanceInvoice). One of the report fields is "Subtotal" which is a calculated field in the query (Material cost x Qty.). This works correctly in the query and the report. The trouble comes when I try to add a calculated field...

That did it. Many thanks mafhobb

I've got a form with property data form (frmPropertyHistory). On this form I have button to add a new property which opens an unbound, modal form (frmAddNewProperty). On this form new I have two fields with data to enter in a table (txtNewOwner and txtNewProperty). This is the code: Private Sub...

Thanks. I will mafhobb

That did it! I should have checked this. Many thanks mafhobb

Hi arnelgp This returns "error 2465. This db cannot find the field "frmMaterials........."

Like this:? For Each ctl In frmMaterialsUseSubform.Form Now I get "Error 424: Object Required" at that line Thanks for the comment on the labels and such. I'll exclude them.

I have a main form (frmPropertyHistory) and a subform (frmMaterialsUseSubform). In the main form I have a combobox and an afterupdate event. The goal is to lock all controls in the subform when the combobox is updated. This is my code: For Each ctl In...