change location picture - Images in Microsoft Access


	Back to Images Comments List

Upload Images @Reply Bookmark Link Email

change location picture

Ludwig Willems

17 months ago

According to Richard, the place where the photos are kept should be the same for everyone. Ultimately everything will be on the server, but to work on it, this will be done at home. At home on the PC itself it is "C" but at work on the server it is "M". Is it not possible to create a text field on the form where you have the choice of C or M and that this is read in and added to your path as a read-in from where the photos should be taken. When you come to work, you simply change the path to M. If you work at home, you change to "C". is this possible??

Adam Schwanz @Reply

17 months ago

You could make a button like this.

    Dim X

    Dim RS As Recordset

    Set RS = CurrentDb.OpenRecordset("Select * From Table1")

    

    While Not RS.EOF

    RS.Edit

    X = Right(RS!TextF, Len(RS!TextF) - 1)

    X = "M" & X

    RS!TextF = X

    RS.Update

    RS.MoveNext

    Wend

    

    RS.Close

    Set RS = Nothing

That would go through and change all the links to M, then you could copy/paste the button and change the M to C to do it the otherway

Now if people at work are going to be using the database while you're at home using it, we'd have to do it a different way.

	Ludwig Willems OP @Reply 17 months ago
Hi Adam, great, I'm going to test this out. If I have worked on it at home, I still have to transfer the file to the server, so this should work. Thanks :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Images.