calling dwg. name in Line List from Components-Process Line

Hi,

Recently I downloded a "Line List Template" from Mr. Kyle Pope's site. this template gives a list as shown below

TAG_ P&ID
1 1/2"-CG-2145-AS4-H2E US012629.DWG
1 1/2"-CG-2185-AS3-H2E FROM US012629.DWG - TO US012630.DWG

I tryed this one in my MDB, but its not working. I had 6 fields in my PID rather Kyle has 5 fields.

Sample by Kyle : 1 1/2"-CG-2145-AS4-H2E requested as "*-*-*-??#-?#?"

My Line fomat : 4"-NP-900-214-A1A-PP requested as "*-*-900-*-?#?-??"
(third field is a commaan value.)

If I run this query in give a error
"Undefined function `GetDwgFrom' in Expression.

Can anybody solve this problem.

Thanks in advance.

You have to use the VBA from the module in the provided database. To transfer a vba module in Access 2007, go to the external Data tab, click Access Browse to the Line List Template.mdb and click Import tables...and click OK.

In the Import Objects dialog, switch to the modules tab, select the LineListModule. Do you have the LineListModule in your current db?

Hi Dave,

Thanks a lot, it works.

Hi Dave,

Its, working but I found that some of lines are not showing the dwg. nos.

That's the joy of working with the Link Database. If you can add the ID_COUNT_ to the query, you may be able to track them down on the Link Table. I think the blank links in the table are a bug. Unfortunately I haven't been able to isolate what causes them.