I usually use the simple "find and replace" method and it works like a charm.
@599CD2 күн бұрын
Indeed
@sidc.38172 күн бұрын
I always wanted to make a family tree database where a child could also be a parent in the tree....been stumped on how to make the child table also a parent table....like self referencing..
@599CD2 күн бұрын
599cd.com/SelfJoin
@johnwatkins392 күн бұрын
I used chatgpt to help me write vba code to import images into my access database. The vba code would put in checkboxes etc. I love chatgpt.
@599CD2 күн бұрын
Yeah GPT can be a great tool for people who already know how to program to have it do tasks like this
@josemariaroman70573 күн бұрын
Inspiring as always. I love it. Thank you.
@599CD2 күн бұрын
You're welcome
@singatamil21053 күн бұрын
Pls tell me if i share my screen my live caption other pereon can able to see ? In ms teams ?
@599CD2 күн бұрын
No idea I'm not a Team's user
@mohanrajanraj69813 күн бұрын
Sir kindly help me. I need to convert the ocr file ( pdf ) into a word document. Any free option is available?
@599CD2 күн бұрын
That is a question for the Google machine
@shawnbuettner60734 күн бұрын
When I look at my tables, the ID number is stored there in the title field, but not the actual title. It looks good on the form, but the table isn't correct.
@599CD2 күн бұрын
Well there's no way that I can help you from here without a lot more information so if you need help post here: 599cd.com/Ask
@johncarter44124 күн бұрын
I have a DB with 3500 records. I also have a folder containing an image for each record. How would linking images to each record affect performance?
@599CD2 күн бұрын
If you're just throwing the file name to the image in the table it shouldn't affect performance at all
@DarryllLamb4 күн бұрын
My OrderDetailF will not fill will all OrderDetails, only one record at a time, but the OrderDetailQ does list all records… Help?
@bmgCams4 күн бұрын
thank for giving knowledge to mankind May you be protected
@599CD2 күн бұрын
It's my pleasure
@janvanantwerp65744 күн бұрын
Ah Look at that.......
@Jgc814 күн бұрын
Use less
@nickbroekhuizen88584 күн бұрын
Thanks, Richard ... I never knew you could use "DIR" in VBA ... learned something .. 👍
@TeguhWijayanto27674 күн бұрын
How to send pay slip email to each employee with 1 click, thank's
@JeffreyRaffel4 күн бұрын
Can you do video for counting lottery winners in Excel for multiple drawings and another video for calculating the lottery payouts in excel for multiple drawings.
@xabaya32945 күн бұрын
i know this is a year later but it was very useful thanks, is there a way to do the same with a variable (i need to take the numeric part of a serial number, increment it and reassemble it for a new serial) thanks
@DingusBatus5 күн бұрын
I do the same thing when typing, and for the exact same reason. If it doesn’t automatically capitalise things then I know I’ve made a mistake.
@houser7475 күн бұрын
Yes please for a Python version.
@peymanyousefi34885 күн бұрын
Hello,can I draw a border just around the details section in report??
@MousaAlKalbani5 күн бұрын
Thank you. Can you make a serious on how to make a Gant Chart on a continuous form to follow-up projects?
@user-gw5nr1oc1h5 күн бұрын
Excellent video. Thank you
@kevinstark-w4z5 күн бұрын
I want to get this mailing system but with bulk list and some tagging for html that convert to pdf
@youknow55695 күн бұрын
WOW! I started on TRS80 Model 1 GREAT TIP! Thank you! IF LEFT$(Q$, 1) = "R" THEN OD = VAL(MID$(Q$, 2, (LEN(Q$)))): DE$ = "CR ": S = 1: PE = 7: PT$ = "RETURN "
@theamazingreviews58305 күн бұрын
Hi, thank you very much for this tutorial! A question: if I already have a Word template with, for example, the company logo (image) in the header, can't I throw my report into the "body" of the Word template? A thousand thanks
@katherandefy6 күн бұрын
Oh hi I miss your channel so much. Have been gone since grad school last yr. By the way that was super exhausting but right at the end I used your channel to finally learn Access. It was an absolute blast and SO much fun. Needless to say I got an A in my data management class centered on Access. You are the very best! Your vids rock. Love your website. So easy to find anything I needed.
@dmfd3056 күн бұрын
How does How does Trim([FirstName)] work if there is a field that contains Ctrl+return? Does it trim after Ctrl+return? I will check, but a point to bring to followers.
@afrinsir74796 күн бұрын
nice
@LeoDaly-c4h6 күн бұрын
Thanks for the info. I tried using the Edge Browser on a form. I put it on to a blank form the same way as you did but when I clicked the button, the browser opened in a separate window. What am I doing wrong.
@HusnaSadat-fo4zt6 күн бұрын
thanks
@jonjcapps6 күн бұрын
Great video, and yes on the Python, I under stand it is a great language to learn. If there is lessons to use in real world like this email, I am game.
@kazzdevlin53396 күн бұрын
So I created a 5x3 sized form in design then when viewed it fills the window. Why is it not showing it as 5x3?
@monasenter6 күн бұрын
Very helpful information and explained in a manner that was easy to understand even for a senior like myself. Thank you so much!
@bjones99427 күн бұрын
This is why I sometimes take beginner courses (or watch beginner training videos) - Especially with Microsoft products. So many things are available it's hard to learn them all. I also use the 'record macro' option to create vba code when I don't immediately have a solution.
@rtatt17 күн бұрын
Rick, have you been sleeping for 30-something years?😂 Honestly blew *my* mind that you *didn't* know this. Normally wouldn't point that out to somebody, but hey, you did ask!😊
@Valencia-13077 күн бұрын
I am following along with the video but after I add the combo box, I get all the screens but don't get the one where I it asks "Remember the value for later use". How can I tie it to the correct table and field?
@Valencia-13077 күн бұрын
or the option to store that value in this field
@stephenbeswick21637 күн бұрын
Hi Richard another excellent video again I really enjoyed your videos and have been watching them now for several years. Can you please make a video on automatic password database very urgent my bank account got accessed by someone now I had to go and change all my password everywhere which was a pain to do thinking of passwords it took me hours so if you can find the time in your vey busy schedule could you please make this video. Look forward to seeing this video many thanks steve bye
@bryancoleman7737 күн бұрын
thank you Richard. I have been watching your videos for many years, unfortunately access is only a hobby for me
@grootew7 күн бұрын
What about mij name Rob Groote Woortmann. First name is Rob and lastname Groote Woortmann. Then you hae 2 spaces how to handel it? It is my real name