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!
@599CD11 ай бұрын
Thanks so much for your kind words. :)
@uat5912 жыл бұрын
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..
@599CD2 жыл бұрын
You can see the date each video was uploaded right below it.
@SiyamandRashid4 ай бұрын
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!!
@joniherscovici52025 ай бұрын
Can you set up inventory ledger using a size grid for clothing. i.e. one inventory item that tracks sizes
@johndavy38202 жыл бұрын
Very useful. Great job as usual! Thanks John
@599CD2 жыл бұрын
Glad you approve. :)
@octaviand12 жыл бұрын
ok, ok ..I'll go now to watch all other videos...
@599CD2 жыл бұрын
Sweet
@nothingness73134 ай бұрын
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
@599CD4 ай бұрын
599cd.com/ask
@ka8s17 ай бұрын
is there any way to add a barcode scanner and printer syetm to this?
@moodkn2 жыл бұрын
Thanks Sir! Very Helpful
@599CD2 жыл бұрын
It's my pleasure
@skverma2892 жыл бұрын
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.
@599CD2 жыл бұрын
Sounds like a job for DSUM: 599cd.com/DSUM I cover FIFO inventory in: 599cd.com/ACD29
@huuhaunguyen36302 жыл бұрын
Awesome, thank you sir!!!!
@599CD2 жыл бұрын
Welcome
@dbdata98362 жыл бұрын
great work
@599CD2 жыл бұрын
Thanks!
@andrewmetcalfe77482 жыл бұрын
Great KZbin. Have you a video on basic inventory stock in/out with barcodes scanning
@599CD2 жыл бұрын
599cd.com/Barcodes
@EWaveRadiator7 ай бұрын
Richard, how do you create tables whose fields have unit? Where do you put the unit of the values in the fields. Thank you.
@599CD6 ай бұрын
I actually have a video on this coming out very soon stay tuned
@usertgvh2 жыл бұрын
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.
@599CD2 жыл бұрын
Something like this? 599cd.com/Gantt
@DriversandDiners2 жыл бұрын
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.
@599CD2 жыл бұрын
Hi Davis. Have you seen this: 599cd.com/Barcode? As far as tracking individual units (items) you'd need serial numbering: 599cd.com/ACD23
@nicemedia1 Жыл бұрын
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
@599CD Жыл бұрын
Sorry, but that's only available for purchase on my website.
@jullianmahin68555 ай бұрын
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 ?
@599CD5 ай бұрын
Is is possible? Absolutely. :)
@nividagarwal68032 жыл бұрын
Need this project on inventory management under MS acess
@599CD2 жыл бұрын
599cd.com/Inventory
@kurosakibankai192 жыл бұрын
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?
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.
@599CD2 жыл бұрын
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.
@thefadedpenguin72822 жыл бұрын
Would I need to do everything in the previous videos in order to do the stuff in this video?
@599CD2 жыл бұрын
No, but it would certainly help.
@accessdatabasedzone42942 жыл бұрын
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.
@599CD2 жыл бұрын
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
@oldcrow7262 жыл бұрын
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 ?
@599CD2 жыл бұрын
Of course it can: 599cd.com/ACD29
@spmotorskorea2 жыл бұрын
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
@599CD2 жыл бұрын
599cd.com/ACD23
@meh3270 Жыл бұрын
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?
@599CD Жыл бұрын
Sounds like you'd need an Aggregate query with a Count: 599cd.com/Aggregate
@MuhammadImran-oo2qp2 жыл бұрын
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.
@599CD2 жыл бұрын
599cd.com/SecuritySeminar
@amystrottmann22022 жыл бұрын
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?
@599CD2 жыл бұрын
I don't understand what you mean by "up to number 95."
@dbdata98362 жыл бұрын
thanks
@599CD2 жыл бұрын
Welcome
@CelticDruidess1 Жыл бұрын
What is a silver customer? Is that some special payment level for Microsoft?
@599CD Жыл бұрын
Nope. Silver Member to my KZbin channel or website. See 599cd.com/THM
@toootttgaming2 жыл бұрын
In my stockoutquery the sum is given but, when i subtract it in stockq with stockin the value is 0 why is that?
@599CD2 жыл бұрын
Without seeing your database, it's impossible to tell
@ssswdon2 жыл бұрын
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 ?
@599CD2 жыл бұрын
All the free templates are listed in the TEMPLATES section under the description.
@edwardsapu20322 жыл бұрын
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)
@599CD2 жыл бұрын
599cd.com/Invoicing
@accessdatabasedzone42942 жыл бұрын
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.
@599CD2 жыл бұрын
First, I'd like to say I'm not sure how I feel about you using "Access Learning Zone" as your KZbin 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.
@accessdatabasedzone42942 жыл бұрын
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
@bobbarth69362 жыл бұрын
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.
@599CD2 жыл бұрын
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. :)
@devi54532 жыл бұрын
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?
@599CD2 жыл бұрын
Reorder levels is in 599cd.com/AC328. I'll be updating this for 2021 soon.
@devi54532 жыл бұрын
Thank you for the Reply, your videos are really helping me at the moment, thank you
@shvesali Жыл бұрын
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.
@ayazakhtarkhan7535 Жыл бұрын
chat gpt
@599CD Жыл бұрын
599cd.com/ask
@willdaiss25982 жыл бұрын
I have 2 warehouses. How would you add a location for the same products?
@599CD2 жыл бұрын
Add a field to store the location.
@weibinren922 жыл бұрын
Hi, could someone explain how he deleted all the records on 15:44?
@599CD2 жыл бұрын
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
@fansad24992 жыл бұрын
Great
@599CD2 жыл бұрын
thx
@usamagamingyt22792 жыл бұрын
Be consistent, make mistakes, experint
@599CD2 жыл бұрын
Yup
@leviramos6262 жыл бұрын
How to become a member? Thanks
@599CD2 жыл бұрын
Click the JOIN button. If you don't see it, then KZbin might not have memberships available in your country. You can sign up on my web site at 599cd.com/Join
@kinotihfriday254 Жыл бұрын
Too fast! Bad teacher.
@599CD Жыл бұрын
Did you watch ALL of the prerequisite videos? Don't call me a bad teacher because YOU didn't do your homework.