Hello Guys:
I now work in the real world where Access dominates, and 99% of the people who work in the governement and/or private industry, never heard of A5. That's unfortunate because I've learned that Access is in many ways a vastly inferior product. In fact, I'm thinking about starting a thread listing the many ways in which Access is inferior to A5. When Access 20007 arrives early next year, they will finally start to make the product easier for their users.
I truly miss most of the guys with whom I've communicated with starting way back around 1990 and lasting almost 15 years. I also miss work with A5 very much.I also appreciated the way Richard, Selwyn, and Lenny treated me over the years.
Anyway, I ran into one of those bizarre, frustrating quirks that's driving me crazy. I have a very simple Contacts application with a basic Parent-Child relationship linked by Contact_ID [character field]. Whenever I have contact with someone, I try my best to post notes in the child table which has only two fields, Contact_ID [link to parent] and a Rich Text Memo field called Notes.
Today I went to see my doctor for a fairly serious problem, and as usual, I took notes and saved them. I then decided to copy 15 years of medical notes from my doctor into Word and it wouldn't work. Every time I tried copying into Word, instead of copying the actual text, the following was inserted:
30302020204Comic Sans MS;
Now listen to this, I can go to any other parent record and copy the text from the child table's notes field into Word. So far, this is the one and only field where I see the above mentioned bizarre behavior. Of course as life would have it, this field has far and away the most important information and that's why I want to copy it from Alpha and paste it into Word.
Since I spend so much time in Access now, I decided to import the table into Access 2003 and then I was confident I could cut and paste from Access into Word. However, Access would not import the child table but I could easily import the parent table.
I then tried changing the field from a Rich Text Memo field to a plain old Memo field and each time I saved that change, A5 would close and fail to save the change.
Something very strange is going on and for the life of me, I cannot figure out what it is. Any thoughts or suggestions? By the way, I've compacted the database, rebuilt the parent-child relationship, closed Alpha, reopened it, and the problem persists.
Thanks,
Robert T
I now work in the real world where Access dominates, and 99% of the people who work in the governement and/or private industry, never heard of A5. That's unfortunate because I've learned that Access is in many ways a vastly inferior product. In fact, I'm thinking about starting a thread listing the many ways in which Access is inferior to A5. When Access 20007 arrives early next year, they will finally start to make the product easier for their users.
I truly miss most of the guys with whom I've communicated with starting way back around 1990 and lasting almost 15 years. I also miss work with A5 very much.I also appreciated the way Richard, Selwyn, and Lenny treated me over the years.
Anyway, I ran into one of those bizarre, frustrating quirks that's driving me crazy. I have a very simple Contacts application with a basic Parent-Child relationship linked by Contact_ID [character field]. Whenever I have contact with someone, I try my best to post notes in the child table which has only two fields, Contact_ID [link to parent] and a Rich Text Memo field called Notes.
Today I went to see my doctor for a fairly serious problem, and as usual, I took notes and saved them. I then decided to copy 15 years of medical notes from my doctor into Word and it wouldn't work. Every time I tried copying into Word, instead of copying the actual text, the following was inserted:
30302020204Comic Sans MS;
Now listen to this, I can go to any other parent record and copy the text from the child table's notes field into Word. So far, this is the one and only field where I see the above mentioned bizarre behavior. Of course as life would have it, this field has far and away the most important information and that's why I want to copy it from Alpha and paste it into Word.
Since I spend so much time in Access now, I decided to import the table into Access 2003 and then I was confident I could cut and paste from Access into Word. However, Access would not import the child table but I could easily import the parent table.
I then tried changing the field from a Rich Text Memo field to a plain old Memo field and each time I saved that change, A5 would close and fail to save the change.
Something very strange is going on and for the life of me, I cannot figure out what it is. Any thoughts or suggestions? By the way, I've compacted the database, rebuilt the parent-child relationship, closed Alpha, reopened it, and the problem persists.
Thanks,
Robert T
Comment