Sunday, 26 March 2006

taimatsu: (minako)
I am putting together a MS Access database to function as a high-tech searcheable songbook. It's all laid out and working well. I have assorted fields and checkboxes at the top, and then the song title and so on, and then a field, obviously, for the song lyrics. I can't put these in as text or memo fields because the length for those is too restrictive. I have, therefore, a lot of plain text documents with the lyrics in, in a separate folder, and I want to apply these to the database. I thought I had it taped, because dragging-and-dropping adds them in as OLE bound objects (stored in the database file). That's fine. I'd also be happy to do them as linked docs, hyperlinks, whatever.

However, it has just fallen apart. I have *two* versions of 'The Dawning of the Day', and I want to record both using separate text files. I just cannot work out how to do this. An OLE Object field will only take one object. AFAICT, a hyperlink field will only take one hyperlink. Text fields won't do any of this stuff. I'm stuck! Anyone got any ideas?

Profile

taimatsu: (Default)
taimatsu

April 2019

M T W T F S S
1234567
891011121314
15161718192021
22232425262728
2930     

Most Popular Tags

Style Credit

Expand Cut Tags

No cut tags