<

MS Access – Passing a String Value within a String Argument

Posted on
4,091 Points
691 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 60

Author Comment

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

Jim.
0

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month