Hi,
I learned how to spell "access" earlier this week. That's how much I know about Access.
I'm pretty fluent on Word and Excel inasmuch that I cannot program VBA, but I know where to look to get the information I need online and I can hunt and peck until I find the formulas I need to get things done. With Access, I'm a complete newbie.
I want to basically make a spreadsheet at this point cause I think everything will be pretty static once I enter it. I want to use Access though cause Access allows for better interface when entering many fields of information, and viewing many fields of information.
Ok, I want to make a table (I know that much). And I want the first field in the table to be the file name. These are recordings, about 4000 of them, so I want an automated way to do this. But I know jack squat about how to do. If I were making a regular table where I enter the information from the keyboard...that I can do. This automated stuff I have no idea.
I've included a screenshot of the directory from where I'll be pulling the filenames. Of note the filenames in the directory will not change, so I do not need the database to monitor the directory in case filenames change. If that makes it easier, then good.
As a side-request if there's an easy way for the filename "mmddyy-hhmmss" (see screenshot) to also be split into two parts (fields 2 and 3) of the same record for date and time of recording, that's be great. And it'd give me an example of formulas within Access too.
Thanks.
PS : I saw another thread on this same forum that spoke against having calculated fields in the same table as entered data. So, maybe I want to have two tables, which is cool with me as long as I'm able to read from them when I pull up a record to look at.
I learned how to spell "access" earlier this week. That's how much I know about Access.
I'm pretty fluent on Word and Excel inasmuch that I cannot program VBA, but I know where to look to get the information I need online and I can hunt and peck until I find the formulas I need to get things done. With Access, I'm a complete newbie.
I want to basically make a spreadsheet at this point cause I think everything will be pretty static once I enter it. I want to use Access though cause Access allows for better interface when entering many fields of information, and viewing many fields of information.
Ok, I want to make a table (I know that much). And I want the first field in the table to be the file name. These are recordings, about 4000 of them, so I want an automated way to do this. But I know jack squat about how to do. If I were making a regular table where I enter the information from the keyboard...that I can do. This automated stuff I have no idea.
I've included a screenshot of the directory from where I'll be pulling the filenames. Of note the filenames in the directory will not change, so I do not need the database to monitor the directory in case filenames change. If that makes it easier, then good.
As a side-request if there's an easy way for the filename "mmddyy-hhmmss" (see screenshot) to also be split into two parts (fields 2 and 3) of the same record for date and time of recording, that's be great. And it'd give me an example of formulas within Access too.
Thanks.
PS : I saw another thread on this same forum that spoke against having calculated fields in the same table as entered data. So, maybe I want to have two tables, which is cool with me as long as I'm able to read from them when I pull up a record to look at.
Attachments
Last edited: