Form Displaying Multiple Tables
Jan 27, 2006
I have a combo box with a list of names in, and a table for each of those people.
When one of these names is selected, i want the contents of the corresponding table to display in a form. Easy Enough.
But...how do I get these tables displaying in one form depending on which name is selected, to save me having 7 copies of the same form just with different sources. All the field names are the same.
One solution I thought of is to put all the data in one table, but would really rather keep it separate.
TIA
View Replies
ADVERTISEMENT
Jul 17, 2014
I am creating a staffing database and currently have two tables:
Table 1 - Staff - which contains staff information ie. First Name, Last Name, Other Names
Table 2 - Staff Work History - which displays the shifts worked by each staff member.
In Table 2 - I have "Staff Name" which is populated using VLOOKUP and searching for the Staff Name from Table 1 - First Name, Last Name, Other Name.
I want Table 2 column "Staff Name" to display all parts of the name - not just display then when on the dropdown when you select the staff person. Currently only the First Name is displayed once you have chosen the staff person.
View 2 Replies
View Related
May 17, 2005
Anyone know how to display multiple records at the same time on a form?
View 1 Replies
View Related
Mar 4, 2013
By means of a multiple value checklist the Field: "Problem" can be selected (marked).The multiple value field information is stored in the table beginsituation in the form Beginsituation. This stored (selected fields only) information I want to be fetched from the table beginsituation and shown in the multiple value checklist in another form called Progress. The user can than change the selection via the multiple value checklist if the user wants this and this information will be stored in the table: "Progress". However I could not get the in the previous form (Beginsituation) selected values in the multiple value checklist.
View 3 Replies
View Related
Nov 18, 2013
I have a form that a user will use to search records. Upon selecting a record, there are three buttons that allows the user to look at more detailed information. This information will be on the many side of the relationship. So I will have multiple values. The called form is just a popup form that I use for several other instances, like displaying memo fields from other tables.
The problem I am having is that only one record shows up at a time on the called form. I have read through the postings and have changed the properties for Default View, Filter on Load, Data Entry, etc. Nothing seems to change the outcome. I have run the query in SQL view and have no issues. It returns the correct records and multiple rows when expecting. Why they don't show up on the form. There are no errors, just the first record from the many side of the relationship shows up in the form. I would like all records to show up, just like when I run the query.
Code:
SELECT Capability
FROM Process_Meetings_Capabilities, Process_Meetings
WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID
AND Process_Meetings_Capabilities.Meeting_ID = 2;
Button Code
Code:
Private Sub Capabilities_btn_Click()
strSQL = "SELECT Capability AS Results"
strSQL = strSQL & " FROM Process_Meetings_Capabilities, Process_Meetings"
strSQL = strSQL & " WHERE Process_Meetings_Capabilities.Meeting_ID = Process_Meetings.Meeting_ID"
strSQL = strSQL & " AND Process_Meetings_Capabilities.Meeting_ID = " & Me!Meeting_cmbo.Column(0)
[Code] .....
View 6 Replies
View Related
Apr 17, 2007
Im making a database about past bid results. In one table i have a list of bidders and which place they came in (along with some other information). I have 20 positions (1st place, second place and so on...), so i made 20 queries that search through the table for my company's name so we can see how many times we came in first, second, third and so on. Now i would like to bring the number of records in each query to a single form. I tried making another query to using the count feature on the other 20 queries but it keeps returning 0 as the number of results per query. But when i open each query up there are obvisouly more that 0 results in each. Is there a way i can bring up the number of results per query all on one form?
Thank you
Dan
View 7 Replies
View Related
Sep 4, 2006
Hey guys and gals, im in dire need of help!
I have a table with two fields. A name field where I have a bunch of unique numerical data and an object field, which contains unique pictures.
I am wondering if it is possible to create a form where I can display say ten pictures (I'm assuming as bound objects) and have each of them display a different object from a different record?
Or in other words can I have one bound object displaying a picture from one record, and a second bound object, displaying a picture from a second record, on the same form?
I have tried searching for everything and any little help would be much appreciated!!
Cheers
Robbie
View 1 Replies
View Related
Aug 3, 2005
At the moment I have a field 'Author' which is displayed using a subform. The user can cycle through the many authors that are associated with each record in the main form. However, what I'd like to do is to display each record simultaneously in the same control, and with a little bit of playing around in VB get the form to work out how many Authors there are and display the names in a particular format. I.e.,
Bloggs, Jones & Smith
Hank & Mason
See what I mean? Does anyone know how I might refernce the records. So logically it would be:
lblAuthor = Record1 + "," + Record2 + " & " + Record3.
If that makes sense...Sorry if this is in the forums somewhere...
View 1 Replies
View Related
Dec 21, 2006
Hi,
I am new to Access forms and need some help. I did some research and figured out to display images in Acess Forms while getting the image path from a text field in the table. The images are suppose to change for each record. I have no problem displaying the first image a different image for each record but I am having problems displaying the second image. I have to 2 different fields for both image paths in the table. Here is the code:
Private Sub Form_Current()
On Error Resume Next
If Not IsNull(Me![Image1]) Then
Me![ImageFrame1].OLETypeAllowed = 1
Me![ImageFrame1].SourceDoc = Me![Image1]
Me![ImageFrame1].Action = 0
Else
Me![ImageFrame].SourceDoc = "C:Documents and SettingsAll UsersDocumentsMy PicturesSample Pictureso-image.bmp"
Me![ImageFrame].Action = 0
End If
If Not IsNull(Me![Image2]) Then
Me![ImageFrame2].OLETypeAllowed = 1
Me![ImageFrame2].SourceDoc = Me![Image2]
Me![ImageFrame2].Action = 0
Else
Me![ImageFrame2].SourceDoc = "C:Documents and SettingsAll UsersDocumentsMy PicturesSample Pictureso-image.bmp"
Me![ImageFrame2].Action = 0
End If
End Sub
The problem is that the function returns after 'Me![ImageFrame].Action = 0' and doesn't go to the part where I am checking if the 2nd image exists. If I take out 'Me![ImageFrame].Action = 0' then it doesn't display the first image and goes on the 2nd image and displays the 2nd image.
So that he bottom line is, with this code I can only display one image (either f1st or 2nd). Also, I tried using .Picture property instead of .SourceDoc but that doesn't work either. How can I change this so that I can display both images?
I really need to figure this out and will really appreicate any help. Thank you
View 1 Replies
View Related
Jul 30, 2013
I am designing a book collection database where each book can contain multiple authors. I used three tables; tblBooks, tblAuthors, tblBookAuthorJOIN. The tblBookAuthorJOIN allows me to create a subform with drop down combo boxes in the Books form linking multiple authors to each books indexed field. The Author table contains the usual FirstName, LastName, MiddleName fields. I would to be able to display the names of each author in the forms header but I am having difficulty.
For example a book may have two authors such as:
Authors table would contain values such as
Last Name: Grisham
First Name: John
Last Name: Twain
First Name: Mark
Textbox in header would display: John Grisham; Mark Twain
The authors would be displayed in the following format in the same order as listed in the subform datasheet.
Attached is a graphic of the form.
View 3 Replies
View Related
Jul 17, 2013
I have a multiple select combobox which shows up in many forms- SubCategories. The user can pick from a list of 154 SubCategories.
Everything is working properly however it is difficult for the user to scroll through the entire list.
My question: Is there a way to represent this ONE field in multiple columns in the combobox?
I know how to add columns for multiple fields to my combobox, but this is one field.
Maybe there is a better way to represent the data... a subform would have the same issue.
View 6 Replies
View Related
Mar 4, 2015
I have a multiple column combo box on my form, that is correctly populating. When I make a selection, it displays the result from the first column. Bound column seems correct, as my table is being populated correctly.
1 - Can I display the values from both columns after the selection has been made?
2 - If not, can I choose to display the second column (not the first) after the user has made a selection?
View 3 Replies
View Related
Aug 22, 2007
Hi, sorry if this has been covered before, I am a new guy around here.
I have two tables in a select query, both with a code field and a monetary value field. The codes are linked. This query is to show the variances in the values of each table as they are meant to have identical codes and values. However, each table has a small handful of codes that are not in the other, but all the query outputs is the variances for codes that are in "both" tables. I realise you can do one way relationships so that you can display all from one table and only those matching from another. However I need the query to show "all" the codes from both tables, and the value difference.
Any advice on going about this? Would be much appreciated! Thanks. :)
View 1 Replies
View Related
May 20, 2006
I have 6 tables that have 1 to many relationships.
I would like to have all 6 tables on 1 form for data entry.
When I use the “Form wizard” and select the tables it wants to group the last 3 tables in 1 subform and it won’t let me add records to the last 2 tables. Same thing happens when I create a query and run the form wizard selecting the query.
I know I’m doing something wrong but I can’t see it……….
Thanks
Paul
Here's an add on question:
When the form wizard adds a subform to a subform the link child and master are filled out and the form updates. But when I add another subform and set the links it will not update.
Example:
form Book has text fiels and 2 sub forms "Chapter" and "Section" subform section child link is ChapterID, master link is [Chapter Subform].Form![ChapterID] --- This updates as expected.
I create a new subform "para" based on a table and set the Child link as SectID, master link [SectionID].Form![Section Subform].Form![SectionID] --- Will not update the subform "para" when the next record in subform "section" is selected.
Any ideas would be great......
View 2 Replies
View Related
Aug 27, 2012
I have one form (Request Form) which has quite bit of information on it. So I decided that I would need the following tables:
tblRequests
tblCustomer
tblSalesperson
tblSupervisor
I think I have created the relationship fairly well. Most of them one-to-many.
I created the form but now I whenever person is making entry I want the information from one form to go into multiples tables. What's the best to go about this?
I have tried couple different ways, Made a query from the tables and then using that as Record Source for the form as well. It doesn't seem to work properly.
View 3 Replies
View Related
Apr 6, 2015
I am trying to take two tables (one is customers and the other suppliers) and turn it into a form to pull up the data from the tables. I need to be able to enter new data. This is for a corrective action form so after pulling up the customer and supplier info, I need to input the problems and corrective action. This information will then be turned into a report that I can print out.
View 2 Replies
View Related
Feb 7, 2005
I am currently designing a database to solve our organisation's training requirements. The db needs to be able to identify an individual member of staff at any particular site and list all the medical devices that they have training on and to what level of competency. So far I have five separate tables:
Staff details
Site
Devices
Competency/Risk
Equipment
By using unique identifiers within each table, we can, in theory, comply with the requirements.
Now here is the problem. Having talked it through with a colleague, we have two possible options.
A. Using a form based on the staff member, combine the salient details and, where needed, create additional fields (such as dates and tick boxes) to record odd items (this is my preference)
or
B. Based on the site, create a make-table query and form a table, sorted by site and then staff, listing all the equipment and competency levels. Given that some staff will work at multiple sites, the table will probably contain over 6500 records with lots of duplication (you can see my bias!)
Which solution is probably the best or should we be looking at solution that combines elements of both?
Thanks in advance
David
View 3 Replies
View Related
Mar 22, 2008
Hi, I am designing a database for a basic payroll function. So far everything was going well until i started to design forms. I cannot delete multiple table entries from one table that connects two tables. This situation is as such:Employee Table: contains entries as follows:ID: Autonumber (PK)First Name Last Name PayCategory (Salary or Hourly) (List Box)PayInfo Table: contains entries as follows:ID: Autonumber (PK)Employee Name (Text)Pay RateThe relationship of these 2 tables is a one to many relationship; where the ID from Employee Table is connecting to Employee Name in PayInfo Table.When i created a form using these 2 tables and added a delete button to it, the entries from Payinfo table get deleted when i click the delete button, but not from the employee table.I have tried everything i can think of :( . What am i doing wrong? Can someone please guide me in the right direction. Any help would be greatly appreciated.
View 2 Replies
View Related
Apr 11, 2005
Sorry for the newbie question but...
I've got a form called 'frmStudent' which is linked to 'tblStudent'. I have designed it as a tabbed form, the first tab has "Student name", "Student Number", etc. The second tab is linked to visits by the student to a mentor (such as a tutor etc). Here I'd like to have "Date of visit", "Mentor Name", etc.
So far I've been able to get the first tab to work (I'm guessing because it's linked to 'tblStudent'), but can't get my 2nd tab to work as I have no clue on how to link it with 'tblVisits'. Is there a VBA methor or perhaps a nother method to do this?
I'm attaching a link to the sample of what I'm doing (please shift-open into frmStudent to view what I'm talking about). Any ideas and suggestions would be greatly appreciated!
DOWNLOAD DATABASE:
http://www.myfilestash.com/userfiles/sabotage1945/Student_Help.zip
Kindest regards,
Sab.
View 4 Replies
View Related
Jun 15, 2005
Hey Guys,
I have 2 tables (tblSET, tblPROJECT) that have a relationship between them in the form of strPROJID (Project ID)
I need to make a form that has all empty fields in it, and when filled in distributes the entered data to the corresponding field in the corresponding table. I have tried using the design wizard and just putting the fields from all tables onto one form, but the "new record" button is greyed out when I do that. I figure this will include coding of some sort but I am far from a coder.
Thanks ahead of time,
JVermast
View 1 Replies
View Related
Aug 16, 2005
I have 2 tables, Test Cases, Test Case Details. I have a tabbed form to display the data. How do I open the form and retreive the data from both tables? Tables are related by ID.
View 2 Replies
View Related
Mar 25, 2013
I currently have 1 form linked to 1 table which data from another table is appended to for editing, re-appended to original table and then rows are deleted. However, this process will need to be done by 4 other users soon and I needed to know if I need to create 4 separate tables and 4 separate forms or is there another way to implement this? The append query has clauses that will display only a specific user data for editing, however, I do believe that if 1 user is in the editing table, then when 1 of the other 4 users attempt to run the query to append their data from the original table, they will get an error message that this table is already in use. I just need to know if there is a way to set up an alternative to re-creating 4 tables/4 forms again.
View 4 Replies
View Related
Jun 2, 2014
I have 3 table each with the same columns.
1st table = current documents
2nd table = documents awaiting approval
3rd table = old documents no longer in use
I currently have a subform within my search form that I use to filter the results via a textbox on the form. I would like to have the contents of all three tables present in the subform.
View 1 Replies
View Related
Sep 22, 2013
I have created some tables using CREATE TABLE but they do not appear in the list of tables although they are there. How to make them appear.
View 1 Replies
View Related
Nov 29, 2007
Can a Append Query move all my data stored in multiple tables to another database with a identical table structure?
Because as I try to work the query, I keep getting prompted to "Select a table" I want to append to, and I don't want to append to just one table...
View 4 Replies
View Related
Oct 14, 2013
I have an issue with a couple of my combo boxes. When in form mode the drop down menu displays a list of options (taken from my source table), this is fine, but the problem is that it allows the user to select more than one of the options in the form of checkboxes. This is not what I intended.
I've attached to pictures to demonstrate the problem. The first is ComboBoxQuery (the one with the problem) and the second is ComboBoxQueryWorkign (the one without a problem).
I'm not sure why this is happening and I've tried comparing all the properties of both these combo boxes and changing some of them to see if I can eliminate the problem without any joy.
I use a very standard SELECT statement to pull the data for the combo box:
SELECT CountryID, CountryName FROM tblCountryInfo ORDER By CountryName
View 7 Replies
View Related
