<

MS Access – Passing a String Value within a String Argument

Posted on
4,061 Points
661 Views
4 Endorsements
Last Modified:
Experience Level: Beginner
5:44
Jim Dettman (Microsoft MVP/ EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
4
Comment
2 Comments
 

Expert Comment

by:Patrick O'Dea
Thanks Jim,
Excellent tutorial - especially those quotes and double quotes ....

The tutorial is very clear and I fully understand it.  The chr(34) makes life easier.

However, please forgive me if, in 6 months time, I get myself in a "quotes" knot again and request help from EE!
Regards,
Padraig in Ireland
(An occasional VBA user whom you have helped numerous times!)
0
 
LVL 59

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Thanks for the comment!

Jim.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Join & Write a Comment

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Suggested Courses

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month