-
Hi everyone!
I'm trying to do the DAO database thing and it's been a battle. I'm using this code to try to open two databases and so far it hasn't hic-uped so I guess this is good.What I don't know is how to refer to the table names.
strSQL = "db.OpenRecordset(SELECT ResultInfo.*, RuleInfo.IdNum" & _
" FROM RuleInfo INNER JOIN ResultInfo ON RuleInfo.IdNum = ResultInfo.IdNum;" & _
", dbOpenDynaset)"
Set rs = strSQL
'This only works with one table(when the rs is 1 table):
rs.addItem
text1 = rs!TableItem1
text2 = rs!TableItem2
rs.Update
'I want to do this:
rs.addItem
text1 = rs.ResultInfo.TableItem1
text2 = rs.RuleInfo.TableItem1
rs.Update
Any hints, codes, or syntax suggestions? This is driving me nuts.
Thanks Again,
Joey O
-
In Access you cannot open tables from 2 different databases, unles in your example it is 1 database and 2 tables. If yes, then your SQL statement looks ok. The only thing that you have to check is to see if the corresponding tables have common values in IdNum field.
Regards,
-
Yes, it's one Access Database. I'm trying to enter new information into ResultInfo table(currently very empty)based on selections from RuleInfo table (very full). I have a bunch of rules and if they pass or fail test,I want results to enter into ResultInfo table.I get err 438 (object doesn't support this property or method) on:
Text1 = rs.RuleInfo.RuleNum
Thanks for you patients Serge,
Joey O