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

    SQL code to input data in field based on data from another table

    OOPS!! I have the query running now, however I find that I am having to make a new Update query for each field and I have 43 fields to have an "X" placed for data in the prime database, how do I create these in a single query, I have tried adding to the SQL window for more fields and...
  2. troyster

    SQL code to input data in field based on data from another table

    Got it!! This helps a great deal. Terry Broadbent tried to give me this, however I misunderstood him... sorry Terry but I really appreciate your help... now it's working. Thanks guys... not sure what we would do without these forums to help one another.
  3. troyster

    SQL code to input data in field based on data from another table

    We have a need to place a character "X" in a field of a relationshiped table based on a field in another table being "not null", this is to occur for several fields and to be updated upon command. We are using Access 2002, what would be the SQL code for something like this?
  4. troyster

    Vba to add data to a table

    99mel, along with mike I also would like to see the code you used for population... Thanks
  5. troyster

    populate a field in a database from data filter from another database

    I need to populate a field in another table based on data matching a filter in my prime database, i.e. place an "X" in tblITR_Instrument.E01 for tblInstrument.instrument=”Y”. The tables have a relationship field, this is to show whether or not an action is needed to be done. I have...
  6. troyster

    populate field based on selected data in another table

    Terry, If you see this please advise me on this as I have tried your code and have issues I believe that is with the syntax. Perhaps I am doing the wrong thing, however I am using Access 2002 and keep getting error messages. Here it is in a nutshell; tbl A is Instrument and tbl B is...
  7. troyster

    populate field based on selected data in another table

    Thanks... this should do the trick. I'll let you know how it goes.
  8. troyster

    populate field based on selected data in another table

    Yes the databases have a relationship field, the query above looks very good... extremely helpful... however is this a line of code to be in a module or other... how do I include this in the database? Thanks for your reply
  9. troyster

    Dial Up Networking Problem

    I recently started using a new machine that has both MS Office 2000 Pro and XP Pro. The main thing as to a dialup connection I found out quickly is that I have to input the DNS info in th TCP-IP window as part of the setup whenever I change providers and establish a new connection (I travel a...
  10. troyster

    populate field based on selected data in another table

    I need to populate a field in another table based on data matching a filter in my prime database, i.e. place an "X" in tbl "B", Field Q for "*XYZ*" in tbl "A", Field "Z". Is this a possibility? I appreciate any assistance in this matter.

Part and Inventory Search

Back
Top