Search results

That doesn't seem to give any clues, the sequence just stops after the first 2 reports. Thanks for your time. Alan

Hi Thanks for reading my thread. No error code is displayed, just prints the first to reports, and I don't know how to step through the code. Thanks Alan

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...

Thank you pbaldy. Worked a charm. Thanks again.

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...

That's brilliant, Thank You You've saved me loads of time. Thanks Again

That's fantastic, works perfectly. What I need now is to delete the result of that field from the [First_Name] field, which will leave me with just the middle names. Or Delete everything up to, and, including the first space in the [First_Name] field. Any thoughts on that bit. Thanks very...

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...

Re: Hide Sub Reports with Select Case [SOLVED] Solved it due to your help, i was putting the select case in too early, on the report itself rather than the code to open the report. Thanks very much, I've been working on that for about 20 hours. Thanks again Alan

Hi I tried "Select Case Nz(Me.Type_of_Business_Code, 0)", but that returns ab Run-time error -2147452567 (80020009). I've put the code on a 'Report Open' The button that opens the report 'filters' to a report to one record, then this code supposed to hide the sub reports not for that report...

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...

Wow, I'd have never got that. Thanks very much, much appreiciated. Alan

Thanks Bob, gave it a try, no luck.

I'll hide the pink [Find_Date] field when it's working, thanks for your time

IE8 problem, used firefox

Nope, can't attach the file.

Thanks for this, there's no confidential data here. If you use the 4th record in the list (JOHN SIMPER) click the button at the end to get the full details. Then the sub form at the bottom is what i'm working on. Thanks again Alan Bummer, now the 'attachment' button doesn't work. I'll...

No Luck, Im doing something wrong, the code under the button ...... Private Sub Find_Today_Click() Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst "[Find_Date] = " & Format(Date, "dd/mm/yyyy") If Not rs.NoMatch Then Me.Bookmark = rs.Bookmark End If End Sub Where...

Another clue, if I find 06/10/10 it won't find the record, but if i change it to 06/10/2010 it does

I've obviously got something wrong because now when I do a normal 'Find' it doesn't find the record. I did substitute the code, but no luck. Thanks