RE: [MS_AccessPros] RE: this is to reply to Duane. (no idea why the Reply button's not working) How do I or is it possible to use the BRING TO FRONT and SEND TO BACK in VBA code?

I expect the single or double-quote issue is based on your regional settings and flavor of SQL.

Duane Hookom MVP
MS Access

________________________________
> To: MS_Access_Professionals@yahoogroups.com
> From: saigonf7q5@yahoo.com
> Date: Fri, 13 Dec 2013 11:48:31 -0800
> Subject: [MS_AccessPros] RE: this is to reply to Duane. (no idea why
> the Reply button's not working) How do I or is it possible to use
> the BRING TO FRONT and SEND TO BACK in VBA code?
>
>
>
>
> Thanks Duane, if I use the double-quote EmployeeID & " - " & LastName
> in the Select clause, it generates an error 13 Type Mismatch, until I
> changed it to a single-quote.
>
>
>
> There's a Select Statement example in my SQL book also showing using a
> pair of single quote but not double. If I remember correctly, I think I
> have used double-quote in my other applications and it worked. Why is
> that?
>
>
>
> Phucon
>
>
>

------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
http://info.yahoo.com/legal/us/yahoo/utos/terms/