Search results

Thanks VBAInet, I'm not sure how to filter on the main report. Usually I'd add: "Like [forms]![Example]![ClientID]" to the criteria of a query, but because there isn't a query, there's no where to put this :( I want when the user clicks the button, it opens the form and they choose...

But the report I've made has taken me days and i'll have the rewrite the whole thing. Is there not something in VBA I code add? Cheer, J

HI, I've created a report which has 4 subreports linked to it via a ClientID. The problem is it prints 2000 reports for the 2000 different ClientIDs. I want, went the button is pressed, for it to ask what ClientID the users wants to print the report for. I know how to do this in a query...

Thanks Isskint. When you do it in the query, do I change the font there or do I do it in the report still? j

Hi Isskint I want a bigger tick on the report. I've found I can do it by 1) Hiding original checkbox 2) inserting a text box, changing font to Wingdings2 and pasting =IIf([Field]=True,"P","") into the control source. I was wondering if there was an easier way. Google suggests there...

Hi, I see that I can't make the tick/check bigger in properties. Is there a way of getting a bigger one on the report at all? I have about 30 to do on a report so I'm praying its not a lot of work each time. I saw on Google that someone suggested using Wingdings tick but not sure how to do...

thanks Minty, i'll give that a go. I've started each page as a separate report and then will drop it all into 1 and pray that works :) Will let you know the outcome. Thanks again, J

Hi, We are creating a report and for some reason we can no longer extend the detail section of the report. It has stopped at 2 A4 pages length and won't let us extend it further. We have about 7 pages of the report, I didn't think this was too much? Anyone know how to change this please...

HI vbaInet, I did it with out the quotes, it didn't work. Like pbaldy's answer, would I have to have the FirstAid field, then hide it? J

This has worked. Not sure why the quote marks came from. I added the FirstAid date box and then the Checkbox and it worked :) Thank you both. To hide the date box, do I do that in the Properties? Thanks again :)

Hi VBAInet, I tried "=IsDate([FirstAid])" in control source but it still didn't tick the boxes that have a date in the FirstAid field, they all remained blank. there are definitely dates in the field, in fact almost all clients have completed the first aid course (see the attached). J :)

Hi PBaldy, Thanks for your help. That didn't work. First it brought through a paremeter box, then when it ran it did not tck the box that had dates against it. Please see the attached images. Jim :)

HI there, I am creating a report and am struggling to use ticks/checks in it. I have a query that looks for a date in a field and if there is a date, return "True", Else "False" in a separate field. I am wanting on my report to show the date, and next to it a tick if there is a date in the...

Hello, Due to the complexity/time it takes to run of a query, I had to break it up into smaller queries and run them individually. From this, I pasted it into 1 spreadsheet. My boss now wants to do a kind of mail merge (not addresses etc, dates of courses etc) from the spreadsheet into a...

That's awesome, thank you all. Both pr2-eugin and Minty's ideas work.

:) Hi, We have a field (tbl_Enrolment.CourseCompletedOn) which holds the date a colleague completed a course. I want to bring through all courses completed within 12 months of todays date ( Date() ) from our database. Is there an easy way of doing this? I checked google and it...

Thanks RainLover, - Max users at any time - up to 140 users in total, would say max at one time could be 50. - Users are all over the UK in 16 offices. Users also work from home. - Internet varies from office to office. Most offices have up to 8mb download speed with a relatively decent...

Hi there, Our Access database is getting a bit sluggish when loading/running reports. My mate said to me that the Access database that our 100+ users at work use to run reports should be "stripped back" to speed things up and to stop unnecessary actions running when they aren't needed. He...

Hi CJ, Cheers for this, i'll give it a go in the next day or two and see if it works(waiting for a data transfer at present!) Thanks again, really appreciated. J

Please see the attached for sample of tbl_enrolment. I've highlighted in green what is causing a problem. These 3 courses all have different CourseIDs but they are one and the same, just with different names. The client has attended the course 3 times over the years but I just want to pull...