Re: Do BraZby'ego.

Article View: pl.comp.bazy-danych.msaccess

Article #137274

Back to pl.comp.bazy-danych.msaccess Previous Next

#137274

From: Smyk
Date: Fri, 02 Sep 2016 14:02

28 lines
1925 bytes

Jacek wrote at Fr 02.09.2016 12:24:

> Cześć Zbyszku.

Jam co prawda nie Zbyszek, ale pozwolę sobie zabrać głos ;)

> Set rs = db.OpenRecordset("Buchalter")
> rs.MoveLast
> rs.MoveFirst
> For x = 1 To rs.RecordCount
>     If rs.Fields("Archiwizowac") = True Then
>         Kat = rs.Fields("Katalog")
>         MkDir ("G:\" & Data & "\Buchalter\" & Kat)
>         k = "Xcopy F:\Buch\" & Kat & " G:\" & Data & "\Buchalter\" & Kat &
> \ /E /Y /H"
>         s = "F:\Buch\" & Kat & "\"
>         d = "G:\" & Data & "\Buchalter\" & Kat & "\"
>         fobj.CopyFolder s, d, True ' tu się wywala, że nie znalazł ścieżki
>         Exit For
>         'q = Shell(k, vbHide)
>         'Sleep (1000)
>         qq = SysCmd(acSysCmdSetStatus, Kat)
>     End If
>     rs.MoveNext
> Next

Czy masz w polu "Katalog" tabeli "Buchalter" wartości które zawierają spację 
?

Technical Details

Message-ID: <nqc0p0$9l5$1@news.albasani.net>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail

References: <1vgbj07534ww9$.1sl0ks9vb4qus$.dlg@40tude.net>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.mixmin.net!news.albasani.net!.POSTED!not-for-mail
From: Smyk <duzy.trzmiel@onet.pl>
Newsgroups: pl.comp.bazy-danych.msaccess
Subject: Re: Do BraZby'ego.
Date: Fri, 02 Sep 2016 16:02:07 +0200
Organization: albasani.net
Lines: 28
Message-ID: <nqc0p0$9l5$1@news.albasani.net>
References: <1vgbj07534ww9$.1sl0ks9vb4qus$.dlg@40tude.net>
Mime-Version: 1.0
X-Trace: news.albasani.net DWt36nn93FQySvDAl+xToZnpyMcGPLdEKQPhM6Jt4CxeS8Mj+SVlhst5tDkWRaiQpQS1DpIZOFwr70FcTLxVGg==
NNTP-Posting-Date: Fri, 2 Sep 2016 14:02:08 +0000 (UTC)
Injection-Info: news.albasani.net; logging-data="CcuwkGog7dIkVausbwqIoiFqV7UE9vw4Oi1CjFzDvlha+sG4/FC+UJDkoB98DfEx1DCrJ3apx9u5lYq3UPnZ1RErliPq4YKY9MA+Bd3dWq1re5PHjA0iwQ0BlGP96B2K"; mail-complaints-to="abuse@albasani.net"
User-Agent: KNode/4.9.5
Cancel-Lock: sha1:thj7DJbD/XH0WMR9Y1MOn7AlKD4=
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message