I will be asking about 10-12 users to enter data into a front end database on a single computer (not all at the same time). In order to make the input of data easy for them (they are not very computer savvy), I was wondering if they could open up the DB, see a splash page, and click on "Enter Data". Then they would enter the primary key (which would identify the record), and then have the fields pop up for them to enter data (similiar to using parameters in a query). This would be easier than them having to enter data info a form.

Please let me know if you have any suggestions on this.

Thanks-
Ryan

Hi Ryan,



What version of Access are you using? Please remember to select the version number when posting questions in case it becomes relevant to the discussion.

Yes, that is very possible but seems to be very annoying. Your non-computer savvy users must have had at least some experience filling out forms somewhere else, right? I just think that it's much easier to enter data when you can see the whole thing.

But anyway, to do what you want, you can either create a pop-up form to ask for each entry, or use the InputBox() function to prompt the user for a response.

Just my 2 cents...

Thanks DB Guy. I am using Access 2010. Sorry for not specifying.

Thanks for the feedback!

--Ryan

Hi Ryan,



Let us know if you need help implementing it. Good luck!

DBGuy-

Do I need to use VBA to create the pop up form? Or is it just a property setting that needs to be toggled somewhere?

Thanks-
Ryan

Hi Ryan,

To make a "popup" form, there is a Popup property that you just need to set to "Yes."

Just my 2 cents...

I once saw some software that created mailmerge documents - that prompted the user for each field in turn before it produced the finished letter.
It was possibly the most irritating UI choice I have ever seen in my career.

Users, computer savvy or not, will ultimately comprehend a form's purpose.
Expecting a bit of user education and accustomisation will allow you to make the end result a much better experience.
Forms are the way.

Enjoy. :-)

DBGuy,

One last question... If I select yes to the popup property it makes the whole form pop up, which seems a littel useless. How do I make specific fields pop up?

Thanks-
Ryan

Hi Ryan,


You can't... What I suggested earlier was to create a separate popup form for each input that you want from the user. Or, you can use the InputBox() function, which looks more like the query parameter that you referenced in your original question.

However, I would like to reiterate my original comment to support what Leigh just mentioned, and that is - popping a parameter to the user for each field in your form could easily become very irritating for your users.

Just my 2 cents...