|
-
Jun 29th, 2006, 07:10 AM
#1
Thread Starter
New Member
VB script in Acces
Please help me out...
On a network share I have pictures of employees. Name of picture is "<employeenumber>.gif".
In Access I have a table containing employeenumber, full name etc.
I like to have a query verify if every employee has it's own picture (why? Because it is used on an intranet). The output should contain the employeenumber and full name of persons without a picture.
Now I tried something with:
test: Len(([Dir$](('O:\picture\') & [employeenumber] & ('.gif')))).
where "O:\picture" is the share on the network which contains the images and "employeenumber" is a field in a table.
But this isn't working.
What am I doing wrong?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|