ms access

[sammie1021]

1. do you know how to convert the amount "in figuare" to "in words"?
2. do you know how to set up a number of each pages can be auto change,
e.g. 10001, the next page is 10002.....

[Douglas J. Steele]

1. See http://www.mvps.org/access/modules/mdl0001.htm at "The Access Web"
for one way of doing this.
2. Rather than setting the text box's Control Source property to =[Page],
set it to =10000+[Page]

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<sa********@hotmail.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com...

1. do you know how to convert the amount "in figuare" to "in words"?
2. do you know how to set up a number of each pages can be auto change,
e.g. 10001, the next page is 10002.....

[sammie1021]

I cannot get successful in setting text box's control sources property
to set it to =10000+[Page]. It appears an error message after set it to
=10000+[Page].
Whether I do some wrong for setting..........

[Douglas J. Steele]

Are you doing this in a report, or somewhere else? It'll only work in a
report: there's no concept of Page anywhere else.

If you are, in fact, doing this in a report and it's still not working, have
you mistakenly used Page somewhere else: a field name, a control name, etc.?
Page is a reserved word and should not be used for anything you create.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<sa********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I cannot get successful in setting text box's control sources property
to set it to =10000+[Page]. It appears an error message after set it to
=10000+[Page].
Whether I do some wrong for setting..........

[Sammie]

I am doing this in a "Form", which contains a unique number of each
page. If it is set to auto, the number will be from 1. I would like
the number can be change the other format, maybe from 10001 or A20001
etc. Hence, I do not need type the number in each form.

Thank you for your help very much.....

Have a wonderful "Valentine Day".
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message news:<es********************@rogers.com>...

Are you doing this in a report, or somewhere else? It'll only work in a
report: there's no concept of Page anywhere else.

If you are, in fact, doing this in a report and it's still not working, have
you mistakenly used Page somewhere else: a field name, a control name, etc.?
Page is a reserved word and should not be used for anything you create.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
<sa********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I cannot get successful in setting text box's control sources property
to set it to =10000+[Page]. It appears an error message after set it to
=10000+[Page].
Whether I do some wrong for setting..........

[hwangtw]

textbox(bounded autonumber field) /properties/format set to
"A2"0000

"Sammie" <sa********@hotmail.com> ¦b¶l¥ó
news:26**************************@posting.google.c om ¤¤¼¶¼g...

I am doing this in a "Form", which contains a unique number of each
page. If it is set to auto, the number will be from 1. I would like
the number can be change the other format, maybe from 10001 or A20001
etc. Hence, I do not need type the number in each form.

Thank you for your help very much.....

Have a wonderful "Valentine Day".
"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message

news:<es********************@rogers.com>...

Are you doing this in a report, or somewhere else? It'll only work in a
report: there's no concept of Page anywhere else.

If you are, in fact, doing this in a report and it's still not working, have you mistakenly used Page somewhere else: a field name, a control name, etc.? Page is a reserved word and should not be used for anything you create.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

<sa********@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

I cannot get successful in setting text box's control sources property
to set it to =10000+[Page]. It appears an error message after set it to =10000+[Page].
Whether I do some wrong for setting..........