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

Solved Yay, it worked It was the field being called "Number" that was the problem. My report is linked to a table, but is opened in with a SQL statement in VB, Is that what you meant by a report getting data from a query? Why is it bad practice to get data from a table anyway? Cheers

Cheers for the quick reply. Trucktime you're really helpful, you've answered at least one of my posts before. :) But... That didn't work that time, I put =Format([Number],"0000000") in the conrol source, and it comes up with #Error :( Is this supposed to be getting and formatting data from...

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

Problem Solved!! Thats done it cheers mate :)

I think I'm having the exact same problem ;) I have a form that opens on a user specified (or new) record with many fields that the user can edit. I only want one record to be able to be edited each time the form is opened. The problem I'm having is if the user is editing the last textbox in...

I have exacly the same problem (I think). ;) I have a form with many fields. It opens on an already existing record selected by the user. The user can change any value in any visible field. When the user presses enter on one field it moves on to the next one (this is fine and what I want) :)...

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

Sorted Cheer mate, thats sorted it. I thought it might be something that simple. Thanks again

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