Hello I already have a few little automated procedures in my database but what I would like is something where:

I click on a button and it opens a form I put in the Title of the DVD/CD whatever I select the Media Type and he Software Type and the drive the data is to come from...

I then click START...

This then looks at the drive and pulls up the first folder on there and takes its name so if the first folder is called test then the automated procedure will copy this and then paste it into my database in the subtitle field.... It will also replicate the title into the title field,media source and software titles accordingly....

Then afterwads I will do any manual checking and any adjustments needed....

I hope someone can help...

I have attached my database for your convienience.

Any help is much appreciated.

Many Thanks

James

Does anyone know if this is possible or how to achieve this?

Any help would be greatly appreciated!!

James

Yes its possible. And there are a number of threads here at UA that discuss similar techniques.

May I suggest you search around, find the examples, and try to put your functions together.

if you have an SPECIFIC questions or want us to check code you have written, please feel free to post.

HTH

Ok thanks for that I will have a search and see what I can find...

I have had a browse and I cant seem to find anything...

What will the others be under...

I have tried searching for automatic,automating adding records automatically etc.. and I cant seem to find any related posts!

Please could you point me in the correct direction for this?

Many Thanks

James

Try searching on Finding folders or Reading directories. That's the key part of what you want to do.

Hi,

I am looking all over the place and I cant seem to find anything... are there any specific posts I should be looking at that you know of?

Many Thanks

James

Any suggestions from anyone?

Many Thanks

James

Can anyone help me or tell me where I should be looking for this? I cant sem to find it anywhere?

Many Thanks

James

James-

Tell us about the searches you've done, both in this forum and the Access
help file.

