Search results

This code works fine to preview an invoice in Access2003, but not in Access2000. DoCmd.OpenReport "Invoice", acViewPreview, , "Invoice.InvNumber = Forms!Invoice!InvNumber" In Access2000 it just opens then closes as soon as it is open. Any ideas why and how to get it working right with both...

OK I know I'm asking a lot here, but I don't know how to go about this: I have a table called customer with Name, Name/Number, Road, Suburb, Town, County, Postcode, Telephone. The user may need to update these details and therefore I need a way of looking them up. That I can do by one field...

Hi, I have a table with an autonumber field that I want to come out on a report at a 7 digit number. eg 67 would be 0000067. How do I do this? :confused: Cheers

I have a currency field that is not saving pennies. (cents if you're Americian i suppose) :confused: if i put in pence it rounds it to the nearest pound. I have tried setting the decimal places to "2", but that makes no difference :mad: :confused: the table is called invoice this also...

Probably a real simple one here guys. :o I need to hide a field and move up other fields on a report if it is empty. I put this code in the onOpen property: If Reports!Invoice!Item1.Value = "" Then Reports!Invoice!Item1.Visible = False I give me an error though. it says "You entered an...

I have a report that has a table layout, one column puts a description of work done, and another puts the price charged, there are 10 rows I want all the rows that are empty to be invisible and everything below tose rows (sub-total, VAT, total) shifted up. I may be able to do this in VB, as i...

I have a form with a combo box (unbound) that gets its values from a table. I also have another combo box which is supposed to get its values from a query: SELECT Vehicle.Registration, Vehicle.Make FROM Vehicle WHERE (((Vehicle.Customer)=Forms![New Job]!Customer)); I have made the first combo...