How to view queries using the wizard in SQL view

We Got It Finally!

Here is the code

Set cdb = CurrentDb

Set rst = cdb.OpenRecordset("SELECT * FROM MstrPhts")

Do Until rst.EOF

strFile = rst!Location

Me.Image25.Picture = strFile

I think that when we used NE.Txt it was trying to read the entire file, reason for not enough memory.

I explained that you a few responses back.

Now you have a new post where you used foggy code.

And why are you even using code? All you need to do is assign the field location as the controlSource to your image control. You are making things more difficult for yourself.

If you look at the screenshot Duane provided, you will see that Sql view is an option on the View pull down, when in query design mode.

Like Duane, I NEVER use the query wizard.

I never use the query wizard which is a feature that would never expose a user to a sql view. It's a wizard interface with the sole purpose of avoiding the SQL view. Create a query by whatever means and then view the SQL.

DHookum;

I brought up the Query Wizard and I do not find the SQL View or Design View on my 365 Office.

The Old NASA Kid put a bunch of old ones he had in my Windows 10 computer to reference because both of us have not worked with Access for a pretty long time, slowly but surely the cobwebs are coming out.

Thanks for being patient.

IchthyologistNeb

I don't think this has changed. From design view, select View->SQL View