Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. rjstephan

    Replace Function Parameters

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

    Collection reference in Replace function

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

    Replace Function for Global Table Changes

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

    Replace Function for Global Table Changes

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

    Reuseable Select Query on Multiple Tables

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

    Reuseable Select Query on Multiple Tables

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

    One Form to Use on 50 Different Linked Tables

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

    Field validation multiple choice

    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?
  9. rjstephan

    Field validation multiple choice

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

    Field validation multiple choice

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

    Field validation multiple choice

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

    Field validation multiple choice

    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?
  13. rjstephan

    Field validation multiple choice

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

    Field validation multiple choice

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

    Add new record, requery and go to newly added record

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

Part and Inventory Search

Back
Top