Table field length limit alternative
in [Tables]
|
From: Gina Whipp on 15 Mar 2010 21:15 Thank you for the reminder! I tend to forget that... -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "John... Visio MVP" <lancucki(a)stonehenge.ca> wrote in message news:e#GmyyJxKHA.2436(a)TK2MSFTNGP04.phx.gbl... Gina, it is futile having a battle of wits with an unarmed opponent. Leave stevie to his delusions. John... "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message news:OH34HvJxKHA.812(a)TK2MSFTNGP06.phx.gbl... > Steve, > > Please grow up... either assist or move along. > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "Steve" <notmyemail(a)address.com> wrote in message > news:#1#tUjJxKHA.1548(a)TK2MSFTNGP02.phx.gbl... > It's a good thing this wasn't a question about time! You might have said > the > change to Daylight Savings Time changes time by 60 seconds. > > > > "Gina Whipp" <NotInterested(a)InViruses.com> wrote in message > news:eicc3KJxKHA.5936(a)TK2MSFTNGP04.phx.gbl... >> shm135, >> >> Have a look at... >> >> http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 >> >> -- >> Gina Whipp >> 2010 Microsoft MVP (Access) >> >> "I feel I have been denied critical, need to know, information!" - >> Tremors >> II >> >> http://www.regina-whipp.com/index_files/TipList.htm >> >> "shm135" <shmoussa(a)gmail.com> wrote in message >> news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... >> Hi, >> >> I need a table which will hold a user's answers to about 27 survey >> questions. Multiple users will use the database to enter responses for >> each question. My problem is that some questions are more than 255 >> characters long and it isn't practical to use such long field names to >> hold the actual question in. Most of the questions require responses >> that are either memos, dates, numbers and yes/no fields. What would be >> the best way to design a table that can hold 27 questions and the >> multiple responses for each? I'd like the possibily to easily make >> changes to the questions, add more questions later. >> >> Any suggestion would be much appreciated >> >
From: Jerry Whittle on 16 Mar 2010 09:32 As far as the 255 character limitation, you might consider upgrading to something like SQL Server or Oracle. They can handle thousands of characters in a field. -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "shm135" wrote: > Hi, > > I need a table which will hold a user's answers to about 27 survey > questions. Multiple users will use the database to enter responses for > each question. My problem is that some questions are more than 255 > characters long and it isn't practical to use such long field names to > hold the actual question in. Most of the questions require responses > that are either memos, dates, numbers and yes/no fields. What would be > the best way to design a table that can hold 27 questions and the > multiple responses for each? I'd like the possibily to easily make > changes to the questions, add more questions later. > > Any suggestion would be much appreciated > . >
From: shm135 on 22 Mar 2010 14:10 On Mar 15, 6:56 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > shm135, > > Have a look at... > > http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "shm135" <shmou...(a)gmail.com> wrote in message > > news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... > Hi, > > I need a table which will hold a user's answers to about 27 survey > questions. Multiple users will use the database to enter responses for > each question. My problem is that some questions are more than 255 > characters long and it isn't practical to use such long field names to > hold the actual question in. Most of the questions require responses > that are either memos, dates, numbers and yes/no fields. What would be > the best way to design a table that can hold 27 questions and the > multiple responses for each? I'd like the possibily to easily make > changes to the questions, add more questions later. > > Any suggestion would be much appreciated Thank you Gina, That really helped.
From: Gina Whipp on 22 Mar 2010 15:31 shm135, You're welcome, glad it helped! -- Gina Whipp 2010 Microsoft MVP (Access) "I feel I have been denied critical, need to know, information!" - Tremors II http://www.regina-whipp.com/index_files/TipList.htm "shm135" <shmoussa(a)gmail.com> wrote in message news:43a5b166-3709-4e9a-bfe8-9e9a0d97750d(a)g19g2000yqe.googlegroups.com... On Mar 15, 6:56 pm, "Gina Whipp" <NotInteres...(a)InViruses.com> wrote: > shm135, > > Have a look at... > > http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 > > -- > Gina Whipp > 2010 Microsoft MVP (Access) > > "I feel I have been denied critical, need to know, information!" - Tremors > II > > http://www.regina-whipp.com/index_files/TipList.htm > > "shm135" <shmou...(a)gmail.com> wrote in message > > news:8807ea5a-9994-468b-8c5f-e73e50ef3988(a)f8g2000yqn.googlegroups.com... > Hi, > > I need a table which will hold a user's answers to about 27 survey > questions. Multiple users will use the database to enter responses for > each question. My problem is that some questions are more than 255 > characters long and it isn't practical to use such long field names to > hold the actual question in. Most of the questions require responses > that are either memos, dates, numbers and yes/no fields. What would be > the best way to design a table that can hold 27 questions and the > multiple responses for each? I'd like the possibily to easily make > changes to the questions, add more questions later. > > Any suggestion would be much appreciated Thank you Gina, That really helped.
First
|
Prev
|
Pages: 1 2 Prev: How do I include more Help options for really inexperienced users? Next: Help with database |