Re: Access 2000 to Access 2003

Any idea how to solve the formatting problem or other scripting problems?

Forinstance, the Format function does not work and the Right and Mid
functions also do not work. I am not writing super in-depth coding, so it is
frustrating that I cannot do the simple stuff.

"Allen Browne" wrote:

> 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: convert first 6 digits into date
    ... For Each SerialRng In SerialRng.cells ... > I did not know that the FORMAT function could do this, ... >>> 'You must compare Dates with Dates, ...
    (microsoft.public.excel.programming)
  • Re: Installed Hard Disk In Dell Vista Machine Today
    ... any research on it) Amazon usually says how many pages... ... "Fast Format IS NOT RECOMMENDED by Microsoft dumbass. ... the article reference a page in the WVRK Book that you're not talking? ... So there we fucking have it you INCOMPETENT amateurs. ...
    (comp.sys.mac.advocacy)
  • Re: How do I apply a different font to a cross reference?
    ... independent of the format of the reference source. ... Define and apply a character style to the reference fields. ... to be formatted with another type of font. ...
    (microsoft.public.word.docmanagement)
  • Re: Need journal for a short letter
    ... sentence in English to save your soul, all you need to do is re-write ... The format for a scientific paper is ... Also, no journal published failure. ... Be sure to reference the literature. ...
    (sci.physics)
  • RE: Data type issues adding data from vbscript
    ... Thank you for your notes concerning the format function. ... Strings Create your own user-defined string formats. ... I need to add the current date to this excel spreadsheet. ...
    (microsoft.public.excel.programming)