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

multi item combo boxes or list box

I am new to Access having used Filemaker for many years. My question
has to do with displaying and creating a line item database. What I
have is a two tables. One has Name, Location, time, disposition and
Offense. The second has Offenses and Description of Offenses. I want to
display, on a form, all the fields in table one with the Offense field,
a drop down, combo box or list box, able to display more than one item.
For example, if the user chooses in the drop down box 59FC, then 59FA,
then 59NS. These would show on the form all the choices, preferably
under each other. I am thinking a third table, a line item table, may
need to be created to store the data for report purposes. But I will
figure that out. Anyway, any suggestions?
vincent

Sample of what I am looking for:

Name Location Time Dispositon Offense
john 123 anywhere 10:00 Weeds 59FB
59FC
59FA

Nov 13 '05 #1
8 3014
vp*****@las-cruces.org wrote:
I am new to Access having used Filemaker for many years. My question
has to do with displaying and creating a line item database. What I
have is a two tables. One has Name, Location, time, disposition and
Offense. The second has Offenses and Description of Offenses. I want to
display, on a form, all the fields in table one with the Offense field,
a drop down, combo box or list box, able to display more than one item.
For example, if the user chooses in the drop down box 59FC, then 59FA,
then 59NS. These would show on the form all the choices, preferably
under each other. I am thinking a third table, a line item table, may
need to be created to store the data for report purposes. But I will
figure that out. Anyway, any suggestions?
vincent

Sample of what I am looking for:

Name Location Time Dispositon Offense
john 123 anywhere 10:00 Weeds 59FB
59FC
59FA


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I believe your DB design needs to be changed (Normalized) to something
like this:

Defendants:
DefendantID -- An AutoNumber column
Name
... other columns that ID the defendant ...

I'm not sure about the following table, since you used such vague column
names.

Crimes: (or some other more specific/legal name)
DefendantID -- a link to Defendants table
Location -- Where the crime was committed ?
CrimeTime -- DateTime when the crime was committed ?
Disposition -- Where the defendant is placed ?
What do you mean by Disposition?

OffenseTypes (your second table):
OffenseCode -- the 59FA, 59FC, etc. codes
OffenseDescription -- the verbiage for each code

Charges:
DefendantID - a link to the DefendantID in Defendants
OffenseID - a link to the table OffenseTypes

Then you'd have a main form for the Defendant; a subform for the Crimes;
a subform in the Crimes subform for the Charges. The OffenseID in the
Charges subform would be a ComboBox. All the subform's would link back
up the subform chain to the main form by the DefendantID.

Read the Access Help articles on subforms for more info.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnfHpYechKqOuFEgEQI0SACgyPpuyUIbXNKNGWmFUpamBP cIGp0AoL5W
2i6lIRu1s4iY+xBBkh2L1w46
=iU4A
-----END PGP SIGNATURE-----
Nov 13 '05 #2
Thanks for your insight. However, what we use is much simpler. What we
need is a simple flat file to log incidents. Everything else is done
except for the combo box that allows for multiple offense codes to be
displayed for one incident. How would I do that? Would I use a list
box? What would the relationship look like? BTW, is there something
like a portal that can be put on a form to display date from another
related file? Thanks again.
vincent

Nov 13 '05 #3
vp*****@las-cruces.org wrote:
Thanks for your insight. However, what we use is much simpler. What we
need is a simple flat file to log incidents. Everything else is done
except for the combo box that allows for multiple offense codes to be
displayed for one incident. How would I do that? Would I use a list
box? What would the relationship look like? BTW, is there something
like a portal that can be put on a form to display date from another
related file? Thanks again.
vincent


