Search results

Hi, when I run that code it brings through the ClientID in the output that I put in, so yes it works. (it was only supposed to bring through a number, not anything else, right?) Thanks for helping VBAInet, both with my Access and spelling issues :D

I couldn't stick it all into one query as the latter ones bring through multiple records per ID and was causing problems. Also, the format the person who wants the report was very specific. The data source(s) are 3 spreadsheets I uploaded to Access, set as tables.

1 - "Final 1" record source = qry_COMPLETEDDATES 2 - "Final 2" = qry_COMPLETEDDATES 3 - "Final 3" = qry_COMPLETEDDATES 4 - "Final 4" - qry_Other Qualifications 5 - "Final5" = qry_Cancellations 6 - "Final 6" = SELECT dbo_Tbl_Client.ClientID FROM dbo_Tbl_Client WHERE...

Record source is empty on the master report. (master report is just a blank report with sub reports dropped in) Only the sub reports have record sources? J

Hi VBAInet :) I have created a form that includes ClientID, CLient Name in a drop down box. I have referred to that form in my criteria of my queries. When I run the reports individually, it asks for the CLIENTID and runs fine. When I've added them all into 1 report as subreports, its asking...

Sorry, I was speed typing! :) So I should create VBA code to say open the Form once the button is clicked? Thanks for your reply! Jim

Hi, I've made a report on a blank report template. I've dropped in 5 sub reports. I have entered into the criteria for each of the queries based on [forms]![ClientForm]!CleintID. to run the report. It wortks but I have to enter the ClientID 5 times. Usually, when I create a button to...

Woo! That has worked :) Got it wrong a few times but all good. Thank you very much for your patience VBAinet!! :)

Where abouts in the code should I paste it? I suck at VBA!

When I create a form which the user selects who/what they want to run the report for, I include other details such as ClientID, FirstName, SecondName. I drop into VBA to open this form when the button is clicked. I add this to the criteria in a query so the report filters on the selected record...

Yes, clientID, but if the filter could show the name, that'd be the best :)

I would say ClientID for filtering (there are no blanks). There are 2000+ records its looking at so the more detail the better. I thought I'd got away from Access. SQL I kind of get and usually just analyse numbers. Designing is a horrid experience!

Yes, that's right. Also, the ClientID the user usually knows. This also helps differentiate between those that have the same name. I really appreciate you helping, its been a long long few weeks.

Actually, Access created an "ID" as primary key. This is due to there being 8 duplicate ClientIDs. So what is linking them all is the "ID" field.

Yes, that's right. All report/subreports are linked via ClientID. In an ideal world, I'd like that the form (Frm_CLientBox) I have created that has the CLientID, Lastname, FirstName come up when the user clicks on the report so they can filter from that point.

Sorry, it's been a long weekend of :banghead: Ok, I need help with getting the part of PBaldy's link to work. I've never done this before so not sure what to do first. Is that better? :)

Ha, I'm a novice developer, my colleague had a heart attack and I've got to look after her system until she returns. I tend to copy paste her VBA and just change the relevant fields. Just to confirm, I can't do what I am wanting to do?

They are used to clicking a button on a form to open a Form with a dropdown box for them to choose a record from before running a report. The form I made for this, based on ClientID, also included First and Last name to help them find who they want. I've started recreating the report based...

Thanks for that. I don't understand lots about VBA so i'll just rewrite the report based on a query. Its got to be user friendly too and this will be too complex for end-users to figure out. Thanks for your help though! J

Ha, no! :( I've just googled it and it says there should be a togglefilter option on the data tab in the report properties, but there isn't? EDIT: found it I think (see the attached), not sure what to do from this point.