Format$ error

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

Using access 2003 using 2002-2003 format, my reports work just fine. Macro
Security is set to low on both computers.
I have a user which I converted also to Access 2003 because I hoped this
would solve the problem.
She gets error messages: Format$ ?
=Format$([weDATE],"Long Date",0,0)
as well as on: StrConv?
=StrConv([EmployeeName],3)

I am assuming something is not loaded properly.
Anyone know what it could be?
Annelie
 
Thank you,
Did some searching in the mean time in the setupconfig group, I found that
answer also. So I went through the libraries and it had a missing Excel 11
library. Which makes sense since this girl has only office 2000, but we
bought access 2003. I replaced the Excel 11 with Excel 9 library and now
everything is working fine.
Annelie

Wayne Morgan said:
It sounds like a reference problem. Here is a good source of information
about this.

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Wayne Morgan
Microsoft Access MVP


Annelie said:
Using access 2003 using 2002-2003 format, my reports work just fine. Macro
Security is set to low on both computers.
I have a user which I converted also to Access 2003 because I hoped this
would solve the problem.
She gets error messages: Format$ ?
=Format$([weDATE],"Long Date",0,0)
as well as on: StrConv?
=StrConv([EmployeeName],3)

I am assuming something is not loaded properly.
Anyone know what it could be?
Annelie
Click to expand...
Click to expand...
 
Where are the references stored? On the local computer or in the database.
I download the database to my computer once a week because I am still making
changes and additions to it.
Do we have to keep resetting the libraries?
Annelie

Annelie said:
Thank you,
Did some searching in the mean time in the setupconfig group, I found that
answer also. So I went through the libraries and it had a missing Excel 11
library. Which makes sense since this girl has only office 2000, but we
bought access 2003. I replaced the Excel 11 with Excel 9 library and now
everything is working fine.
Annelie

It sounds like a reference problem. Here is a good source of information
about this.

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Wayne Morgan
Microsoft Access MVP


Annelie said:
Using access 2003 using 2002-2003 format, my reports work just fine. Macro
Security is set to low on both computers.
I have a user which I converted also to Access 2003 because I hoped this
would solve the problem.
She gets error messages: Format$ ?
=Format$([weDATE],"Long Date",0,0)
as well as on: StrConv?
=StrConv([EmployeeName],3)

I am assuming something is not loaded properly.
Anyone know what it could be?
Annelie
Click to expand...
Click to expand...
Click to expand...
 
So what is the recommended way of handling the situation of various versions
of office or access?
I just re-installed my excel from Office 2000 to resolve this particular
issue. But in January I will have another user who has Office 2003. Can you
just copy the library files from one version to another?
Annelie
 
Use late-binding where you don't have to set Excel Object
Library as a Reference. Provided that you use only
features that are avalable in both XL2K0 and XL2K3, you
code should pick up whichever available on the PC.

Check Access VB Help / your Access VBA books on late-
binding.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top