<

MS Access – Passing a String Value within a String Argument

Posted on
4,134 Points
734 Views
4 Endorsements
Last Modified:
Published
Experience Level: Beginner
5:43
Jim Dettman (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

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 67

Author Comment

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

Jim.
0
While working on a calendar and appointment scheduling application, I found I needed to synchronize multiple sub-forms, displayed side-by-side, so users would be able to see the schedules of multiple care providers and identify gaps in their schedul…
Callback functions are a hidden gem in Microsoft Access. With these, you can dynamically fill a combobox or listbox entirely from code with a versatility way beyond what a simple static value list can offer. This article covers how to share one call…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month