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 No 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 No 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 No 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 No comments

74 additional answers

Sort by: Newest
  1. Anonymous
    2023-07-27T14:23:16+00:00

    IMB

    You had told me that your example ob the Command Button was not in pixels. I tried to find the mathematical method you used, but just too many responses. Now that we are close to where we want to get to, do you think we should open a new case?

    Yo example changes the size of the Image on the form. Since everyone is using pixels, do we want to try to change them or convert your formula to pixels?

    Thanks

    T. Z.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2023-07-27T14:05:36+00:00

    IMB:

    I have been using the Zoom like you recommended. I looked at all 33 images and on 4 there was a noticeable difference.

    On the test that the State of Nebraska sent us I noticed that many of the images have a large white border around them that the image takes into consideration.

    Now saying this, none of the 33 actual blood images have that border around them.

    I have a call into the IT department at the SAC Base to see it they or the State of Nebraska can assist us. It is critical for that State because they have had a fatality in which this application hopes to address.

    I tried messing with Microsoft Paint and that has become extremely frustrating.

    On the programming side, when you increase the size of the image on the form it increases the size of the image. I am looking at:

    variable Name = Me.Image.Width. So every image, large or small appears as 14300 x 12870.

    When I tried to remove the White Border in Paint to see if it would make a difference, It would not let me remove the white border.

    My next test is going to involve your Command Button Test to see what happens there.

    The pathologists will be here at 1:30PM Central Time.

    Thanks Again

    T .Z .

    Was this answer helpful?

    0 comments No comments