So you need "Many" offense codes for each "One" incident? Sounds like a
One-To-Many relationship doesn't it? That requires two tables if you want
to do it right. Otherwise just use Excel.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #4
Yes, yes! I have created the two tables, Log and Offenses, with a
relationship between two fields, i'll call them "callnumber", this is a
number field, to link them together. I have imported the data needed
into the second table, which has three fields, offenses, offense
description and callnumber. How do I show in the form the fields
"offenses" and "offense description". This needs to be a drop down for
"offenses" to ease data entry. Thanks.

Nov 13 '05 #5
vp*****@las-cruces.org wrote:
Thanks for your insight. However, what we use is much simpler. What we
need is a simple flat file to log incidents.


Hi Vincent,

No offense meant, but you mentioned you have used Filemaker for years,
which, I assume, allows relational database principles to be followed.
As MGFoster or Rick mentions, the description of your requirements
dictates a multi-table normalized approach. If you don't want to do
this (and multi-table design of a database is kind of difficult if
you're not used to it) and would prefer a flat file, your job would be
made much, much easier by simply using Excel, I think. 8)
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Nov 13 '05 #6
Thanks. I wasn't offended. I am trying to adjust my thinking to Access
from Filemaker and my description was a little blurred. I am used to
the multi-table approach. What I could do all day in Filemaker is
becoming a chore in Access. But that's another Google Group. Anyway, is
there a book or website that I can look at samples in order to get a
clear understanding as how Access works. Thanks

Nov 13 '05 #7

<vp*****@las-cruces.org> wrote
is there a book or website that I can
look at samples in order to get a
clear understanding as how Access
works. Thanks


A very good example, Northwind.MDB, comes packaged with Access and will have
been installed in the folder hierarchy where you installed Office, unless
you opted for a custom install and omitted it. There is a very useful Orders
and Solutions sample database, temporarily housed at
http://www.mvps.org/access/downloads/bapp2000.exe. Many of the samples in
that database refer to Northwind.

If you are using Access 2003, follow the link in Help to Office Online |
Training, and follow the links there to specific topics. You'll find a
number of useful, thankfully brief online training courses. If you are not
using Access 2003, most of the material will still apply, and you can go
directly to http://office.microsoft.com/en-us/training/default.aspx.

Larry Linson
Microsoft Access MVP

P.S. Here's the body of a post from late last year in the
microsoft.public.access.gettingstarted newsgroup, by Jeff Conrad, a
self-confessed Access Junkie, who did us all a great favor by collecting and
posting these links:

Here's one or two links, grouped by category, to help in your Access qwest.
Please watch out for any
possible line wrapping on these links. You should definitely find one or two
things in here to help
you. <g>

Number One on your start list:

http://www.mvps.org/access/
(A definite must!)

Microsoft Knowledge Base for searching:
http://support.microsoft.com/?scid=fh;[ln];kbhowto
Getting Started:

http://www.mvps.org/access/tencommandments.htm

ACC: Database Normalization Basics
http://support.microsoft.com/?id=100139
http://support.microsoft.com/?id=209534
http://support.microsoft.com/?id=283878

Glossary of database terms:
http://www.dhdursoassociates.com/dat...lossary-3.html

Where to find information about designing a database in Microsoft Access:
http://support.microsoft.com/?id=289533

"Understanding Relational Database Design" Document Available in Download
Center:
http://support.microsoft.com/?id=283698
http://support.microsoft.com/?id=164172

ACC2000: "Understanding Relational Database Design"
http://support.microsoft.com/?id=234208

Naming Conventions:
http://www.xoc.net/standards/rvbanc.asp

http://www.eade.com/AccessSIG/downloads.htm
(See the last download titled "Understanding Normalization")

http://www.oreilly.com/catalog/acces...pter/ch04.html

http://www.datatexcg.com/Downloads/D...gnTips1997.pdf

Database Normalization Tips by Luke Chung
http://www.fmsinc.com/tpapers/genacc...abasenorm.html

Support WebCast: Database Normalization Basics
http://support.microsoft.com/default...lurb060600.asp

