How to build an ODBC Connection

Duane;

Here is the code I copied from you in my computer:

I created an Image Area for my Image, It is Image25

Dim strFile As String

strFile = "C:\NEPhotos"
strFile = Left(strFile, InStrRev(strFile, ""))
strFile = strFile & "NEPhotox\NE.txt"
Me.Image25.Picture = strFile ?????????????

One of my fields contained "C:\NEPhotos\NameofImage

maybe it should have been "C:\NEPhotos\NE.txt\Name of image.

On the above line I get the message---- Microsoft Office can't open the file 'C:\NEPhotos\NE.txt

This is why I tried to put the images in Excel, Which did not work! The file is not open anywhere else.

I also tried to look at it using a Message Box and it only comes up with False.

T. Z. I think has a good idea on the List Box Idea, but I want to get this to work first. He is with me now.

It is telling me that I am on Access 2007 again.

The one nice thing is knowing Assembler is looking for Access07

With all of the hacking going on, it is almost impossible to do anything.

                 def = 0

                 str  WorkA

                 str WorkB,'Found at Location'

                 cmt cnt,'Access07' 

                 DS newadr = 8 

                 adr  = def

RaG adr = adr +1

                 mva = \* + newadr eq    

                 cmp = \*,lgt, 8 

                 ne goto RaG

                 cmmt prtr, WorkB

                 Goto End

End lbel *

I ran this program which searches the computer byte by byte'

It found it way out at the end with no indication it was attached to anything. The entire area was used for storing comments.

Probably not a problem, but it is scary

Please try to stick with us, T.Z. appears to be great with Combo Boxes and List Boxes.

Mr. Hookum;

I am T. Z. and will be taking over for J.J. known to you as the IchthyologistNeb.

I tried to sign on and create my own profile, I am stationed at Reese AFB

We have had huge security problems at the base so that may be the problem

On this application that I worked on at the base, I have changed the entire approach. Hopefully I will be doing the right thing.

Before we go any farther, J. J. is an unbelievable programmer, while programming stealth fighters a pilot got in trouble J.J. got on the computer and landed the fighter. To almost anyone's knowledge it is believed to be the first time a plane was landed b a programmer. J.J. saved a pilots life and a multi-million dollar fighter.

I think that individuals who learned older techniques are having problems, I look at their stuff and a thousand things run through my mind.

The approach I have taken is to use a list Box to select the Blood Sample.

I did this because the doctors can look at a bunch of samples instead of one at a time.

I liked the approach, but just finished my Access Class on May 26, 2023. J.J. said you have a lot of patience, I had no instructions on Images or working outside the MDB environment. In fact looking at things on line my text book seems to have much simpler examples. The Air Force will be having me work on administrative applications, nothing scientific.

The path to the images is in a field called Location. It has the drive #, directory and folder all included in the field.

J.J. always programed things where the information on the computer are in the record files themselves. So the field named Location will in reality have C:\NEPhotos\BloodName. He does a lot of stuff like this. It has something to do with security.

I guess in this way you do have to construct a variable to hold everything.

So how does the contents of the field Location find the Image?

As I understand it, the image is in two locations, a text file and in a folder by themselves. So as I understand it, the strfile was unnessary.

Thanks in Advance

T. Z.