Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2008

Tip: Looking for answers? Try searching our database.

rs! question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cyberwolf - 29 Feb 2008 17:24 GMT
When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
end of statement error with "NDItemNumber" highlighted.  I know it has
something to do with the 2 but I can't figure hout how to get around it.

Sorry if this is a duplicated post but I don't think I posted the 1st one
correctly.

TIA
Robert Morley - 29 Feb 2008 17:30 GMT
2 is considered an invalid character to start a name with.  It's okay within
a name, but not as the first character.  Try rs![2NDItemNumber] and see if
that works.  I believe it should.

Rob

> When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
> end of statement error with "NDItemNumber" highlighted.  I know it has
[quoted text clipped - 4 lines]
>
> TIA
mcescher - 29 Feb 2008 17:40 GMT
> When I try to create this line rs!2NDItemNumber = st2nd I get an unexpected
> end of statement error with "NDItemNumber" highlighted.  I know it has
[quoted text clipped - 4 lines]
>
> TIA

Cyberwolf,

.Fields("2NDItemNumber") = st2nd

Hope this helps,
Chris M.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.