Search results

I get that you need to start at the beginning but not being formally trained I lack the understanding that of how things will all come together in the end, and what is possible and not possible. So I am not necessarily building forms and reports and queries at this point but I am trying to...

If I kept all my separate tables for different Uniform Parts and added a field for issued to and put a Cadet ID number in and accessed all the tables through a tabbed form. Then I could do away with the StoresIssued or ItemsAssigned table all together. Then if I need to report on what is...

Good questions. The Status has 5 possible statuses looked up from the StatusTable issued instock Lost by Cadet decommissioned Authorized Destruction I want the StoresIssued form to allow me to automatically switch from instock to Issued. I have 2 types of Uniform parts those with an ID# like a...

I have a stores data base for a cadet unit. I have a table where I want to track what specific uniform parts are issued to a cadet. StoresIssued(table) Cadet last name cadet first name ShirtID# PantsID# Boots ID# +5 other items Each type of part has its own table ShirtTable ShirtID (Primary...

I did resolve this myself by putting in a validation rule <DateAdd("yyyy",-9,Date()) and >DateAdd("yyyy",-12,Date()) and the a validation text "the applicant is not between the ages of 9 and 12"

I have a situation where I am entering data and a Date of birth is being entered. I want want to restrict the date so that someone who is between the ages of 9 and 12 can be entered. I think that I need to enter the argument in the Validation Rule Field of the DOB column in the table. However...

Question 3 I have an Item that has no size and there is no difference between one or the other thus they are not unique and have no ID number on them. Is there a way in a table to make keep track of inventory available mathematically? For instance entering the total number available and then a...

This is for a Cadet Unit. Each Cadet is issued a Uniform that they return at the end of the year, or sometimes in the middle of the year they need to exchange a part of their uniform if it is too small. I think that the first reply has covered question 1. When I create the form for entry I...

I am new to the forum and I apologize if this is a common question nut I need to start somewhere my Access skill is beginner. I have a stores data base Stores Table that records who is issued what uniform parts each component has it own table lets use shirts Each shirt is marked with an ID...