rs! question

#1

Why can't I write to a field name 2ndItemNumber with

rs!2ndItemNumber = st2nd. When I type that in I get a message expected end
of statement and "ndItemNumber" is highlighted. I know it has something to
do with the 2 but I can't figure out how to get around it.

#2

Yeah, you can't start a field with a number sign and reference it without
special treatment.

A fix would be to bracket the field, as in: rs![2ndItemNumber] = st2nd

Hope this helps,

"Cyberwolf" <u41738@uwe> wrote

Quote:

Why can't I write to a field name 2ndItemNumber with

rs!2ndItemNumber = st2nd. When I type that in I get a message expected
end
of statement and "ndItemNumber" is highlighted. I know it has something
to
do with the 2 but I can't figure out how to get around it.

#3

On Fri, 29 Feb 2008 12:37:55 -0600, "ARC" <PCESoft (AT) PCESoft (DOT) invalid>
wrote:

Quote:

Yeah, you can't start a field with a number sign and reference it without
special treatment.

A fix would be to bracket the field, as in: rs![2ndItemNumber] = st2nd

Hope this helps,

"Cyberwolf" <u41738@uwe> wrote

Why can't I write to a field name 2ndItemNumber with

rs!2ndItemNumber = st2nd. When I type that in I get a message expected
end
of statement and "ndItemNumber" is highlighted. I know it has something
to
do with the 2 but I can't figure out how to get around it.

Or,

rs("2ndItemNumber") = st2nd

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

rs! question

comp.databases.ms-access comp.databases.ms-access

rs! question - 02-29-2008 , 11:00 AM

Re: rs! question - 02-29-2008 , 12:37 PM

Re: rs! question - 02-29-2008 , 02:17 PM