Results 1 to 9 of 9
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    type conversion issue (access 2003)

    Post deleted by gbanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: type conversion issue (access 2003)

    You should specify YMD instead of YDM as date order.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: type conversion issue (access 2003)

    Sorry Hans I mistyped in my posting. I am using YDM not YMD. Can you still adivse? Thanks....

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: type conversion issue (access 2003)

    The import specification in your database has YDM. As I wrote, you should use YMD. The dates will then import correctly - at least they did for me.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: type conversion issue (access 2003)

    In addition, see the annotated screenshot below. The date order should be changed from YDM (the current setting) to YMD.
    Attached Images Attached Images
    • File Type: png x.png (21.2 KB, 0 views)

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: type conversion issue (access 2003)

    Thanks Hans. I got it now. A new morning breads a clearer mind.

  7. #7
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: type conversion issue (access 2003)

    Hans,
    What program do you use for your annotations? I always seem to fumble around when I try annotating screen shots; I use Word but not very effectively.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: type conversion issue (access 2003)

    This one was done in good old Microsoft Paint.
    Many screen capture programs have an option to annotate screenshots; I use FastStone Screen Capture ($19.95) but there are also free utilities - see for example the thread in Other Software Applications starting at <post:=595,580>post 595,580</post:>.

  9. #9
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Chicago, Illinois, USA
    Posts
    116
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: type conversion issue (access 2003)

    Thanks, I'll take a look at these.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •