Access 2016 - How to Make a Database - Part 10 - Inventory Tracking - Part B

[@martinarcher6838]

How come these does not have more likes. It's amazing and getting me started. Thank you.

[@olgacherkasova6623]

Good afternoon! Thank you so much for the Access tutorials you create! I started using this software just about a month ago with zero knowledge of it and now after learning lots of things by watching your videos, I actually get a lot of things done in my DB and it is of a great help at my work! I am actually at the point where I created a form that allows me to update the record that already exists in the corresponding table (the 'override button' part of your tutorial), which is super exciting (lots of time saved)! The structure of the form is as follows: Record # (drop-down list of all records - you select the one you want to see all the info for) Date Record Created Description Date Issue Closed The things listed above are all arranged as one 'column' (vertically) in this form and are not enabled as you instructed - you can only retrieve the information from the table and show it to the user after the Record # was selected, can't manually change it. The next 'column' in the form are the text boxes for input of the new information that is going to update the one that already exists in the table (purpose of the 'enter a value' box in your video). And then I have several 'update' ('override') buttons to the right of each of the fields that could potentially be updated. So basically the form looks like Description > "box showing Existing Description" - Enter new description > "box for entering new description" - 'Update' button. Same structure for Dates info. The "description" and "date opened" parts get updated as expected and work just fine (I followed your directions on writing the VB code for this form). However, I encountered an issue with updating the "Date closed" field. This field is different from "description" and "date opened" ones because, obviously, it is left blank until the time that the issue is resolved and there is a date to enter in that field. So, when I enter the date in "enter date closed" field and click on corresponding 'update' button, I get the following error: Run-time error '-2147352567 (80020009) The value you entered isn't valid for this field. There is a prompt for "debug". When clicking on it, the VB window with the code opens and highlights the second line of the following code: Private Sub Update_ClosDate_Click() Me.Closure_Date = Me.Update_ClosDate (this line is highlighted) Me.Update_DateOpened.Enabled = False Me.Update_Descr.Enabled = False Me.Update_UnPl_ClosDate.Enabled = False End Sub Could you please help me with solving this issue? In addition, in the video above you mentioned that it is possible to not accept the blanks in the "add new value" box to avoid blank cells in the table. Could you please let me know which video you explain how to do it in? Thank you! I appreciate your help!

[@nigelriza4814]

Great job. Loving the series. I hit the same error (hitting button when Quantity_Entered was null before it happened to you in the video! Great overview - and jumping straight into simple VBA was an unexpected bonus. Been writing code for Excel for several years but only just gotten around to learning Access. So - thanks again. Really appreciate it.

[@pamsalzgeber6093]

This video series was so incredibly helpful. Thank you so much! I have 2 questions. Is there a way to add a button to refresh the form and update more products without having to close the form? And, when opening the form, is it possible to make it open clean instead of keeping the data from the last query?

[@bradmonk69]

Awesome video. Helped me out no end... apart from one little issue. I have created a sales form which allows purchase of multiple products (individual records), however when I press the save button, it only deduct stock from the final product/record and not for any of the previous ones in the form. Is there a way to make this work for multiple lines or is it a method for updating single product lines at a time? Thanks again!

[@lalokaza6285]

hi, is there a way to add a date on the form and then add the information to a table? to keep a record of the stock coming in and out? Awesome lesson, helped a lot

[@SuperDude69]

Hey, Great video, really helped me get started. Just wondering whether you have any plans to release the follow-up in the Inventory Tracking series?

[@designanddeploy5991]

Soon. I had started some other Access tutorials but they never caught on so will be returning to this one.

[@MuddinNYC]

What if you have one product and it's tracked via serial #. Is there a way to select multiple serial #s and change their value from say in office to sold?

[@ALRiverside]

Question? I have a roster of names, 20 pages. For some reason after I made a correction i know have 40 pages with every other one blank. How do I fix this?

[@amzarhasmizan1919]

Sir....how to remove the number which when we open the form...two digits number appear in the textbox...how to remove it...I need your explanation

[@shinu051]

Sir, ............I have got an error code while running this code," run time error 438, object doesn't support this property or method ". Why this happened?

[@adammontgomery7980]

Couldn't you use the same function for all three buttons; checking which one was clicked. I just hate to see code repeated.

[@designanddeploy5991]

I usually try to avoid redundant code too but it will have a negligible impact on performance if any. And if it turns out you need to customize, keeping them separate allows for that.

[@PabloMoricz]

Hey! I was following this tutorial and I encountered a problem! After adding the add button and writing the code on VB, I runned the code but it says there's a compilation error and that the use of that feature/property is not valid. I get the "Private Sub AddButton_Click()" line highlighted in yellow and the quantityEntered part marked as if that would be the errror. I have no idea why this happened as I followed your instructions step by step and went over them many times before writing you. Could you help me out? Thanks!!

[@designanddeploy5991]

Can you post the exact code somewhere such as pastebin? Also, make sure the names of the fields in the code exactly match the actual names of the fields. Also, use the autocomplete that the VB text editor uses to make sure the names are correct.

[@PabloMoricz]

Option Compare Database Private Sub AddButton_Click() Me.Product_Quantity -Me.Product_Quantity + Me.quantityEntered Me.AddButton.Enabled = False Me.reduceButton.Enabled = False End Sub Private Sub reduceButton_Click() Me.Product_Quantity -Me.Product_Quantity - Me.quantityEntered Me.reduceButton.Enabled = False Me.AddButton.Enabled = False End Sub This is what I have. Thanks for replying and your help so far! =)

[@designanddeploy5991]

Both of the me.product_quantity seem to have a minus sign instead of an equals sign.

[@fabiow6]

Could you help me with this: I have a table and a form to register what is happening witch chemicals - TblChemRegister. And there are informational like: Date, Employee (lookup from another table), Chemical (lookup from TblChemType) quantity that was used (ChemUsage), and a comment what was it used for. The goal is that when usage is registered (John took 5l of paint), then field ChemQuantity in table TblChemType is updated. I would like to do it by some simple VBA code. And I am sure it is simple, I just can ot figure it out... Can you help me please.

[@designanddeploy5991]

My apologies, I am not sure how that differs from this. Although I posted it some time ago, I thought it demonstrated updating totals.

[@fabiow6]

@@designanddeploy5991 I just figured it out. To be able to update field in another table I needed to include that field in a form. Then it was simple Me. command. Just like you said in a video. So the problem is solved. Thanks for yours videos. They were very helpful. Just as a bonus, do you know if there is a way to do it without adding that field in to the table?

[@ephraimsaarenas1789]

I receive run time error '2164'

[@thedohhh]

i dont have product quantity. i have product quantity label when entering the code. please help

[@thedohhh]

nvm,...figured it out in the last video