Import Form which acts like Microsoft Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

Does anyone know a way to create an input form which looks and acts like
Microsoft Excel without using Active-X controls?

Thank you,

Sarah
 
Hi Sarah,

It depends what you mean by "looks and acts". For instance, you could create
a table with a comfortable number of text fields named A to whatever, the
first field being a Long primary key. Populate it with a comfortable number
of records, all fields being Null apart from the primary key which runs from
1 to whatever.

Then display it in a continuous form, so the user can enter stuff into the
text fields, and write code that does what you want.

But IMHO it would be a great deal simpler to use Excel!
 
Thanks for your input John.

Sarah

John Nurick said:
Hi Sarah,

It depends what you mean by "looks and acts". For instance, you could create
a table with a comfortable number of text fields named A to whatever, the
first field being a Long primary key. Populate it with a comfortable number
of records, all fields being Null apart from the primary key which runs from
1 to whatever.

Then display it in a continuous form, so the user can enter stuff into the
text fields, and write code that does what you want.

But IMHO it would be a great deal simpler to use Excel!
Click to expand...
 
Back
Top