473,324 Members | 2,535 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

selecting data from 2 tables to a 3rd table using a form

Hi I am a newbe at this
I have created 3 tables one called computers the other software- and the third installed apps What I am trying to do via a form is to have on the one side a combo box showing the p/c names, and on the other side a combo box showing all the apps. What I am trying to do is to select a pc name from the p/c name combo and then selecting a few apps from the other combo box (installed aps) and this info is written to a table showing the p/c name and the apps associated with it.
thank you
Feb 15 '08 #1
2 1511
Delerna
1,134 Expert 1GB
Hi Lucas 45 and welcome.
Thats a big question to try and answer in a forum.
What have you tried in order to achieve it so far?
What difficulty are you having making it work?

I assume you are going to display the list of applications on the form for the selected computer and that as you select an application in the combo box it will be added to the list displayed on the form
If so then what you are trying to achieve will probably need to be done with some VBA code on your form. How familiar are you with VBA?
Feb 17 '08 #2
Hi Lucas 45 and welcome.
Thats a big question to try and answer in a forum.
What have you tried in order to achieve it so far?
What difficulty are you having making it work?

I assume you are going to display the list of applications on the form for the selected computer and that as you select an application in the combo box it will be added to the list displayed on the form
If so then what you are trying to achieve will probably need to be done with some VBA code on your form. How familiar are you with VBA?
Hi Delerna
Thank you for your reply. You are correct in that I will need to do some VBA coding. In Essence what I am trying to achieve is updating a table by using 2 other via combo boxes. I guess I have to find a way In VB to read a: the computer name from the one Combo as well as the selection made in the other combo box and write the data into a third table. I can then do a query on that table. Looks like I have to brush up my VB.
Feb 19 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Mark Hargreaves | last post by:
Please help!!! I have a problem with a query that I cannot seem to resolve!! First things first, I am using MySQL version 4.0.17, which means I cannot use subselects. Here is my problem: ...
8
by: Steve Jorgensen | last post by:
Hi folks, I'm posting this message because it's an issue I come up against relatively often, but I can't find any writings on the subject, and I haven't been able to figure out even what key...
4
by: Sami | last post by:
I hope someone will tell me how to do this without having to do any VB as I know nothing in that area. I am a rank beginner in using Access. I have created a database consisting of student...
6
by: aaj | last post by:
Hi all I use a data adapter to read numerous tables in to a dataset. The dataset holds tables which in turn holds full details of the records i.e. keys, extra colums etc.. In some cases I...
1
by: Bob Loveshade | last post by:
I am looking for an example that shows how to select and highlight multiple rows in a DataGrid. My DataGrid is part of a Web User Control which is contained in an ASPX page. I haven't been...
9
by: Brad | last post by:
I have written some code to manipulate data/records in a MASTER (order header) and DETAIL (order details) tables. What I have written is too extensive to post but essentially trying to: 1....
11
by: Ron L | last post by:
I have a data table that lists a series of items in my database. In my user form, I want the user to be able to filter by a number of criteria (e.g. location, contract, date modified, etc). Other...
48
by: phillip.s.powell | last post by:
MySQL 3.23.58 - 4.0.17 (yep, several database server instances, don't ask) I have database Spring with table Students I have database Summer with table Students I am tasked to produce a...
6
by: Wesley Peace | last post by:
I hate to cross post, but I've gotten no answer yet on a problem I'm having with visual studio 2008. I've created a series of forms with controls to access a Access database tables. The...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.