Search results

thanks damn, i thought that might be the case, i don't have office xp only 2003, what do you suggest for securing the fe and or the be? cheers optidisk

Hi, I have created a fe/be database, now my problem is that I want to make it secure and I thought creating an mde would be just the ticket but the client I am creating it for is running access 2000 and I have created it in access 2003 under XP Pro but in 2000 format, when I go to create the mde...

xlent, many thanks - just the ticket

Hi I have been searching this forum for 3 hours for a solution, some come close others are pure gobble de gook to me. I have on a form 1 combobox where a name is chosen, from that choice I would like the address, suburb, state etc automatically placed intheir relevant fields. I have tried...

Here's what I have so far I have attached the database, the problem reports are the three different types of invoices.

The only way I got it working was to put the sum functions in the detail section and hide duplicates. I tried every section in the report and having it in the detail section gave the best results for the printout cheers optidisk

The page footer

No they are text - (milling grade of timber) I have sort of got it working by using hidden fields in the detail of the report in the calculation fields, only problem even after setting the hide duplicates value to yes, I still get one repeat of the totals on a new page.

still not working Thanks for all the tips everyone but unfortunately if I put the iif sum in the report footer where it is wanted I get Error. As for the select query, you've lost me there - the underlying select query for the report is made up of five fields from 2 tables and two calculation...

I tried this in a select query - Quota: Sum(IIf([Grade]="O",[VOL],0)) and I now recieve the error msg "You Tried To Execute a query that does not include the specidied expression "ID" as part of the aggregate function" ID is in the query but not needed for the function, what does this mean...

I'll give that a go, thanks optidisk

I have created a logging report that shows the records from a form, the fields are Species, Length, CDUB, RAD, VOL, Grade I need to sum the VOL of each Grade, so if a row has the grade "O" include it in the sum. there are 5 different Grades so I will need 5 formulas. I tried this...