Functions displaying #Name

[SJCYork]

Hi

I have just starting using PDFCreator to create PDF via code. However some users are reporting problems where the Format Function is being used. It displays #Name when formatting a date and Currency amount and an integer with leading zeros. It seems to be mainly in reports at the moment.

I think its clashing with either another Format function in the PDFCreator library or its the order of the references.

I have tried moving the order of the references and removing some that are not needed any more.

Anyone have the same problem and resolved it?

Thanks

 

[HiTechCoach]

on the machines having an issue check to see if there are any missing references.

 

[darbid]

I remember having a similar problem where a basic VBA function was not working.

I agree with HiTechCoach that it might be a missing reference.

But I recall that I also found that I had a corrupt form.

This means that things like compacting/decompiling are in order.

Also IMHO when I get problems like this I make a new MDB and import all objects into the new MDB and add all references again. I think it helps a lot and my MDB goes on an instant diet as far as size is concerned as well.

 

[SJCYork]

Thanks for your help.

I got round it by removing the functions from the calc controls, creating an on format event and then specifying the library the function came from in the code. so:

me.txtDate=vba.date()

or me.txtCustID = vba.format(.....

Works ok now.

I think the missing reference is probably right as not everyone has PDFCreator installed yet.

Thanks again guys

 

[HiTechCoach]

Thanks for your help.

I got round it by removing the functions from the calc controls, creating an on format event and then specifying the library the function came from in the code. so:

me.txtDate=vba.date()

or me.txtCustID = vba.format(.....

Works ok now.

I think the missing reference is probably right as not everyone has PDFCreator installed yet.

Thanks again guys

The way I prefer to get around not every workstation having the PDFCreator installed is to use Late binding. This allows you to NOT set the reference (earily binding).

I nthe code that using the PDFCreator , I also check to see if it is installed. If not, then do not run the code that uses the PDFCreator libriary.