🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Do BraZby'ego.

#133811
From: Smyk
Date: Fri, 02 Sep 2016 16:02
27 lines
852 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ê
?

Message-ID: <nqc0p0$9l5$1@news.albasani.net>
Path: polish.pugleaf.net!archive.newsdeef.eu!apf1.newsdeef.eu!news.usenet.farm!..!..!not-for-mail
References: <1vgbj07534ww9$.1sl0ks9vb4qus$.dlg@40tude.net>