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

Duane Hookom 26,935 Reputation points Volunteer Moderator

2023-07-28T01:53:37+00:00

Holdpath should not be Dim as Image. It’s a string value that is the path to the image. The code I and others have provided doesn’t use Dim as Image. I don’t know where you found that. It’s very simple if you just stick to my code. The only difference might be is if you store the entire drive, folder, and file name in your field.
Was this answer helpful?

0 comments No comments
Anonymous

2023-07-28T00:06:29+00:00
We got it! Here is the code that worked.
```
                    Me.Image25.Visible = False  
                      
                    Me.Image25.Picture = HoldPath  
                      
                    ImgWdth = Me.Image25.ImageWidth  
                    ImgHgth = Me.Image25.ImageHeight  
                      
                    Me.Image25.Visible = True  
                      
                    rst.Edit  
                        rst!Photosize = ImgWdth + ImgHgth  
                    rst.Update
```
When you use .Visible = False it changes something

I am not sure Microsoft wanted it this way, but it works. After you get the number that is not bound to the Image, then you display the image again.

Now I have the file with the smallest whatever number I have so I can find the smallest image. Now all we have to do is wait for the Pakistan file and that will be our final test.

J. J. just came in and said try this and it worked. It is good because he is not an Access fan.

As soon as I can try it with the Pakistani file and it works, we will close this baby out!

Time for a beer!

T. Z.
Was this answer helpful?

0 comments No comments