Topics Search

Inventory Form with Display Lookup

Inventory Form with Display Lookup
Views: 2
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:

More topics

 

Inventory Form with Display Lookup

Preview
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

Preview
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?

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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

Preview
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?
 

Look up ms access 2003

Preview
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 Column Display

Preview
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: