Search results

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

Hi Guys Wonder if you can help as I am not even sure where to start with this small problem that will make a big difference. I have a database that produces yearend accounts, its highly specialized to my industry. The year end accounts have schedules these can be 1 to 3 On my form I have it...

Hi Again, I have worked this out by creating a button on the form that opens the report just for that form, it then returns all the correct data. If I go to another form and click the button it returns the correct results for that form as well. It only works when the form in question is 'in...

Hi Thanks for this, but in the database you attached the field show Name, or an error or 0! And I seem to have to have the form open on the record to return the right amount but that then goes back to original posting that its showing the same result on every page

Hi After fiddling about a bit i finally work it out and works fine and returns 0 instead on an error message. Thank you for your help

I have enclosed a strip out version on my database if you open the Main Site Table, form you can see the problem i am having