File address and extension

[kolait]

Hello friends
I have a file to import students' photos.
I do not want to use dialogue.
I have three fields in Table 1. Student code. student's name. Student photo address
At the installation location there is a folder called one where the user has to put all the photos.
With a query, I extract the location of the photo along with the name of the photo and place it in the address of the photo.
As :
[CurrentProject]. [Path] & "\ 1 " & [Table1]! [B] & ".jpg"


But the question and the problem:
If the user puts the photos in another format in the folder, it will not be placed in the address. What can I do to fix this problem or what is your suggestion?

[Welshgasman]

Look for other image formats?
Make them use .jpg only?

[kolait]

Look for other image formats?
Make them use .jpg only?

==============
I want the photos to be in any format and be included in the path along with the photo address.
With this query, only GPG files are imported.
How do I add other formats to the address?

[kolait]

==============
I want the photos to be in any format and be included in the path along with the photo address.
With this query, only GPG files are imported.
How do I add other formats to the address?

I want the photos to be in any format and be included in the path along with the photo address.
With this query, only GPG files are imported.
How do I add other formats to the address?

[Welshgasman]

Why not filedialog???

[Micron]

Don't have time to download right now, but why not use something like Left(strThePath,Instr(strThePath,".") & Mid(strThePath,Instr(strThePath)+1) ?
If I have that wrong, the logic is
- get everything up to the period and use that for the first part
- get everything after the period
- concatenate those values

[kolait]

I want to import photos for a thousand people ..
With one-on-one dialogue, you have to choose which takes a lot of time

[kolait]

Thanks for taking the time.
I do not know these ..
Can you help in the sample file format?

[Welshgasman]

So as micron infers, look for the . that separates prefix from suffix and hope all those files are graphical?

[moke123]

Tried to open your zip file but I get an error that it is empty or corrupt.

[kolait]

Yes, everyone in the folder is graphic

[Micron]

Turns out momma gave me a few minutes. Try this in your button click event

Private Sub Command45_Click()
'MkDir CurrentProject.Path & "\photos"
Dim Path1 As String, Path2 As String, FullPath As String

FullPath = DLookup("h", "table2", "ID=1")
MsgBox FullPath

Path1 = Left(FullPath, InStr(FullPath, "."))
Path2 = Mid(FullPath, InStr(FullPath, ".") + 1)


MsgBox Path1 & Path2
End Sub

Both messages should be the same. First is just what's in the table for ID1. Second is the second part of the string concatenated onto the first part of the string. So if the pic is a gif, that's what you should get.

[kolait]

Tried to open your zip file but I get an error that it is empty or corrupt.

File modified

[kolait]

Thank you, but it was not done

[Micron]

Thank you, but it was not done

That means what and was directed to whom?

If I change the table record from jpg to gif, I get exactly what you seem to be asking for. If you're asking how to implement this once it's figured out, you didn't say that. If that's to be in a query, then don't specify the file extension in your query, just use LIKE Operator. I would have made a suggestion but in your example you use Table1.B but that field has nothing in it that resembles a picture file name or its extension.