This is great. I am taking a "beginning" computer class and this is the stuff that my college considered beginning. This video is so much better than the videos and book that is required. This video rocked for my brain. This is like a class for dummies which is what I really needed.
Hi there, first off : thanks a lot! This is amazing. One question: I stumble over the continuous form being continuous, as it shows me one record only and I need to navigate similar to your customer form. Help?! Best, Agata
@@599CD I have it just as big as the labels and I am still only seeing 1 entry sadly. Edit: Never mind! Seems I somehow missed the step to make it a continuous form instead of a single form.
Hi Richard Thank you for your very professional video tutorials about MSAccess. I have been doing programming since punched tapes and cards but with MSAccess I began a few days ago. I am Hungarian and as a retired person I found an endless occupation: learning Chinese language. I built up a database for Chinese words I have learned. Tried to use a search button upon your tutorial a problem came across to me. Inputbox could accept Chinese characters perfectly, but returned "??" instead Chinese characters I input before. Could you advice a proper soultion to handle this problem? (Database, Chinese input, keyboard changeing from Hungarian to Chinese and back, sorting Chinese all operating well). Thanks in advance Harmon Hungary
I have followed instructions for the continuous form and I have to scroll to get each record. Mine doesn’t look like yours. I have deleted it and then I will remake it and follow step by step and something.
Is there a setting that will tell Access to remember the size and location of forms created? My main menu form seems to always open wider than I had moved things around. Thanks!
OK, THIS is really Step ONE. Now to decide if I should import my other Databases, Customers, Orders, ect... Or just Make them up-STARTING with This. LoL
Yeah, that's really a question for you that you have to answer because I've generally found that my students tend to restart building their databases from scratch after they've taken a bunch of my lessons because you learn so much that you didn't know before and then you're like, "Oh, I should have done it this way," or "I should have done it that way." So, whether you want to start with my blank template or rebuild yours from scratch is completely up to you. That's the benefit of learning.
My blank forms open up max screen size, Do you know where can this default window size be set, as yours is on this video.. ps im using a mobile phone as my desk top access runs offline with it being win xp..which is over vulnerable.. Happy new year 2022 Richard. Thx for insights..
Why do prefer a continuous form to a datasheet form? Don't they essentially do the same thing, only with the datasheet form, you don't have to do any manual labor?
I have a split DB on a shared drive and I have a main menu form that is configured to open just like suggested in your video (Options-->Current Database-->Display Form). This worked for my users for a long time, then suddenly for some users it wouldn't auto open. I then tried having an auto exec macro to open the form automatically and it was the same scenario, worked for some not others. Any idea why this might be happening?
@@599CD read some stuff and figured it out. Essentially I use more monitors than my users and I wasn't saving things on my primary monitor. So it wouldn't show on my users bc it was saved to a phantom 3rd monitor they don't have. The key was to ensure all forms have auto center as default. This fixed the problem.
Access is frustrating. I followed the exact instructions on this video but when I look at my main menu, I get a name error as opposed to reading the words Main menu. The instructors main menu comes out perfectly. What's going on? Furthermore, maybe you can make a video about name errors because I've gotten so many of them over the past couple of days
I am hoping you do a video on making a background picture for a form. Let's say I want to highlight a certain portion of the form by having the color behind it yellow, but the rest of the form blue. Or I want the background to be more interesting by giving it a texture. I realize I need to make a picture for that, but cannot find out how to make a picture in access. I see the options to add a picture, but no instructions on how to make one. Microsoft did this in the Northwind Database, but I haven't been able to do it in mine.
Well, you have to make your own picture in whatever other picture program you have (even Paint). Once you do that, you can set it as the Picture property for the form, or you can insert it as an object like I do here: 599cd.com/1336
When i click on the button, I am getting the following error" The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically, can you please help?
I have a question... I open one of my search form, and the combo box have a the ID from client. How can i get it a combo box empty (without any ID)? Thank you guys in advance.
Your videos are making me love Access and its possibilities. I built the CustoerListF as descried step by step For some reason, the records showed up with a gray background on purple. Also there appears to be extra spacing between each record. What did I miss? I purchased Level 2, and membership is next for me. Thanks
In main menu form, can I use text or label instead of commond button wizard. Also is text and label giving double click? I have task like this, but I shouldn’t use commond button wizard for double click. Thank you 🤍
This is great. I am taking a "beginning" computer class and this is the stuff that my college considered beginning. This video is so much better than the videos and book that is required. This video rocked for my brain. This is like a class for dummies which is what I really needed.
Thanks :)
You are the best teacher I have ever had !
Thanks
This was an easy to follow tutorial, even as an ESL learner. Thank you for sharing!
You explained it perfectly and it's very easy to follow step by step for a beginner. Thank you so much! :)
You're welcome
You are fantastic at teaching this material.
I appreciate that!
Literally got two A in my school for this man thanks !
Sweet
This lesson saved me a whole lot of time and effort. Thank you so much Sir.🙂
Most welcome!
brilliant video, super helpful loved it!!
Glad it was helpful!
Good video Richard!
Hi there,
first off : thanks a lot! This is amazing. One question: I stumble over the continuous form being continuous, as it shows me one record only and I need to navigate similar to your customer form. Help?! Best, Agata
Check the size of your detail section. If it's too tall, you'll only see one record.
@@599CD I have it just as big as the labels and I am still only seeing 1 entry sadly.
Edit: Never mind! Seems I somehow missed the step to make it a continuous form instead of a single form.
Hi Richard
Thank you for your very professional video tutorials about MSAccess.
I have been doing programming since punched tapes and cards but with
MSAccess I began a few days ago. I am Hungarian and as a retired
person I found an endless occupation: learning Chinese language.
I built up a database for Chinese words I have learned. Tried to use
a search button upon your tutorial a problem came across to me.
Inputbox could accept Chinese characters perfectly, but returned "??"
instead Chinese characters I input before. Could you advice a proper
soultion to handle this problem? (Database, Chinese input, keyboard
changeing from Hungarian to Chinese and back, sorting Chinese all
operating well).
Thanks in advance
Harmon
Hungary
Sorry, but I have zero experience with foreign language sets.
Fantastic explanation 🙏
I have followed instructions for the continuous form and I have to scroll to get each record. Mine doesn’t look like yours. I have deleted it and then I will remake it and follow step by step and something.
Hi Sir Nice Video. I like this Video......... Thanks Sir For Blank Database Template Video uploading
You're most welcome
Hi Richard
Thanks for your amazing channel, could you please create a simple double entry accounting system for small business in access?
599cd.com/QQ
Awesome help!!!!!! THANK YOU SOOO MUCH!!!!
You're welcome!
Wow you have given me some great ideas...thank you
Most welcome 😊
Thank's a lot for your help and your job, you deserve your MVP and you are better than this certificat
thank you
Thank you. I'm a "former" MVP. 2014 and 2015. Didn't renew. :(
Is there a setting that will tell Access to remember the size and location of forms created? My main menu form seems to always open wider than I had moved things around. Thanks!
When you save a form in Form View, it should remember its location. SIZE is based on your design view.
if you have to link form to table why didnt you create the tables with customer data and then create the forms? this was really confusing
Great Tutor clear easy to follow
Glad you think so!
OK, THIS is really Step ONE. Now to decide if I should import my other Databases, Customers, Orders, ect... Or just Make them up-STARTING with This. LoL
Yeah, that's really a question for you that you have to answer because I've generally found that my students tend to restart building their databases from scratch after they've taken a bunch of my lessons because you learn so much that you didn't know before and then you're like, "Oh, I should have done it this way," or "I should have done it that way." So, whether you want to start with my blank template or rebuild yours from scratch is completely up to you. That's the benefit of learning.
Beautiful , Nice job, Thank you
Thank you too!
I can't find the links that Richard says I can find below the video. Where are they?
ua-cam.com/video/ZUdFaKmHIzs/v-deo.html
Great video..... understood thoroughly. Thank you so much.
Great to hear!
My blank forms open up max screen size, Do you know where can this default window size be set, as yours is on this video.. ps im using a mobile phone as my desk top access runs offline with it being win xp..which is over vulnerable..
Happy new year 2022 Richard. Thx for insights..
599cd.com/Overlapping
I have set up my Blank file with the basic, User login, CRM and Administration pages for admin.
Good job.
Simply amazing.
Thanks
Why do prefer a continuous form to a datasheet form? Don't they essentially do the same thing, only with the datasheet form, you don't have to do any manual labor?
I have a bunch of reasons. This is actually the topic of an upcoming video. :)
I have a split DB on a shared drive and I have a main menu form that is configured to open just like suggested in your video (Options-->Current Database-->Display Form). This worked for my users for a long time, then suddenly for some users it wouldn't auto open. I then tried having an auto exec macro to open the form automatically and it was the same scenario, worked for some not others. Any idea why this might be happening?
No idea without seeing it
@@599CD read some stuff and figured it out. Essentially I use more monitors than my users and I wasn't saving things on my primary monitor. So it wouldn't show on my users bc it was saved to a phantom 3rd monitor they don't have. The key was to ensure all forms have auto center as default. This fixed the problem.
Access is frustrating. I followed the exact instructions on this video but when I look at my main menu, I get a name error as opposed to reading the words Main menu. The instructors main menu comes out perfectly. What's going on? Furthermore, maybe you can make a video about name errors because I've gotten so many of them over the past couple of days
Something's probably spelled wrong.
I am hoping you do a video on making a background picture for a form. Let's say I want to highlight a certain portion of the form by having the color behind it yellow, but the rest of the form blue. Or I want the background to be more interesting by giving it a texture. I realize I need to make a picture for that, but cannot find out how to make a picture in access. I see the options to add a picture, but no instructions on how to make one. Microsoft did this in the Northwind Database, but I haven't been able to do it in mine.
Well, you have to make your own picture in whatever other picture program you have (even Paint). Once you do that, you can set it as the Picture property for the form, or you can insert it as an object like I do here: 599cd.com/1336
I have been trying to do this too. My boss wants the company logo on the forms.
When i click on the button, I am getting the following error" The table is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically, can you please help?
Run down the 599cd.com/Troubleshooter
I have a question...
I open one of my search form, and the combo box have a the ID from client. How can i get it a combo box empty (without any ID)?
Thank you guys in advance.
Set it to 0
Your videos are making me love Access and its possibilities. I built the CustoerListF as descried step by step For some reason, the records showed up with a gray background on purple. Also there appears to be extra spacing between each record. What did I miss? I purchased Level 2, and membership is next for me. Thanks
I've never seen that before. Since you're a student, post this in the Forum on my web site with a screen shot. 599cd.com/ACF
@@599CD I figured it out. I had to move up my alignment and tighten up the spacing between the detail and footer sections!
THANK YOUU SIR
Thank you
Welcome!
Thanks
How do I deactivate the Microsotof Access security Notice?
Put your database in a Trusted folder.
I created Lots of Softwares in Microsoft Access
Sweet
🙏🙏🙏🙏🙏🙏
Welcome
I must be pretty thick...I had to continuously go back 10 seconds. The narration is too fast.
That's the beauty of video learning - you can rewind as many times as you need.
In main menu form, can I use text or label instead of commond button wizard. Also is text and label giving double click?
I have task like this, but I shouldn’t use commond button wizard for double click.
Thank you 🤍
599cd.com/OnDblClick