Using A List Box To Display Query Information

Jul 30, 2013

I'm trying to get a listbox to display results of a query that are only related to the current record being viewed.I have a form (setup as a continuous form) that displays a vendor table. I have a query setup to reference what parts a vendor supplies, and I would like those results to be visible on the form. I would use a subform to make this happen, but if I try and drop a subform on the main form, it says it won't do it with a continuous form. So, the listbox. I copied my form, dropped in the subform, and took a copy of the SQL statement. I then took that SQL statement and dropped it on the Row Source of the unbound listbox. I do get a return of Parts and Prices, but its the whole list, not just a list for the currently displayed vendor. My SQL is currently thus:

Code:
SELECT tblPrice.[Part Number], tblPrice.Cost, tblPrice.[Price Date], tblPrice.[Bulk Discount], tblVendors.[Vendor Name]
FROM tblVendors INNER JOIN tblPrice ON tblVendors.[VendorID] = tblPrice.[VendorID];

I have tried to wrap my head around it, and I'm stuck. GoogleFu has also failed me, as I can't find something quite on point to what I'm doing.

View Replies


ADVERTISEMENT

Button Action To Display Information From Contact List On Click

Jan 21, 2013

I would like to know how on a report to make a button action that when i click it present information from contact list (full contact details).

View 1 Replies View Related

Forms :: Create List Box To Only Display Information From Another Form Related To Current Form

Mar 20, 2014

What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.

So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.

View 1 Replies View Related

Forms :: Display Some Information From Query In Pop Up Window

Jun 18, 2015

I've created a query called "JobHistoryQuery" and a form called "JobHistoryMultiForm", this displays all Jobs related to an Asset and all the information about that job. There are some fields (BilledMonth, BilledYear, BilledValue, Parts Required, PartsUsed), however, that I would only like to see if I need to see them (as there is quite a lot of information on the form and ideally, I'd like to be able to see the key information from each job from that asset with ease). What I would like is to create a button that says "Billing" and "Parts" for each job and it brings up a pop up window displaying that information.

View 11 Replies View Related

Restricting Display Of Information

Jan 16, 2007

I have built a database to be used by several users. One of the tables contains some fields which I don't want some of the users to be able to see.

All users log in to the database with their own username and password.

How can I hide the fields to everyone except a specific group of users?

Thanks,

Gary

View 7 Replies View Related

Created List Box With One Column - Display All Characters Of List Item

Jan 2, 2014

I have created listbox with one column (contains one column only), now i would like to display all the characters of list item (want scroll bar to listbox).

How do i display all text of list item, I have already fixed Column Widths to max length (22";0.1"). However when scrolling to right, it is going to next blank column of list box, which is created only to change Column Widths property.

View 12 Replies View Related

Auto Display Information When Entering ID

Jul 23, 2005

Hi All!

I'm working on a Personal Information Database.

I want my system to do the following whenever I

enter a person's ID:

If the ID is already entered before, I want all

the personal info fields to be populated with

the person's details.

If the ID is not entered, then I will enter all

the person's details.

Any help will be very much appreciated!

Regards,
CS.

View 8 Replies View Related

Using Form Fields To Display Other Table Information

Jan 17, 2006

Hi, I was wondering if anyone could help me.

I have a simple database, consisting of two tables and one form. I'd like the form to display information mainly from the first table (table 1). For this, I have used the Form Wizard, which works well and displays as it should. My problem comes when trying to display data from table 2, without using the Form Wizard.

I have a simple field called 'Number' in 'Table 2'. I'd like this value displayed in a text box along with table 1's data. I've tried using the expression builder, which gives me something along the lines of:

[tbl_Table 2]![Number]

But this is displayed as:

#NAME

...when I open the form. Could anyone explain how I do this correctly please? All I'm trying to do is display data from other tables in the form.

Any help is much appreciated.

View 5 Replies View Related

Forms :: Form To Display Information From Junction Table?

Feb 3, 2014

I've established a many to many relationship using a junction table.

So I have 3 tables (A for "materials", B for "batches", and J for "junction")

Form A is linked to table A, and contains a subtable linked to a query from table J. This allows me to input materials into table A and then list all of the batches it may be used in that are in table B. I successfully got this to input all the batches and materials combinations in table J.

Now on form B, which is linked to table B, displays the batch information, with the subtable J.

My problem, is that only the materials primary key is showing, not the other information that should be linked from table A.

View 14 Replies View Related

Forms :: Unable To Display Information Based On Data In Another Box

Nov 15, 2013

I am trying to get a form to display certain information based on the data in another box. I have to input some exam results and want to assign a level to them. So, if they score < 13, the result would read "Below Entry 3" if between 13 and 21 "Entry 3" etc If this was a spreadsheet I would use an if function, but I am not sure that I can do this here

View 14 Replies View Related

