PDA

View Full Version : project cd catalog?



balloon
02-09-2007, 05:44 AM
I do a project as smart cd catalog.
save by access database
programming by access
I only solve some problems of project.
I don't know clearly about phasing code.:think:
I hope any help from members.:help
Thank you very much.
Regard.

lucas
02-09-2007, 09:31 AM
Moved to access forum

OBP
02-09-2007, 12:29 PM
Can you explain what it meant by "Phasing Code"?
For us to help you it would be best if you post a ZIPPED copy of the database as an "Attachment" to your post using the Go Advanced and Manage Attachments Buttons.

balloon
02-09-2007, 10:32 PM
database

OBP
02-10-2007, 09:01 AM
Balloon, I have looked at your database, the Table and Relationship setup looks OK.
So what do you want to do with it that you can't do?

balloon
02-12-2007, 03:56 AM
:help I don't know much about vba. I have a problem.
I code for a scan button, it add directory list in table 'detail'.
I only code to add 1 disk.

1. I want to add folder in table, my code only add file.
2. And I need to add 'IdParent' to determine levels and use 'IdParent' to display treeview (tree directory list) as windows explorer.
3. I want to take information disk to add to table 'disk'.

I need to help about code for 1, 2, 3.

Thank you very much.
Regards.

OBP
02-12-2007, 04:42 AM
For someone that doesn't know much about VBA you have certainly done a very good job on your Scan button.
In your FileSearch routine the "FoundFiles(x)" should contain the "Complete" Path of your file.
You can use this "String" to obtain the "Folder" that contains the file.
Is that what you want to do in Question 1?
It also contains the disk which you want to add to your "disk" table.