Hi
I made up a small sample for you that will recurse the directory(ies) depending on where you start the search from. ( see code )
The table tblFiles stores all the names & paths of the files. You can use the table as a record source for a listbox.
Give it a try as follows: from the debug...
Good morning
I had begun to put something together regarding Access commands, but did not have a chance to finish it. Possibly, if you do vave a chance to finish it please post it back.
Best regards
Maurice
Sometimes if you have used a certain font on the development machine that is not available on the other users machine, you may end up with strange display results.
Good afternoon
Sorry for the tardy respose, I've been away for a few days. I've tried coding the app for resorting the columns, however this seems to affect the Bookmark.
The best way to sort the columns is to place the cursor in the field - i.e. Order, then right click then select Sort...
Your command line would be something like this:
DoCmd.OpenReport "rptDetails", _
WhereCondition:="RecordID=" & Me.RecordID
or you can create a query to print only the current record
Create a form and enter your dates there, then reference the form and the control name(s) on your report.
i.e. Frm_Dates
txtStartDate, txtEndDate
then your references will be Frm_Dates!txtStartDate and Frm_Dates!txtEndDate
When you share a database in Microsoft Access and try to update a record
that another user has already updated, your update is not successful, and
you receive the following error message:
Data has changed; Operation stopped.
After you click the OK button, you receive the following...