Using Excel in an Access Form for entering data

[Guest]

I created a form in Access that requires a simple spreadsheet that allows
data entry to the Excel object I have inserted into the form. It's simply 4
rows of name, date, hours and a total at the end of the 3rd column. The
object looks perfect but I can't type in the Excel portion of the form. How
do I maintain the link, allow users to enter data and retain the data when I
review the form?

 

[Joseph Meehan]

I created a form in Access that requires a simple spreadsheet that
allows data entry to the Excel object I have inserted into the form.
It's simply 4 rows of name, date, hours and a total at the end of the
3rd column. The object looks perfect but I can't type in the Excel
portion of the form. How do I maintain the link, allow users to
enter data and retain the data when I review the form?

Sorry I don't have an answer, but I do have a question. That sounds
like something that would not require Excel. Why are you using Excel.

 

[Guest]

Hi Joseph, you are so right! This is really not what I want to do but I have
a memo field for comments and when the form prints out and goes out in the
field with the tech, he needs a space to write comments. All I really need
to do is find out how to create a memo field that is filled with lines. I
tried special effects but could not find the way to create a field with 5
lines within the field for handwritten comments that will be entered once the
service call is returned to the office. Suggestions??

Thank you for your reply.

 

[Joseph Meehan]

Hi Joseph, you are so right! This is really not what I want to do
but I have a memo field for comments and when the form prints out and
goes out in the field with the tech, he needs a space to write
comments. All I really need to do is find out how to create a memo
field that is filled with lines. I tried special effects but could
not find the way to create a field with 5 lines within the field for
handwritten comments that will be entered once the service call is
returned to the office. Suggestions??

Sure. First I would use a report to print it out because you can make
it look prettier when you print it. In either case, I would not try to make
the Memo filed larger, but rather I would allow blank space in the report,
with lines if you like, for the notes.

 

[Guest]

Joseph,

it seems as though your suggestion is a report because it is not possible
for a memo field to contain lines in the form, is that accurate?

 

[Joseph Meehan]

Joseph,

it seems as though your suggestion is a report because it is not
possible for a memo field to contain lines in the form, is that
accurate?

There Is a line tool in design mode. You just need to make space and
draw in the lines. There is even a way to assure straight lines, but off
hand I forget the key code for it.

 

[Guest]

Joseph, thanks. I went into form design and drew lines in over the comment
memo field so that when it prints the record the lines appear but when I
enter data into the form the lines end up behind the field. I guess that
will work but one would think that Access would allow you to add that as a
special effect. Appreciate your help.