RE: Excel as data entry form?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks.

I normally work in Access, but am unable to use that for this application,
so I have decided to create a userform for my data entry purposes. I looked
at the Excel "data forms", but the limit of one line of visible text was not
sufficient for my needs.

Thanks again for your feedback.

Dale
--
Email address is not valid.
Please reply to newsgroup only.


"challa prabhu" wrote:

Hi,

About data entry forms

Microsoft Excel provides the following types of forms to help you enter data
in a work*** range.

Data forms

Excel can generate a built-in data form (data form: A dialog box that
displays one complete record at a time. You can use data forms to add,
change, locate, and delete records.) for your range. The data form displays
all of your column labels in a single dialog box, with a blank space beside
each label for you to fill in data for the column. You can enter new data,
find rows based on cell contents, update existing data, and delete rows from
the range.

Use a data form when a simple form listing the columns is sufficient and you
don't need more sophisticated or custom features. A data form can make data
entry easier than typing across the columns when you have a wide range with
more columns than will fit on the screen at one time.

Work*** forms

If you need a sophisticated or specialized data entry form, you can create a
work*** or template (template: A workbook that you create and use as the
basis for other similar workbooks. You can create templates for workbooks and
worksheets. The default template for workbooks is called Book.xlt. The
default template for worksheets is called Sheet.xlt.) to use as a form and
then customize the work*** form to meet your needs. For example, you might
create an expense report form for people to fill out online or in printed
form.

Use this method when you want complete flexibility to customize your form.
Work*** forms are particularly useful when you want individual printable
copies of your forms. You can develop a data entry application using the
Microsoft Visual Basic Editor (Microsoft Visual Basic Editor: An environment
in which you can edit macros that you've recorded and write new macros and
Visual Basic for Applications programs.) to keep the data from the forms in
an Excel range.

Important:

Please to the topic " Add, edit, find, and delete rows by using a data form"
in the online help

Challa Prabhu


"Dale Fye" wrote:

Please excuse the crosspost, but I'm using Internet Explorer to post this and
cannot figure out how to multi-post.

I have a need to collect some information from a wide variety of sources
throughout my internationally dispersed organization. I cannot use an
internet based questionnaire because of the sensitivity of the information
(can encrypt the Excel file), and don't want to hassle with the email
problems associated with distributing an Access database. However, I will
ultimately need to pull this data into an Access database.

My boss does not want to actually use a "spread***" view within Excel to
enter the data, he wants to have Form like look and feel as the first page of
the spread***. Anybody have any ideas for using Excel and Access in this
way?

--
Email address is not valid.
Please reply to newsgroup only.
.

Quantcast