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.
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.
Is there any way to fill cells in Access tables with the results of using vLookup in an Excel worksheet? I'm trying to vLookup the quantity of products sold in the worksheet and make that number available on an Access table and form. Can the two aps jibe like this?
How do I paste to multiple cells in access 2007? Basically I want to copy one cell in the dataview and then highlight maybe 10 cells and copy the info from the one cell into the highlighted 10 cells at one time. I had no problem doing this with 2003 but in 2007 this seems to be an issue. Any help is appreciated!
I need to export multiple queries into a single spreadsheet in different range of cells. Means one query need to be exported from B2:E2 and second query need to be exported from B10:E10. In this way need to export 18 queries' result into one sheet only on different name range.
I am using Access 2007 and need to export data into Excel 2003 format.
Is it possible to import an excel spreadsheet which contains some merged cells. What I have got is a spreadsheet (like Raw Data in the zip file) and I need it looking like (Finish Data) but in a access table.
I use a Access database to import data from an email generated from google docs..When the data imports to the table it creates a "Memo Field" with several lines of carriage seperated data containing the Form Field name & answer. (ie: Firstname=John, Surname=smith, etc)Is there any way to seperate this data in the cell into seperated cells in a new record?
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!!
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:
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
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.
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.
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)
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?
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. :)
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?
hi ! i'm very "fresh" in access , and i want to learn how to build something like vlookup . i have 2 tables : car , general
i want to get a query that give me :
id number plate color 1 111111 blue 2 222222 black 3 999999 not found
i want to see all the id's and all th number plate and the color's. in id=3 there is no color in the table , and i want to see this line in my query with the words "not found" at the color column
I've created a DB to track costs of subcontractors hauling loads for a warehouse that services a number of stores. I've created a stores table and a hauliers table. Hauliers will charge different rates to other hauliers for delivering the same stores. How do I key in a haulier ref and a store number and get the database to return the cost of this trip. It would be easy in Excel with a VLookup, but how do I do it in Access.
Can I create a query with hauliers down the row headings and stores along the column headings from the existing tables?
I have the SQL statement for the VLookup (Dlookup), but I don't know where to enter the statement. Please tell me exactly where I need to enter the statement. In the SQL Specific menu? Union? Pass Through? Data Definition? Or some place else?
UPDATE Table1 INNER JOIN Table2 ON Table1.material = Table2.Material SET Table2.Serial = [Table1]![serial];
Also, do I need the ";" at the end of the statement?
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
I have 3 tables: [SurveyVendor], [Surveys] and [SurveyResults]
SurveyVendor has 2 fields: [VendorID] - PK [VendorName]
Surveys has 3 fields: [SurveyID] - PK [VendorName] - FK [SurveyName]
SurveyResults has 3 fields: [SurveyResultID] - PK [SurveyName] - FK [SurveyQuantity]
I used the LookUp wizard to establish the relationships, and I chose to include 3 fields when linking [SurveyResults].[SurveyName] to [Surveys].[SurveyID]. I'd like the ID, Survey Name and Vendor Name to be displayed when making a choice in the combo box. And I would like the column to only display the SurveyName.
However, what's happening is the VendorID shows up instead of the VendorName when I click the combo box for [SurveyName]. And the SurveyID shows up in the column results, rather than the Survey Name.
