<

MS Access – Passing a String Value within a String Argument

Posted on
4,114 Points
714 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
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 61

Author Comment

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

Jim.
0

Featured Post

Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Generating random numbers is quite easy, but making them persistent to form updates, deletes, sorting, and filtering takes a little more work. Here we will show how to accomplish this with a few lines of code.
If your application will be used by financial auditors, then never ever use the delete functions to remove incorrect documents from your ledgers because financial auditors will require to audit, even cancel or reject documents and reasons for their …

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month