Inventory Form with Display Lookup

I'm using a form to enter inventory data into a table. The fields that the form is inputting into my tblInventoryData are TagNumber, PartNumber, Qty, Dept. I also have an tblItemList that has field names of PartNumber, PartDescription, UnitCost. What I would like to do is have a box on the form that would display the PartDescription when the PartNumber entered into the form matches a PartNumber in the tblItemList. I don't want the the PartDescription added to the tblInventoryData, I just what a display to confirm that the correct part is added. Can this be done? Any help would be much appreciated.

Sponsored Links:

Related Topics

Inventory Form with Display Lookup
I'm using a form to enter inventory data into a table. The fields that the form is inputting into my tblInventoryData are TagNumber, PartNumber, Qty, Dept. I also have an tblItemList that has field names of PartNumber, PartDescription, UnitCost.

What I would like to do is have a box on the form that would display the PartDescription when the PartNumber entered into the form matches a PartNumber in the tblItemList.

I don't want the the PartDescription added to the tblInventoryData, I just what a display to confirm that the correct part is added. Can this bedone?


Access 2010 Lookup Column Display
MODEL
INVENTORY

MANUFACTURER
MAN_NUM
MAN_NAME

MODEL
MODEL_NUM
MODEL_NAME
MAN_NUM (FK)

INVENTORY
INV_NUM
MODEL_NUM

I am trying to create a lookup in the Inventory Table for the MODEL_NUM column. I would like when the user clicks the drop down box they see the choice options as MAN_NAME, MOD_NAME.

Then when someone chooses the option they want it displays the MODEL_NAME in the field. I would actually like it to display a calculated column of MAN_NAME and MODEL_NAME,

When running a query it displays the data that I want. When looking at in datasheet mode it only shows MOD_NAME. It then displays the MOD_NUM.

SELECT MANUFACTURER.MAN_NAME, MODEL.MOD_NAME
FROM MANUFACTURER INNER JOIN MODEL ON MANUFACTURER.MAN_NUM = MODEL.MAN_NUM
ORDER BY MODEL.MOD_NAME, MODEL.MAN_NUM;

For extra information my properties are as follows:

DISPLAY CONTROL: Combo Box
ROW SOURCE TYPE: Table/Query
ROW SOURCE: Code Above
BOUND COLUMN: 2
COLUMN COUNT: 3
COLUMN HEADS: YES
COLUMN WIDTHS: 0";1.6459";1.3646"


Getting display value of lookup column?
How do you programmatically get the display value of a lookup column?

I have a lookup column that works fine, but when I try to get the value through vba, I can only get the bound value (a number). I tried doing it the way I would for a combo box: [field].Column(1), but that didn't work. I need the display value so I can use it in a Dlookup function on another table


Trying to combine two pages
I have two pages connecting to a WMS database (SQL 2005 Express). The first page connects to an inventory table to display what inventory is found in a particular set of warehouse locations (Populated locations - also joins on a second table to get a description).

The second page connects to different table to display a list of warehouse locations that do not have inventory in them (Open locations).

Open locations do not show up in the inventory table until there is inventory in them.


Lookup values after entering data in form
This one should be an easy fix, Access 2010. I have a form with a text box entry where you input an inventory code for shipping.

Example XX? for X being the letters and ? being the numbers

I have 3 tables listing of these codes in separate categories and the information of the items they represent.

How do I auto-fill on the form, the additional data from these codes. And is it possible to have this data saved in the shipping table, or does it only display on the form.


Displaying a list of entered records that updates with each entry
I have two tables, one for "Parts" and the other for "inventory". Each box in inventory has data that needs to be entered, such as Part Number, quantity, Revision, location, etc. Parts and inventory are keyed on [Part No].

I would like to enter inventory records on a form and in a subform display all inventory records already entered for that part number. Basically I would like an add button and a save button but am not understanding how to do this - work with the record data and then save.

Once saved I want this record to be added in a running list of inventory for that part.

I am having trouble with getting the list to display because I am working with entry into the list but am not sure how to setup add record and save record code. How do I work with the dataand then save it and have it pop into the running list of inventory for that part?


Multi Column Lookup Wizard Display 3 columns change which one is shown on table
I am doing a 3 column lookup wizard for my table in the form .
[Data from table] [Group Value] [lookup Value]

When I am finished it shows the Group Value. I want it to show the lookup Value


Inventory Controls from Subform
I have a form "PRF" that uses a subform "PartsF" within "PartsF" there are 15 line items each utilizing a lookup to a table "Inventory" which displays the Manufacturers Part Number (Inventory!Part_ID, Forms!PRF!mp1, Forms!PRF!mp2, Forms!PRF!mp3.etc.) now I'm being asked to calculate the parts on order qty by part #.

I'm assuming I will have to redesign the form somehow but I'm at a mental block right now.

Is there a way to perform a Dlookup or query that If Forms!PRF!mp1.mp15, find Forms!PRF!q1.q15 (quantity to order) andthat number will be stored in a field in the Inventory table?
Or do I have to re-design the form?


Lookup Column Display
I've created a lookup column that brings a name from Table 1 to Table 2. In Table 1 the name is divided into 3 columns: Extension (Primary Key), First Name, and Last Name. In Table 2 I'm combing these three columns into one using a Lookup Column.

When I go to datasheet view in Table 2 this column is only displaying the First Name, I can only see the Last Name if I click on the drop down button.

