Search results for query: *

I have put the following into the After Update Event on the date selection combo box Private Sub cmb_Date_AfterUpdate() DoCmd.ShowAllRecords Me!**NOT SURE WHAT TO PUT HERE**.SetFocus DoCmd.FindRecord Me!cmb_Date Me!cmb_Date.Value = "" End Sub I had this running and lost it!

Hi, The criteria of this has changed. I now have a table named tbl_Data, A report rpt_ByDate and a form frm_ByDate. The form has a combo box on it called cmb_Date. Is it possible to print a report of records in the table matching only the date chosen in the combo box? Any help would be...

No message box. I have fiddled a bit and can now get one of the combo boxes to work i.e. I select a date and click the print report button and it shows the report but it only has one line of the report. I will do the same with the other combo box. I just need to work out how to filter the...

Thank you but that line still comes up as an error. Also the report I have made is only showing 1 ine of the query.

I'm sorry I have never used VB but really appreciate your help. I put this onto the button event but have done something wrong as it is coming up with errors. **************************************************** Private Sub btn_Hours_Click() Dim db As Database Dim qd As QueryDef Dim...

I have imported data from a text document and created tables from each import. I have a form with a combo box with a list of choices. The choices are the same name as the tables created from the imports. The names are related to dates of the data dump. When the user selects a date (the...

Thank you, now I am at least getting headings but no data.

Hi I'm having trouble creating a form with a user entered start date and finish date. When the user clicks the button I would like a report to filter data from a query between the dates specified by the user. I have created the query, a report and the form. I have tried to put the following...