Search results

Hi Guys I'm trying to print out several reports from one button. I have created individual buttons for each of the reports and they work fine. But when I try to amalgamate them it stops printing after the first two reports regardless of which ones are at the top of the list. Any suggestions...

Hi Guys I'm trying to join 2 bits of info together to set data in a field. The first part is the field name which always starts with the text "Name_", the second part is a variable field name (which is actually a time slot). I've done ... If "Me.Name_" & [Temp_Time_Slot] <> "" Then...

Hi Guys I've got a field that contains a clients First Name and any middle names. e.g. Bill Richard Stephen I'd like to copy the first name (up to the first space) to a field called 'First_Name' (Bill), and any other names to another field called 'Middle_Names' (Richard Stephen). A client...

Hi Guys I have a main report called rpt_Presentation, and lots of sub reports which I only what to show one at a time depending on a user choice by changing a field called 'Type_of_Business_Code' which has numerical values 1 to 10. The following code I've put on a 'Report Open' I've tried...

:D Hi Guys I've got a subform (frm_Date_Worked) with lots of records with consecutive dates in one field [Date_Worked]. I need a button on the subform that will go to the record with today's date. I've been looking at 'DoCmd.GoToRecord', but I can't get it right. Thanks for your help. Alan

I have totals in a report that work fine if there is a record entered that meets the criteria for the report, but if there is no record, the result of the unbound calculated field on the report is #Error, What do I need please ?

I've got a table with Vehicle_ID as the Primary Key and four other tables with Vehicle_ID as a foreign field for joining. When i try to make a query based on the master table with the sub tables linking it with a one-to-many join, i lose the ability to add data to the query. I only have to add...