How to build an ODBC Connection

Anonymous
2023-07-13T21:47:21+00:00

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

Microsoft 365 and Office | Access | For business | Windows

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 Reputation points Volunteer Moderator
2023-07-17T13:32:34+00:00

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.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2023-07-16T21:14:38+00:00

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

Image

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

Image

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

Imb.

Was this answer helpful?

1 person found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2023-07-16T20:19:59+00:00

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

Hi T.Z.,

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

Imb.

Was this answer helpful?

1 person found this answer helpful.
0 comments

74 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-27T12:59:49+00:00

    I am going to inform the pathologists today that we may have to insert a column in our Names of Blood Samples Table a one character code for very hard to read samples.

    Hi T.Z.,

    Please don't use a one character code: the users must know whatr that means.

    Instead use a firm definition, e.g. "Hard to read".

    Time for "Coding" to save diskspace, or use of Assembler, are over nowadays.

    Imb.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-07-27T12:19:26+00:00

    Mr. Hookum;

    Yes we know that;

    Somewhere with the 8,000 images we have between 80 % and 90 % are not a problem; One of the COVID blood tests the spores could only be seen on 75" monitors.

    I am going to inform the pathologists today that we may have to insert a column in our Names of Blood Samples Table a one character code for very hard to read samples.

    One thing I am very happy about is how with every one of us working together came up with a solution, maybe not a 100% perfect solution, but it should answer at least 85% of the questions!

    Maybe the best suggestion was using a Command Button to increase the size of the image. I also feel that my list box to help locate the sample was a good idea.

    I just hope that the doctors, J. J. and the Old NASA Kid like all of them, now that they are back.

    Morocco threw the last tough one back at us, which I do not know what to do with. It appears that pixels take up a lot of memory. One pixel can be two bytes or in some rare used colors three bytes. Now that I know what I am doing, much of this has to do with the size of the image on a form?

    When I ran tests on what IMB gave us (a brilliant idea by the way) I noticed that it could go up to the number of twips. When I increased the area for the image, it would increase the number of twips it could display. Therefore I am under the opinion that the size of the image allocated on the form increases the clarity.

    I am going to rearrange the form today to move the list box and the buttons to make as much room possible for the image area to be a large as possible in the middle of the form.

    J.J. did design a second form to display the image, when the image on the first form was too small, you can click on it and a second form appears with just the enlarged image.

    I am using a sample database the State of Nebraska sent us, but I am still testing the form with the new test database. I am thinking if I combine the ideas IMB and J. J. gave me combined, I am hoping for the perfect solution.

    I am not an Assembler programmer and will never want to be one, but if we have to go in that direction (for now I do not think so) I understand this will make a difference.

    You guys have been very patient with us; I retrospect I do not think we really knew what a control is, now we have a much better idea.

    Thanks Again!

    T. Z.

    Was this answer helpful?

    0 comments