[AccessD] Single and Double Inverted Commas!

Gustav Brock Gustav at cactus.dk
Thu Nov 30 06:15:16 CST 2006


Hi Chris

Well, still lazy, so why not:

  Me.MonTotDBAdmin.ControlSource = Replace("=DSum('DCAdminEventTime','qry" & strInitials & "_Mon')","'","""")

/gustav


>>> cclenright at yahoo.com 29-11-2006 22:39:36 >>>
v\:* {behavior:url (#default#vml);}v\:* {	BEHAVIOR: url (#default#vml)}Hi Gustav,
 
I love lazy!
 
Problem is though that there are 42 controls that I want to change depending on the "strInitials" picked up when the name of the member of staff is selected to open the form.
What I am looking for is the correct syntax for something like
 
Me.MonTotDBAdmin.ControlSource = "=DSum('DCAdminEventTime','qry"   & strInitials &  "_Mon')"
 
Which I know is completely wrong but I have forgotten how to use those %$*^"£$   "s and 's but would create 
=DSum("DCAdminEventTime","qryEM_Mon") if strInitials="EM"

 
Chris
 
-------Original Message-------
 
From: Gustav Brock
Date: 29/11/2006 16:22:02
To: accessd at databaseadvisors.com 
Subject: Re: [AccessD] Single and Double Inverted Commas!

 
Hi Chris
 
How about a lazy solution:
 
  strControlSource = "=DSum('DCAdminEventTime','qryEM_Mon')"
  Me.MonTotDBAdmin.ControlSource = Replace(strControlSource,"'","""")
 
/gustav
 
 
>>> cclenright at yahoo.com 29-11-2006 12:14:08 >>>
  I am getting too old and have been away from programming far too long
  I never have understood the use of " and ' completely
  Could someone please correct this for me,
  Me.MonTotDBAdmin.ControlSource =
  and what I want it to equal is
  =DSum("DCAdminEventTime","qryIG_Mon")
  but with the IG being replaced with strInitials
  My attempt with strInitials="EM" came out as =DSum('DCAdminEventTime','qryEM_Mon') and wouldn't work
 
  Thanks
  Chris




More information about the AccessD mailing list