The Lookup Column is working fine in terms of functionality, the issue is with how it's displayed. I need to be able to see both First Name and Last Name without clicking on the drop down.

As I've built queries and reports it continues to only display the first name, which won't work if I need to print anything. My lookup column properties are asfollows:


Look up ms access 2003
I have a table with three fields in it which have a combo box lookup. I have then created a form with various fields on it but want the three drop down lookup's to display all three under one column.

I.e. lookup's are Order, Forname and Surname. On the form I have selected Order and from that want all three to appear under that column.


Lookup values after entering data in form
This one should be an easy fix, but I am brand new to Access.

Access 2010

I have a form with a text box entry where you input an inventory code for shipping.

Example XX? for X being the letters and ? being the numbers

I have 3 tables listing all of these codes in separate categories and the information of the items they represent.

Question:

How do I auto-fill on the form, the additional data from these codes. And is it possible to have this data saved in the shipping table, or does it only display on the form. (It is ok if this data won't be saved


using a form to put items on a report
Im trying to make a form that has some items on it, Basically im making an inventory report, and different people have different inventory types, and they have to mark in a collum weather they have the item in the inventory type (category, like home inventory or office inventory). I need to make a form, and have the three inventory types there with all the equipment in them listed and a space for them to fill in if they have or dont have the item.

Then I need corresponding checkboxes for each of these items on the form. If checked, the category goes on the report, if not its left off. None of the items are in the database or anything, they will just be written in on the item on the form. I know this is probably pretty basic but I dont have alot of experience with this.What im essentially looking for is how do I transfer information from a from to a report, and how do I set up conditions with that for something to appear on the report or not appear


Filter form with command button
I have an Inventory form that displays inventory in a datasheet type view, which has filtering textboxes at the top. The first filter criteria field (Cat) uses a combo box to select which category to filter the inventory by (Prototype;Production).

[CODE]

When I click this button, it opens the Inventory form, and "Prototype" is displayed in the combobox, but the form isn't filtered. How can I activate the filter in the code sothe Inventory form is showing only the Prototype parts when it opens?


Inventory: add/remove stock qty from table
I hope someone can help me - I haven't touched Access in years and I have been "volunteered" by my employer to write a basic inventory system. I am using Pendragon forms along with the now obsolete Handspring Visor equipped with scanner to scan barcodes and collect data.

What I can't seem to wrap my head around is performing a record lookup from the scanned data (I have a table with scanned data to add to inventory (tblAddInventory), a table with scanned data to remove from inventory (tblRemoveInventory) and a master table with all ofmy warehouse inventory (tblWarehouseMain) and performing a calculation on the records to add - or subtract - stock, depending on what table the data comes from.

I am (er, rather used to be) comfortable with VB.

I have tried to create an update query as well as some basic code via control on a form, but I'm finding myself at a loss. Anyone willing to take a shot at helping or pointing me in the right direction?


Customize how data is displayed by creating a lookup field
When you want a field in a datasheet, form, or report to display a certain value while the field stores a different value, you create a lookup field. A lookup field is useful when you want the field to display something more meaningful than a number, such as an ID (or other foreign key (foreign key: One or more table fields (columns) that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related.) value). For example, instead of displaying a contact ID number, Microsoft Office Access can display a contact name. In this example, the contact ID number is called the bound value, or the value that is stored in the source table, query, or list. The contact ID number is automatically looked up in the source and replaced with the contact name. The contact name is referred to as the display value.


How to display subform item in form
I have problem with display subform item in a form. I'm trying to create a inventory database. I want to display Units on Hand in a form. I set Unit On Hand in a SubForm Header of Product, and I want to display it in Product Form. But it is not working (Please see attached database


Use an Access 2007 Lookup List
A lookup list in Access 2007 is a column in a table whose values are retrieved from another table or query. They are frequently used to display a list of choices in a combo or list box. A lookup list may be created manually but you should use the Lookup Wizard to create a lookup column whenever possible. The following steps will show how this is accomplished in Access 2007.


Simple Inventory
I'm trying to use a query to show my current inventory. I produce chili and have ingredients and when ever I use an ingredient I would like it to be removed from my inventory and whatever I created will be added to my inventory or query.


retail and wholsale in a ms access 2007 database
please is it possible to have a store inventory, retail inventory ,wholesale inventory separately in ms access database?
the sale point will be one it will just reflect where the item is coming from.
for example someone comes to buy from wholesale, it deducts from the inventory in wholesale, if the person comes to buy from retail it deducts from the inventory in retail
at the end of the year if we want the stock taking, it does the individual inventory and totals all the inventory together
would be glad if any help is rendered


Add or change a lookup column
Sometimes, the value you want is tracked in another table. For instance, suppose you want to record the customer for an order in the Orders table. However, all customer information is tracked in the Customers table. You can create a lookup column that displays the customer information in a combo box or list box control. Then, when you select the customer in that control, an appropriate - such as the customer's primary key value - is stored in the order record.
This article explains what a lookup column is and how to create one.
In this article
* What is a lookup column?
* Create a lookup column in Datasheet view
* Create a lookup column by using the Field List pane
* Create a lookup column in Design view
* Understanding the bound value and the display value in a lookup column
* Introducing the Lookup field properties
* Using the Lookup Wizard
* Change a lookup column
* Change a field to a lookup column