Thanks Crystal, what part of your rSql function writes all the statement
to the debug window? In any case I put a breakpoint at the line rSql S
in said function and copied the value of the S string variable into a
new SQL view of a query and the view gives me 1035 records so I suppose
if the append query were to run then the DirPath table would have 1035
records appended to it but instead, when all the code has run, it only
has 1 record with only the datAdd field filled while the other four
fields remain empty. You say the DirPath table does not have any such
deletion rule but then why if you try to delete its single record, you
can't while you can delete records from the Files table for example?
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@...> wrote:
>
> Hi Giorgio,
>
> thanks, Giorgio! I agree, Wayne's code is amazing!!! I would like to
see your database when it is done :)
>
> my function to run SQL writes all the statements to the debug window
so you can press Ctrl-G when the code is done to see them all.
>
> If the SQL statement executed, it will have a dashed line below with
the time it took and the count of the records that were affected. If
there are no stats below the statement, then something is wrong with it.
>
>
> You can copy the SQL statement from the debug window to the SQL view
of a query to find out what is going on and why the values were not
written.
>
>
> > "DirPath table, for some reason, doesn't allow deletion of its
record"
>
> the table does not have any such rule.
>
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
> ________________________________
> From: giorgio_rovelli no_reply@yahoogroups.com
> To: MS_Access_Professionals@yahoogroups.com
> Sent: Wednesday, September 12, 2012 2:59 AM
> Subject: Re: [MS_AccessPros] search
>
>
> Fantastic stuff Crystal [:)]
>
> I've tried it out on a folder that has subfolders leaving the search
> open to all files (*.*)
>
> I was expecting this code
>
> S = "INSERT INTO DirPath ( DirID, NumDirs, SizePath, NumFilPath )
" _
> & " SELECT D.DirID " _
> & " , Count(d2.DirID) " _
> & " , Sum(d2.SizeDir) " _
> & " , Sum(d2.NumFilDir) " _
> & " FROM Dirs AS D, Dirs AS d2 " _
> & " WHERE (Left([d2].[FPath], Len([D].[FPath])) = [D].[FPath]) "
_
> & " AND D.RunID=" & gRunID _
> & " GROUP BY D.RunID, D.DirID;"
>
> in the Public Function ListFilesToTable to create a row in the DirPath
> table and it does but why is only the datAdd field filled while the
> other four fields remain empty since the Dirs table created in my case
> has 1035 records? Does it have anything to do with the fact that the
> DirPath table, for some reason, doesn't allow deletion of its record?
>
> Now I have brilliant code written by Wayne Phillips that gets
additional
> file properties that are exposed by Windows such as the Date and Time
a
> picture was taken, or the Length of an MP3 file ... so I will update
> this database to include these new treasures (smile) ... sometime!
>
> Hopefully that will happen soon [:D]
>
> Giorgio
>
>
> --- In MS_Access_Professionals@yahoogroups.com, Crystal
> strive4peace2008@ wrote:
> >
> > Hi Youssef,
> >
> > check out this free tool :
> >
> > ListFiles Database
> > by and modified by Crystal
> > http://www.AccessMVP.com/strive4peace/DB_ListFiles
> >
> >
> > You give it:
> > - a directory -- ie: c:\, d:\myData
> > - checkbox to include subdirectories or not
> >
> > - a file mask to search for -- ie: *.jpg
> >
> >
> > Warm Regards,
> > Crystal
> >
> > *
> > (: have an awesome day :)
> > *
> >
> >
> >
> > ________________________________
> > From: Youssef
> >
> > i need a code to make the following:-
> >
> > 1- search for a file with no certain type in my computer
> > 2- copy this file to a certain folder i decided previously
> >
> > reason
> > i designed a database to be used as an archiving system and the old
> scanned documents spread all over my computer and i need to collect
them
> in a certain folders according to my work needs.
> >
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar