Search results

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).

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.

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...

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...

I'm getting the hang of what to do. Have deleted Laptop and entered one of mine incl all the details/fields except Filename. I see the Green text info. Where is the data entered, e;g; If I wanted a browse Dialog to pick up all the details automatically? Then a method to add all the files in a...

It's good to get a bit of an overview, This is all very new and unknown, How you've done things is different to what I know or understand so it will take me a while to figure it all out (he says optimistically). I'll have a go at frmSummary as you've outlined. Might not succeed but can always...

I may be missing something but If there are no queries how would you find a particular backup file? I can see how you could query the table holding the filenames, but how are the other tables included? I've haven't ever used a report and I'm not (yet) sure of the subforms functions. They...

That's a very impressive front end @Larry. You didn't use your 'junction' method in msg 41? I would next populate the tables then see if I can follow how it all works? I did think there might be more queries and get a idea how they used the tables. This is a bit of of a jump from where I was...

Thanks Larry, Opening it now. Pat, I was reading the serial number from the drive. It seemed a good way to identify it,as presumably it'd be unique. But early days to see issues and time to fix.

Thanks Larry appreciate that. Don;t do it for me though ! Although I'd learn either way, all going well.

@LarryE There's only empty tables as per the design prior to your Junction design. (I don't think that'll be what you want, but will attach it. No, I'm told it's too large). I started with a table and fields I thought would be used/needed. It's all changed since then. Serial number is the...

I have corrected the ID naming error. Whatever design you choose I'll use. Sounds good, thanks. An example of a query would be useful.

When I went to change 'ID' there was no rename option so I figured it might be a Access Generated Read Only field. Now I see I can overtype it. LOL ah well, can't win them all.

So NOT like this Larry?

Wow! This is quite something,Very differnt. I've been hours building the tables/relationships for the first time ever. Access doesn't let you make a mistake and you have to think in numbers. Drive F is now a number dependent on another number etc. I was sure the Drive table should come before...

Nothings been done that can't be started over. I'm retired so all the time in the world, A bit intrigued with LarryE suggestion. I've learnt a few things/ideas thanks to this thread. When initially asked what my aim was I didn't have a good answer, It was mosly to understand/see an example of a...

A lot to ponder... Not completely sure about Docs advice about FSO and the four separate fields. Can come back to that. I've removed the drive name from the Drives table, replacing it with ID and changed the drive letter field to Len1. I couldn't see how to set it as a byte. then I added...

Yes it is being built piecemeal, seems a reasonable plan when not sure exactly what might all entail. As it develops I (expect to) get a better idea of what I want, or what's possible, Sorry if that's contrary to advise, but it's interesting to do. (And I doubt I know any better right now) I...

This is great :) Thanks everyone for the feedback, So all my Text Fields in Drives which were "WIN10-PC" are now a numeric with value 1. (matching Win10-PC autonumber in Computers). SELECT Computers.ComputerName, Drives.[Drive letter], Drives.[Volume Name] FROM Computers RIGHT JOIN Drives ON...

Thanks @plog that's what I need to know, I've changed DiskManagement data type to Numeric, Do I keep the Computers table? getting conflicting advice on that. And Join on ID field of Computers. That's 1 but there's no corresponding field in Drives. Or does Access know some other way?