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!

  • Congratulations IamaSherpa 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. scotent

    Update records based on an identifying feild from another table(xpost)

    FInal version UPDATE tblCompanies INNER JOIN test ON tblCompanies.CompanyName = test.CompanyName SET test.BusinessSector = tblCompanies.[Business Sector]; Thanksfor the help guys
  2. scotent

    updating records based on another table

    Thanks Greg - finally battered my way through about half an hour ago. Thanks for the tip tho, it is basically what I ended up with. After a lot of attempts that wiped out data from the referring table which was scary. Fortunately I was working on test tables.......
  3. scotent

    Update records based on an identifying feild from another table(xpost)

    I have been messing around with this code UPDATE CompanyContacts SET CompanyContacts.BusinessSector = CompanyContactsold.BusinessSector WHERE CompanyContacts.CompanyName = CompanyContactsold.CompanyName Not working tho.
  4. scotent

    Update records based on an identifying feild from another table(xpost)

    I have a list of companies that have a currently empty field for 'Business Sector' I have another table thta contains a portion of the records that have this feild filled in. What is the best procedure for running a query that will update the fields in the new table based on the existing data in...
  5. scotent

    updating records based on another table

    I have a list of companies that have a currently empty field for 'Business Sector' I have another table thta contains a portion of the records that have this feild filled in. What is the best procedure for running a query that will update the fields in the new table based on the existing data in...
  6. scotent

    what does runtime error '2001' mean

    have got a dynamic query builder which runs ok some times and sometimes produces a an error as above^
  7. scotent

    Dynamic query form

    I have the following code attached to a command button, it takes its input from four drop down boxes. What I would like to do is: a) allow for a null value i.e. if nothing is selected in the dropdown and b) have the resultant recordset appear in the main body of the form as a datasheet view...
  8. scotent

    dynamic query - code acting like a parameter query

    Eureka! Seek and ye shall find. Nothing wrong with the code at all.... was operator confusion, I havd put in mismatching feild names for comparison in the table. Doh!
  9. scotent

    dynamic query - code acting like a parameter query

    DoCmd.OpenQuery "Dynamic_Query" the above line seems to be the problem, i think. this is the line highlighted when the debugger runs. Any thoughts, am starting to lose the will to live.
  10. scotent

    dynamic query - code acting like a parameter query

    I have tried to adapt some code I found on the microsoft site for dynamic query. Private Sub cmdRunQuery_Click() Dim db As Database Dim QD As QueryDef Dim where As Variant Set db = CurrentDb() 'Delete existing dynamic query; trap the error if the query does not exist On Error Resume Next...
  11. scotent

    Dynamic Query tutorials

    http://support.microsoft.com/default.aspx?scid=kb;en-us;Q136062 for anyone interested - this is a useful page
  12. scotent

    Saving recordsets for future reference

    Both excellent suggestions - will try both in combination. Will let u know how i get on. Thanks
  13. scotent

    Saving recordsets for future reference

    What is the easiest way to save a recordset? The idea is that after having dynamically created a query, the user can save those results for future reference. Saving the bquery will not produce an accurate reord of the a previous recordset as the records will be ammended, added and changed over...
  14. scotent

    splitting fields into separate elements

    Hi Thanks for that, I ,have wimped out. As I have only a couple of hundred records it may well be less time consumeing to do it by hand. Luddite I know but time is an issue. Thanks for your suggestions tho
  15. scotent

    Dynamic Query tutorials

    Are there any good resources to help idiots through the pain of creating dynamic queries? TIA
  16. scotent

    splitting fields into separate elements

    I have a set of records (company details) exported from Outlook. The address feild is a concatenation of the seperate address lines. This means that instead of the usual address1, address2 etc it all appears in the address1 feild. the actual alements fo the address are de;imited by a carriage...

Part and Inventory Search

Back
Top