Recent content by Keiath

The CaseNumber is an autonumber and primary key

Hi, I have a Form 'Case' and i set up a button so that it would only print the report for the form i am looking at. DoCmd.OpenReport "Report1", , , "[Case]=" & Me.CaseNumberID But its still printing all the forms, can anyone tell me what I am doing wrong? Thanks

Yes that opens up each report, but what I acctually want to do is print all the reports as 1 if that makes sense

I use this for 1 report Private Sub Command732_Click() DoCmd.OpenReport "Budget2", acViewPreview, , "[SITE NUMBER] = Me![SITE NUMBER]" End Sub that ask for the site number of the form and report i want I then tried this:- Private Sub Command735_Click() DoCmd.OpenReport "Front"...

That kinda works only problem is it wants to print all of the accounts (490) of them, what i need it to do is to only print the reports for the form inview Thanks

Hi Guys I have a form that produces Year end accounts, therefore each page is totally different from one another, there are 10 reports per set of accounts. I have created 10 buttons that out puts the desired report Profit and Lost, Balance Sheet ect ect. What I would like now is a way to...

I will refrain from double posting and thanks for the tip on the space requiring enclosing

I use 2 sites as a ref point, this site gave me the correct answer (thank you again) so i posted the solution onto the other site, so a) they know not to bother answering and b) that others can see the answer

=DLookUp("[Expense Discription]","[Expense Codes]","[Expense Code] = " & [ExpCombo]) This worked is this because its 2010 I am working with? And Thank you So much

Hi Guys I have a subform that has the Expense Code from the Expense Codes Table and I want to look up the Description (yes I know its not correctly spelled in the formula but it is in the table) =DLookUp("Expense Discription","Expense Codes","Expense Code=" & [ExpCombo]) But I keep getting...

Yep that was it, works perfect Thank you so much for your help Keiath

Hi Goh Same Form opening a different set of reports So the buttons i have are IandE1, IandE2, IandE3 they in turn open a set of reports according to its number of schedules Now on the same form I have another 3 buttons BalS1, BalS2, Bal3 and again they in turn open there reports according to...

Hi Again Here's a question the above works perfect for the 3 buttons i have- with covers 1 set of reports. As I said there are 3 sets of reports requiring 3 schedule reports as above I tried to do the same again on the next group of reports but I cant use the same button name, so I tried...

Hi Yeah didn't put it in the form current, added the refresh line and all works prefect thank you

Hi Thanks for this, I changed my buttons ect to read what you have it works sort of when I go to a record that has say 3 schedules it doesn't allow me to enter 1 and 2 great, but when I go to the next record and say that's a 1 schedule its not resetting, ie, 1 and 2 are still not available but...