Search results

Hi, ...think i'm after a similar problem to you guys.i'm trying to make a label invisible on a form, when the field is null. I don't need anything to move. I tried the above code and all i got was 'Can't find macro 'If Me'' Have i done something wrong here?

Thanks From a table!

Basically i've created a table called VAT holding 2 records of VAT rates. I've created two records in a combo box . In my form these records appear in my drop down list, however when i select either value the actual field value remains on naught. Am i missing something really simple here?

don't know if this is right...but the simplest approach i would do...is to create a button in design view of your form. follow the wizard...using the options Record Operations...Duplicate Record When this is created name it 'duplicate'(orwhatevers logical to you) and whenever you need to copy a...

SORRY!!.. i meant a field in a report....this is the wrong forum as well..... can anybody help?? Don't dare post this in the report forum aswell...after last time!

Hi. Does anyone know how to set a textbox label on a form so that it only shows if there is information to go in it!! Rather than print out an empty field! ...thank you so much if anyone can solve this!!!

...sorry..made amistake ...mean this number cannot be my order ID!!!

can anyone tell me how to solve what i hope is a simple problem!! every reord on my order form has an automated(autonumber) orderID...however i need a number that is displayed on this form that is only generated when a form is (e.g. invoice) does anyone even understand this waffle?? basically...

Just really wanted to knoe if this is a feasible option!... I want a drop down list that currently contains all my products to also contain all my services!...is this possible??

thanks... but i managed to persuade a VB expert in my office solve my little problem.............!!!

Hi....am totally stuck!!! I've got an order form from which the user can chose a shipping type e.g. postage, express etc. I have a table caled 'shippers' which contains the field 'default cost' which holds the information i want generated. The problem is that i have no idea how to generate the...

Brilliant !!! thanks pat!! ..problem solved :D

Sorry..look i was just looking for help, please don't make things difficult

Its ok...i just checked your profile. i didn't realise you were at that 'hormonal stage'. Its ok ....i realise your socially inept. :D wanna play?

I don't wear glasses get rid of your sad eye..rich

Colin. I agree it would have been funny.. but rich seems to have spent quite a bit of his time today going around my various posts and making unhelpful comments. I appear to not be the only one either :(

thanks for all your help colin and indecisive!!! think its nearly there.....!!!:)

Rich. please be constructive and leave me alone

Does anyone know anything about currency conversion methods? e.g. i have an order form with generated three different reports. One of these reports is an invoice for the customer in pound sterling. However i also want to generate a purchase order from suppliers..which needs to be in dollars. I...

Hi i was wondering if anyone new how to make a query so that when a user types in e.g. a licence number into an order form, the license number and the customer details could be added to another access database table in the appropriate fields?? I'm pretty new at queries, so i need quite a dummy...