Continuous Forms in Microsoft Access. Product Inventory List Form. Click to Open Specific Product.
ฝัง
- เผยแพร่เมื่อ 29 มิ.ย. 2024
- Learn how to create continuous forms in Microsoft Access. Otherwise known as List Forms, these allow you to scroll up and down and view all of the products in a table or query. We will create a continuous form to display a list of our products. I'll also show you how to click on one of the products, and then click on a command button to open up the single form for that specific product.
Wyatt from Anchorage, Alaska (a Gold Member) asks: How can I display all of my products in a list so that that I can scroll up and down through them. I'd also like to be able to click on one to open up that product's form. A total count of products and my total inventory value would also be nice to see, too. Thanks!
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to calculate a line total (qty on hand * unit price) in addition to form footer totals for the total value of your inventory and the total number of products on hand.
MEMBERS ONLY VIDEO:
• Continuous Forms in Mi...
BECOME A MEMBER:
/ @599cd
LINKS:
Get on my Mailing List: 599cd.com/YTML
AutoNumbers: • AutoNumbers in Microso...
What is a Form: • What is a Form in Micr...
Open Form Specific Record: • Microsoft Access Open ...
Open Specific Report: • Display a Single Recor...
On Dbl Click Event: 599cd.com/aca1
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: amicron@gmail.com
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, continuous forms, form header footer, what is a continuous form, columnar form, how to create continuous form, creating continuous forms, open specific record, find specific data to display
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Thanks for your fine work, you are effective in teaching ms access.
Many thanks!
Thanks richard sir, your videos are helping me alot, thanks.🙏
My pleasure
I love you dude. This was fun. Thank you kindly.
You're very welcome. Dude. :)
Really nice.
Thank you so much
Most welcome 😊
thanks for the video.... really solved my problem
Welcome
Well-Done Richard.
Thanks
im searching this video long time
thnxx sir
You're welcome
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! Nice!
You bet!
Hi Sir...... Nice video Thanks Sir
Most welcome
Thank you
You're welcome
Thanks sir
Welcome
Thanks
Welcome
Gee, I work with a programmer named Wyatt who moved to Alaska.
It's probably the other Wyatt in Alaska.
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.
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?
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.
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
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.
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
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.
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
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
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.
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
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.
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
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: th-cam.com/video/oFHDAOkSQ0Y/w-d-xo.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
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
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.
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 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
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.
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
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 TH-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
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 👍
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!