SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
as i havnt really used access that much i need yous guys help on this one.
when you have a drop down options box in one of the cells of a spreadsheet thingy.. i can only enter 4 options onto this dropdown box..
but i want to enter a lot of options into this dropdown box
you get me ?
|
AJP
Member
Registered: 8th Sep 02
Location: Third roof tile on the left
User status: Offline
|
 great description dude
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
are you designing the form?
|
AJP
Member
Registered: 8th Sep 02
Location: Third roof tile on the left
User status: Offline
|
oh and if you want you can call me and i will try and work out what you are on about 
work number in u2u
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
sorry 
well you know you can have different things in the cells.. and one of them is a dropdown box yeah...
well i can only enter 4 thingys into this options list.. so only 4 are being shown on the list, where i actually need around 10 options
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
well have you created the table?
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
ALEX GET OFF THE BLOODY PHONE 
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
nope its a user that has called it through mate.. i dont actually have any access tables created and i dont wanna fart around making one just to see how to do this...
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
the data has to be in the tables for the list of options to be created
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
user has got the table up infront of him with 8 options written in the lookup table
then when he goes to the main sheet he can only see 4 of the 8 options on the dropdown box..
if that makes sence
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
isn't the wizard going through it with him?
|
ed
Member
Registered: 10th Sep 03
User status: Offline
|
I'm so glad that the National Curriculem for A level Computer Science only required me to be able to program Q BASIC... I would have probably been able to help you if we learned something worthwhile
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
quote:
Originally posted by almost_me
isn't the wizard going through it with him?
i think he has already created it and is comming back to ajust it
|
Dan Lewis
Member
Registered: 31st Jan 05
Location: Leicestershire
User status: Offline
|
the wizard should show all the data in it and the user selects which data they want to be displayed. so cant he just delete it and try the wizard again? or just create a new drop down menu??
|
SteveW
Member
Registered: 15th Jul 02
Location: Up in the clouds
User status: Offline
|
its sorted now.. i just asked him to save the table and everything then shut it and re open it.. tis fine now..
silly wanker
|
