pic coding problem

G

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
 
D

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
 
G

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.

Daniel said:
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 said:
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
 
D

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







ghost said:
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.

Daniel said:
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 said:
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
 
G

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.



Daniel said:
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







ghost said:
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.

Daniel said:
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
 
D

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






ghost said:
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.



Daniel said:
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







ghost said:
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
 
G

ghost

thank you a lot
it works

Daniel said:
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






ghost said:
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.



Daniel said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top