Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
Top Bottom