Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
i get two different errors depending on which approach i take to display information from to different tables in my Access DB. The code is as follows:
'Populate SQL to get member info
SELECT tblPictures.Picture, tblPictures.ProfilePic, tblMembers.MemberID, tblMembers.Sex, tblMembers.City, tblMembers.State, tblMembers.Country, tblMembers.LoginName, tblMembers.Headline, tblMembers.Television, tblMembers.Orentation, tblMembers.Hobbies, tblMembers.HereFor, tblMembers.Music, tblMembers.Movies, tblMembers.Books, tblMembers.MaritalStatus, tblMembers.BodyType, tblMembers.Smoke, tblMembers.Drink, tblMembers.AboutMe, tblMembers.Occupation, tblMembers.Children, tblMembers.Religion, tblMembers.Ethnicity, tblMembers.GeneralInterest, tblMembers.Heros, tblMembers.LikeToMeet, tblMembers.Education FROM tblMembers INNER JOIN tblPictures ON tblMembers.MemberID = tblPictures.MemberID WHERE tblPictures.ProfilePic=True AND tblMembers.MemberID=[member ID in this case 2];"
oRS.open SQL, oConn, 3
'--- Populate vText - BEGIN ---
vText = "
vText = vText & "
|" & oRS.fields("tblMembers.LoginName") & "|
error when calling for the LoginName. I get ADODB.Recordset (0x800A0CC1) Item cannot be found in the collection corresponding to the requested name or ordinal. When calling for it as it is in the code above. However, if I were to take out the tblMembers part of it so its just LoginName I get this error: (0x80020009) Exception occurred. The querry works fine in the DB. IDK whats up with that. Any ideas?