It strikes me that, with 456 posts (that's considerable)-- none of them
informative--that you regard this forum as your personal help-file.

Please let us know what you're doing to help yourself.

Bob

p.s.: Is it leech or leach, I'm confused.

Right ok I have tired the searched as above but the thing is because I have no idea what any of the code means I dont know if it helps me or not....
This is why I am needing the assistance in finding somethig specific...

I have done sewarched for automatic,Automation,CD Drive etc and the list goes on...

Please could someone give me something to search for which could return a result that would relate to what I am needing and then I can see if I can progress from there...

James

I suggest you look at ScottGems' response on the previous page. You are going into advanced search and removing the 1 month time limit, I take it?

There IS information here. You just have to find it. Bear in mind that everyone is a volunteer, and we are unlikely to help you if you don't try to help yourself first. I'm not meaning to get on your case - God forbid!! All I and anyone is trying to do is give you a gentle push in the right direction - things sink in easily when you've figured it all out for yourself. We just give you the tools.

That said - I know how frustrating it can be when you're trying to get some help. Look again at what you want to do, and try redefining your search parameters. "File System" is probably a good place to start.

This is NOT going to be plain sailing - what you want to do will require a good understanding of the code and the way Access and Windows works... so if you think this is above your current level of knowledge then I'd recommend reading up on it a LOT first (or getting someone more experienced to do it for you - at a cost, of course!)

Just my $0.02...

Ad

Ok thanks for that I will try yet again searching....

Its my own database that I have created with a little helpe from these forums..... I understand the code thats in them but when it comes to modyfying it I could modify some but not all this is because the people who have helped have explained to me what the code does so I have been picking up bits and pieces... Hence I would like to accomplish this myself for my own personal gain...

I undertstand where everyon is coming from and yes I do understand... but when I am reading the posts and looking at the code I dont know if it will be useful or not to me you see...

I will again have a look but I am just unsure as to what I would search for as these are other peoples posts and I have no idea what there on...

Many Thanks

James

Hello I have found the following code from that search paramater that you have given me...



and I was wondering if I am on the right lines with this?

If I am is there a simple way of modifying the code to something near what I want? And then I could build a form to go with it?

Many Thanks

James

Sorry about the width thing Is there anyway that could be word wrapped?

Thanks

James

I have also found this thread...

This Post

Am I on the right lines?

If so what would I need to do to modify this code to suit my needs?

The code in the above is the one which returns the folder name...

Many Thanks

James

Hi,

You're looking at the first option on that page (in the last link you posted), I assume? The second one displays the standard windows file > open dialog box... which isn't any good for you.

I'd still look at using the file system object for getting the information. There is code somewhere around the site that detects what drive the CD is, too... I'm sure I've seen it around. This would be another piece of the jigsaw...

Ad

You are correct indeed I am looking at the first part of the post...

Am I on the correct lines with my two posts of code?

Can they be modified to work? or pulled together?

I am not to sure I understand wjhat you have said :

"I'd still look at using the file system object for getting the information"

What do you mean by the above?

I will now have a look for detecting the CD...

James

Hello Again...

Hows about this post for the CD Drive Detection?

This Post

Does the code detect the CD Drive or does it do something else as well I couldnt tell from the code or the posts...

If it detects the D Drive does it also put it into a field where I could select it?

If not how could teh code be modified to achieve this?

Many Thanks

James

Hello Again,

I have found the following on MVPS.org...

Link

It detects the Drives...

I was wondering could this be used but could it be used to display also what is in the drive at the time such as the title of the CD like My Computer does....

Then it can list the Drives and the title of the CD/DVD in the drive so its easier for the user to select which one?

I have used what I have found on other posts I have looked at and searched there sites such as MVPS/org...

Thanks Again

James

Woah woah... slow down. Don't run before you can walk. You should understand the code you're going to be using - or at the very least understand the purpose.

Let's take a step back, and look at the big picture for a minute. Why do you need this information - what are you trying to acheive.

Give me an answer to that, and we'll go from there.

Ad

Ok then...

Right what I am wanting to do is to create a button on my main form which would then open another form....

This form which is currenty the active window would have he following:

A combo Box Listing the drives that my computer has (such as my computer does) and the title of the CD (Again like My Computer does)

A field where by I can type in the Title of the thing I am inputting (this maybe diffrent to the title of the actual media displayed in the combo box above). This will be replicated each time a record is added on the current CD/DVD.

A media Type combo box where I select the media type (I already have this) This will then be replicated to each record which is inputter automatically the same as the title field will.

A Software Type Combo Box (again I have one of these) I select this and again its the same as media type where it replicates each time a record is entered....

If any of the fields are not entered it would pop up a msg box stating what is missing and that it needs to be filled in... Then it would start the routine.

Ok...

Now When I have type in the Title and selected the media type and the software type then I would select the Drive to pull the information off....

Ok then I would click the start button on there and what it would then do is it would take the names of each folder in turn and copy that and then paste that into the subtitle field....

That first record would then have the title (put in by the original form),the subtitle and artist (due to the copy and paste of the folder name on the CD/DVD)

Note: The artist is automatically moved accross due to some code which is on the after update event...

Also on that first record it would have the media type and the software type again specified in the form where I clicked start....

Then it would go to the next folder on the CD/DVD.

Until it reached the end...

It gives me a msgbox telling me its finished... then I click ok and it brings up the data its just entered for manual inspection....

Once that been done I can then close that and the data is then put onto the main list....

Then I can go back and do it again for the next CD/DVD....

Does this help?

Many Thanks

James

OK - so let's split this up a bit. The first thing you want to do is get the name of the CD or DVD in the drive, correct? Are these Audio or Data CDs/DVDs?

Ad

Ok it could be either or...

Yes like 'My Computer' does when you insert a CD/DVD..

Does it change the code?

Many Thanks

James

Ah.

Ok. Time to lay it on the line - this is going to require the use of a LOT of APIs to get the information - so it's very advanced stuff.

Can I ask now - WHY do you want to do this? I get the impression that this is for a CD/DVD media library - am I correct?

Ad

Yeah it pritty much yeah....

Right ok basically each week I could get from 1 DVD full of MP3's from my mate... or I could get 10... It is very very very time consuming copying and pasting everything like that in considering its about 400 Copy and pastes if its 10 DVD disks that not including DVD's software n stuff...

Hence I would like a way of making my life easier so I am not trapped at my PC copying and pasteing...

I will still do it if you let me know whats going on and what does what and where it goes...

I am ready lead on my mentor!!

James

So you're looking at something to strip the contents of the disk and copy the contents... I assume onto your hard drive? Or do you just want the disk indexed?

I don't honestly think that Access is the tool you want. Yes, it's probably possible.... but would be a heck of a system to maintain - never mind to build.

There should be some software that can index the contents or something like that out there. I'll have a look later on and see if I can come up with anything. But you should know, I'm going to be very busy at work over the next few days as I've got to take a day off this week (interview) - and have a system to finish off by Monday, so although I'll try to help where I can, I might not be around as much as I have been.

If you want to take this to email, feel free - best email to get me on during "normal" office hours is adaytay@gmail.com, as I can get that from my work pc.

Ad

Addendum... here's one link for you... this the kind of thing you're after? (There's a flash demo that shows it in action too)

HTH,

Ad

Thanks for the E-Mail and the link I will keep the E-Mail thing going and then when its all done I will post the finished article so that if others want this doing then they can have it right here...

Also I just want the names of the folders going into my database not the contents...

As for that link yes something like that is what I want...

But I just want the folder names and thats all in my database...

Are you getting a better understanding of what I am after or am I making no sense?

Many Thanks

James

No you're making perfect sense.

Let me just be absolutely sure I've got it right - you want to set a process running that will trawl the contents of the disk, and copy the folder names (and hierarchical structure) into the database somewhere?

I still think NOT using access is the only way to go. Although it would potentially be possible to create something that would trawl the disk and index it for you (using the File System Object in Access, hence my earlier mention of this), to create something with the level of sophistication you want would require significant programming knowledge and a complex understanding of how Windows works.

To be honest, not even I would attempt to write this program - it's way over my skill level. It would be a heck of a challenge though! My suggestion is to download the free version of the software and see if that's any good for you. Also, google for "Disk Indexer" and see what kind of things get returned.

Ad

Actually, I've just had an additional thought to this. You could potentially hook an access db into the indexer service to feed the information into your database that way.

That might be another route worth investigating.

Ad

Ok I am making perfect sense thats a first for me

Right ok what I want the process to do is to look at the contents of a CD/DVD and pull off the folder names thats all...

I could download the software a free version of it but the thing is I would like it to add it straight into my database and have it run from the database so I can manually check this...

Please could we add this into my database?

Many Thanks

James

Right... What level of folder names are we talking? Top level only? Or would you need to drill down to further subdirectories?

Ad

Yeah just the top level...

Thanks

James

Right...

After a good search through the site I've tracked down something that will index the entire contents of a selected drive at the press of a button - a great utility by ScottGem that I missed first time around - sensational idea, and kudos to Scott!!

Now the code is a bit buggy (that's ScottGem saying that, not me) and doesn't quite meet your requirements, but it DOES give you some idea of how it should all be linked together.

I suggest you download the code from here, look at it and try to understand where it's coming from, and how it works. Then, you should try to come up with an amended version that just gives the folder names and populates those into a table.

Ad

Thats ace but I would need the Drives as a selection from a drop down box...

That gets the path and everything I would only need the name of the top line and put it into a field... That example puts the path and everthing into a table...

Should I PM ScottGem about this? to see if he can shed any light on this?

Also It does not just get top leveel it gts the full directory listing?

Thanks

James

Yes. We'll get to that - at the moment we're finding a method of getting the folder names.

That's why I told you to look at the code and try to understand it - so that it can be modified to suit your needs.

To acheive what exactly? See above point.

See my second point above. I am not going to write your solution for you - unless you pay me. Neither will anyone else here. I'm quite willing to help you write it yourself - but you must read and digest my posts - I'm sorry to be blunt but all of your questions were answered in my previous responses. This is a trait I have noticed in your other posts on the site, in that you rush ahead of yourself - look at things one step at a time.

Have you tried playing around with the code to see how it works?

Ad

Ok I would like to PM ScottGem to see if he can assist me in modifying he code to just get the top line...

Also sorry about getting ahead of myself..

I havent as of yet... Its just that I have that much to get doneand I would like to get it all done before Xmas comes around...

I will do that probably tomorrow and stuff to see if I can get to grips with things...

Thanks for that...

James

James,

*I* can help you with this - I actually had a little play around with Scotts' code and can get just the top level folders - it's actually quite simple. And no, I'm not going to post the code. I'm mentoring you - not doing your work for you!!

My original question still stands - have you looked at the code and tried to get something working?

Ad

Not as of yet but maybe tomorrow after work I will give it a try...

I will asl have a mess with the code and see if I can get it working....

And I understand about the mentoring thing...

I really appreciate it as well...

James

Ok... tell you what. I'm feeling generous today, had some great news last night. Plus I missed your response to that the first time around

I'm actually away from Thursday night to Sunday so won't be able to check in. If I do enough to the code so that you can understand how it works, for both the folder names and the combo box thing (drive list), you should be able to take it from there. I'll have a play later on (I MUST do some proper work now!) and post what I get a bit later.

How does that sound?

Ad

That sounds great I really do appreciate it.... Your a life saver!!!

I will give it a go and then I will play with the code and see how I get on...

Then when you return hopefully we will have sorted this little problem...

I thank you so much...

I will indeed try my hardest to get everything up and running for your return so all this posting will not be wasted!!

Thanks Again Its much appreciated....

James o!

Ok... update at (check the time of the post) - didn't have chance to do anything at work as crazy day. Will try to do some tomorrow (Thursday)

Ad

Ok thats fine and thanks for letting me know...

I really do appreciate what your doing

James

Are we any further with this as I havent heard from you in a while I know you have been away..

Just curious..

Thanks

James

How are we getting on with this?

Last post you made stated that you would be throwing me some basic code that I could work with and I could see if I could mess about with and correct it so that we could get underway with this little project...

Is this still the case?

Many Thanks

James

Hi there,

Just wondered if you got anywhere over weekend? I have been without my internet you see so I have been unable to check...

If not dont worry...

Thanks

James

Do we have any update on this?

its just that I would like to have this done for Xmas if possible?

Thanks

James

Version 1 here.... let me know... if there *IS* a password on the zip, try "letmein"

Ad

Ok thats Ace...

How do I go about putting a title,media type and software type on the form its self... so it replicates them with the data? and I would need them adding to a form so that the code in there will run...

Thanks

James