Hi Clive, thank you, yes, I did intend to upload
ListFiles_080323_Crystal.zip because I don't have a file of my own, I
was just trying out Crystal's mdb and found the problems I outlined.
Are you able to delete any records from the DirPath table of the mdb
I've uploaded(which is basically Crystal's mdb ListFilesToTable function
run on my pc's c:\access folder)? And also why only the datAdd field in
the DirPath table gets filled while the other four fields remain empty?
Can you spot what part of the code writes all the statements to the
debug window?
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...>
wrote:
>
> Hi Giorgio,
>
> Did you intend to upload "ListFiles_080323_Crystal.zip" ?
>
> Crystal wanted you to upload your database.
>
> Regards, Clive.
>
> --- In MS_Access_Professionals@yahoogroups.com, giorgio_rovelli
no_reply@ wrote:
> >
> > I've uploaded the file to the 2_AssistanceNeeded folder.
> > I do see the output in the debug window, I was just wondering what
makes it go there, since I don't see any statement in the rSQL function
that would carry that out.
> >
> > Giorgio
> >
> > --- In MS_Access_Professionals@yahoogroups.com, Crystal
<strive4peace2008@> wrote:
> > >
> > > Hi Giorgio,
> > >
> > > DirPath has no related tables. You should be able to delete
records with no worry. Can you post your database so I can see what the
problem is?
> > >
> > > > "what part of your rSql function writes all the statementto the
debug window?"
> > >
> > > it doesn't really matter which statement does it ... turn on the
debug window and you will see everything :)
> > >
> > >
> > > Warm Regards,
> > > Crystal
> > >
> > > *
> > > (: have an awesome day :)
> > > *
> > >
> > >
> > >
> > >
> > > ________________________________
> > > From: giorgio_rovelli no_reply@yahoogroups.com
> > > To: MS_Access_Professionals@yahoogroups.com
> > > Sent: Thursday, September 13, 2012 9:06 AM
> > > Subject: Re: [MS_AccessPros] search
> > >
> > >
> > > 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]
> > > >
> > >
> > >
> > >
> > >
> > >
> > > ------------------------------------
> > >
> > > Yahoo! Groups Links
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
>
Tidak ada komentar:
Posting Komentar