Ask Experts Questions for FREE Help !
Ask
    martinakl's Avatar
    martinakl Posts: 1, Reputation: 1
    New Member
     
    #1

    Dec 20, 2011, 04:56 AM
    Runtime error 3075?
    Hi. I have an SQL code using in VBA Access. There is still some syntax error and cannot see it. I would really appreciate, if anyone has any idea. Thanks. Here is is.
    Set rst = Application.CurrentDb.OpenRecordset("SELECT DISTINCT da_MF_DATA_complete.*, com.[comment] As comment FROM da_MF_DATA_complete " _
    & " LEFT JOIN (SELECT mf_id, max([date]) As last_date FROM dbo_mf_comment WHERE status_id = 'RLC' AND dbo_mf_comment.origin = 'ACN' GROUP BY dbo_mf_comment.[mf_id]) " _
    & " As last_comment ON last_comment.[mf_id] = da_MF_DATA_complete.[mf_id] " _
    & " LEFT JOIN dbo_mf_comment As com ON last_comment.[mf_id] = com.[mf_id] AND last_comment.[last_date] = com.[date] " _
    & " WHERE current_mf_status_id = 'RLC' AND mf_complete IS NULL ORDER BY return_priority DESC;")

Check out some similar questions!

Why am I getting a runtime 3075 missing operator error in the following statement [ 0 Answers ]

strSQLA = "SELECT * FROM tblAgreements WHERE tblAgreements. = LIKE " & "*" & !!. & "*"*" ;" This code is inserted in as VBA in Microsoft access 2010, basically look in the table agreements within ID, for the user's input, say 550 entered in text box. Can you assist?

Updating records and getting Runtime Error 3075 [ 3 Answers ]

Hello there! For the access program I am going to do, there is already an existing data. I had imported it from Excel. Now, I have created a URN field from the look up table and wanted to update it to the main table which comprises the existing data. I've used the following code but I keep on...

Runtime error [ 1 Answers ]

I bought a new Nikon L20 camera, but when I load the transfer software to my computer With WinXP and when I try to open it I get a runtime error C++ Library. Do you have a cure for this problem. Thanks for any help, Ed Hood...

Runtime error [ 1 Answers ]

On certain internet site I get popup message runtime error do you wish to debug yes or no? When I press yes I get another box coming up I then go into remote and then it says access denied what am I meant to to do with this annoying item:mad:


View more questions Search
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.