Rstart = DLookup("RangeStart", "acRanges", "RangeLetters = ""EQ""")

Martin Kevin got it right in your case. Here's a few more examples that may help in the future:
Rstart = DLookup("RangeStart", "acRanges", "RangeLetters = 99") 'if the ids are numbers, like autonumbers
Rstart = DLookup("RangeStart", "acRanges", "RangeLetters = """ & variableString & """)
Rstart = DLookup("RangeStart", "acRanges", "RangeLetters = " & variableNumber)
Rstart = DLookup("RangeStart", "acRanges", "RangeLetters = " & Str(variableNumber)) 'if might have a comma as the decimal

Thank you so much Kevin & Thomas.   Thomas, I tried your "variable string" version for my ultimate objective of DLookup("RangeStart", "acRanges", "RangeLetters = """ & [fkAccountType] & """) and got the error "The expression you entered has an invalid string".  Can you help me one more time?

You've only got 3 """ at the end. You need 4 """". I know. It's confusing.

Watch: Double Double Quotes

It's not your fault. The example that Thomas gave above is actually wrong. Naughty, naughty.

I'm gonna leave it here long enough just to bust his balls... I'll fix it later. LOL

Thank you so much, Richard.  I now have a beautiful RangeStart and RangeEnd for my Chart of Accounts.  Please be nice to Thomas.  We need people like him :-)

Martin I just kid with my long-time students and Access Veterans. He's a good guy. I kid cuz I love. :)

Yea I screwed up. I actually make a lot of errors in my comments. I can't type or see very well in these little comment boxes that Richard gives us. Especially without an EDIT feature once we later see an error.

At least I can fix errors on my little laptop screen, after going nuts counting little quote lines or parenthesis in a procedure.

"'''"'''" Can you tell how many single and double quotes I just typed? Aggghhh
On an old dumb terminal, which was mono-spaced, at least you had a chance.

Thomas

1 Double Quote
3 Single Quotes
1 Double Quote
3 Single Quotes
1 Double Quote

My dad wrote all his articles and books on an old Remington typewriter, except his last, in which he used an old DOS word processor, possibly named Word Pro if I remember correctly. I have no idea how the publishers of that day did the varying font sizes for an article. I suspect it was cut and paste by graphic artists of the day. If Richard lets the link remain, you may enjoy the articles (my dad's showing how someone proceeded Elon by 60 years in auto driving cars, p.55 of the mag). I get a kick out of the advertisements, many for the up-and-coming career of becoming a TV repairman.

https://www.worldradiohistory.com/Archive-Poptronics/50s/58/Pop-1958-05.pdf

Kevin You got a better screen or eyes than me. I don't remember what I typed, but I'll trust you.

LOL. I copied it to Notepad. Made it easy to see them.

Yeah, I've been meaning to build an edit feature, and it hasn't been a priority because it doesn't come up that often. I have an edit feature, so that's what really matters. LOL. It's just bulletproofing it so the average users can't mess with stuff. I don't feel like properly encoding everything to make it safe. For now, it's just the moderators and I who can edit stuff, but it'll come eventually when I get around to it.

My dad had a bunch of round pieces of wood made, about the size of a 50-cent piece back then, that just had the characters "2IT". He would hand them out to students or others that were late with something like homework.

I probably have a few in my "remembrance box" for missed Saturday morning chores. I think I got a can of sixty-year-old firecrackers from Hawaii in there still too. For $1 you got a big string of them, that we would use in Wrist Rocket slingshot wars around the old WWII bunkers on the North Shore of Oahu. I just passed on my original Wrist Rocket to my 10-year-old son. He'll have to wait a little longer for the stored away throwing knives and bull whip. (This was all long before the Indiana Jones films came out.) Colombia customs confiscated my collection of pellet guns when I moved here. A very sad day. They made such a scene out of them at the airport, something every USA boy had in the 1960s.

Richard, we need a way to add photos without resorting to a new post.

Yeah, that's on the list too. I'm a database guy, I'm not a web UI guy, so I do what I can when I can. I looked into making it so you could paste pictures directly into a text box, and that's a lot of work. One of these days I'll get around to it, lol.

Speaking of the Round Two-It, did anybody have any of those Dilbert Mint tins? I used to have some.

And wait, you gave a wrist rocket to a 10-year-old?

Nice! :)

Martin sorry we hijacked your thread. It happens sometimes.

Richard That's about the age my dad let me buy one, with my own $ (about $5 which was damn expensive for the times), at Pep Boys after dinner at Joe's Cafe on State St in Santa Barbara. The next day, the neighborhood bully said I couldn't hit the "broad side of a barn", which I didn't understand the meaning of until it was explained with more laughs. A few minutes later I proved him wrong with a well-placed rock to his back side (which wasn't too broad) from twenty yards. And imagine, I didn't get sent to prison (or juvie) for it.

I never saw the Dilbert Mints. In some box, I've got the original Dilbert book of daily comics. A "friends" son stole my still sealed Playboy featuring Madonna, and the well-worn one I got from my dad of Marilyn. Now, that was pure evil!

I am honoured to have stimulated such an exchange :-)

Martin Here are some videos which may help you with errors in the future.

Error Messages
Error Handling
Trap Form Errors

Thank you.  I'm struggling to wade through the tutorials.  I'm currently on Expert 6!  it's truly amazing how important learning the little tweaks at the lower levels is.  I though I was was advanced but I learn something in almost every lesson

I should start a whole page filled with comments from users who said that. One of the things people always want to do is skip the beginner levels, and I'm like no, you really shouldn't. It's not because I'm trying to sell more lessons (the beginner levels are priced really cheaply), but because they're filled with little nuggets of wisdom that you really need to have later on.

That's one of the reasons I don't open my forums up to everybody. I want this to be a discussion with people who have learned how to use Access from me and do it my way. I look at forums online, and you get all these other people with all these different ideas and ways of doing things. Experts think they know what they're doing, answering questions, and I'm like, no dude, that's not how that works. That's why this is a closed ecosystem.