5 Rules of Database Normalization:
http://www.datamodel.org/NormalizationRules.html
Access Data "Clean-up" Tips:
http://pubs.logicalexpressions.com/P...cle.asp?ID=182
Interface Design topics:
http://www.isii.com/ui_design.html
Tutorial Style:

http://www.microsoft.com/Accessdev/a...bapp97/toc.htm

Microsoft Access 2000: Building Applications with Forms and Reports
http://tinyurl.com/2szmm

http://www.dur.ac.uk/its/training/se...&campus=durham
(Sample practice file for download as well)

http://www.geekgirls.com/databasics_01.htm

http://mis.bus.sfu.ca/tutorials/MSAccess/tutorials.html

http://www.microsoft.com/office/prev...s/column06.asp

http://www.functionx.com/access/

http://www.bcschools.net/staff/AccessHelp.htm#Top

http://www.fontstuff.com/access/index.htm

http://www.fgcu.edu/support/office2000/access/

http://www.oit.duke.edu/ats/training/docs/access1/

http://cisnet.baruch.cuny.edu/holowc...html#sec_intro

http://ddmara.tripod.com/access/index.html

https://secure.vtc.com/cd/access2003.htm

http://www.simply-access.com/Start_m...tutorials.html

http://www.rogersaccesslibrary.com/Tutorials.html

Tutorial: Analyzing Data Using Access
http://www.microsoft.com/education/AccessTutorial.aspx

Sample Database Models/Table Designs:

http://www.databaseanswers.com/data_models/index.htm
Download Samples:

http://rogersaccesslibrary.com/TableOfContents3.asp

http://www.invisibleinc.com/divFiles.cfm?divDivID=4

http://www.candace-tripp.com/access_downloads.htm

http://www.datastrat.com/DataStrat2.html

http://members.shaw.ca/glenk/index.html

Fred Boer's fully functioning library application.
Lots of different topics for study included:
http://www3.sympatico.ca/lornarourke/fred.zip
The mighty Sensei Leban's site for all things magical:
(Please bow in reverence on your way in.)

http://www.lebans.com/
Advanced Topics:

http://www.trigeminal.com/utility.asp

http://www.mentalis.org/index2.shtml
Misc: Downloads/Samples/Helpful Articles

http://www.granite.ab.ca/accsmstr.htm

http://allenbrowne.com/tips.html

http://www.viescas.com

http://www.daiglenet.com/msaccess.htm

http://www.users.bigpond.com/papwalker/

http://www.applecore99.com/index.asp

http://www.helenfeddema.com/access.htm

http://www.dbases.net/knowledge_base/

http://ourworld.compuserve.com/homepages/attac-cg/

http://www.aadconsulting.com/index.html

http://accdevel.tripod.com/

http://ffdba.com/downloads.htm

http://www.attcanada.net/~kallal.msn.../msaccess.html

http://www.mvps.org/btmtz/

http://www.jstreettech.com/Downloads.asp

http://www.liquorman.net/Tips.html
Helpful Articles/Code Samples:

http://www.pacificdb.com.au/MVP/MVPCode.htm

http://members.rogers.com/douglas.j....cessIndex.html

http://www.winsoft.sk/daofaq.htm

http://www.calvinsmithsoftware.com/HardToFindTips.htm

http://www.mvps.org/vbnet/

http://www.master-office.com/developers.htm

http://www.trevor.easynet.co.uk/AccFAQ/

http://www.theofficeexperts.com/access.htm

http://www.access.qbuilt.com/

http://www.microsoft-accesssolutions.co.uk/

http://www.blueclaw-db.com/ms_access_examples/index.htm

http://www.jamiessoftware.tk/

http://www.pdtech.co.uk/prod01.htm

http://easyweb.easynet.co.uk/~trevor/AccFAQ/
(A little dated, but still some helpful things)

http://www.vbexplorer.com/VBExplorer/VBExplorer.asp
Run Command Constants:

