Recent content by jv2

Ive got the problem sorted now... I noticed that I had put the details of the staff member in the page header, but I was not forcing a new page after each of the detail section... obviously some of the staff details were disappearing tehre somehow... it is now printing all 12... Rich, I think...

the sub reports are related by "staff_number"... only one of them has any data entered for one of the sub reports. however, the report prints out "empty" pages for the rest of staffmembers... i.e. it comes out with the staff details at the top of the page... but, the report only prints out a...

Hello all... I have a wierd problem and not sure what is causing it... any pointers in the right direction would be greatly appreciated!!! so, I have a report, which is based on query, which queries the "staff" table. For example, I have a query which returns 12 staff members for a particular...

I have tried searching, but couldnt find anything which I would've understood to be the same what I am looking for.... maybe I am using wrong search criteria? I read the article you linked to, but did not think this was what I am actually after... Let me rephrase the question... How do I...

Hello all... I was wondering if anyone would have a bright idea on how I might solve the following... I need to build an app which has several forms with a number of questions on them... i.e. first with client details etc... then the following forms with lots of different sets of questions...

nevermind.... worked around it with a bit of error handling... should have thought of it earlier :) On Error GoTo Err_lblFormat If [MonthClosingStock] <= [MinStockLevel] Then [Warning].Visible = True Else [Warning].Visible = False End If Exit_lblFormat: Exit Sub Err_lblFormat: MsgBox...

I really dont think it does... :( Have a look at the pic... is this what you mean?

no... it doesn't. :(

hello again... Im running access 2.0 (yuck... I know) I have the following in one of report footers... If [MonthClosingStock] <= [MinStockLevel] Then [Warning].Visible = True Else [Warning].Visible = False End If How would I run this code only if the report has records? Because at the moment...

problem solved by the lovely people at Experts Exchange... :D I now have QryA SELECT Format([NewStockDate],"m") AS NSMonth, * FROM NewSTOCK WHERE (((Format([NewStockDate],"m"))=[forms]![Reporting]![select_month].[value])); and MainQuery SELECT DISTINCTROW Qry_Stock.*...

thank you for the suggestion... but this gives me the same results... the query works if there is data for the selected month in table NewStock... but when there isn't... I dont get anything back from the query...

would anyone be able to tell me how to construct a query that will return all values from another query even if one of the tables has noe related records? I have query which joins another query and a table... the query works fine if that table has related data... then the query returns all the...

found a way round it :) not using the sub query now... just the table... which then returns multiple record for one item if more than one new delivery... then in the report I grouped by item and the put the new stock in the detail (hidden) and used the sum in the calculations... :rolleyes:

Hello... Got a bit of problem creating this query which uses another query. I have a query which takes parameters from form (month,year) which then lists all new stock in that month... then I have a crosstab query which sums new stock deliveries for each item within that month... Then I have...

haha... yeah Im sure it's a bit of a mess.. but it does what it's supposed to do... :) but hmm... so it returns a value for you... very interesting... so in other words there doesnt seem to be anything wrong with it if opened in a newer version of access... but here Im still getting #name? which...