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!

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.

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...

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...