Search results for query: *

How do you make a collection reference to all fields in a table as the first argument in the Replace function of A2K? I want to replace ABC with XYZ in all fields in a table. Thanks.

Can you make a collection reference to all fields in a table as the first argument in the Replace function of A2K? Thanks!

I wanted to avoid looping thru all possible fields individually. If you use the Replace command off the menu in a table you can search and replace all fields in the entire table at once -- that's what I would like to do with a function. Thank you.

In Access 2002 how do I use the VBA Replace function to search all fields in a table and change all occurences of "ABC" to "XYZ"? Thanks in advance.

Thanks! OK, I got the combo box part and I looked at the SQL SELECT code that currently is the RecordSource for the Form, and I assume an AfterUpdate event on the Combo Box would trigger the change in the RecordSouce for the Form, but how do I get the stored variable Value in the Combo Box into...

I have a select query with two linked tables. I want to be able to dynamically change one of the tables in the query to any one of 50 identically structured tables so I don't have to have 50 queries that are all the same except for one of the linked tables it references. The idea is to get a...

I have one form that I want to use on 50 different tables (all with identical fields) that are linked to a front end so when the form is loaded a prompt will ask "which ID?" and that ID's table will be loaded in the form. How do I dynamically assign the form's record source this way...

Jim, You have given the best response so far. Could this perhaps be done with a macro with conditional statements and the set value action?

I am not sure who it is that doesn't get it. I don't know how you would split the single form entry to two separate fields in the table, but in any event, for that approach to work, I would have to have FIVE table fields in the event the entry has ALL FIVE PERMITTED WORDS. Get it? Thanks.

Junior, that works if you only want one of the possilbe allowed words --- but I want to have one or more of the allowed words, but only the allowed words. Take a look at my example posted in the original question. Thanks

The answer given in the table section doesn't work.

You missed the difficult part -- having more than one of the valid words in the field. Your method only allows one of the possible words, but not two or three. Got a better solution?

I have a field I want to validate to contain one or more of only five specific words, ie, red, green, blue, white, yellow. The IN expression requires ONE of a list, but I want to be able to have more than one from the list, but always only from the list. Example of Color Field in: Record 1 -...

I have a field I want to validate to contain one or more of only five specific words, ie, red, green, blue, white, yellow. The IN expression requires ONE of a list, but I want to be able to have more than one from the list, but always only from the list. Example of Color Field in: Record 1 -...

In a form as you enter new records they are shown in the order entered until you requery or leave and re-enter the form in sorted order. I would like to be able to enter a new record, requery the form and then be taken to the new record in the sorted order. For instance the form is date...