Richard, you are the absolute best! I was having difficulty with my QOH and my very first customer was getting concerned. I watched this video and everything panned out. I purchased some of your SQL seminar and Access Updater in the past. I need to become a member of your 599cd website. Your teaching style is unmatched and second to none. Thank you so much for saving my reputation! LMAO!
Have been watching your videos for years, 🙏 but didn’t know these are new series filmed in or 2022.. may I suggest putting dates on thumbnails or even the Access version so we know what’s new, what’s old.. at any rate, much appreciation for your clear and very useful videos..
Hi richard! I see your lots of free videos and learnt a lot about access from them. I also prepare my templates for make my work easy. I am now designing a inventory database for my sister's. I need to get valuation of my inventory in hand in terms of purchase cost. I wanted to set off my sold items in terms of FIFO (First In Fist Out) then need to calculate the value of my stock in hand at the end of the month. How do I do it? Can you suggest a few tips and tricks also.
Hello Richard, I am currently trying to develop a process for inventory at this company I am working at. I want to find a way to tell the part #'s where to go in our warehouse when scanned into our database based off of the company. For example we get an Incoming shipment from US steel, and I would like to develop a way for when our workers scan that part in for them to tell them where to put it. For example, Row A1, column 1. Would love to hear back from you, your videos have helped me a lot.
I'm going to ask this only 2.5 minutes into the video ut is there function to AUTOMATICALLY send an email to pertinent addresses as soon as an item reaches a set re-order point. EG we have 52 socks Item #123, the reorder point is 50, we issue 3, we now have 49 socks - an email is instantly sent to purchasing notifying them we need to re order socks item #123.
Love your informative videos. Question taking this knowledge I am creating a inventory database for Printer Parts and I have some parts that work for more than one model I have a model ID table already and would like to know how to assign a part multiple ModelIDs' so that I would not have to make multiple entries of the same part for each model, this way when stock goes out it can reflect one entry instead of having to adjust for multiple ones, can you advise please?
I don't do it that way. If you change the data in your product table, it changes your order details. See the extended cut for 599cd.com/Invoicing for the right way.
Hi I tried the inventory query and it is working, but in my order form where I use a combo box to show the product names together with it's quantity on hand, the product name just duplicates instead of update the quantity on hand instead
Just getting started on building Database for my company. Question is we use several components together to produce 1 product, so would be pulling items from inventory 2 or 3 different directions to make one new product to sell. Is this something Access can do ?
Good Day Richard. Could you please guide me on how to download the invoicing template so I can used it as my guide on making my first database for Warehouse Monitoring.
First, I'd like to say I'm not sure how I feel about you using "Access Learning Zone" as your UA-cam channel name. Are you really sure about that? I see that you're a member, so I'll cut you some slack, but you know that's my company name, right? I see you're in the UAE and I'm registered here in Florida, but... you may want to rethink that. Anyhow, since you're a Gold member, you can sign up for an account on my website at 599cd.com/YTFU and download the template there.
Sorry to hear that, i was not thinking about that name when i created because whats on my mind is Computer Learning Zone. Il just look and think for another one
Hello sir My name is Abbas and I'm from Afghanistan. I'm greatly thankful of you, and I'm a top fan of you sir. I like to be a golden/ silver member, but according to my area, all the banks and accounts are in lockout! There is no way to have Master Card ! I have done my project according your project. Now I will be very thankful if you share or show me a way to access the inventory project video part 2. I need your helps to complete my data-base project. Your sincerely Abbas
I have this question. I am now trying to make my first access inventory databased. I have a customer list, with its own product. Is there any way on how to do that when i select a specific customer on my delivery form, only their product will appear on the drop down list.
First, thank you for changing your channel name. I appreciate it. As far as your question goes, is it just one product per customer? In other words, each customer has ONE thing they order from you? If that's the case, you could just use a DLookup, but it all depends on how you're handling it. If you want more help, post in my Forum. 599cd.com/AF
You videos rock!, I noticed that you mentioned about free templates but when I click on one it just takes me to the details page. How do I get these templates ?
Hi Richard i would like to watch extended cut on inventory. I handle large quantities autoparts. I watch most of your videos in youtube. Is there update query for one record only? Because updating all record on table takes long time. Please recommend videos to watch
Hi Richard! I've been trying to build an equipment management system and I can't figure out how to produce a report for the most borrowed equipment in my system. Can you suggest the best way to do the report?
Hello Richard, Been watching a lot of your videos.. I am currently trying to build a simply database for my company which is still operating off spreadsheets. I have a good idea where I want to go with things and I'm going through each section 1 at a time. I am currently trying to get our stock Done first. Have you a video regarding the Restock/Low Stock warning as well as a Subform added to a Stock Navigation Form say, which shows the item Low on stock with Qty and Supplier to reorder from?
Hi Richard, I have created the inventory following your video, did the stock query, but see it is only showing up to number 95 for products. Do I need to subscribe to be able to see more or is that all it shows?
dear richard i searched much video to know how to creat login form and authorize some user .but no one can creat compelete video.kindly upload a complete video about login form,(How to creat Login Form,Authoriazation access in build Macro plz.
Hi,can you create a small database that will capture Teacher qualification,students enrolment for all Sectors ,Primary,Elementary,Secondary high School and Vocational.and also would capture Schools infrastructures ?
I want a form that shows different items as rows while dates as columns so that I could track changes over a period of time for different items. Please suggest ways to do; my thought was to create a crosstab query but it doesn't update automatically when new data is added. Please suggest/ help.
Hi Richard. I really appreciate the tips and training on Access. I have a question about inventory. I am making an inventory section for the database that I created. But in the inventory, I can have 3 classes of a unique part number: Brand New, Rebuilt, and Running Take Out (RTO). How can I group the availability for each class? For example, if I have 4 pieces Brand New of Part Number 8156001, 10 Pieces Rebuilt, and 2 TRO and then want to add 3 pieces to Rebuilt one and sell 2 brand new ones, how can I get the database updated related to each class? I really appreciate your help in this regard.
Hi Rost! I really need a simple Invoicing which outline the following; No#, particular, quantity, unit price,10%gst, sub total & total. Should you be helpful on that? Thanks...... Edward Sapu (Papua New Guinea)
Select all the records by using the record selectors, then press DELETE on your keyboard. This is Access 101 stuff. Inventory is a lot more advanced. Start here: 599cd.com/ACB1
Click the JOIN button. If you don't see it, then UA-cam might not have memberships available in your country. You can sign up on my web site at 599cd.com/Join
This is all just sooo confusing. All the necessary Pre-Requisites videos are linked to the website, and if I follow the link to the website, I can't watch any of the member video because I joined as a member on youtube and not the website.
Richard, you are the absolute best! I was having difficulty with my QOH and my very first customer was getting concerned. I watched this video and everything panned out. I purchased some of your SQL seminar and Access Updater in the past. I need to become a member of your 599cd website. Your teaching style is unmatched and second to none. Thank you so much for saving my reputation! LMAO!
Thanks so much for your kind words. :)
Have been watching your videos for years, 🙏 but didn’t know these are new series filmed in or 2022.. may I suggest putting dates on thumbnails or even the Access version so we know what’s new, what’s old.. at any rate, much appreciation for your clear and very useful videos..
You can see the date each video was uploaded right below it.
Very useful. Great job as usual! Thanks John
Glad you approve. :)
Thanks Sir! Very Helpful
It's my pleasure
iam making a database for my project and this video is very helpful.......it would help me alot if you could give the link of the first video..
ok, ok ..I'll go now to watch all other videos...
Sweet
great work
Thanks!
Awesome, thank you sir!!!!
Welcome
Can you set up inventory ledger using a size grid for clothing. i.e. one inventory item that tracks sizes
Great UA-cam.
Have you a video on basic inventory stock in/out with barcodes scanning
599cd.com/Barcodes
Hi richard! I see your lots of free videos and learnt a lot about access from them. I also prepare my templates for make my work easy. I am now designing a inventory database for my sister's. I need to get valuation of my inventory in hand in terms of purchase cost. I wanted to set off my sold items in terms of FIFO (First In Fist Out) then need to calculate the value of my stock in hand at the end of the month. How do I do it? Can you suggest a few tips and tricks also.
Sounds like a job for DSUM: 599cd.com/DSUM
I cover FIFO inventory in: 599cd.com/ACD29
Need this project on inventory management under MS acess
599cd.com/Inventory
Hello Richard, I am currently trying to develop a process for inventory at this company I am working at. I want to find a way to tell the part #'s where to go in our warehouse when scanned into our database based off of the company. For example we get an Incoming shipment from US steel, and I would like to develop a way for when our workers scan that part in for them to tell them where to put it. For example, Row A1, column 1. Would love to hear back from you, your videos have helped me a lot.
Hi Davis. Have you seen this: 599cd.com/Barcode? As far as tracking individual units (items) you'd need serial numbering: 599cd.com/ACD23
Richard, how do you create tables whose fields have unit? Where do you put the unit of the values in the fields. Thank you.
I actually have a video on this coming out very soon stay tuned
Would I need to do everything in the previous videos in order to do the stuff in this video?
No, but it would certainly help.
is there any way to add a barcode scanner and printer syetm to this?
I'm going to ask this only 2.5 minutes into the video ut is there function to AUTOMATICALLY send an email to pertinent addresses as soon as an item reaches a set re-order point. EG we have 52 socks Item #123, the reorder point is 50, we issue 3, we now have 49 socks - an email is instantly sent to purchasing notifying them we need to re order socks item #123.
where to find the extended cut out videos ? i became a Gold member but seems to be i have access to the introduction videos only!!
Love your informative videos. Question taking this knowledge I am creating a inventory database for Printer Parts and I have some parts that work for more than one model I have a model ID table already and would like to know how to assign a part multiple ModelIDs' so that I would not have to make multiple entries of the same part for each model, this way when stock goes out it can reflect one entry instead of having to adjust for multiple ones, can you advise please?
2nd table, one-to-many relationship. 599cd.com/Relationships
It seems to me that the orderdetail could use a combo box to select the product.
That’s what I did on my learning database.
I don't do it that way. If you change the data in your product table, it changes your order details. See the extended cut for 599cd.com/Invoicing for the right way.
Hi I tried the inventory query and it is working, but in my order form where I use a combo box to show the product names together with it's quantity on hand, the product name just duplicates instead of update the quantity on hand instead
599cd.com/ask
Just getting started on building Database for my company. Question is we use several components together to produce 1 product, so would be pulling items from inventory 2 or 3 different directions to make one new product to sell. Is this something Access can do ?
Of course it can: 599cd.com/ACD29
Good Day Richard. Could you please guide me on how to download the invoicing template so I can used it as my guide on making my first database for Warehouse Monitoring.
First, I'd like to say I'm not sure how I feel about you using "Access Learning Zone" as your UA-cam channel name. Are you really sure about that? I see that you're a member, so I'll cut you some slack, but you know that's my company name, right? I see you're in the UAE and I'm registered here in Florida, but... you may want to rethink that. Anyhow, since you're a Gold member, you can sign up for an account on my website at 599cd.com/YTFU and download the template there.
Sorry to hear that, i was not thinking about that name when i created because whats on my mind is Computer Learning Zone. Il just look and think for another one
What is a silver customer? Is that some special payment level for Microsoft?
Nope. Silver Member to my UA-cam channel or website. See 599cd.com/THM
Hello sir
My name is Abbas and I'm from Afghanistan. I'm greatly thankful of you, and I'm a top fan of you sir.
I like to be a golden/ silver member, but according to my area, all the banks and accounts are in lockout! There is no way to have Master Card !
I have done my project according your project.
Now I will be very thankful if you share or show me a way to access the inventory project video part 2.
I need your helps to complete my data-base project.
Your sincerely
Abbas
Sorry, but that's only available for purchase on my website.
I have this question. I am now trying to make my first access inventory databased. I have a customer list, with its own product. Is there any way on how to do that when i select a specific customer on my delivery form, only their product will appear on the drop down list.
First, thank you for changing your channel name. I appreciate it. As far as your question goes, is it just one product per customer? In other words, each customer has ONE thing they order from you? If that's the case, you could just use a DLookup, but it all depends on how you're handling it. If you want more help, post in my Forum. 599cd.com/AF
You videos rock!, I noticed that you mentioned about free templates but when I click on one it just takes me to the details page. How do I get these templates
?
All the free templates are listed in the TEMPLATES section under the description.
Hi Richard i would like to watch extended cut on inventory. I handle large quantities autoparts. I watch most of your videos in youtube. Is there update query for one record only? Because updating all record on table takes long time. Please recommend videos to watch
599cd.com/ACD23
Hi Richard! I've been trying to build an equipment management system and I can't figure out how to produce a report for the most borrowed equipment in my system. Can you suggest the best way to do the report?
Sounds like you'd need an Aggregate query with a Count: 599cd.com/Aggregate
Hello Richard, Been watching a lot of your videos.. I am currently trying to build a simply database for my company which is still operating off spreadsheets. I have a good idea where I want to go with things and I'm going through each section 1 at a time. I am currently trying to get our stock Done first. Have you a video regarding the Restock/Low Stock warning as well as a Subform added to a Stock Navigation Form say, which shows the item Low on stock with Qty and Supplier to reorder from?
Reorder levels is in 599cd.com/AC328. I'll be updating this for 2021 soon.
Thank you for the Reply, your videos are really helping me at the moment, thank you
Hi Richard, I have created the inventory following your video, did the stock query, but see it is only showing up to number 95 for products. Do I need to subscribe to be able to see more or is that all it shows?
I don't understand what you mean by "up to number 95."
dear richard i searched much video to know how to creat login form and authorize some user .but no one can creat compelete video.kindly upload a complete video about login form,(How to creat Login Form,Authoriazation access in build Macro plz.
599cd.com/SecuritySeminar
Hi,can you create a small database that will capture Teacher qualification,students enrolment for all Sectors ,Primary,Elementary,Secondary high School and Vocational.and also would capture Schools infrastructures ?
Is is possible? Absolutely. :)
I want a form that shows different items as rows while dates as columns so that I could track changes over a period of time for different items. Please suggest ways to do; my thought was to create a crosstab query but it doesn't update automatically when new data is added. Please suggest/ help.
Something like this? 599cd.com/Gantt
Hi Richard. I really appreciate the tips and training on Access.
I have a question about inventory.
I am making an inventory section for the database that I created. But in the inventory, I can have 3 classes of a unique part number: Brand New, Rebuilt, and Running Take Out (RTO).
How can I group the availability for each class? For example, if I have 4 pieces Brand New of Part Number 8156001, 10 Pieces Rebuilt, and 2 TRO and then want to add 3 pieces to Rebuilt one and sell 2 brand new ones, how can I get the database updated related to each class?
I really appreciate your help in this regard.
chat gpt
599cd.com/ask
thanks
Welcome
I have 2 warehouses. How would you add a location for the same products?
Add a field to store the location.
In my stockoutquery the sum is given but, when i subtract it in stockq with stockin the value is 0 why is that?
Without seeing your database, it's impossible to tell
Hi Rost! I really need a simple Invoicing which outline the following;
No#, particular, quantity, unit price,10%gst, sub total & total. Should you be helpful on that?
Thanks...... Edward Sapu (Papua New Guinea)
599cd.com/Invoicing
Hi, could someone explain how he deleted all the records on 15:44?
Select all the records by using the record selectors, then press DELETE on your keyboard. This is Access 101 stuff. Inventory is a lot more advanced. Start here: 599cd.com/ACB1
How to become a member? Thanks
Click the JOIN button. If you don't see it, then UA-cam might not have memberships available in your country. You can sign up on my web site at 599cd.com/Join
Great
thx
This is all just sooo confusing. All the necessary Pre-Requisites videos are linked to the website, and if I follow the link to the website, I can't watch any of the member video because I joined as a member on youtube and not the website.
Welp... if you contact me to set up an account on my web site, like the end of every video says, then you can watch them there. :)
Be consistent, make mistakes, experint
Yup
Am I the only one who can't find microsoft access anywhere?
You should be able to find it on Microsoft website: 599cd.com/BuyAccess
Too fast! Bad teacher.
Did you watch ALL of the prerequisite videos? Don't call me a bad teacher because YOU didn't do your homework.