*So* frustrating... (geek whinge/cry for help)
Sunday, 26 March 2006 07:30 pmI 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?
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?