Linking Combobox

Nov 21, 2006

Good day all,

I got a quick question..

I got 2 tables

Departments:
ID
Department

Functions:
ID
Function
Department_ID

They are linked with an one to many relation.

Now when i'm making my form i want to have 2 combo boxes, 1 listing the results found in Departments.Department and another listing the results of Functions.Function where the Functions.Department_ID is equal to Departments.ID.

When i put this in an sql query it doesnt work, at best it asks me to put in the Departments.ID manualy tho i want the functions combobox updated when i pick something from Department.

Thanks in advance

View Replies

Linking Combobox To Form And Updating

Jul 15, 2005

I have a combobox that displays information about a current record on a form (much like a subform would show all information related to a certain record). So for example, there is a user and the combobox would list all the users applications. Now, when the record is changed (via the navigation buttons) I want the combobox to requery, but I don't know where the query should go. I tried putting the requery under the primary key's afterupdate method, but no go.

Can anyone think of a solution? Do you understand my problem?

Thanks in advance.

View 3 Replies View Related

Forms :: Linking Combobox With The Subform

Jan 30, 2015

I have a form with a combo/dropdown on the MAIN form and a child subform.I have designated a Master /Child link of ID to FGId respectively linking the combobox with the subform.

However, when a select an item from the combobox I expect to see the subform datasheet refresh accordingly. This is not happenining , even when I force a refresh call on the subform control itself....?

View 1 Replies View Related

Forms :: Update Row-source Of Combobox Based On Value Selected On Another ComboBox?

Apr 26, 2015

I am trying to use a combobox called Manufacturer to select which table the combobox called Model gets it's rowsource from using the code below.

Code:

Private Sub Manufacturer_AfterUpdate()
If (Me.Manufacturer.Value = "Siemens") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SeimensTable"
Me.Model.RowSource = "SELECT Model FROM SeimensTable"
Else
If (Me.Manufacturer.Value = "Samsung") Then
Me.Model.RowSourceType = "Table/Query"
Me.Model.Recordset = "SamsungTable"
Me.Model.RowSource = "SELECT Model FROM SamsungTable"
End If
End If
End Sub

But when I run the form and select Manufacturer. Combobox Model remains empty. tell me what I'm doing wrong?

View 5 Replies View Related

Saving Contents Of Combobox As String, And Inputing In Another Combobox

Jan 13, 2005

How would I modify multiple comboboxes in subforms at the same time. For example.. In main form ComboboxA user selects 1992, Combobox1 in subform1 is also changed to 1992, as well as Combobox2 in subform 2.

Whats the best way to do this?

View 2 Replies View Related

How Can I Filter One Combobox Based On Another Combobox Selection?

Apr 22, 2005

I have 2 comboboxes, the first one is called "activity", whereby I have 3 options to choose from, and the second is called "level".

When I click an "activity", for example Drawings, I want the "level" combobox to list a unique set of options for that category. and if I click on a different "activity" for example Planning, I want the "level" combobox to show a completely different set of options.

If anyone can give me any help on how to do this then I would be very grateful!!

Thanks

Angela :eek:

View 2 Replies View Related

Combobox Based On Previous Combobox

Jan 25, 2006

I've tried searching the forums and haven't found quite what i'm looking for. I would like to be able to change the source for a combobox based on another combobox. The simplest way i can summarize that is i want to be able to choose A or B, depending on my choice i want another combobox to display all the values that A or B can have.

Thanks

Jim

I'm not sure I worded that very well. :(

View 1 Replies View Related

Combobox Depends On Input Of Other Combobox

Feb 25, 2008

Hey all,

I've read some tutorials on this sort of thing, but I can't seem to piece it all together to achieve what I want.

I have a table Products that contains the fields Product, Size and Brand. I also have a form, frmProducts, that has a combobox linked to each of the fields in the Products table. I want to be able to select a product from the first combobox, tab to the Brand combobox and have only those brands associated with the product already selected.

