Notepad to Access 2007

[UnsolvedCoding]

Hey all -

I've got a new one that is baffeling me.

The person whose position I took over wrote a program that grabs information for excel, creates a text file in Notepad and then loads the text from Notepad into Access. Once in Access the information is added to the database and the hyperlink is created.

I can create a hyperlink using view spreadsheet# however that is not the same format as was used before and doesn't always work.

There are no queries used, and the databse was changed so that hidden items were exposed. In short I am trying to figure out how to import info so that the hyperlink creates itself and works.

Ideas?

 

[SkipVought]

hi,

Where's the code that your predecessor wrote?

BTW, hyperlinks do not auto create, ex nihilo.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[UnsolvedCoding]

Thats part of the problem. There is code to show how she got things to Notepad but nothing showing what happens when the text file gets imported to Access.

Unhiding items in Access doesn't show any queries or macros so at this point the assumption is it has to do with the exact wording in Notepad.

Each line in Notepad is to hold the same information, if information is missing it is simply skipped. Information is seperated by vbtab.

Here is the original wording

Juvenile 4118765 1178973 7/26/2008 48 J30 2009 C:\Program Files\2008\2009\Juvenile.xls JG


And here is my wording

Juvenile 4118765 1178973 7/26/2008 48 J30 2009 View file#\\C:\Program Files\2008\2009\Juvenile.xls JG

My wording usually - but not always - creates a hyperlink.

 

[UnsolvedCoding]

By the way, I found out last night that View file# and View Spreadsheet# would change the wording on the hyperlink and have since gone to view file#