Recent content by cathie

  1. C

    SQL Twit here... Can anybody help me with this?

    That worked beautifully! Thanks so much for the assist! It is indeed greatly appreciated!
  2. C

    SQL Twit here... Can anybody help me with this?

    I am trying to return all rows even if there are no expense entries in the ExpenseLog table. I'm pretty sure I have superfluous stuff in here. Unfortunately, I know close to nothing about SQL :( . I am getting a "'JOIN' expression not supported" error from Access 2016. I am trying to link 2...
  3. C

    Form: Find ALL records matching a criteria from header combobox

    Thanks so much Cronk! That made all the difference! ;)
  4. C

    Form: Find ALL records matching a criteria from header combobox

    I have a form with header combobox that I am allowing the user to select find criteria with. The problem is that it is only returning 1 record. I want it to select all records. The box contains states of the union. When for example "NJ" is selected, all NJ records, not just the first, should...
  5. C

    Strange Error: Run-Time 3707 Database Engine does not recognize name

    Brilliant! And I, sir, am a twit! Thank you for the speedy assist! :)
  6. C

    Strange Error: Run-Time 3707 Database Engine does not recognize name

    I used this same exact code on a few other comboboxes with no problem... I can't understand why it's not working this time... I even changed the fieldname thinking it might be a keyword... MS help says it's probably misspelled but I copied it out of the table design... Any idea what might be...
  7. C

    HELP! - Run-time error '3034': Syntax error in insert into

    Hi arnelgp :) I am a twit of major magnitude! I got it to work! I had an incorrect column name. That SQLFix code is terrific though, and I appreciate you sharing it! Thanks again for all your help!
  8. C

    HELP! - Run-time error '3034': Syntax error in insert into

    Re: HELP! - Run-time error '3134': Syntax error in insert into Thanks so much for the replies and assistance! I tried your solution with some minor tweaking and unfortunately, I still get the same result :( I tried with and without a closing semi-colon... the last 2 numeric figures are...
  9. C

    HELP! - Run-time error '3034': Syntax error in insert into

    Can anybody eyeball something that I can't see??? MySql = "INSERT INTO All2 (LoanType, Street, Unit, City, State, Zip, Borrower, Vendor, DateRecd, Wholesaler, Processed, " & _ "UploadID, Result, Latitude, Longitude, ZillowID, Zestimate, ZRestimate...
  10. C

    Using Access VBA to Loop through Excel Rows

    I have the following code and have searched the 'net extensively to try to help find a solution and I am having no luck at all. I want to open and loop through an excel file in a specific format which on the face seems simple enough. I want to take the values from that spreadsheet and do some...
See more
Top Bottom