FInal version
UPDATE tblCompanies INNER JOIN test ON tblCompanies.CompanyName = test.CompanyName SET test.BusinessSector = tblCompanies.[Business Sector];
Thanksfor the help guys
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.......
I have been messing around with this code
UPDATE CompanyContacts
SET CompanyContacts.BusinessSector = CompanyContactsold.BusinessSector
WHERE CompanyContacts.CompanyName = CompanyContactsold.CompanyName
Not working tho.
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...
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...
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...
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!
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.
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...
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...
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
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.