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?
7 1938
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
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
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
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.
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.
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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: 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...
| |