Thank you, Richard. By far the clearest explanation I've found. I needed this for a 'filter on load' property for an edit list form and thanks to you it works just the way I need it to.
Hi Richard, have revisited this video many of times along with some other videos on Access Concatenation. At first, I thought concatenation would forever remain a mystery to me but I must say the fog is beginning to lift and the dots or might I say the quotation marks are moving much closer. Thank you for all that you contribute to the Access community and of course ""& Happy &"" & " " & ""& Birthday &"" & ""!""
Use these: “ (ASCII 147) ” (ASCII 148) ‘ (ASCII 145) ’ (ASCII 146) instead of these: " (ASCII 34) ' (ASCII 39) within your text data, and you avoid having to use double-double or double-single quotes in VBA or SQL. E.g. at 6:27, you can use: Greeting: "She said, “Hello Brent”" “ is not on the keyboard, but you can type it by pressing and holding the Alt key and typing 0147, then releasing Alt. ” can be typed the same way, but with 0148. ‘ with 0145, and ’ with 0146. Use these special quotes for your text data in your tables and display purposes, and leave the standard single and double quotes for VBA and SQL.
Hi Richard, I think the quotation mark in the second position inside the double double quotes works as an escape character to let the VBA interpreter know that it is a string, like in many programming languages. I could be wrong as I'm new to Access.
It's possible. So long since I recorded this video that I don't honestly remember what you're talking about. What is the time index? I don't want to have to rewatch the entire video. LOL
@@599CD 7:21 " " " " The quotation mark in the 2nd position tells VBA to stop treating the quotation mark in the 3rd position as special characters And treat it as a part of the string. (quotation marks are used as a special character in VBA). heh Just ignore what I'm saying if I'm still not making sense to you. English is not my native language.
Can you someday show how to print envelopes in Access? I spent an enormous amount of time (with help from your videos) creating a database with all the names and addresses of my friends. (Modeled after your Customer Contact database.) I had to hand address Christmas cards because I couldn't figure out how to get Access to print an envelope.
Personally, I recommend mailing labels. They're a whole lot easier than dealing with envelopes from a physical standpoint, and there's a nifty label wizard. You're right though - I haven't covered printing envelopes in any of my classes. I did get a question about them from a Member a little while ago. I'll have to add it to the list.
Yeah, I don't endorse Facebook anymore. I still have the groups, but only because people have signed up and do still use them. Facebook's draconian policies have caused me to move away from them.
You shut your mouth! If Microsoft put out good training videos like this, I'd be out of a job. (But if Microsoft is willing to buy my company, I'd consider it...)
@@599CD Lmao. Nothing against you, bud. :) You have done so much amazing work for the Access community, and have saved so many people so many hours of frustration and research-fatigue. I'm so glad there's a place for you in the Access ecosystem, and with the value you bring, that'll never change. I really liked this video, but I wanted to a deep dive on this so I FULLY GET IT, not through someone else's eyes, but to the letter of every rule and protocol discussing quotes and quoting IN DEPTH, so there's less guesswork. And I cannot find ANYTHING anywhere that goes into amazing depth on this. It's nice to know "when you're in this situation, do this" but it's really nice to know all the technical details in depth.
I get it. That's what reference books are for. I recommend the Access Bible. th-cam.com/video/DArGClwOcLI/w-d-xo.html See this page for more about my teaching style, and how I'm different from a reference book: 599cd.com/FutureLesson
Thank you, Richard. By far the clearest explanation I've found. I needed this for a 'filter on load' property for an edit list form and thanks to you it works just the way I need it to.
You're very welcome
Excellent. Best explanation and examples I've seen. Thanks.
You're very welcome!
Hi Richard, have revisited this video many of times along with some other videos on Access Concatenation. At first, I thought concatenation would forever remain a mystery to me but I must say the fog is beginning to lift and the dots or might I say the quotation marks are moving much closer. Thank you for all that you contribute to the Access community and of course ""& Happy &"" & " " & ""& Birthday &"" & ""!""
MyReply = "Thank " & "You!"
HOLY Krack... You explained this so easy even I understood.. Mercy beacoup ..
Welcome
Really helpful! Thank you a lot!
You're welcome!
Use these:
“ (ASCII 147)
” (ASCII 148)
‘ (ASCII 145)
’ (ASCII 146)
instead of these:
" (ASCII 34)
' (ASCII 39)
within your text data, and you avoid having to use double-double or double-single quotes in VBA or SQL. E.g. at 6:27, you can use: Greeting: "She said, “Hello Brent”"
“ is not on the keyboard, but you can type it by pressing and holding the Alt key and typing 0147, then releasing Alt.
” can be typed the same way, but with 0148. ‘ with 0145, and ’ with 0146.
Use these special quotes for your text data in your tables and display purposes, and leave the standard single and double quotes for VBA and SQL.
I personally hate those "smart quotes" but I see your point.
Hi Richard, I think the quotation mark in the second position inside the double double quotes works as an escape character to let the VBA interpreter know that it is a string, like in many programming languages. I could be wrong as I'm new to Access.
It's possible. So long since I recorded this video that I don't honestly remember what you're talking about. What is the time index? I don't want to have to rewatch the entire video. LOL
@@599CD 7:21 " " " " The quotation mark in the 2nd position tells VBA to stop treating the quotation mark in the 3rd position as special characters And treat it as a part of the string. (quotation marks are used as a special character in VBA). heh Just ignore what I'm saying if I'm still not making sense to you. English is not my native language.
Well-Done Sir.
Thanks
Dear sir.. pls relese the full lesson regarding stock in & out , value count of goods . Sir Your kind attention highly appreciate.
599cd.com/Inventory
You are a star
Shining so bright... :)
Can you someday show how to print envelopes in Access? I spent an enormous amount of time (with help from your videos) creating a database with all the names and addresses of my friends. (Modeled after your Customer Contact database.) I had to hand address Christmas cards because I couldn't figure out how to get Access to print an envelope.
Personally, I recommend mailing labels. They're a whole lot easier than dealing with envelopes from a physical standpoint, and there's a nifty label wizard. You're right though - I haven't covered printing envelopes in any of my classes. I did get a question about them from a Member a little while ago. I'll have to add it to the list.
how concatenate multiply textboxes of values in access form and save them in one field of table
Huh?
Good afternoon
Please help me how to get (and) sign in Ms access.
Here ya go... 599cd.com/BuyAccess
A string with an apostrophe character causes troubles every time: like 3' or can't or 2's
Indeed it can. That's why I prefer using double-double quotes. 599cd.com/DoubleDouble
=[place]&", "&[date]
Bali, 18/08/2021
How to change become "Bali, 18 Agustus 2021" ???
Use the FORMAT function for the date part. In your case: FORMAT([Date],"dd mmmm yyyy")
599cd.com/glossary/access/format/
Howdy! What's the Facebook group?
Oh wait, never-mind, found it in the description above.
Yeah, I don't endorse Facebook anymore. I still have the groups, but only because people have signed up and do still use them. Facebook's draconian policies have caused me to move away from them.
*sigh* WHY IS THERE NO MICROSOFT ARTICLE SOMEWHERE THAT EXPLAINS ALL THIS!?!?!? Why do they leave this to random people on the internet to explain!?!?
You shut your mouth! If Microsoft put out good training videos like this, I'd be out of a job. (But if Microsoft is willing to buy my company, I'd consider it...)
@@599CD Lmao. Nothing against you, bud. :) You have done so much amazing work for the Access community, and have saved so many people so many hours of frustration and research-fatigue. I'm so glad there's a place for you in the Access ecosystem, and with the value you bring, that'll never change. I really liked this video, but I wanted to a deep dive on this so I FULLY GET IT, not through someone else's eyes, but to the letter of every rule and protocol discussing quotes and quoting IN DEPTH, so there's less guesswork. And I cannot find ANYTHING anywhere that goes into amazing depth on this. It's nice to know "when you're in this situation, do this" but it's really nice to know all the technical details in depth.
I get it. That's what reference books are for. I recommend the Access Bible. th-cam.com/video/DArGClwOcLI/w-d-xo.html
See this page for more about my teaching style, and how I'm different from a reference book: 599cd.com/FutureLesson