Recordset issues, get a good record count but no field data. worked till 365

[homelessvet1]

what does that mean?

if you debug.print rs.recordcount you get 37818? even though the code exits if it is 0 which is what you are saying it is doing?

You expect the code to interpret ImlJobID as lmlJobID?

you can see from your own code the I of ID

It is an "I" in both. I went back and looked.

[homelessvet1]

Here is a debug shot.

[CJ_London]

your movelast needs to be before your recordcount

your other mistake is using rs. rather than rs! for referencing a field, they are always late bound

[homelessvet1]

your movelast needs to be before your recordcount

your other mistake is using rs. rather than rs! for referencing a field, they are always late bound

Thanks for the "rs!" typo. You are spot-on.
Made the change but no-bueno. Still does not find field. I appreciate your time on this. I may go back to my other win 7, Access 2007 unit and try this.
Have spoken to Microsoft, reinstalled 365 twice at their suggestion but no luck.
They admit there is a bug and want my reports but I am running out of time on this. Win 7 may fix it. Please don't quit suggesting tho, the rest of the system must run on Win 10, Office 365.

[CJ_London]

It is an "I" in both. I went back and looked.

you must be using a really weird font

in your query you have

m1tclcropped.lmlJobID

so how does an I appear as l and I in the same word? perhaps that's the microsoft bug?

yet doesn't

in your code

rs!ImlJobID

[Micron]

Was going to say earlier that last night I examined the web page source here and the I's are both I's. IIRC, one was upper case and the other lower but both the same letter. Not sure what font that Firefox uses to render the page code, but it's not the same as the forum version.

[CJ_London]

Interesting - for me a lower case I is i - a lower case L is l

[homelessvet1]

Interesting - for me a lower case I is i - a lower case L is l

You solved it. The field name was showing and printing Iml but was LML . The program now runs fine.
Spent a week for a program that ran 5 seconds. Data is now converted and I have the weekend off.
Thanks to all.
Tried to mark as solved but couldn't.

[Micron]

Not sure how an L can be converted to an I by any browser. I must be missing something because this ( ImlJobID )was pointed out back in post 12, to which you
replied that the field lmlTimecardID did in fact exist in the recordset and the latter certainly looks like a lower case L.
Glad you figured it out anyway.