http://www.tkwickenden.clara.net/
A massive list of other Access links:

http://www.geocities.com/waddly/accory.html

http://dmoz.org/Computers/Software/Databases/MS_Access/

http://www.directory-base.com/access/
Add-Ins/Utilities:

My personal favorite on Doug Steele's site:
http://members.rogers.com/douglas.j....ocumentor.html
;-)

http://mphillipson.users.btopenworld.com/

http://www.fmsinc.com/

http://www.moshannon.com/

http://www.rickworld.com

http://www3.bc.sympatico.ca/starthere/findandreplace

http://www.peterssoftware.com/index.htm

http://www.dbi-tech.com/default.asp

http://www.zada.com.au/accessaddins.htm

http://www.mztools.com

http://www.logico-solutions.com/

http://accesstools.narod.ru/

http://www.directory-base.com/access...itle=Add%20Ins

http://www.skrol29.com/index.php?lang=us
Live Access chats every Tuesday and Thursday:
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Access User-Level Security:

Security FAQ (the Security Bible):
http://support.microsoft.com/?kbid=207793

Jack Macdonald's Security Document:
http://www.geocities.com/jacksonmacd...ssSecurity.pdf

Lynn Trapp's Ten Security Steps:
http://www.ltcomputerdesigns.com/Security.htm

Joan Wild's Tips:
http://www.jmwild.com/security02.htm
Creating menu bars and tool bars:

http://www.microsoft.com/Accessdev/a...ers/ba01_6.htm
Additional Access Forums:

http://www.accessvba.com/

http://www.utteraccess.com

http://www.access-programmers.co.uk/forums/
Book Recommendations:

http://www.developershandbook.com/
(A VERY good book to have)

http://www.viescas.com/Info/books.htm

http://www.fmsinc.com/toplevel/books.htm
Some of the MVP web sites:

http://www.mvps.org/links.html
Database Recovery:

http://www.pksolutions.com/

http://www.atroplan.com/
Search Google archives on Access newsgroup posts:

http://tinyurl.com/ctj2
That should keep you busy for a while! ;-)

Nov 13 '05 #8
Thanks a bunch. Didn't know there was so much help out there. Thanks
again!

Nov 13 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Greg Bryant | last post by:
Hi folks. I'm porting a cf site to php, everything's going very well, I like php much better (this, of course, being the correct forum to make that statement :). One problem I have is with...
9
by: Frances | last post by:
Hi All, * PREMISE * I'm creating an Access form with 150 items subdivided into 20 categories. Multiple categories (and items) can be selected so my user wants checkboxes. All of the options...
3
by: mal | last post by:
Sorry for repost - system added to another subject for some reason Have tried numerous ideas from the group to solve this one. It is such a simple example that it should be straightforward ! I...
6
by: CindyH | last post by:
Hi Does anyone know how to create a multi column combo box from the same table? Thanks, Cindy
2
by: Dave | last post by:
I have 3 tables of information feeding into 4 combo boxes on my main form (DR Form). I have as many list boxes (acting as text boxes) as there are fields in each one of the 3 tables. Once...
1
by: freetime | last post by:
Greetings, This is my first post so I will try to be brief and accurate. I have a report that uses 9 user selectable filters (Dates, Y/N's as Combo Boxes and 4 Multi-Select List Boxes. ...
12
by: micarl | last post by:
How would i print a report based on criteria selected from several Combo Boxes as well as multiple Multi Select List Boxes, that are located on the same form? I can get one Multi List Box, just...
1
by: woodey2002 | last post by:
Hi Everyone and many thanks for your time.. I am trying to begin access and a bit of VBA i am enjoying it but I have a annoying problem I just canít get any where on. My databse mostly includes...
4
by: sree078 | last post by:
I've a list of items which I bound to multiple combo boxes. In the due course in the code...I had to add an item into one combo box...but I don't want it to be reflected into any other combo...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.