ms access

[sammie1021@hotmail.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.....

[Douglas J. Steele]

Re: ms access

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!)



<sammie1021@hot mail.com> wrote in message
news:1108307134 .855527.41510@o 13g2000cwo.goog legroups.com...[color=blue]
> 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.....
>[/color]

[sammie1021@hotmail.com]

Re: ms access

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]

Re: ms access

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!)



<sammie1021@hot mail.com> wrote in message
news:1108308828 .149923.174730@ o13g2000cwo.goo glegroups.com.. .[color=blue]
>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........ ..
>[/color]

[Sammie]

Re: ms access

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_djsteel e@NOSPAM_canada .com> wrote in message news:<esudnWlRU IW_PpLfRVn-tg@rogers.com>. ..[color=blue]
> 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!)[/color]
[color=blue]
>
>
>
> <sammie1021@hot mail.com> wrote in message
> news:1108308828 .149923.174730@ o13g2000cwo.goo glegroups.com.. .[color=green]
> >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........ ..
> >[/color][/color]

[hwangtw]

Re: ms access

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

"Sammie" <sammie1021@hot mail.com> ¦b¶l¥ó
news:2649257f.0 502131806.63ced 1df@posting.goo gle.com ¤¤¼¶¼g...[color=blue]
> 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_djsteel e@NOSPAM_canada .com> wrote in message[/color]
news:<esudnWlRU IW_PpLfRVn-tg@rogers.com>. ..[color=blue][color=green]
> > 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,[/color][/color]
have[color=blue][color=green]
> > you mistakenly used Page somewhere else: a field name, a control name,[/color][/color]
etc.?[color=blue][color=green]
> > 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!)[/color]
>[color=green]
> >
> >
> >
> > <sammie1021@hot mail.com> wrote in message
> > news:1108308828 .149923.174730@ o13g2000cwo.goo glegroups.com.. .[color=darkred]
> > >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[/color][/color][/color]
to[color=blue][color=green][color=darkred]
> > > =10000+[Page].
> > > Whether I do some wrong for setting........ ..
> > >[/color][/color][/color]