How to build an ODBC Connection

Anonymous

Now that we have a folder with all of the images, How do I connect to it;

Use the query Wizard?

Where do I find the Data Connection Wizzard?

The name of my folder on the C: Drive is NEPhotos

Can I do it with a SQL statement

I have searched around for where and how to do it, but so far got nowhere.

Thanks Again Guys.

Old NASA Kid

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Duane Hookom 26,935 Volunteer Moderator

In all honesty we have never been made aware of project requirements, statement of purpose, scope, number of users, security, how the application needs to be updated and distributed, how data changes will be handled, etc. I have asked but never been answered. How can we get you somewhere when we really have no idea of where you are going. It's like we are in the back seat of a car offering directions without a clear understanding of our final destination. We know full well how to drive and shift and obey traffic laws and navigate but the drive often makes the same mistakes, doesn't seem to hear, plays the radio too loud and doesn't respond. Apparently the driver knows how to drive a tractor in a field but we are in a nearly self-driving car.

I have also suggested several times that based on your need for distributing this application across many locations with limited resources and who knows what age of computer, you should consider a web based application. This would allow for instant updates to all users worldwide, You could restrict access if needed. There would be absolutely no cost to any end user unless you wanted to charge a subscription. Images would be available to all users as long as they had a computer, tablet, or phone connected to the internet. No installing anything anywhere.

If you want to continue down the Access path, please consider creating one new thread with the information I suggested in the first sentence above. Also provide what you currently have which I believe is thousands of images.

0 comments

Answer accepted by question author

Anonymous

I re-vitalized an old form, with two jpg-files:

For future use, you can even enlarge the pictures using the Zoom+ button:

So, in principle it works, but only with a valid file-specification.

Imb.

0 comments

Answer accepted by question author

Anonymous

Me.Image25.Picture = strFile ?????????????

Hi T.Z.,

If strFile contains the full filespecification, including drive and filetype, it should work

Imb.

0 comments

74 additional answers

Anonymous

2023-07-26T07:02:03+00:00

I got it to work, I always have problem with scripting, but I got it.

To give you an idea of what is happening, the images of the blood samples come in from all over the world.

Saying this many times they are too small and we have to make them larger.

What you sent me the image moves back and forth on the form, I need it to be larger, however it is not all a waste because I learned a lot.

Hi T.Z.,

What do you mean with "back and forth on the form". Is it placed on a shifted position instead of in/decreased? Or is it hidden behind an other control?

Btw, a control is any object in the graphical userinterface that can "control" the program: Textbox, Listbox, Commandbutton, ...

When you have other controls on your forms, this can interfere with increased size of your image control. Maybe it is better to show the image in a separat form with only the image control.

But you got it to work?

Please ask your next questions to make this project a success, preferably in a new thread.

I have specialized in working with dynamical solutions in Access. If necessary, your Amsterdam collegues could contact me for a visit.

Imb.
Was this answer helpful?

0 comments No comments
Anonymous

2023-07-26T03:59:17+00:00

Imb:

I got it to work, I always have problem with scripting, but I got it.

To give you an idea of what is happening, the images of the blood samples come in from all over the world.

Saying this many times they are too small and we have to make them larger.

What you sent me the image moves back and forth on the form, I need it to be larger, however it is not all a waste because I learned a lot.

The pathologists throughout the world feel that people are saying that there are about 8,000 known illnesses and diseases, Our pathologists believe it is only about 5,000 and they want to use this to compare the pictures on the blood samples. All of the medical associations have every hospital in the world to send us only .JPG formats.

I also think I understand what a control is now.

I get up very early, so I am going to try to multiply the numbers together.

I have already designed several forms to try to make the images larger.

Thanks for everything, I will try to keep you updated and for the record there are three of us working on this plus hospitals in Australia, Indonesia, Italy and The Netherlands.

It is unfortunate but many of our male veterans are leaving the country, it is J.J.'s job to try to stop it. He is also an Assembler Programmer, The Old NASA Kid programmed for many years at NASA, but like me is also weak in Access.

T. Z.
Was this answer helpful?

0 comments No comments