pic coding problem

[ghost]

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx

 

[Daniel]

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P

 

[ghost]

hi,
the pic on the network and all company users use the D as a sharing.
the problem is the pics does not appares at the network. i need to write a
code for making the path from the current project
thx.

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx

 

[Daniel]

ghost,

i need to write a code for making the path from the current project? i'm
not sure I follow.

Do you mean the path is relative to the path of the database? Then

Me![ImageFrame].Picture = CurrentProject.Path & "\" & Me![ImagePath].Value

If this doesn't answer your question, you're going to need to explain more,

Daniel P

hi,
the pic on the network and all company users use the D as a sharing.
the problem is the pics does not appares at the network. i need to write a
code for making the path from the current project
thx.

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx

 

[ghost]

The problem is when other users use the database the pic does not appears.
Cause of the database reading the path from my D drive. I need the database
look for the image path from the sheared folder not from my D drive. The
database is shared in LAN. I tried the code but dose not work
Thx.

ghost,

i need to write a code for making the path from the current project? i'm
not sure I follow.

Do you mean the path is relative to the path of the database? Then

Me![ImageFrame].Picture = CurrentProject.Path & "\" & Me![ImagePath].Value

If this doesn't answer your question, you're going to need to explain more,

Daniel P

hi,
the pic on the network and all company users use the D as a sharing.
the problem is the pics does not appares at the network. i need to write a
code for making the path from the current project
thx.

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P





:

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx

 

[Daniel]

So what I said is correct. you need to do 2 things:

1- run an update query to change the currently stored paths (D:\...) to
whatever teh UNC path is to that shared network directory
(server-name\\directory\....). this will fix your current data.

2- Modify your existing code for entering the paths to make the switch form
Local drive to UNC paths. For this you should use the
http://www.mvps.org/access/api/api0003.htm

Daniel P

The problem is when other users use the database the pic does not appears.
Cause of the database reading the path from my D drive. I need the database
look for the image path from the sheared folder not from my D drive. The
database is shared in LAN. I tried the code but dose not work
Thx.

ghost,

i need to write a code for making the path from the current project? i'm
not sure I follow.

Do you mean the path is relative to the path of the database? Then

Me![ImageFrame].Picture = CurrentProject.Path & "\" & Me![ImagePath].Value

If this doesn't answer your question, you're going to need to explain more,

Daniel P

hi,
the pic on the network and all company users use the D as a sharing.
the problem is the pics does not appares at the network. i need to write a
code for making the path from the current project
thx.

:

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P





:

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx

 

[ghost]

thank you a lot
it works

So what I said is correct. you need to do 2 things:

1- run an update query to change the currently stored paths (D:\...) to
whatever teh UNC path is to that shared network directory
(server-name\\directory\....). this will fix your current data.

2- Modify your existing code for entering the paths to make the switch form
Local drive to UNC paths. For this you should use the
http://www.mvps.org/access/api/api0003.htm

Daniel P

The problem is when other users use the database the pic does not appears.
Cause of the database reading the path from my D drive. I need the database
look for the image path from the sheared folder not from my D drive. The
database is shared in LAN. I tried the code but dose not work
Thx.

ghost,

i need to write a code for making the path from the current project? i'm
not sure I follow.

Do you mean the path is relative to the path of the database? Then

Me![ImageFrame].Picture = CurrentProject.Path & "\" & Me![ImagePath].Value

If this doesn't answer your question, you're going to need to explain more,

Daniel P







:

hi,
the pic on the network and all company users use the D as a sharing.
the problem is the pics does not appares at the network. i need to write a
code for making the path from the current project
thx.

:

Where is the pic stored? On your pc or somewhere on your network? Both can
present issues.

The PC:
Big no no! Make sure they are store on the network where everyone has
access. Always keep in mind the permissions setup on the folder you place
them in (you may have to speak with your network admin).

The Network:
The issue with the network is that in many companies each user maps the
drives themselves and thus each user has a different name for the same drive.
Thus you may refer to drive d:\ in your path when John right next to you
calls it X:\. The solution is to always use UNC drive paths (eliminates the
issue altogether). For this take a look at:

http://www.mvps.org/access/api/api0003.htm

I'm going on but you also didn't give the error.

Hope I hit the bullseye

Daniel P





:

Hi,
I have a database on LAN. There is a form used to show employee pic. On my
pc the pic working, but on the LAN it is not. I use the blew coding but stall
not working
Private Sub Form_Current()
On Error Resume Next
CurrentProject.Path Me![ImageFrame].Picture = Me![ImagePath]
can any body help me
thx