Notepad

  • Thread starter Thread starter SeRene
  • Start date Start date
S

SeRene

Hi,

Is it possible to allow the user to have a notepad-like
feature in MS Access whereby the user can open the feature
to type in some comments and messages for reference sake.
I've tried making use of e table object and setting the
data type as "Memo" and create a form with it. However,
this is not feasible because when the user wants to create
more "memos", he needs to create more tables and more
forms!!

Helpppp!!
 
SeRene said:
Hi,

Is it possible to allow the user to have a notepad-like
feature in MS Access whereby the user can open the feature
to type in some comments and messages for reference sake.
I've tried making use of e table object and setting the
data type as "Memo" and create a form with it. However,
this is not feasible because when the user wants to create
more "memos", he needs to create more tables and more
forms!!

Helpppp!!
Click to expand...

There should be no reason to create more tables and forms.
A table with a memo, date, category would be one way.
Since you are working in a database I would assume the memos relate in some
way to something. A subform would be one way of showing all memos related to
a particular item.
 
There should be no reason to create more tables and forms.
A table with a memo, date, category would be one way.
Since you are working in a database I would assume the memos relate in some
way to something. A subform would be one way of showing all memos related to
a particular item.
Click to expand...

Hi,

The memos are not related. That is why if i need a new
memo, i will need to create a new table. The function must
work like notepad. Whenever you have a notepad file, you
can enter whatever messages you want in it and save under
a name, "Text1" and the next time you need to enter
messages again, you open up notepad and enter your
messages in another new notepad and give it another new
name, "Text2".
This is what i need.
 
The memos are not related. That is why if i need a new
memo, i will need to create a new table.
Click to expand...

Why do you need a new table. Why not just create two fields:

MemoName MemoText
The function must
work like notepad. Whenever you have a notepad file, you
can enter whatever messages you want in it and save under
a name, "Text1"
Click to expand...


Ok, so then
MemoName : Text1
MemoText : Your text notes go here.
and the next time you need to enter
messages again, you open up notepad and enter your
messages in another new notepad and give it another new
name, "Text2".
Click to expand...

Ok, so then:
MemoName: Text2
MemoText: Your text notes go here...

And so on.....I count 1 table...and each new memo you need simply goes into
a new record...
 
Why do you need a new table. Why not just create two fields:

MemoName MemoText



Ok, so then
MemoName : Text1
MemoText : Your text notes go here.


Ok, so then:
MemoName: Text2
MemoText: Your text notes go here...

And so on.....I count 1 table...and each new memo you need simply goes into
a new record...
Click to expand...
Hi,

I've tried your method but the result isn't what i want.
Actually, i need to display those memos in "Form" format.
So if i only create 1 table with all the different Memos
inside, the result will only be 1 Form with all the memos
in it. What i need is to have a form for each memo. Is it
attainable w/o creating countless of tables?? Having many
forms is alright.
 
There should be no reason to create more tables and forms.

Hi,

The memos are not related. That is why if i need a new
memo, i will need to create a new table. The function must
work like notepad. Whenever you have a notepad file, you
can enter whatever messages you want in it and save under
a name, "Text1" and the next time you need to enter
messages again, you open up notepad and enter your
messages in another new notepad and give it another new
name, "Text2".
This is what i need.
Click to expand...
If the memos are not related, then why bother with a database? Just use
Notepad, this is a Windows environment.
 
I've tried your method but the result isn't what i want.
Actually, i need to display those memos in "Form" format.
So if i only create 1 table with all the different Memos
inside, the result will only be 1 Form with all the memos
in it. What i need is to have a form for each memo. Is it
attainable w/o creating countless of tables?? Having many
forms is alright.
Click to expand...

I don't understand why you need a form for each memo. You want to things the
other way round, a form can have as many records as it wants. That way, you
only need to have once nice form that looks like a large text editing
screen. You then simply change the record for the form, not the form for the
record!

So, why not build a form that has the one field with the memo name near the
top, and then ALL OF THE rest of the large left over area of the form is a
singe large memo text box area?

The result will be a form that has the memo name at top, and the rest of the
large screen area simply displays the memo text that you can edit.
 
Back
Top