This is how I think it should work:
1.ComboBox1 selects productA
2.ComboBox2 takes its options from a query that searches Products table for all instances of productA and displays all available brands. brandA is selected.
3.ComboBox3 get its options from another query that searches for all instances of productA that also have brandA and displays all available sizes.

What I'm having trouble with in particular is passing the data between queries. For example, I can't figure out how to tell the query to search for all instances of productA when its defined by the first combobox. Do I have to store it as a variable somewhere?

I hope I've been clear.

View 6 Replies View Related

Linking One To Many

Feb 6, 2005

i am new to databases and have developed a ads site

when the user registers they can post ads for free.

i would like to allow one user to post more than one add.

these are my databases

[members]
memberid = autonumber (primary key)
username unique
password
surname
firstname
address
post code
country

[ads]
adid autonumber (primary key)
adtitle
price
picture
contact
date posted
end date

i am guessing i will have to create a one to many database but i am lost at how to do it.

any advice would be appreciated.

View 1 Replies View Related

Linking Help!

Jul 17, 2007

hello,
I've got a back-end/front-end Access database. The front end sits on a user's desktop. There's one table she needs to update, but cannot because it's not linked. It's table called Login that contains passwords/users names. The table did not exist in the front-end. I would like to copy it from the back-end to the front-end and link it, but when I try to do that, I don't see it in the list of tables. I do this rarely. How does this work exactly?

thanks-

View 2 Replies View Related

Linking To A SS

Dec 13, 2007

Is there anyway to link an excel spreadsheet to an existing database table - so that entries into either update each
other?

View 1 Replies View Related

Linking Tables In Two DB's

May 19, 2005

Question for someone..... I was looking at the "LinkTables" in Access..... I see that I can link one database to another..... When I do this I can add the table to my relationship window... I have not played with this too much.. But looks interesting. Now, all the info I might add to this linked table is stored in the other database??? If this linked table is also linked to other tables in the other DB can I use those in queries? Not much covered (that I can find) in the Access help files on this sort of thing.
Thanks

View 3 Replies View Related

Linking To Database

Jun 27, 2005

I have a field on my Form. The form holds all the information about Artists under our record label. I need to be able to attach a copy of each artists contract to their separate form. I just found out that you can't physically attach this. Does anyone have any ideas and how I could play this. Any ideas would be well appreciated.

Thanks
Shane

View 2 Replies View Related

Linking To Another Database

Dec 1, 2005

I use a packaged software program at the dealership I work at. In the past I have been able to pull queries and information out of the database and into Excel. The query builder pulls the data as read-only and thus no fear of changing the main database. I have developed an access database for doing commissions. I want to be able to link my database with the companies database as read-only. This would save typing a lot of the duplicate information (ie customer name, date etc.). I have been able to successfully link the 2 databases but realized quickly that anything I change in msaccess will change on the main database. I don't want to corrupt the main database and really only want to pull the information for viewing. Any comments or help would be greatly appreciated.
Thanks
Rob

View 6 Replies View Related

Linking Databases

Dec 15, 2005

I have a Form that refers to two Reports, both of which refer to two query's one for each. the whole lot(1 Form, 2 Reports, 2 Querys) is in one mdb file and the actual database is another mdb file. How do I get my objects to get their data from the main Data Base File? the 5 objects are acting as a small report making application.

View 5 Replies View Related

Linking Databases

Jan 11, 2006

:confused: Does anyone know if there is any way to link to seperate databases so that any information entered in one will update the same information in the other and visevirsa?

Thanks

View 3 Replies View Related

Linking To Excel...?

Jan 15, 2006

I want to use the data contained in Access table in an Excell app. What is the best way to link them - preferably in 'real time' - is there a way excell can read directly from the tables? We need to analyse some of the data in the database through Excell....

Any suggestions welcomed...?

View 8 Replies View Related

Linking Tables

Jun 26, 2006

I am looking to lonk tables in a database.

I have one table a pc tables which has a list of pc's

the other table is a pc software table which has a list of software

i want to build a form to show the pc's and their software how do i do this

View 5 Replies View Related

Linking Information

Feb 8, 2007

I am having a hard time linking some certain information. I think I have my relationships formatted correctly but not all the information is connecting.

