Search results

I know you can output a form to a printer but is there anyway of printing it without the standard soft grey background, I know I can change the background to white but I would prefer to keep the form with the soft grey as it makes it much easier on the eye for data entry...........would a macro...

Thanks for pointing me in the right direction with the Zero/Null point......what I had done after I put in the calculations was take out the default 0 (Zero's) in the fields for easier data imput and so I needed to use the Nz function at the start of my expression to stop the expression...

Thanks to both of you for all your help. Paul

Jack you are a Star......your turning out to be my personal mentor......I have spent all day today on my problems, I don't just jump onto the forum for the answers, otherwise I'll never learn......but it is a great relief when you find the solution......your help really is greatly appreciated

I have a calculations on a form that add up different objects on the form ie: =[Handling Charge]+[Packing]+[Delivery Cost] to give me a sub-total then further similar calculations and then finally adding the totals togther, it all worked very well but for some reason they have stopped doing hte...

I have an input form that has a control on it to create a new record, but what I'm finding is that when I tab through entering data when it gets to the end of the Tab Order it creates a new record, can I stop it doing this ?

Sorry........... I discovered that I didn,t have all the fields named in the Combo Box....it works a treat except that if any of the fields are empty, say Post Code (Zip Code), then I get an error message "Field (name of field} cannot be a zero-length string" with the option to Debug or End, if...

Typed in exactly as you stated but the field are still blank, I'm sure it's because I have the fields set up from the fields list from the order table and need to change them to display the results from the columns in the query......but how ?

I have created an Order Form and Order Table to store the data. I also have a Main Table which contains all my Names and Adresses. To make life easy I decided to select the Customer Name by creating that field as a Lookup Combo Box in the Order Table and this looks up a query of Names and...

Thanks for the info, what I was trying to do was to catch the users eye by highlighting fields on the form..............never mind it may be one development for Microsoft for the future, Many thanks once again

Can I designate colours for each option in a combo box as you can with a Yes/No box, for example : Urgent in Red, Chase in Blue, Normal in Green, Non-Urgent in Orange and anything manually entered in default Black

What I have done in the end is create a new table and a subform with a Date and Type of Contact control, then placed the subform onto the main form with a control button that takes me to "View all contact records". I shrunk the display box down to reveal only the current record on the main form...

I am trying to re-create the Calls form used in the Contact Management template which is a Bullet Point datasheet with a single form containing detailed notes (Memo), all info is sourced from the same table. The nice touch it has is that as you scroll down the bullet points for each customer the...