Forms :: Way To Display / Hide Information On Subform Using Check Box?

Jul 11, 2013

Is there a way to display/hide the information on a subform using a checkbox?So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays?

View 5 Replies View Related

Forms :: Buttons To Display Information Stored In Excel Sheet

Sep 2, 2014

I would like to first state that I am new to Access and trying my best to pick up on skills, so pardon if my questions seemed redundant or illogical. I'm trying to create a sort of quick-access/all-in-one Access form that..

1) Displays contact details stored in an excel sheet
2) Opens application on click
3) etc..

I am able to get pointer 2 sorted out, however am having trouble with pointer 1.

I have the contact details stored in an excel sheet, of which I am aware of how to import it into Access. However, my idea was to have a tab where firstly there are 4 buttons, say buttonA to buttonD.

I want it to perform an action such that when i click buttonA, 5 other buttons (say button1 to button5) appear on the right of the 4 existing buttons.

If I press buttonB however, button6 to button10 will appear and replace the button1 to button5 at the same spot.

After which, if I press button1 etc, there will be a field where contact details are displayed (name/number/etc) and it switches as I press different buttons.

View 3 Replies View Related

Combine Two Columns To Display Information In Third Column As Unique Identifier

Jul 23, 2015

So i have a access database with a main field that we can call vendor # (LIFNR) and another called Company code (BUKRS). There are multiple company codes under a single vendor #. Example:

LIFNR
BUKRS

0000010535
1010

0000010535
5060

0000010535
5610

0000010536
1010

0000010536
5060

0000010536
5610

What I am trying to do is create a 3rd column where i can have a unique row for each of these fields without it repeating. There is no unique identifier in this table and that is what i am trying to achieve.

View 3 Replies View Related

Drop Down Look Up List - Fill In Information

Dec 4, 2006

I would like to have a lookup list (drop down), if an item is not in the list I would like to be able to enter it at that time - how would I go about setting this up. I am new to Access and not sure where to start.

Table City:
CityID Autonumber
City Text
Zip Text

Also, I would like to be able to type a letter - say W and it would go to cities that start with W (Wauwatosa), rather than having to scroll through the list.

View 2 Replies View Related

Modules & VBA :: Searchable Form - Message Box To Display Information Based On Expression

Nov 24, 2014

I have a searchable form that display information on agreements other companies have with us. If a company requests an inspection we have 30 days to go out and complete it.

I am trying to create a message box that will display all inspections that are due within 5 days when the form loads. No luck so far, only broken dreams.

Is it possible for message boxes to use expressions and display information that fits the criteria?

View 2 Replies View Related

Forms :: How Data Is Passed Using Foreign Keys - Cannot Display Proper Information

Jan 25, 2015

I'm trying to understand how data is passed using foreign keys.

I'm using Allen Browne's 'Don't use Yes/No fields to store preferences' at: [URL] ....

I've also downloaded his sample DB, RelationBasics, to use as a guide.

Attached is my version of the Student / Sport DB as described on the webpage.

I use 2010 at home (saved as 2003 version) and 2003 at work (JPNSE OS). Both result in the same thing.

The problem I'm having is I cannot get the actual sports to display in the combo-box, only the Sport_ID number.

I've tried building both forms with and without actual data in the TBL_Student & TBL_Sports tables, but no mater what the result is the same.

View 2 Replies View Related

Queries :: List Form Showing Specific Information In Table

Oct 27, 2014

Okay so basically below is the table I'm linking to a list box, the field i'm focusing on is the 'Disallowed' field:

Now this is the form i'm linking it too:

As you can see the list box on the right is currently just showing the whole column under the Disallowed list, but I want it to show the specific country, obviously I'm using a single form template but the information changes depending on what country i'm on (I presume I need some kind of Query that uses whatever is shown in the Country box)

I was trying to use SELECT * from tblCountries where [Country]='"&forms!frmCountryDetail!Country&"'" but this is giving me an error from the [Country] tag so this isn't working:

View 3 Replies View Related

Forms :: Using One Dropdown List Box To Display A Selecting In Another Dropdown List Box?

Aug 4, 2014

I have a form where I have two drop down list box.The first list box is called Transaction_Type. It contains three values: Created, Allocated and Sold

The second list box is called Product_Status. It contains 6 items: Allocated, Produced, Reworked, Shipped, To Be Produced, Unallocated.

I have a products form. When a user created more inventory they will selected in the drop down list create, then a quantity. Then I would like the status of the product to update to "Unallocated".

When the user placed an order but doesn't finish it they will choose the status of the inventory to be allocated so I would like the product status to be updated to allocated automatically.

They other status the user will choose them self and do not need to be linked to each other.

In my vba code I have tried with the OnClick and AfterUpdate sub procedures with the following code.

