UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Whats The Best Ui Form To List 10 Txtbox Fields + 5 Checkbox, Any Version    
 
   
AlvinGenius
post Aug 10 2019, 07:54 AM
Post#1



Posts: 14
Joined: 6-July 16



Hello UA,

I'm creating an event app

and i've to list all users data in continuous form in tabular mode in form and every user have 10 fields and 5 check boxes to be filled

My Question is : what's the best way to insert them all in to fit laptop screen

need ideas !! iconfused.gif

example of user data attached in db
Attached File(s)
Attached File  tabular.zip ( 17.73K )Number of downloads: 18
 
Go to the top of the page
 
theDBguy
post Aug 10 2019, 08:26 AM
Post#2


Access Wiki and Forums Moderator
Posts: 76,294
Joined: 19-June 07
From: SunnySandyEggo


Hi. Having field names like check1, check2, check3, etc. is typically a sign of a non-normalized table structure. What are they supposed to represent?

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
Jeff B.
post Aug 10 2019, 09:16 AM
Post#3


UtterAccess VIP
Posts: 10,275
Joined: 30-April 10
From: Pacific NorthWet


You are describing 'how' (continuous form, 10 textboxes, 5 checkboxes).

If you'll describe 'what', folks here may be able to offer more suggestions.

--------------------
Regards

Jeff Boyce
Microsoft Access MVP (2002-2015)

Mention of hardware or software is, in no way, an endorsement thereof. The FTC of the USA made this disclaimer necessary/possible.
Go to the top of the page
 
AlvinGenius
post Aug 10 2019, 01:47 PM
Post#4



Posts: 14
Joined: 6-July 16



@theDBguy
check boxes can represent alot of info required

i'm creating a project for our company's yearly conference

in my case text fields represent :

Order ( textbox)
Gender ( Combobox )
Prefix ( Combobox )
Name ( textbox)
Job title ( textbox)
Country ( Combobox )
Institution Type ( Combobox )
Institution Name ( textbox)
Type of participation ( Combobox )

check boxs represents :

VIP Guest ( Yes/No )
CEO ( Yes/No )
Guest ( Yes/No )
Press/Media ( Yes/No )
Registered ( Yes/No )

All this info must be filled in 1 form as it's basic for every participate and it must be in continues form

and there's more 4-5 forms with another information to be filled like arrival, departure, hotel, visa stats, speech, session assigned .

@Jeff B.
i'm asking for the best way to distribute this fields, and need suggestions on that .

Go to the top of the page
 
theDBguy
post Aug 10 2019, 02:06 PM
Post#5


Access Wiki and Forums Moderator
Posts: 76,294
Joined: 19-June 07
From: SunnySandyEggo


Hi. The only thing I could say is make sure your table structure is normalized to make your life easier down the road. If you need help normalizing your database, let us know. Here's an example table structure I might suggest for a "conference" database.

tblGuests
GuestID, pk
CompanyID, fk
JobTitleID, fk
GuestCategoryID, fk
FName
LName
etc...

tblCompanies
CompanyID, pk
CompanyName
etc...

tblJobTitles
JobTitleID, pk
JobTitle

tblGuestCategories
GuestCategoryID, pk
GuestCategory (VIP, CEO, etc)

Hope it helps...

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Access Website | Access Blog | Email
Go to the top of the page
 
AlvinGenius
post Aug 10 2019, 02:39 PM
Post#6



Posts: 14
Joined: 6-July 16



@theDBguy
your structure is very much what i've already
my structure have 16 tables already pullhair.gif

tblGuestCategories
GuestCategoryID, pk
GuestCategory (VIP, CEO, etc)

regarding this
there's no guest category

guest maybe VIP and CEO in the same time
guest maybe guest and registered
for that i'm putting em as checkboxes

i'm attaching my design the upper side is filters
Attached File  design.PNG ( 51.12K )Number of downloads: 23


as you can see that's navigation form with 9 tabs

First tab for basic information for participate ( sorry it's in arabic ) but you can get it easily

and as u can see the form is wide, and i designed it in my 27' screen , and this app should run on laptop!!

that's why i'm asking for the best distribution for this fields

Go to the top of the page
 
GroverParkGeorge
post Aug 10 2019, 06:04 PM
Post#7


UA Admin
Posts: 35,661
Joined: 20-June 02
From: Newcastle, WA


"...guest maybe VIP and CEO in the same time ..." Your term for these is "GuestCategories". I normally think of these as "roles" because each person can fill different roles at different times. It amounts to the same thing, though.

That relationship calls for a Junction Table. It is NOT a single field in the Guest table, and it is not a series of Yes/No fields with checkboxes in the guest table.

The Junction table has at least two fields, both of which are Foreign Keys.

tblGuestGuestCategory
--------------------------
GuestID
GuestCategoryID

Together, these two fields are the Primary Key for this table, what is usually called a Composite Primary Key.

For each Guest there will be one or more records in tblGuestGuestCategory. For each of those records, there will be a valuein GuestCategoryID pointing to the GuestCategory which that Guest is in.

Data entry into that table is usually done through a subform bound to it.

You can see an example of this here. It has different subject matter. It does have the same kind of relationship, though. And the forms used in that example db are the way you will need to set up the form and subform design in your database. You won't use the "checkbox" design, or perhaps I should say that you shouldn't. It's not appropriate to the way the data should be stored. It is quick and easy, but that's generally not such a good long-term solution.

--------------------
My Real Name Is George. Grover Park Consulting is where I do business.
How to Ask a Good Question
Beginning SQL Server
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    16th September 2019 - 11:19 AM