Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250

    Unanswered: Creating DOS command, I can't fill a memo field beyond 339 chars!

    The following code:
    ' cmd for delete from server if exist in DVDimg (ie.)

    'if exist "d:\helps\cd_tulips4\ppt\00002445 Figures 1-3.ppt". (del /f "N:\tulips4\00002445\00002445 _
    Figures 1-3.ppt".) ELSE echo "N:\tulips4\00002445\00002445 Figures 1-3.ppt". didn't copy.

    ' DVDimg = "d:\helps\DVDimg\"

    cmdString = "if exist " & dQ & DVDimg & rstDups(4) & "\" & rstDups(5) & "_" & _
    Format(rstDups(7), "hhmm") & "_" & rstDups(1) & dQ
    cmd2String = ". (del /f " & dQ & rstDups(0) & "\" & rstDups(1) & _
    dQ & ".) else echo " & dQ & rstDups(0) & "\" & rstDups(1) & dQ & ". did NOT copy. "
    rst2Batch.AddNew
    rst2Batch!dosCommand = cmdString & cmd2String
    rst2Batch.Update


    YIELDS:
    if exist "\\Aa830787eb\d$\helps\DVDimg\ppt\369152_1000_ April 25, 2002 Meeting - RC empTheads.ppt". (del /f "N:\abc\abc Functional Area Shared Data\Structures and xyzPDQ\4uImg2sv4_25_02 Meeting\MiscNotes\ April 25, 2002 Meeting - RC empThe ads.ppt".) else echo "N:\abc\abc Functional Area Shared Data\Structures and xyzPDQ\4uImg2sv4_25_02

    PROBLEM: Notice that the truncation of [Meeting\MiscNotes\ April 25, 2002 Meeting - RC empThe ads.ppt". did NOT copy.] The message doesn't get past about 339 characters.

    "cmd(2)String" is(are) locally declared String(s), dQ is char(34) or ", and rst2Batch!dosCommand is a memo.

    Any Ideas?

  2. #2
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,477
    Provided Answers: 11
    Why not Us some Script


    Download the help file
    http://msdn.microsoft.com/library/de...ist/webdev.asp

    in there there is a heaps example which will do every thing you want
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

  3. #3
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Thanks for your reply, but I don't need to script to the best of my knowledge (I know zero about script, and a lot about DOS and VBA).

Posting Permissions

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