If Me.Transaction_Type.Value = "Created" Then
Me.Product_Status.Value = "Unallocated"
End If
If Me.Transaction_Type.Value = "Allocated" Then
Me.Product_Status.Value = "Allocated"
End If

Yes when i select "created" from the drop down list it does not change product_status to say "unallocated"

(in using access 2007)

View 14 Replies View Related

Display A List Of The Most Recent Records

Aug 31, 2005

hi. i would like this to happen....

i have a database where jobs are entered and the date and times of the jobs are kept in separate Date and Time fields.
to enter a date the user uses this method "30 12 05" and to enter a time like this "21.30"

i would like a query that will display the 10 most recent job additions according to their respective date and times. however, it will not be enough simply to view these records in a report.. what would be ideal is if the 10 records are opened.. in their original form format (goto next record...previous...(1/10...5/10) and the fields are editable like in the default job entry form. this is because after a job record has been added, maybe 20 or so minutes later, that record would need to be retreived as the last bits of information for that record will have been established.

how can this be acheived. i am clueless at the moment, so if there is a solution even resembling this scenario that would be ideal. (if a filter is going to be used...it can be either the 'date' or the 'time' fields, ideally though the query would use a combination of the two to retreive a more exact date to filter the records by)

thank you access world for even considering my dilema.

View 2 Replies View Related

How To Display List Of Value Based On Combo Box

Mar 17, 2015

I want to create a combo box on a form where I can choose between 5 company names, and upon my choice, I want a list box or another combo box to display the departments under the company I chose (each company has different departments), and when I choose the department, I want to another combo box to display the limited job titles under that department.

For example: I choose company A > combo box displays the 5 departments under company A (dept.1,2,3,4) I choose dept. 4 > display job titles under dept. 4

How can I do that? Should I do a table? A query?

View 3 Replies View Related

How To Display Data From A Relation In List Box

Jul 3, 2013

I made a database with 3 tables:

"city"
"company"
"person"

Each company has a director (I choose from a list that's bound to "person" by its ID field)

Each person lives in a city (I choose from a list that's bound to "city" by its ID field)

So:

- a person's city is stored in "person" as the ID of "city", so I only have numbers (1, 2....)
- there can be two persons in "person" with the same name (the only thing that differs them is the city they live in)

The problem is:

When I try to choose a director in "company" from a list, it shows me the name, surname and the ID of the city the person lives in, all from the table "person". The trouble is, since there can be two persons/directors with the same name, I really need to see their cities (the real city name, not just its ID). But I still want the city in "person" to be stored as ID of "city".

I attached my database so you can see what I'm writing about.

practice.accdb

View 2 Replies View Related

List Box Won't Display Time Correctly

Jun 25, 2014

What I want is for the "Time In" column in the listbox to show the time as hh:mm, just like the other two. The listbox is pointing to the table correctly, as evidenced by all the data showing up, but what floors me is despite the "sign_in" table showing time in all three columns in the desired format of hh:mm, the listbox seems to have its own thoughts about how to display the called data.

View 7 Replies View Related

Need To Display A List Of Folder/subfolder Contents

Nov 15, 2006

In access, I need a way to display a list with folder contents, for example...

Folder1
subfolder1
file1
file2
subfolder2
file1
Folder2
subfolder1

etc

View 1 Replies View Related

Reports :: How To Get List From Form To Display In Report

Apr 7, 2014

I'm trying to get a list into a report, the specific list is build in a form.

How can i get this list displayed in a report ?

Can i load the list using vba code or is there an easy-er way of doing this ?

View 1 Replies View Related

Display Specific Records In A Subform Using A Dropdown List

Apr 12, 2005

Hi to all,
I developed a database where I keep all the problems that I face and their solutions along with its category.

Now I want to have a form that when I choose each category, I should have all its records.

I heard that I should implement this by using a subform but I couldn't manage. With a search at the topics I've seen that I should use a macro but I don't know how to implement it.

Possibly after the lookup field I should have an After Update function but how can I connect it with the subform?

ex. at category "hardware: floppy" i have 2 records and i want to see only these, and when i choose category "hardware: hard disk" to have other 5 records of that category

Help plz?

View 9 Replies View Related

Modules & VBA :: Combo Box Will Not Display List In Correct Order

Nov 3, 2014

I have code attached to a command button to fill a Combo Box with data from a music collection. A letter of the alphabet is entered into a Text Box then records beginning with that letter are copied from a table, either by Artist or Title. They are saved to a temporary table at which time they are in no particular order. Those records are copied to a further table and saved in alphabetical order. This table is then used to fill the Combo Box.

I used two temporary tables because the records were not displayed in the correct order. I hoped this might cure it, it did not. The records are in order in the table but not in the Combo Box.

Code:
Private Sub Command68_Click()
'SEARCH AND FILL COMBO BOX
On Error GoTo errTrap
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM tempList;"

[Code] .....

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved