473,323 Members | 1,570 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,323 software developers and data experts.

Combo Box in Access

Hi,

I am making a library database. I have three tables (tbl_books, tbl_category, tbl_publisher). Now the tbl_category and tbl_publisher are linked to the tbl_books via combo box, so when you are entering the data of the book it will show as a drop down menu.

Then i also made a form so the person that is going to enter the data uses the form because it is more user friendly.

Now my question is, it is possible that in case that he is going to add a new publisher he types it in the form as he is filling in and it is automatically saved in the tbl_publisher table?
May 16 '10 #1
7 1938
patjones
931 Expert 512MB
Hi microbert,

What you are asking for is possible. But if I could ask you a couple questions to better answer yours...

Do you have the publishers table set up with just publisher name, or is there also something like an ID number also associated with each publisher? Is your combo box bound to the publisher table so that whatever changes you make to the table are reflected in the combo box? And, if the answer to both those questions is 'yes', when you make a selection from the combo box, are you storing the publisher ID in the book record, or the actual publisher name?

Pat
May 17 '10 #2
Hi thanks for your reply,
the answer for your questions:

Do you have the publishers table set up with just publisher name, or is there also something like an ID number also associated with each publisher?
Yes right now i have a column for ID (which is auto number) and another for publishers. but if it is a problem i can change it

Is your combo box bound to the publisher table so that whatever changes you make to the table are reflected in the combo box?
Yes, i think so

And, if the answer to both those questions is 'yes', when you make a selection from the combo box, are you storing the publisher ID in the book record, or the actual publisher name?
i don't know the answer to this i will check it out
May 18 '10 #3
patjones
931 Expert 512MB
Hi microbert,

As I always do, I'm going to use my test database to validate the advice I give you...and I'll do so as soon as work calms down a bit this afternoon.

In the meantime, I want to suggest that when you make a selection from the combo box, make it the publisher ID that you store in the book record. This avoids unnecessary duplication of names in the books table, and is accomplished by making the combo box two columns...the first is publisher ID, and the second is publisher name. Making the bound column property = 1 will ensure that the combo box value after selection will be the ID number for whatever publisher you selected.

Additionally, if you want to hide the ID column and show just the publisher names, you would set the column widths property to 0"; 2" for instance...so as to make the ID column disappear but yet still be a part of the combo box.

I'll let you know about the list editing soon.

Pat
May 18 '10 #4
Ok thanks very much for your help,

when i have the time i will try it ... but right now i need to focus more in my exams that are coming soon. then after i will put my fucus on this database.

thanks a lot.
May 18 '10 #5
NeoPa
32,556 Expert Mod 16PB
I would reinforce the point Pat made about how to use the ComboBox control. It's not a good idea even to consider doing it otherwise than this. It introduces so many potential problems.
May 21 '10 #6
Hi,

I tried to make something like you told but i was unsuccessful.

can you please send me a sample database that do what i am trying to do, it will really help me to understand exactly what i am doing?

thanks very much for your help.
May 23 '10 #7
NeoPa
32,556 Expert Mod 16PB
No.

We are not here to do your work for you. In fact it is against our rules to do so (IE. I will remove any such offering were it to be posted).

I suggest, if you want to get this working, you put in some work yourself to that effect. We can help by answering specific questions, but we are not a free resource to do it for you.

Administrator.
May 23 '10 #8

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

Similar topics

5
by: Cillies | last post by:
Hi all, I have three combo boxes on a form! what I want to be able to do is manipulate access to the last two combos, depending on the selection of the options in the first combo. I have...
1
by: Jeff Smith | last post by:
Hi This is a repost due to no responses Here's a problem I've encountered with Access 2003 which has got me to redesign how I get the row source in a second combo box using the first combo...
1
by: sara | last post by:
I am learning how to use simple functions to make my apps more powerful and efficient. On one screen, I want to populate field B: ItemDescription by looking up the ItemDescription in the Items...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
6
by: onnodb | last post by:
Hi all, While working on an Access UI to a MySQL database (which should be a reasonable, low-cost, flexible interface to the DB, better than web-based, much less costly than a full-fledged .NET...
8
by: salad | last post by:
I was wondering how you handle active/inactive elements in a combo box. Let's say you have a combo box to select an employee. Joe Blow has been selected for many record however Joe has left the...
4
Rabbit
by: Rabbit | last post by:
Cascading Combo/List Boxes This tutorial is to guide you in the creation of Cascading combo/list boxes. That is when you have multiple combo/list boxes where the selection of an option in one...
2
by: biganthony via AccessMonster.com | last post by:
Hi, I decided to install Office 2003 Service Pack 3 on my home computer to test (in full knowledge that there may be some issues with it). After installation, I have noticed that with a small...
5
by: giandeo | last post by:
Hello Experts. Could you find a solution for this problem please! I have the following tables in Access Database Table Name: origin Fields Names: country, countrycode Table Name: make...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
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...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
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
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.