Odd Error Message

[Kalisto]

I modified a form, so that from the OnOpen method, it does a DLookup to get a path to a logo from the database.

This is then displayed on the page. On all of the PC's in the office this works a treat.

However, on 2 laptops out in the field, the users are seeing the following "Visual Basic Cant convert the Datatype of one of the Arguments you entered" And then it displays a macro halt message box.

Has anyone any ideas why these 2 machines are complaining? (My initial thought was folder permissions, but all the info is being pulled out of the database.)

Cheers

K

 

[Crowley16]

I think the clue lies in the "out in the field" bit...

try testing that a client can access the logo first, before drawing the logo onto a form...

--------------------
Procrastinate Now!

 

[Kalisto]

The issue now is that I am not an access programmer..

I know that the logos are on the PC, and in the path that is expected of them, as Ive talked one of them through checking that they can see the logo.

So,any suggestions on
a) How can I protect them if their pc cant see the logo, and
b) How can I then rectify the issue

would be greatfully received

Cheers

K

 

[PHV]

Why not posting your actual code and saying us which line of code is highlighted when in debug mode ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Kalisto]

dim s as string
s = dlookup("logo","defaults")

if s <> "" then

logo.picture = currentproject.path + s
endif

hth.
the issue that really confuses me is why cant the laptop see the logo when its in the same path as on my pc

k

 

[JoeAtWork]

Try this:

logo.picture = currentproject.path & s

 

[Kalisto]

I will try that, but I dont see why the + or & would work on some and not on others. I think that the issue is more fundamental.

Currently Ive given up using the vba and Ive a sub form on the page that needs the logo, and a macro that pulls data from that and populates the image.

It works on mine so ...

K