Search results

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

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

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

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

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

Hello! Got a bit of a problem with setting passwords for admin to the database... When I set a password for the admin... and then start another unrelated database, it will ask for the password I entered for the other database... how do I set separate passwords to each database? what is going...

Hello all!! I have been trying to get this to work for a while now... but I just cant work out what is going wrong... I have used the HasData property successfully before, but no luck now. I have a sub report "Report.NewStockMonthTotal" with the Name "NewStock". To do the calculations...