<

MS Access – Passing a String Value within a String Argument

Posted on
4,081 Points
681 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Join & Write a Comment

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
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, …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month