Re: Access 2000 to Access 2003

Hi Rachel

The MS ActiveX controls such as common dialog and calendar are very much
prone to breaking and versioning issues, and - as you found - once a
reference is broken nothing works.

The best solution is to avoid these controls. For example:
http://www.mvps.org/access/api/index.html
contains many of the API calls you need for the File Open dialog, system
fonts, the color dialog, and so on. By using the API calls instead of the
ActiveX controls, there is no extra reference to break.

This way you can get by with as few as 3 references, and these normally
don't break when switching version. More info on that:
http://allenbrowne.com/ser-38.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Rachel" <Rachel@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2D0F3996-6BE3-4D00-A629-4A3F4EAD8F65@xxxxxxxxxxxxxxxx
> When I opened my Access 2000 database in Access 2003 I the reference to
> the
> Common dialog control is missing and the code that I wrote has problems
> now.
> Forinstance the Format statement is not recognized. It states that it
> needs
> the proper library to work. Ok, there must be a reference that I need to
> check. I thought that it was attempting to convert the vb to vb.net and I
> attempted to add the System.convert in the code by using the statement
> Imports System.Convert and it is also not recognized. Any help is
> appreciated. I know VB 6.0 as well as VB.net and some VBA so please help
> me.
>
> Rachel


.

Relevant Pages

  • Re: Access 2000 to Access 2003
    ... Look for MISSING REFERENCE. ... The MS ActiveX controls such as common dialog and calendar are very much prone to breaking and versioning issues, and - as you found - once a reference is broken nothing works. ... Forinstance the Format statement is not recognized. ...
    (microsoft.public.access.conversion)
  • Re: Date/time picker problem
    ... > Some activex controls need the word object to reference its properties ... > Edhy Rijo ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Broken or missing reference
    ... If you do not use ActiveX controls from MSCOMCTL.OCX - you can just remove this reference ... file in the system32 folder and refresh the link, but I still get this error ...
    (microsoft.public.access.modulesdaovba)
  • Re: VB6 to .NET
    ... One of the requirements of the Migration Tool is that the VB6 project must ... be capable of being compiled clean (with reference to ActiveX controls) or ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Executable for other OSs
    ... Regarding ActiveX controls, I am only using the Common Dialog control ... to show the user the standard File Selector form on start up. ...
    (microsoft.public.vb.com)
Loading