Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / New Users / July 2005

Tip: Looking for answers? Try searching our database.

Remove Quotations marks from String Variable?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
GolfGolf - 31 Jul 2005 19:54 GMT
How do I remove the quotation marks from a string variable?
Can it be done?
MacDermott - 31 Jul 2005 20:31 GMT
Could you be a little more specific on just what you want to do?
Are you concerned about quotation marks embedded in a string?
   In that case, you can use the Replace function to replace them with a
blank string.

OTOH, if you're concerned that you see string values reported with quotation
marks around them, that's so you can tell where the string value begins and
ends.  Those quotation marks aren't really part of the value.

> How do I remove the quotation marks from a string variable?
> Can it be done?
GolfGolf - 31 Jul 2005 20:54 GMT
I am trying to refer to a subform field from another form.
I am trying to set the time from a popup form

I have; varTime = "Forms![Form1]![Form2].Form![ChickInTime]"
in the popup from
When the popup closes i am trying to set varTime = anopther Variable
that is a specific time.
But it's not working

> Could you be a little more specific on just what you want to do?
> Are you concerned about quotation marks embedded in a string?
[quoted text clipped - 7 lines]
> > How do I remove the quotation marks from a string variable?
> > Can it be done?
John Vinson - 01 Aug 2005 00:16 GMT
>I am trying to refer to a subform field from another form.
>I am trying to set the time from a popup form
[quoted text clipped - 4 lines]
>that is a specific time.
>But it's not working

That should set varTime to the text string

Forms![Form1]![Form2].Form![ChickInTime]

since you're setting it to a literal text string.

Try removing the quote marks - does that cause problems? If so, what
problems?

                 John W. Vinson[MVP]    
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.