I have a lot of questions, and I'd greatly appreciate informative replies...
I want to be able to have Field A for each record in Table One where I can enter keywords separated by commas or semicolons. How should I format the field to be able to handle this?
I have Field B in Table Two. The entries in this field possibly contain a few of the keywords from any of the records in Table One - NB: These tables are not related by the Relationships tool. The keywords here are separated by spaces. Basically, I want to design a Query that searches for the presence of one or more of the keywords present in all the records in Field A of Table One. If any record in Field B of Table Two contains one or more matches, I want each of those Field B entries to be displayed, along with links to each of the Field A records it matches.
Here is another thing I would like to be able to do (unrelated to the previous stuff). I have an OLE Object field in a table. In the form of this table, I want to have a text box with a button "Browse..." next to it to use to enter the path of a JPG image. The image will be previewed in a box within the form. How do I do this?
And here is another ( 😉 ) thing completely unrelated to the previous stuff. I have a field with a lookup containing 2 values. These are displayed in my form (using AutoForm) as a combo box I can convert to a list box. But I want the values to be displayed as option buttons. How do I do this?
I want to be able to have Field A for each record in Table One where I can enter keywords separated by commas or semicolons. How should I format the field to be able to handle this?
I have Field B in Table Two. The entries in this field possibly contain a few of the keywords from any of the records in Table One - NB: These tables are not related by the Relationships tool. The keywords here are separated by spaces. Basically, I want to design a Query that searches for the presence of one or more of the keywords present in all the records in Field A of Table One. If any record in Field B of Table Two contains one or more matches, I want each of those Field B entries to be displayed, along with links to each of the Field A records it matches.
Here is another thing I would like to be able to do (unrelated to the previous stuff). I have an OLE Object field in a table. In the form of this table, I want to have a text box with a button "Browse..." next to it to use to enter the path of a JPG image. The image will be previewed in a box within the form. How do I do this?
And here is another ( 😉 ) thing completely unrelated to the previous stuff. I have a field with a lookup containing 2 values. These are displayed in my form (using AutoForm) as a combo box I can convert to a list box. But I want the values to be displayed as option buttons. How do I do this?
