If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill in a field based on input of data in another field
Hi,
I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! |
#2
|
|||
|
|||
Fill in a field based on input of data in another field
Tammy
I may be reading too much into your description ... It sounds like your user is required to type in a [PermanentCountry] value .... why? If the database already possesses a tblAwardCountries, why not use a combobox to list those and let the user select the correct one? And if it is a new, never-been-entered Country, Access HELP has plenty of information on using the LimitToList property and the NotInList event to handle adding a new one. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi, I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! |
#3
|
|||
|
|||
Fill in a field based on input of data in another field
Hi Jeff -
Thank you very much for your response. My user can use a lookup list to enter the the [PermanentCountry] (got that one covered - thanks for suggesting, though), but not all of the countries qualify for the award. She has a list of countries that *do* qualify for the award - she would like enter a value in the [PermanentCountry] field, and then check to see if that value exists in the [tblAwardCountries] table. If it does exist in the award table, she'd like a notification in another field that the country she entered qualifies for the award. We are just starting to work through this, so any ideas are helpful. All of her records will have a permanent country, but not all countries qualify for the award. The list is way too long for her to remember all of the countries that qualify. We were hoping to find a way for Access to look at the [PermanentCountry] field entry, then check to see if there is a match in the [tblAwardCountries] table - if so, update another field based on whether the country exists in the table. The field that is updated can be a text, memo, or yes/no data type (could be something like [EligibleForAward]). Again, haven't put this together yet, trying to figure out a way to do this through Access, and not VBA. I can copy and paste code, but if something goes wrong I woudn't know how to fix the code. Thanks, again, Jeff. I hope that makes it a little clearer (?). "Jeff Boyce" wrote: Tammy I may be reading too much into your description ... It sounds like your user is required to type in a [PermanentCountry] value .... why? If the database already possesses a tblAwardCountries, why not use a combobox to list those and let the user select the correct one? And if it is a new, never-been-entered Country, Access HELP has plenty of information on using the LimitToList property and the NotInList event to handle adding a new one. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi, I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! . |
#4
|
|||
|
|||
Fill in a field based on input of data in another field
Are you saying that there are two separate lists? One for "permanent", one
for "awarded"? If so, why?! A single list (table) to hold Countries, with attributes (i.e.fields) for "permanent" and "awarded" (or are those mutually exclusive categories?)... Now, if there are MORE than just those two y/n categories, you may wish to consider a list (table) of countries, then a related junction table that holds valid pairs of country X attribute. For example, Country 1 might have neither "permanent" nor "awarded", so it wouldn't be in that junction table. Country 2 might have both, so would have TWO records in the junction table, one for each. All this depends on your underlying domain and table structure, about which I can only guess so far. More specific description may lead to more specific suggestion... Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi Jeff - Thank you very much for your response. My user can use a lookup list to enter the the [PermanentCountry] (got that one covered - thanks for suggesting, though), but not all of the countries qualify for the award. She has a list of countries that *do* qualify for the award - she would like enter a value in the [PermanentCountry] field, and then check to see if that value exists in the [tblAwardCountries] table. If it does exist in the award table, she'd like a notification in another field that the country she entered qualifies for the award. We are just starting to work through this, so any ideas are helpful. All of her records will have a permanent country, but not all countries qualify for the award. The list is way too long for her to remember all of the countries that qualify. We were hoping to find a way for Access to look at the [PermanentCountry] field entry, then check to see if there is a match in the [tblAwardCountries] table - if so, update another field based on whether the country exists in the table. The field that is updated can be a text, memo, or yes/no data type (could be something like [EligibleForAward]). Again, haven't put this together yet, trying to figure out a way to do this through Access, and not VBA. I can copy and paste code, but if something goes wrong I woudn't know how to fix the code. Thanks, again, Jeff. I hope that makes it a little clearer (?). "Jeff Boyce" wrote: Tammy I may be reading too much into your description ... It sounds like your user is required to type in a [PermanentCountry] value .... why? If the database already possesses a tblAwardCountries, why not use a combobox to list those and let the user select the correct one? And if it is a new, never-been-entered Country, Access HELP has plenty of information on using the LimitToList property and the NotInList event to handle adding a new one. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi, I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! . |
#5
|
|||
|
|||
Fill in a field based on input of data in another field
Hi Jeff,
This is why I love this discussion group - I needed ideas, and you just gave me a good one! I was thinking too deeply about this - I can see us using one table for all countries, with an extra field that distinguishes whether the country is eligible for the award or not (y/n would be perfect). Gosh, I feel dumb for not coming up with that one on my own! Thanks for putting up with my scramble thoughts! Your patience is greatly appreciated! "Jeff Boyce" wrote: Are you saying that there are two separate lists? One for "permanent", one for "awarded"? If so, why?! A single list (table) to hold Countries, with attributes (i.e.fields) for "permanent" and "awarded" (or are those mutually exclusive categories?)... Now, if there are MORE than just those two y/n categories, you may wish to consider a list (table) of countries, then a related junction table that holds valid pairs of country X attribute. For example, Country 1 might have neither "permanent" nor "awarded", so it wouldn't be in that junction table. Country 2 might have both, so would have TWO records in the junction table, one for each. All this depends on your underlying domain and table structure, about which I can only guess so far. More specific description may lead to more specific suggestion... Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi Jeff - Thank you very much for your response. My user can use a lookup list to enter the the [PermanentCountry] (got that one covered - thanks for suggesting, though), but not all of the countries qualify for the award. She has a list of countries that *do* qualify for the award - she would like enter a value in the [PermanentCountry] field, and then check to see if that value exists in the [tblAwardCountries] table. If it does exist in the award table, she'd like a notification in another field that the country she entered qualifies for the award. We are just starting to work through this, so any ideas are helpful. All of her records will have a permanent country, but not all countries qualify for the award. The list is way too long for her to remember all of the countries that qualify. We were hoping to find a way for Access to look at the [PermanentCountry] field entry, then check to see if there is a match in the [tblAwardCountries] table - if so, update another field based on whether the country exists in the table. The field that is updated can be a text, memo, or yes/no data type (could be something like [EligibleForAward]). Again, haven't put this together yet, trying to figure out a way to do this through Access, and not VBA. I can copy and paste code, but if something goes wrong I woudn't know how to fix the code. Thanks, again, Jeff. I hope that makes it a little clearer (?). "Jeff Boyce" wrote: Tammy I may be reading too much into your description ... It sounds like your user is required to type in a [PermanentCountry] value .... why? If the database already possesses a tblAwardCountries, why not use a combobox to list those and let the user select the correct one? And if it is a new, never-been-entered Country, Access HELP has plenty of information on using the LimitToList property and the NotInList event to handle adding a new one. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi, I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! . . |
#6
|
|||
|
|||
Fill in a field based on input of data in another field
Forest & trees, Tammy, forest & trees.
You'll spot something I'm not seeing sometime. Thanks, and keep coming back. Regards Jeff B. "Tammy" wrote in message ... Hi Jeff, This is why I love this discussion group - I needed ideas, and you just gave me a good one! I was thinking too deeply about this - I can see us using one table for all countries, with an extra field that distinguishes whether the country is eligible for the award or not (y/n would be perfect). Gosh, I feel dumb for not coming up with that one on my own! Thanks for putting up with my scramble thoughts! Your patience is greatly appreciated! "Jeff Boyce" wrote: Are you saying that there are two separate lists? One for "permanent", one for "awarded"? If so, why?! A single list (table) to hold Countries, with attributes (i.e.fields) for "permanent" and "awarded" (or are those mutually exclusive categories?)... Now, if there are MORE than just those two y/n categories, you may wish to consider a list (table) of countries, then a related junction table that holds valid pairs of country X attribute. For example, Country 1 might have neither "permanent" nor "awarded", so it wouldn't be in that junction table. Country 2 might have both, so would have TWO records in the junction table, one for each. All this depends on your underlying domain and table structure, about which I can only guess so far. More specific description may lead to more specific suggestion... Good luck! Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi Jeff - Thank you very much for your response. My user can use a lookup list to enter the the [PermanentCountry] (got that one covered - thanks for suggesting, though), but not all of the countries qualify for the award. She has a list of countries that *do* qualify for the award - she would like enter a value in the [PermanentCountry] field, and then check to see if that value exists in the [tblAwardCountries] table. If it does exist in the award table, she'd like a notification in another field that the country she entered qualifies for the award. We are just starting to work through this, so any ideas are helpful. All of her records will have a permanent country, but not all countries qualify for the award. The list is way too long for her to remember all of the countries that qualify. We were hoping to find a way for Access to look at the [PermanentCountry] field entry, then check to see if there is a match in the [tblAwardCountries] table - if so, update another field based on whether the country exists in the table. The field that is updated can be a text, memo, or yes/no data type (could be something like [EligibleForAward]). Again, haven't put this together yet, trying to figure out a way to do this through Access, and not VBA. I can copy and paste code, but if something goes wrong I woudn't know how to fix the code. Thanks, again, Jeff. I hope that makes it a little clearer (?). "Jeff Boyce" wrote: Tammy I may be reading too much into your description ... It sounds like your user is required to type in a [PermanentCountry] value .... why? If the database already possesses a tblAwardCountries, why not use a combobox to list those and let the user select the correct one? And if it is a new, never-been-entered Country, Access HELP has plenty of information on using the LimitToList property and the NotInList event to handle adding a new one. Regards Jeff Boyce Microsoft Access MVP -- Disclaimer: This author may have received products and services mentioned in this post. Mention and/or description of a product or service herein does not constitute endorsement thereof. Any code or pseudocode included in this post is offered "as is", with no guarantee as to suitability. You can thank the FTC of the USA for making this disclaimer possible/necessary. "Tammy" wrote in message ... Hi, I'd like to know if this can be done without VBA, since I'm not familiar with programming....Access 2007 My user has a table that contains countries: [tblAwardCountries]. When she enters a value in her [PermanentCountry] field, she would like the database to check to see if that country exists in [tblAwardCountries]. If it does exist, she would like another field to automatically update to "Eligible for Award". Can this be done without programming? I thought of the IN operator, but there are too many countries to have to type into the expression. Using a table will be easier to keep updated. Thanks for any suggestions! . . |
Thread Tools | |
Display Modes | |
|
|