Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Still in Access....
Message
 
To
03/04/2002 22:18:32
General information
Forum:
Microsoft Office
Category:
Access
Miscellaneous
Thread ID:
00640691
Message ID:
00640769
Views:
13
This message has been marked as the solution to the initial question of the thread.
>2: RunSQL SQL Statement:
>
UPDATE transaction SET particulars=changeover() WHERE LEN(particulars>0
Doesn't changeover requires a parameter? And a parentheses is missing. The Complete query should read:
UPDATE transaction SET particulars=changeover(particulars) WHERE LEN(particulars) >0
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform