![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
valkryorOver the past little while, I've been trying to turn the information from an old music database of ![[livejournal.com profile]](https://www.dreamwidth.org/img/external/lj-userinfo.gif)
fuzzpsych into something functional. We can still use the old program (PCF7) on our system, but it's not very elegant or very pretty or very searchable.
No problem, thinks I, I'll just dump the info into Open Office and take it from there. Except every time I tried to copy-and-paste the information into the table, Open Office would "stop responding" and I have to use Task Manager to shut it down. I tried changing the initial spreadsheet into an Open Office spread sheet, I tried it as an Excel sheet, I tried taking all of the entries, some of the entries, one of the entries. All returned the same results.
By now I'm grumbling and annoyed, so I leave it alone for a couple of days before turning to Access. I like Access, I really do, but I wanted to give Open Office a whirl to see what it's database program is like and, besides the healthy dose of frustration, I still don't know. I likely won't, either, since the two databases I currently have are both Access databases and that's the one thing that Open Office can't read/open.
I spent a good number of hours yesterday happily building a database. I haven't used Access in over a year, and most of it came back to me quite quickly. For everything else, F1 is a useful key. :)
But nowfuzzpsych has a sexy new database just for his vinyl with all the functionality that he wanted, including being able to search for songs and in the Notes section (both things PCF7 was incapable of). I even figured out how to add a parameter query to the form as a command button and when the file is opened, I have it set to go right to the form which should make things easier all round.
To be honest, it's a very simple database: one table, one query, one form, but it doesn't need anything else. I'm thinking of going back and simplifying my own Comics database for the same reason. As cool as it is to see relational tables and foreign keys, it's not necessary for what I need. But that can wait. :)
fuzzpsych into something functional. We can still use the old program (PCF7) on our system, but it's not very elegant or very pretty or very searchable.No problem, thinks I, I'll just dump the info into Open Office and take it from there. Except every time I tried to copy-and-paste the information into the table, Open Office would "stop responding" and I have to use Task Manager to shut it down. I tried changing the initial spreadsheet into an Open Office spread sheet, I tried it as an Excel sheet, I tried taking all of the entries, some of the entries, one of the entries. All returned the same results.
By now I'm grumbling and annoyed, so I leave it alone for a couple of days before turning to Access. I like Access, I really do, but I wanted to give Open Office a whirl to see what it's database program is like and, besides the healthy dose of frustration, I still don't know. I likely won't, either, since the two databases I currently have are both Access databases and that's the one thing that Open Office can't read/open.
I spent a good number of hours yesterday happily building a database. I haven't used Access in over a year, and most of it came back to me quite quickly. For everything else, F1 is a useful key. :)
But now
fuzzpsych has a sexy new database just for his vinyl with all the functionality that he wanted, including being able to search for songs and in the Notes section (both things PCF7 was incapable of). I even figured out how to add a parameter query to the form as a command button and when the file is opened, I have it set to go right to the form which should make things easier all round. To be honest, it's a very simple database: one table, one query, one form, but it doesn't need anything else. I'm thinking of going back and simplifying my own Comics database for the same reason. As cool as it is to see relational tables and foreign keys, it's not necessary for what I need. But that can wait. :)
