By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,594 Members | 2,059 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,594 IT Pros & Developers. It's quick & easy.

Database Problems

P: 13
I am building a form that has information that fills in from an access database.

I want to be able to use the same database to fill in several identical fields. For example: I have to select 4 people and all their info and put it into the form. I do this by selecting their last name from 4 separate combo boxes. But how do i separate the info to prevent person ones info from going into person 2's info fields...

I would like to use the same database so i can update and still maintain a master

Any suggestions??

Thanks,
Greg
Nov 28 '06 #1
Share this Question
Share on Google+
4 Replies


Dököll
Expert 100+
P: 2,364
I am building a form that has information that fills in from an access database.

I want to be able to use the same database to fill in several identical fields. For example: I have to select 4 people and all their info and put it into the form. I do this by selecting their last name from 4 separate combo boxes. But how do i separate the info to prevent person ones info from going into person 2's info fields...

I would like to use the same database so i can update and still maintain a master

Any suggestions??

Thanks,
Greg
Hey Greg! Can you give a little more? It sounds like you know what you are doing already. Are you getting info from different tables? If you are already building an existing access database, you can write a query that feeds into the form (i.e. data from table, to query, to form). Get in your table, add an ID for each user, make the ID field the primary key. Grab unique instances of each user from a query, feed into your form. Make the ID field, on your form, in your "Group Header", get all data fields in there. Good luck by the way, a form through access can be a pain.

Dököll
Nov 29 '06 #2

Expert 5K+
P: 8,434
Which VB are we dealing with here, though?
Nov 29 '06 #3

P: 13
Which VB are we dealing with here, though?
I am using VB 2005 Express

Thanks
Nov 29 '06 #4

P: 13
Hey Greg! Can you give a little more? It sounds like you know what you are doing already. Are you getting info from different tables? If you are already building an existing access database, you can write a query that feeds into the form (i.e. data from table, to query, to form). Get in your table, add an ID for each user, make the ID field the primary key. Grab unique instances of each user from a query, feed into your form. Make the ID field, on your form, in your "Group Header", get all data fields in there. Good luck by the way, a form through access can be a pain.

Dököll
What I am trying to do is to is make a program that i can put passenger info into for a buisness. (just a fun project, not serious). SO i want to be able to select their name from a combo box and have their info appear. Also I would like to be able to add passengers.

I have made an access database with the appropriate fields but the problem is that when i select a name in combobox1, the info will fill into textboxes that i don't want them to.

I need to separate how a text box will receive the info from the database.

I'm very new at this but If you don't think access is the best way, I am open for suggestions.. I don't want to have separate tables for each passenger because I would like a master list. I am also unsure what type of query i should be using to separate these. Can you give me a sample code??

Thanks for you help
GREG
Nov 29 '06 #5

Post your reply

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