Search results

Hi, I have used Chergh's coding to solve this same issue I was having with exporting the filtered data from multiple subforms. However, I am getting a runtime error of "3061: Too few parameters. Expected 1." on the vba line: set rs = db.openrecordset("QueryName1") My format follows this...

I was attempting to work on this again today, and I think I corrupted the original UReport form. After rebuilding it and redoing the references/criteria in the other subforms/queries, the new UReport form now populates the subforms as required! I must have cleaned-up some incorrect code in the...

Thanks vbaInet. I tried your first suggestion, however the subform didn't populate at all. Is it possible I need to requery the query attached to the subform first, then requery the subform? There's definately something missing between the query, subform, and combo-box. Any ideas based on...

My apologies for the confusion in my original post, jdraw. A simplified description of what I’m building: A database that consists of three tables; Claims, Sales and ProductList. ProductList has a primary key of ‘ProductCode’, and the other two tables are raw records of the sales and...

Hi, I am currently building a main form with a combo box control, two subforms and a hidden text box (optional). There are many different references to be made between tables, queries and forms to get to the result I am after, and I have tried many different codes from other people’s queries...

Hi, I am currently creating a form with queries attached to command buttons. The queries are there to populate fields in my underlying table, so I can ultimately pull a final report from all the updated data. I am using queries to recreate the SUMIFS and AVERAGEIFS functions from Excel...

Thanks MarkK! It works perfectly :) And I understand what the code's requirements were, based on your explanation. So thank you.

Hi Gina, Thanks! That's really close. It populates into the TodaysDate field, against the correct records (WHERE tblMyTable.ProductCode = Me.txtProductCode). However, it's populating 30/12/1899 as the date. I've tried playing with the 'Date' part of the code to get it to return today's date...

Hi Gina, TodaysDate is Date/Time data type. And txtProductCode is a textbox field, which is populated by a combo box. Thanks.

Hi, I am currently creating a form which includes a command button to update a field in a table to show Today's Date, at the time of running a query I am still yet to write. I have the following code for my Command Button, which is returning the Runtime Error 3464 (Data type mismatch in...