[AccessD] Single and Double Inverted Commas!

Hi Chris

Demo sent off list

I am not too sure the dot controlsource property can be set at runtime (IE
Changed via code with the form 'running') - I am sure someone on the list will
correct me if I have it wrong

See ya
 
Darren
------------------
T: 0424 696 433

-----Original Message-----
From: Chris Enright [mailto:cclenright at yahoo.com] 
Sent: Wednesday, 29 November 2006 10:14 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Single and Double Inverted Commas!

  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

 
---------------------------------
Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com