By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,638 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,638 IT Pros & Developers. It's quick & easy.

Memo

P: n/a
abc
I have an access database connected to a front-end in Infopath. In my
access db, I have memo data types which Infopath does not support. Is
there anyway I can break up the memos into mutiple text fields, but
still appear as a paragraph still (> 255 char.)??

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
MLH
Well, not being the one most likely to give you the best
advice, here's what I'd do...

Create a table named tblBigMemos. Assuming your table
with the memo in it is named MyTable and that it has a
keyfield named [MyID] and its memo field is named [MyMemo],
I would have these fields in tblBigMemos...

[BMID] -keyfield, autonumber or some natural key (can't imagine one)
[MyID] -link to a unique record in MyTable
[BMSnip] -contains 255-char snippets of records in MyTable.

Using DAO, run through the records in MyTable once, reading
MyTable.MyMemo once through each loop. Chop off pieces
using Left$(MyMemo,255], writing them to new records in
tblBigMemos until there's nothing left. Do this over 'n over
until EOF of MyTable.

Your import should be much easier then.
Nov 13 '05 #2

P: n/a
abc
I'm a basic access user. Could you explain in detail the last part
"Using DAO..."?

THANKS

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.