|
|
|
|
|
|
Welcome to the Australian Ford Forums forum. You are currently viewing our boards as a guest which gives you limited access to view most discussions and inserts advertising. By joining our free community you will have access to post topics, communicate privately with other members, respond to polls, upload content and access many other special features without post based advertising banners. Registration is simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. Please Note: All new registrations go through a manual approval queue to keep spammers out. This is checked twice each day so there will be a delay before your registration is activated. |
|
|||||||
| The Bar For non Automotive Related Chat |
 |
|
|
Thread Tools | Display Modes |
08-04-2005, 11:27 AM
|
#1 | ||
|
not here much anymore
Join Date: Dec 2004
Location: Sthn NSW
Posts: 22,918
|
Hoping someone here is better at these than i am. Im currently trying to setup a database to help us find out where our business is coming from (i.e. what advertising is working best). So, i have columns set up for each place where we advertise.
I need to enter a rule that makes sure only one can be ticked for each client (i.e. you cant say that they found us from both Phone Book and TV), but i cant work out what that rule is. The example in the Help section is that >9 = Must be 10 or more. Basically, i need to enter it so that once on box is ticked, you cannot tick another. Anyone got any idea what the formula for that is?! Kinda need this ASAP.
__________________
2024 F150 XLT
|
||
|
|
|
08-04-2005, 11:35 AM
|
#2 | ||
|
hibernating
Join Date: Dec 2004
Posts: 2,135
|
how i would do it is just use one column instead of so many different columns. and set it up as a combo box (drop down list thing) that way you can only select one from the list.
|
||
|
|
|
|
08-04-2005, 12:14 PM
|
#3 | ||
|
Last warning
Join Date: Dec 2004
Location: Mornington Peninsula, Victoria HeadCount: 3
Posts: 11,194
|
can't u make it a radio button, don't they automatically do what u want aslong as they're grouped together?
__________________
FALCN6 - Turbo, Air Bag Suspension - Hibernating EL GT - Supercharged NASCAR - 83 Thunderbird , Bagged DAILY - BA Fairlane Ghia, Boss 260 Turbo OFFROADER - Ford Explorer 
|
||
|
|
|
|
08-04-2005, 12:39 PM
|
#4 | ||
|
Banned
 
Join Date: Dec 2004
Posts: 8,303
|
My memory is fuzzy on this but like John said, I think radio buttons would be the way to go. I think it might be in the Marcro section (like how you start with a window for Tables, Queries, Macros, etc)
Check out VisualBasic stuff in the Help section, and steal some of the example code. That's what I did :reverend: Also a floating toolbar came up which gave you options for text boxes, buttons, etc. Hope that made sense, rather than just being a post+1 for me -Dave- |
||
|
|
|
Microsoft Access Formulas
Linear Mode
