espenskaug

I have two questons?

1) how do i call on information in a folder using vba. Eg. Dlookup ("[productname]", "c:/my documents/images/"??????, "[productid]")
(how to access and use information outside the databases)

2) how do i match a field in a table with pics in access. (i have 6000 pics that need to be linked/reached in a access form) i am trying to access these pics without physically put 6000 pics into an ole table??

please help!!!

Robby

Follow this link, I explain how it can be done.

Robby

OOPs, forgot to answer Q1.....

I never used Dlookup, but maybe you can take the logic from an INSERT INTO.....

"SELECT Field1, Field2 INTO OtherTable1 IN 'c:\OtherDatabase.mdb' FROM ThisTable1 WHERE Field2= '" & strText & "'"

espenskaug

thanks, you saved my superbowl day weekend?