Hope you can help fix this

H

headintheclouds

Registered User.

Local time

Today, 01:31

Joined

May 2, 2005

Messages

24

• Jul 6, 2006

• #1

Hi there

Not to good at VB but it's something i want to learn so I hope you can help me. I have attached a database I am working on, i have designed a form (roughly for now) and managed to modify some vb code as to be able to browse files on a pc and select the directory path of the folder. This works great but heres were am stuck I want to store the directory path into the record. As each record will have a different file path.

Hope you can help

P.S Using Access 2003

 

Attachments

• Audit Database.zip

  55.8 KB · Views: 152

S

Studentos

Registered User.

Local time

Today, 03:31

Joined

Dec 23, 2005

Messages

38

• Jul 6, 2006

• #2

Try this in debug window (Ctrl+G):

xx = "C:\xxx\ccc.bbb" : ? Left(xx,instrrev(xx,"\"))

 

ghudson

Registered User.

Local time

Yesterday, 20:31

Joined

Jun 8, 2002

Messages

6,194

• Jul 7, 2006

• #3

Look at the ParseFileName() code I have in my browsing sample where you found the code you are using. I am not using the parts that extract the location of the select file but the sPath = Mid$(sPath, Len(sDrive) + 1) line should give you want you want.

 

H

headintheclouds

Registered User.

Local time

Today, 01:31

Joined

May 2, 2005

Messages

24

• Jul 7, 2006

• #4

Thanks ghudson worked like a dream once I had seen that...many thanks mate

HITC

 

ghudson

Registered User.

Local time

Yesterday, 20:31

Joined

Jun 8, 2002

Messages

6,194

• Jul 7, 2006

• #5

Another satisfied customer!