Hi Richard, thanks a lot for this very intuitive video about Access... I´m a Mac user and I had no idea haw can I use Access... Noy thank you I can create Inventory for my Slide Collection easily 😃
I have a database for creating labels for inventory products (1 label per product number that is concatenated (thank you for that Richard). I have a form with all inventory that I filter for my records. They have a checkbox to select for printing. Is there a way to create a button to select all? Something easier than selecting the checkbox 726 times?
FYI You can change the alternate color feature by right clicking the form and choosing from the context menu. A little bit faster than going into the properties :)
@@599CD I just remember you saying that you don't like alternate colors on continuous forms, and I'm in agreement! no problem, least I can do for all the great tips, insights, and instruction you've provided :) Thanks for all the great vids! Really amazing content.
I would use a form datasheet in a subform for this. I've used datasheets a lot in my 20+ years mainly because of the easier and more intuitive navigation. They look like an Excel worksheets and the arrow keys navigate as you expect. On a continuous form, however, pressing down goes right instead, and up goes left. Datasheets also allow column width adjustments and alternating row colors for readability, neither of which can be done on continuous forms. But datasheets also have many shortcomings. I've seen tons of people on the Internet who prefer continuous forms. I don't see any videos on datasheets in your channel, so I'm guessing you are not a fan either.
Hi Richard, can you help me the following. According to your tutorials On ship date products moving out of stock with click on command button and on return date stock return back into stock with a click of command button. Want to use one button click to activate the the above process. Is this possible? Regards Graham
Yes, Graham. It is certainly possible. There are multiple ways you could do it, either with action queries or with recordsets. See if this helps you: ua-cam.com/video/oFHDAOkSQ0Y/v-deo.html
Hello, please also tell how to build database for library management system in which you can add student,staff and issue and return books form, auto over due fine and also generation of their reports.
@@599CD The wizards are turned on. They did work and then stopped so not sure why. I have now managed to get them working again by deleting the office key in the registry (backed up first). This has had no other detrimental effect on any office application. Many thanks for your reply.
Sure. Just make a continuous form out of it, and then drop that form in another form as a subform. Oh, and one of the first things I do is show people how to turn off the tabbed interface. Watch 599cd.com/Continuous and of course 599cd.com/Blank
6:12 I don't know why but cut/paste does not work for me in forms. I can copy/paste labels one at a time, which works but is just a bit tedious. Not sure if anyone else has had this issue?
hi sir.... I was wondering if we have a field called like customer ID in the field of ProductT... and make a query to link them.... how do we show the list of record in the productT inside the query.... because when i link customerT and also productT it will have blank database
Hello. After creating the form, I needed to change the primary key from employee ID to an auto number. I now need the form to pull from the auto number in the filter instead. How can I change this? The reason being when I click to open an employee it is pulling the old information and not the updated one. We want to keep the original one for audit purposes.
One question, I don't have any membership plan, but still may I ask you a problem. I created an add record form (form1) from a table (table 1). I created another table (table 2) which contains two columns, product_id and product_name. "Form 1" contains two combo boxes (product_ID and product_Name)which will store data in table 1. These two combo boxes are linked together through a query (query1) which ahas two fields added ( product ID and Product Name), so that when I select a particular product _id from combobox1, combo box2 will automatically get product names related to product_id in combo 1. But the problem is that after having few entries, the combo box behaves differently. It rather searches/ fetches the data from the table in the other fields of the form, rather than taking a new entry, why?
hi Richard make a video on how to load another continue form with related record by click button. for example: customer to order/contact or order to order details as your member only video. Please.
@@599CD I need to open up the access form through the windows ID, example If l log in to windows on my userID, I want to see the form that is associated only with my userID when I click on the access file.
hi i need a form to receive fabric after dyeing, where i can receive a gate pass (delivery) with more than one items on single document in a single date: Kind of like parent child form where i put date and other information (like dyeing name, gate pass number, etc.) only once and the child form will take information in tabular form for multiple entries (like fabric type, item description and gross weight & net weight) lets say four different types of items received in a single date on a single document and you don't want to enter repetitive information for every different item, Thanks.
I don't understand what you mean they're single forms and continuous forms those data sheet view which looks like a table but I never use that there's also split forms and some other options that I again I never use I stick with pretty much single forms and continuous forms that's it
I have paid for a silver membership just now, But I am unable to get access. The payment is deducted from the bank. Where should I complain about this ?? ?? Is there any customer care no pls?
Sorry about that. If you signed up on UA-cam you have to talk to their customer service. I have absolutely ZERO control. That's one of the reasons I also started offering memberships directly on my site: 599cd.com/THMember
Thanks for your fine work, you are effective in teaching ms access.
Many thanks!
I love you dude. This was fun. Thank you kindly.
You're very welcome. Dude. :)
Hi Richard, thanks a lot for this very intuitive video about Access... I´m a Mac user and I had no idea haw can I use Access... Noy thank you I can create Inventory for my Slide Collection easily 😃
Glad it was helpful!
thanks for the video.... really solved my problem
Welcome
I have a database for creating labels for inventory products (1 label per product number that is concatenated (thank you for that Richard). I have a form with all inventory that I filter for my records. They have a checkbox to select for printing. Is there a way to create a button to select all? Something easier than selecting the checkbox 726 times?
im searching this video long time
thnxx sir
You're welcome
Thanks richard sir, your videos are helping me alot, thanks.🙏
My pleasure
Hey Rich! Is there a way to highlight the entire row and not just one field when selecting an entry on the continious form?
Yep. Click on that little box to the left of the row. That's called the RECORD SELECTOR.
Really nice.
Thank you so much
Most welcome 😊
Well-Done Richard.
Thanks
Richard. Is there a way using vba to set the columns width of each column separately?
Yes, it's possible, but it's much easier to do with list box column widths. I may cover this in a future developer lesson.
FYI You can change the alternate color feature by right clicking the form and choosing from the context menu. A little bit faster than going into the properties :)
See... even I learn something new every day. I don't use alternating back colors often in forms, so I never even noticed that. Thanks for sharing.
@@599CD I just remember you saying that you don't like alternate colors on continuous forms, and I'm in agreement! no problem, least I can do for all the great tips, insights, and instruction you've provided :) Thanks for all the great vids! Really amazing content.
I would use a form datasheet in a subform for this. I've used datasheets a lot in my 20+ years mainly because of the easier and more intuitive navigation. They look like an Excel worksheets and the arrow keys navigate as you expect. On a continuous form, however, pressing down goes right instead, and up goes left. Datasheets also allow column width adjustments and alternating row colors for readability, neither of which can be done on continuous forms. But datasheets also have many shortcomings. I've seen tons of people on the Internet who prefer continuous forms. I don't see any videos on datasheets in your channel, so I'm guessing you are not a fan either.
Yeah, I really don't like datasheets. You lose a lot of control and functionality with them. I never let end-users see them.
Hi Sir...... Nice video Thanks Sir
Most welcome
Hi Richard, can you help me the following. According to your tutorials On ship date products moving out of stock with click on command button and on return date stock return back into stock with a click of command button. Want to use one button click to activate the the above process. Is this possible? Regards Graham
Yes, Graham. It is certainly possible. There are multiple ways you could do it, either with action queries or with recordsets. See if this helps you: ua-cam.com/video/oFHDAOkSQ0Y/v-deo.html
@@599CD Thanks for the feedback. If you can show me how to do this. Will pay your hourly rate
Email me exactly what you're trying to do: amicron@gmail.com
Hello, please also tell how to build database for library management system in which you can add student,staff and issue and return books form, auto over due fine and also generation of their reports.
599cd.com/ACD23
Thanks for the great tutorial. Unfortunately my wizard does not work. Any ideas to get it working or program the button without the wizard.
Are the wizards turned off? There's an ON/OFF button in the toolbox.
@@599CD The wizards are turned on. They did work and then stopped so not sure why. I have now managed to get them working again by deleting the office key in the registry (backed up first). This has had no other detrimental effect on any office application. Many thanks for your reply.
Thanks! Nice!
You bet!
Richard, do you have a video that shows how to make a query result show in a subform and not make a new page/tab with the results?
Sure. Just make a continuous form out of it, and then drop that form in another form as a subform. Oh, and one of the first things I do is show people how to turn off the tabbed interface. Watch 599cd.com/Continuous and of course 599cd.com/Blank
Thank you
You're welcome
6:12 I don't know why but cut/paste does not work for me in forms. I can copy/paste labels one at a time, which works but is just a bit tedious. Not sure if anyone else has had this issue?
No idea.
How would you do a continuous form if you have two table with a 1 to N relationship. So in this example, products and who bought them?
Make a query. Use the query for the form.
Can you create a continuous from from a query? I have a bunch of calculations and it looks like excel so it is easier for my users
You sure can... 599cd.com/try
hi sir.... I was wondering if we have a field called like customer ID in the field of ProductT... and make a query to link them.... how do we show the list of record in the productT inside the query.... because when i link customerT and also productT it will have blank database
I go: Customer > Order > OrderDetails > Product
See 599cd.com/Invoicing
Hello. After creating the form, I needed to change the primary key from employee ID to an auto number. I now need the form to pull from the auto number in the filter instead. How can I change this? The reason being when I click to open an employee it is pulling the old information and not the updated one. We want to keep the original one for audit purposes.
599cd.com/Ask
One question, I don't have any membership plan, but still may I ask you a problem.
I created an add record form (form1) from a table (table 1).
I created another table (table 2) which contains two columns, product_id and product_name.
"Form 1" contains two combo boxes (product_ID and product_Name)which will store data in table 1. These two combo boxes are linked together through a query (query1) which ahas two fields added ( product ID and Product Name), so that when I select a particular product _id from combobox1, combo box2 will automatically get product names related to product_id in combo 1.
But the problem is that after having few entries, the combo box behaves differently. It rather searches/ fetches the data from the table in the other fields of the form, rather than taking a new entry, why?
Feel free to submit your question at 599cd.com/TH
Thanks
Welcome
Gee, I work with a programmer named Wyatt who moved to Alaska.
It's probably the other Wyatt in Alaska.
hi Richard make a video on how to load another continue form with related record by click button. for example: customer to order/contact or order to order details as your member only video. Please.
Feel free to submit it: 599cd.com/TechHelp
Thanks sir
Welcome
do you have a video on add a new patient/customer with at least one treatment/product please. l am one of your silver members by the way
Patient/Customer/Student with a Treatment/Order/Class is all the same stuff. Just different pieces parts. See 599cd.com/Invoicing
Is there a way to open up a form by network user ids by user form
Huh?
@@599CD I need to open up the access form through the windows ID, example If l log in to windows on my userID, I want to see the form that is associated only with my userID when I click on the access file.
hi i need a form to receive fabric after dyeing, where i can receive a gate pass (delivery) with more than one items on single document in a single date:
Kind of like parent child form where i put date and other information (like dyeing name, gate pass number, etc.) only once and the child form will take information in tabular form for multiple entries (like fabric type, item description and gross weight & net weight)
lets say four different types of items received in a single date on a single document and you don't want to enter repetitive information for every different item, Thanks.
See the extended cut for this video: 599cd.com/Default
sir there unable to seem data in single form while i select specific record .there seem only first record
Huh?
same case with only first record of the single form is opening even when i select a different product
What is the difference between. Continous and database view
I don't understand what you mean they're single forms and continuous forms those data sheet view which looks like a table but I never use that there's also split forms and some other options that I again I never use I stick with pretty much single forms and continuous forms that's it
@@599CD thank you 👍
I have paid for a silver membership just now, But I am unable to get access. The payment is deducted from the bank. Where should I complain about this ?? ?? Is there any customer care no pls?
Sorry about that. If you signed up on UA-cam you have to talk to their customer service. I have absolutely ZERO control. That's one of the reasons I also started offering memberships directly on my site: 599cd.com/THMember
Hello Sir,can you please explain how to use cascading combo in Continuous Forms ???
That's covered in the Extended Cut for: 599cd.com/Cascading
wouldnt you want a table for the "productlistF?"
If you want, sure
Why not just create a datasheet form instead of a continuous form?
I don't like datasheet view. It's for developers, not end-users.
Thank you
Welcome!