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
|
|||
|
|||
allowing multiple values causes front end to report error
My database is split into back and front ends. I already have one text field
that allows multiple values in a combo box with value list. When I add another multiple value field, the front end gives an error message "the search key was not found in any record". It works ok with the text field as a single value only combo box with value list, it's only when I allow multiple values that it gives the error. What is going on? as I said, there is already a field that allows multiple values, and that one works just fine! As far as I can tell, all the other parameters for the second field are set the same as the first. |
#2
|
|||
|
|||
allowing multiple values causes front end to report error
Try:
1. Delete the linked table from the front end. 2. Compact/repair the front end database. 3. Compact/repair the back end. 4. Open the front end, and link the table again. Let us know how you go. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jey" wrote in message ... My database is split into back and front ends. I already have one text field that allows multiple values in a combo box with value list. When I add another multiple value field, the front end gives an error message "the search key was not found in any record". It works ok with the text field as a single value only combo box with value list, it's only when I allow multiple values that it gives the error. What is going on? as I said, there is already a field that allows multiple values, and that one works just fine! As far as I can tell, all the other parameters for the second field are set the same as the first. |
#3
|
|||
|
|||
allowing multiple values causes front end to report error
That solved it, thanks! I've set them to compact on close, so hopefully I
won't run into that again. "Allen Browne" wrote: Try: 1. Delete the linked table from the front end. 2. Compact/repair the front end database. 3. Compact/repair the back end. 4. Open the front end, and link the table again. Let us know how you go. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. |
#4
|
|||
|
|||
allowing multiple values causes front end to report error
Jay,
Actually, setting your database to Compact on Close might very well cause other issues. Maybe not *today* but most likely *tomorrow*. It is recommended you uncheck 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 "Jey" wrote in message ... That solved it, thanks! I've set them to compact on close, so hopefully I won't run into that again. "Allen Browne" wrote: Try: 1. Delete the linked table from the front end. 2. Compact/repair the front end database. 3. Compact/repair the back end. 4. Open the front end, and link the table again. Let us know how you go. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. |
#5
|
|||
|
|||
allowing multiple values causes front end to report error
Jay, hopefully you get that message.
What Gina is saying to you is important. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Gina Whipp" wrote in message ... Jay, Actually, setting your database to Compact on Close might very well cause other issues. Maybe not *today* but most likely *tomorrow*. It is recommended you uncheck 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 "Jey" wrote in message ... That solved it, thanks! I've set them to compact on close, so hopefully I won't run into that again. "Allen Browne" wrote: Try: 1. Delete the linked table from the front end. 2. Compact/repair the front end database. 3. Compact/repair the back end. 4. Open the front end, and link the table again. Let us know how you go. -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. |
#6
|
|||
|
|||
allowing multiple values causes front end to report error
"Jey" wrote in message ... My database is split into back and front ends. I already have one text field that allows multiple values in a combo box with value list. When I add another multiple value field, the front end gives an error message "the search key was not found in any record". It works ok with the text field as a single value only combo box with value list, it's only when I allow multiple values that it gives the error. What is going on? as I said, there is already a field that allows multiple values, and that one works just fine! As far as I can tell, all the other parameters for the second field are set the same as the first. |
Thread Tools | |
Display Modes | |
|
|