Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using a form to create fields in a table

Status
Not open for further replies.

clickster

MIS
Feb 19, 2002
89
US
I was wondering if it is possible to use a form to create fields in a table (as opposed to records). I would like to enter the name for the new field and have the new field added as a Yes/No field
 
It's quite possible, you can create you're own 'Wizards'. You should look into the createTableDef, CreateField, creteIndex, etc. expressions, etc.

Also, open up in the WizLib.mda's (wiztool.mda, WizMain.mda) etc, tho I think they're Mde's now. In the older versions of access, you could simply rename them to .mdb, and look at all the code behind the Wizards.

if you were mischevious (as I was!) you could change the messages, labels, directions and code, etc. in the Wizlib's on other programmer's machines so that they'd get suprising behaviour (!!) when they went through a wizard! Yes, I had too much time on my hands but I had alot of fun with that!
--Jim
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top