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