Data Input Form

[john.keese]

I have been using Access for many years, but have never done anything
with VBA. I am actually embarrased to ask this.

I have a very simple 5-column table called "Comments Table" with
employee contact information (parenthesis is the actual column name):
the employee number (RWACS), the date of contact (Week Ending), the
severity level (Severity), the job code that the comment is regarding
(Job), and the comment (Comment).

I want a form that has a text box at the top where I key in the
employee number. Then I would like a larger box that displays all of
the information for that employee. Then I would like a blank line that
I can add type in another record. Finally, I would like a "Submit"
button to actually add the record that I just typed in to the table.

This seems simple, but I am having a difficult time with this. Can
anyone help? Thanks!

 

[John Vinson]

I have been using Access for many years, but have never done anything
with VBA. I am actually embarrased to ask this.

I have a very simple 5-column table called "Comments Table" with
employee contact information (parenthesis is the actual column name):
the employee number (RWACS), the date of contact (Week Ending), the
severity level (Severity), the job code that the comment is regarding
(Job), and the comment (Comment).

I want a form that has a text box at the top where I key in the
employee number. Then I would like a larger box that displays all of
the information for that employee. Then I would like a blank line that
I can add type in another record. Finally, I would like a "Submit"
button to actually add the record that I just typed in to the table.

This seems simple, but I am having a difficult time with this. Can
anyone help? Thanks!

It sounds like you want a Continuous Form based on the table; rather
than a textbox to type in the employee number, why not use a Combo Box
to display all the valid employee numbers, autofill them when the user
types, and have it bring up the data for that employee? Put a Combo
Box in the form Header, and use the combo wizard option "Use this
combo to find a record".

No Submit button is required (though of course you can put one on the
form, belt and suspenders style, if you wish); a continuous Form
automatically displays a blank "new record" at the bottom of the list,
ready for new entry, and that record will be saved to disk
automatically when you finish typing it.

No VBA is required at all. It sounds like you've been doing everything
in table datasheets, perhaps? Forms are MUCH more flexible!

John W. Vinson[MVP]

 

[John Vinson]

I have been using Access for many years, but have never done anything
with VBA. I am actually embarrased to ask this.

I have a very simple 5-column table called "Comments Table" with
employee contact information (parenthesis is the actual column name):
the employee number (RWACS), the date of contact (Week Ending), the
severity level (Severity), the job code that the comment is regarding
(Job), and the comment (Comment).

I want a form that has a text box at the top where I key in the
employee number. Then I would like a larger box that displays all of
the information for that employee. Then I would like a blank line that
I can add type in another record. Finally, I would like a "Submit"
button to actually add the record that I just typed in to the table.

This seems simple, but I am having a difficult time with this. Can
anyone help? Thanks!

Answered in your other thread ("Data Entry Form").

John W. Vinson[MVP]