Re: couple question about Ivoice FORM

#1

got an email on the first question and its fixed...

still need 2nd one though, please

"simsghost" <simsghost (AT) hotmail (DOT) com> wrote

Quote:

FIRST issue :

at the top of the invoice that lists all the company info, the phone
number
is the last thing.
I currently just set it to control source = phone number, but on the
invoice
it shows ie 5558001234
i want
(555)-800-1234

tried using this but get a error
=DLookUp("[PhoneNumber]","Phone Number")

SECOND issue :

when completing a sale, and i goto preview invoise it always asks me for
the
customers state/province and then the shipping state/province in a little
popup window. I would like it if it just read it from the customers info
like everything else... any ideas

thats all for today
reply : simsghost AT hotmail dot com

#2

hi!!!!

well the query is not being supplied with the customers state/province
and shipping state/province values.

if u can give more details as to from where and how u open preview
invoice it would be helpful.

thanx
bala

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: couple question about Ivoice FORM

comp.database.ms-access comp.database.ms-access

Re: couple question about Ivoice FORM - 08-19-2003 , 07:44 PM

Re: couple question about Ivoice FORM - 08-22-2003 , 09:44 AM