For example: I have a form where I am creating a sales quote. In the form I have a combo box where I select my product ID. When I select the product ID, the product name automatically populates but the price does not.

I have attached a screenshot of my relationships. Can someone please look it over and see if anything stands out to you as being incorrectly formatted? Or offer any advise in getting my price to connect to the product ID I enter?

View 14 Replies View Related

Combo Box Linking

Mar 14, 2007

Is it possible to link two combo boxes together e.g. i have combo box 1 with a list of products and combo box 2 with a list of each of the products corresponding product codes. basically if a select a product e.g. football from combo box 1 i want the footballs product code e.g. 001 to be displayed in combo box 2. i hope that makes sense, can any one help, thanks.

View 2 Replies View Related

Help With Linking Tables...please!

Jun 29, 2007

I have a table with job info like: job #, job name, job addy.
I would like my end query to look like this: job #, job name, job notes.
I want the query to list all jobs, job names, and job notes for a particular week(we have a weekly meeting on the status of our jobs), so if I were to query the jobs for 6/26, i would get: job #, job name, and job notes for that date as fields in my query.
I am not sure how to accomplish this. Should I make a seperate table that contains job notes? If so, how would I accomplish this and create a relationship between the job info table and the job notes table?

Thanks in advance!

View 4 Replies View Related

Linking Forms

Nov 21, 2007

Please please please help me!!

Firstly to set the scene i am trying to create a training DB.

I have a form with one textbox in it which is for the course title. I then have a continuous subform with all the peoples details in it and whether they are trained or not.

There are nearly 40 courses and 33 people.

The problem i have got is that i want the list of people to stay constant in each course but this the gives the problem of the 'Course Completed' checkbox. BECAUSE if i link the subform to the mainform and a new person starts you have to go through every course and add them and if i dont link the forms the 'Course Completed' checkbox stays the same!

Is there anyway to have it so that the list of people in the subform stays constant even when one is added to the table but the checkbox gets updated?

I have tried this many different ways like adding the checkbox as a subform etc etc but with no luck!

If you can think of a better way i am VERY open to ideas - Thanks in advance!!

View 2 Replies View Related

Help With Relationships And Linking

Dec 27, 2007

I've got an issue I can't seem to get around. I've got a linked table from an ODBC (tbl_1). I then have a make-table query (qry_1) that takes the fields, formats them, and creates a static table (tbl_2). I then have a one-to-many relationship between tbl_2 and another table (tbl_3). When I try to run the make-table query which overrides tbl_2, I get the following error: "You can't delete the table tbl_2; it is participating in one or more relationships". How do I get around this? Any help is much appreciated, thanks.
ps. The main goal is to link a form to the two tables (tbl_2 & tbl_3) for updating purposes.

View 6 Replies View Related

Linking To .CSV File

Feb 21, 2008

I am linking to a csv file with the following

Me!JobHolder = mID
DoCmd.DeleteObject acTable, "TempTPSCSV"
On Error GoTo Err_Handler
DoCmd.TransferText acLinkDelim, , "TempTPSCSV", Me!FileSelected, True

Which works fine - except that I intermitently get error 3501 - ie file is already open or user needs permissions. Neither or which seems to be true - as on subsequent tries it eventually works OK.

THis seems to happen when file has circe 50k records , not when it has 100 records.

Any ideas whats causing this - and how to get round it.

Ta

View 5 Replies View Related

Linking Tables

May 16, 2005

:confused: How can I link a table to one specific item in another table in order to avoid repeating information? (ex: school name that would be narrowed down to its different departments)

View 3 Replies View Related

Table Linking

May 19, 2005

Ok...I have an issue that I don't know how to resolve.
I have a table called 'orders' in the orders table there is a place for " quantity', 'colours' and per unit. The cost per unit is based on quantity and colours.
For example: 12-35 shirts 1 colour are $2.85 per unit. 12-35 2 colour are $3.50 and so on.
I would like to be able to put in the quantity and # of colours and the Unit price fills in a field.
I don't know how I can accomplish this.

View 2 Replies View Related