Data (entry) form - expose properties?

  • Thread starter Thread starter Poseur
  • Start date Start date
P

Poseur

As I was mapping out the user form I would need to allow my
users to easily enter data for a record, I came across the
"built-in" data form. It's pretty close to what I need except I
need it to be a no brainer - enter the index field data, pre-
entered fields initialize, the user enters the rest which is
validated, and never touches the spreadsheet.
But this thing is untouchable. One can programmatically visible
it by Application.ShowDataForm but that's it - can't alter
events code or properties. It is not amongst the xlDialogs (far
as I can tell). It's an arrogant little untouchable pris
taunting me into going thru the whole deal of re-creating it.

Any way to undress it and do something with it?
 
Hi

AFAIK you can't play with the Data Form's properties but you could have a
look at
http://j-walk.com/ss/dataform/index.htm
John Walkenbach has an Enhanced Data Form as a downloadable add-in - check
out it's features / functions & other details at the web site

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Forms for Data Entry; re-loading data 1
Access Property sheet data missing also syntax 0
User Form Text Date Format 3
VBA Data Entry Window 1
best way to validate data in forms; 2010 1
Table Data Entry from Form 2
clear user form after entry 11
Spaces in data entry 6

Back
Top