Relationships

[LarryE]

If I hover over Report the balloon it says Delete this Account.

So sorry, that should be Open Report instead of Delete This Account.

1. Open The FrmCumputer in Design mode
2. Change the Control Tip Text property from Delete This Account to Open Report

should be

I did click it and got something I couldn't return from

When you click the Report button it opens the report for you to view and/or print. It's a list of all the backup files and where they are located. When you close the report, the main Computer form opens again.

Where is the data entered, e;g; If I wanted a browse Dialog to pick up all the details automatically?

I don't know what you mean.

 

[David44Coder]

I've changed the tip text, and seen where to close the Report.
I kind of see how the PK and FK works. Always numbers and PK is Access-generated autonumber. Correct ?
Is a sub form always a child of a main (parent) form?
Are the sub Forms just dragged into the main Form. Footers are headers are extensions of the main form?
Why do you say not to enter data directly to the tables, only through the Form? It (seems to) allow entry of only one thing at a time.
I meant pick up a folder name from a browse dialog, rather than typing the name in - and again for the files, getting them all at once.

 

[LarryE]

PK is Access-generated autonumber. Correct ?

Yes.

Are the sub Forms just dragged into the main Form. Footers are headers are extensions of the main form?

Yes.

Are the sub Forms just dragged into the main Form. Footers are headers are extensions of the main form?

They are not "dragged", but yes they are inserted as a control.

Why do you say not to enter data directly to the tables, only through the Form? It (seems to) allow entry of only one thing at a time.

That is correct. You enter each Computer name, Volume name, Drive, Folder and Backup file name one at a time.

I meant pick up a folder name from a browse dialog, rather than typing the name in - and again for the files, getting them all at once.

It may be possible. I will see what can be done.

 

[David44Coder]

Thanks Larry. I'm getting a better idea and it good seeing how this all fits together.
I can get a list of folder names & files. Populating tables automatically is pretty essential.
It's not practical to enter one at a time unless done by code.
Then seeing how to query it in a useful way. I can handle this in one table but not so good with many.

 

[LarryE]

Thanks Larry. I'm getting a better idea and it good seeing how this all fits together.

I can get a list of folder names & files

. Populating tables automatically is pretty essential.
It's not practical to enter one at a time unless done by code.
Then seeing how to query it in a useful way. I can handle this in one table but not so good with many.

I have been able to use some complex and advanced VBA code to be able to select the files you want, break them into Drive, Folder and File parts and then append the parts to the appropriate tables. I am still testing it.

If you will attach the file containing the folder and file names, I will see if I can import them all at once into the appropriate tables. If you can send it in EXCEL or ACCESS table format, that would be ideal.

 

[David44Coder]

Attached has a few folders and names, not sure how many you want but any Windows files structure would suffice.
Would be interested to see you method for select the files you want, break them into Drive, Folder and File parts as I have done something similar but not applied it yet.

 

[Gasman]

Attached has a few folders and names, not sure how many you want but any Windows files structure would suffice.
Would be interested to see you method for select the files you want, break them into Drive, Folder and File parts as I have done something similar but not applied it yet.

Nothing attached?

 

[LarryE]

Attached has a few folders and names, not sure how many you want but any Windows files structure would suffice.
Would be interested to see you method for select the files you want, break them into Drive, Folder and File parts as I have done something similar but not applied it yet.

Here is a file that allows you to select files from any environment (Volume), and extract the Drive, Folder and file name. Doing this without using the File Picker is another matter. I am still experimenting with that.

 

[David44Coder]

Not sure what happened to my attachment but will try again.
Larry,. may need some instructions as not sure what to do. Choose BackUp Files in Filter Field
then what comes next ? Enter anything in File Name and it grows another row (to a max of 6).

 

[LarryE]

Not sure what happened to my attachment but will try again.
Larry,. may need some instructions as not sure what to do. Choose BackUp Files in Filter Field
then what comes next ? Enter anything in File Name and it grows another row (to a max of 6).

I received the file with the table inside. I am working to see if I can add all of the file records in the table at one time to their related Drive, Folder and BackupFile tables.