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 TouchToneTommy 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. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Also, quick question for you, would adding a hyperlink using a hyperlink field with ctrl + k be the most effective/ safest way to add a link to a specific location? Thanks
  2. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Exactly right, that was the big issue. Oh well, time to add hyperlinks for 1000+ rows haha. Thank you for your patience and assistance throughout the past few days!
  3. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Oh, that is exactly what I'm looking for - but just my attachments aren't actually showing (as you can see they all say "0" when in reality there's 1-3 attachments per row. I will probably opt to storing hyperlinks for each row since it seems a whole lot easier. Thanks again for your assistance...
  4. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    I get the merged table with both attachment fields! However, the pdf files I previously attached are not present. Please see the photo to see what I am talking about. Thanks again
  5. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Unfortunately not, I receive the error "syntax error in query expression 'U.*T1.Softcopy'. :(
  6. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Sorry, so the code would look like this? SELECT U.* T1.SoftCopy AS T1SoftCopy, GII.SoftCopy AS GIISoftCopy FROM qselGII_Softcopy GII RIGHT JOIN (qselT1_Softcopy T1 RIGHT JOIN quniTable1GIIRegister U ON T1.IDKey = U.IDKey) ON GII.IDKey = U.IDKey;
  7. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Sorry, I don't understand what you mean? The Nz() code was not used in any other queries? Thanks
  8. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    By that you mean to not include the attachment column? That's a shame, I thought it could be done. Thanks for your assistance anyway, I appreciate it.
  9. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Hi guys, thanks so much for responding. Apologies for the delayed reply, I have not been in the office over the weekend. I used your exact code (as below) for the last query Dhookoom, and I received an error as follows: "The multivalued field 'T1. Softcopy is not valid in the expression...
  10. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Thanks dhookom, it now works for the first query. However, I receive the following error on the last query: Is there something that I've overlooked? Thanks again for your patience :)
  11. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    And just to let you know- FYI this is my first week of using access. So please excuse my horrible explanations and me being so clueless. I appreciate your patience :)
  12. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Thanks for taking your time to reply dhookom! I truly appreciate your help! I have followed all of your code, but have unfortunately received a couple errors. For the first query you provided, I received the following error: I added the "IDKey" onto the second SELECT line code following the...
  13. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    @dhookom - Thanks for the reply, I appreciate it. I have left the primary key as "ID" for both tables, where each row is given a number (i.e. 1,2,3,4...). These numbers between each of my tables have no correlation though, I'm just wanting to paste one table on the bottom of another in order to...
  14. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    @Andrzejek - Thanks for your reply, I appreciate it. Correct that SQL works perfectly and joins the two tables together. However, I did not include my attachments field ([Softcopy]) within that, otherwise I would receive the error "the multivalued field '[Softcopy]' cannot be used in a UNION...
  15. Anthony343242

    MS ACCESS UNION ALL with Attachment data type

    Hi All, I was just wondering if anyone can elaborate on what the code would look like for the answer by Programmer dhookom on thread700-1724615: https://www.tek-tips.com/viewthread.cfm?qid=1724615#post I know this has been answered before but I am having some struggles. This is my SQL code as...

Part and Inventory Search

Back
Top