Inventory/Asset tracking database.
I have been asked to provide a simply 'database' for the uniform lady, so she can do away with paper and keep a better track of what is going on in her uniform store. not the organisation. As they are tight as a fishes backside.
She wants to record detail like what current stock she has, when she receives new stock, she can add it and when a staff member asks for new uniform, she can record what has been asked for against the employee's record and again. and the current stock adjusts.
In total there are only about 80 people in the company, but the company supplies 30 \- items, which can be broken down into 4 major categories Mens, Ladies, unisex and safety gear, ofcourse all come in a variety of sizing.
a section for current stock and then a record for each employee with the requested the new uniform, what date it was issued and what uniform was issued.
What would be a better platform to use Excel or Access. At this stage I don't know which way to turn. Maybe you know of something that has been designed, built and available.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
It is also important to be able to make queries by department, by type of asset.
Here is a screenshot of the tables I tought I can create. I have knowledge in Database development but this is my first real project. I don't know what other table I should consider !
Eventually I would like to be able to create a form for adding new assets to the database, but am having trouble structuring my tables in a way that allows me to create the form that I want.
The form that I envision would pop-up and give me the option to type the new assets name in a text box, and select the asset type from a combo box. After these are filled out, there will bea "next" button that moves me to a new pop-up form.
This new pop-up form will allow me to enter specific data about the asset I have just entered. The dilemma is that when I select "Rods" for asset type, I should be able to enter specificdata that would not apply to a selection for "Reels." I am having a lot of trouble designing my tables to give me this kind of freedom in my forms.
Is this a good design for inventory database?
The filter quick search macro no longer works. It says:
"The ApplyFilter action requires either the Filter Name or Where Condition Argument is set"
Has anyone ever done this? Which 3rd party bar-coding software is the best and the most user-friendly that works with Access
What I need is a table combining the two and subtracting sales from purchases to give me the total inventory of each product. I know this isn't too difficult but I haven't messed with Access in 5 years or so and am coming up blank
On a theoretical basis, how would you do this
The company I work for has inventory at our physical location (our shop) and we also have inventory on trucks. I need to track the inventory in the shop and trucks so that when items get below a certain preset level I can run a report to find out how many of each part I need in each location.
Create purchase orders and receive the inventory to whichever location I need it at. I would like to at some point be able to track where the parts are going.
Since the code is tracking the inventory as FIFO (by lots), can I track the cost associated with each lot and tie the cost to each individual sale line
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, I created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when I open up Asset Register Form - I can input all the information and it will be saved in Asset Register Table, but I have to input Building ID manuly for the same building, and I have about 300 items ;(. How do I automate this proccess, so building ID populates automaitcly for all items when I enter information (and saves it in Asset Register Table)?
Please inform me if I made very stupid mistakes in my database, any critisism will be appreciated, I am trying to learn Access