Search results

Probably a stupid question but I can live with that: Is it possible to use the same underlying query for different (but similar reports or forms)? Or do you have to copy and rename it. eg can you use qry1 as the data source for both rpt1 and rpt2?

Thanks. I tried naming the field on the subreport something completely arbitrary - txtTotalAmountProposal235 - and it's still doing the same thing. So I don't think that's it. Is it something to do with the fact that the subreport (boardproposal) is in list (table) form, and it is only...

Thanks a lot - the combination of Q141624 and Pat's advise to use subreports gave me exactly what i wanted. I have another problem now though. I need to sum the amount in the proposal subreport and show this figure on the main report. I have followed previous advise on the forum and put a...

Ah, that's why I couldn't find it. Thanks v much!

thick question: how do you search by article ID?

Thanks, I've been searching using 'join' which is coming up with a lot of stuff which i've been browsing through looking for inspiration! Will try that now.

Something like this: Company Name Key Individuals Proposal amount [Co 1 Name] fred, joe, mary £500,000 [Co 2 Name] mark, judith £100,000 etc

I have a database in which i have to record data relating to companies, with a page for each new company. One of the pieces of data is key individuals who work for the company, and since this is a repeating field, i have set up a separate table called tbl KeyStaffand linked it to the company...

Ha ha, I know it was confusing, I was kind of changing my mind as i wrote it. Sorry about that. Forgive me for sounding thick, but I assume the month() function extracts the month from the date, and then I can store it in a variable, and assign this variable to a text box on my form? I don't...

I have a situation where I need dates in two separate formats. Currently I have 3 fields - FollowUpDay (eg 19), FollowUpMonth (eg may) and FollowUpYear (eg 03). What I want to do is retain these, but have another field - FollowUpDate - in date/time format. So I can work with the two formats...

thanks v much for having another look at it. the original one worked ok after fiddling about with it a bit. i think what i'd done was put line separators in where you hadn't which is what confused it! i only worked it out about an hour ago after worrying all night. anyway, thanks again, it...

Sorry to drag this one up again, but I've been trying to recreate the syntax in access 97 and I'm getting an error. Can anybody see what's the matter with this line of code? Set Qdf = dbs.CreateQueryDef("", "SELECT tblHIBOpsTraining.TrainingArea, _ tblHIBOpsTraining.ID...

Sorry to drag this one up again, but I've been trying to recreate the syntax in access 97 and I'm getting an error. Can anybody see what's the matter with this line of code? Set Qdf = dbs.CreateQueryDef("", "SELECT tblHIBOpsTraining.TrainingArea, _ tblHIBOpsTraining.ID...

I'm struggling with this problem and I'm sure it's simple. I've search the forum without success for a solution, and have found it necessary to ask! I want to have a command button which when pressed makes one subform visible and another not visible. To do this I've been attempting to declare...

That's great, it works. Thank you very much.

Unfortunately adding those two parentheses doesn't make a difference. That would have been a great answer!

Would that prevent it ignoring the [name] parameter in the criteria of AccountHandler?

Oh, I get you! No, they were all entered like that - (there's also CreatedDay but that's not relevant here). Is that likely to cause a problem?

Yeah, they're stored in a table.

No problem, here it is: