Forum Home
Press F1
 
Thread ID: 29547 2003-01-24 02:40:00 Access 2000 - Dynamically creating a form tbacon_nz (865) Press F1
Post ID Timestamp Content User
116227 2003-01-24 02:40:00 I want to be able to click a button on a form and in the onclick event dynamically create another form with fields depending on parameters I supply .

I know it can be done, but I can't get to grips with the actual mechanics .

Has anyone got a code fragment that will point me in the right direction?

TIA . 		tbacon_nz (865)
116228 2003-01-24 10:43:00 Sounds like you want to base the form or subform on a query that uses dynamic lookup (Autolookup)
Bit more info on exactly what you are trying to acheive would be helpful. 		Stumped Badly (348)
116229 2003-01-24 13:26:00 is this in an HTML file??
if you call your .HTML file ".asp" you can use SQL to create a form,field and insert anything into the access database
i would sugest going to school.......... www.w3schools.com
look at ASP and SQL 		sc0ut (2899)
116230 2003-01-24 20:35:00 What I am actually trying to achieve is to dynamically (i.e. at run-time) _create_ a form with controls that will to some extent be defined by the user.

The application is to process questionnaires from surveys. Each survey may have a different number of questions, which are defined in a table. I want as part of the setup for processing the survey to create a form that will reflect the number of questions in that particular survey. This form will then be used for data entry of survey responses.

Maybe I am going about all the wrong way, and my problem is actually not being able to define a database structure/queries/forms etc. that reflect what I want to do.

What I envisage at the moment is:

Questions table:
Question number
Question text

Manager table:
Manager id
Manager name

Respondents table:
Respondent id
Respondent name

Relationships table:
Relationship id
Respondent id
Manager id

Responses table:
Relationship id
Question number
Response

Manager:relationships - one to many
Respondents:relationships - on to many
Relationships:Responses - one to many

I am trying to make the data entry as painless as possible. We know by the time the responses come in how many questions there were, and I want to have a form that is "pre-filled" to as great an extent possible, so it is only necessary to select the relationship(which will relate to a single survey response sheet) and then click an option button for the value of each response, preferably all on the same page without scrolling.

So hence my idea orf going through a "set-up" phase at the start of each survey, where all the questions are entered in the table, and then from that a response form is generated.

Sorry this is so long, but I would be grateful for any guidance.

Thanks again. 		tbacon_nz (865)
116231 2003-01-24 21:33:00 Learn Access basic.
What you want is not easy to explain since you haven't got the knowledge yet and the answers are not in the help file associated with Access.

try Access 2000 Programming Weekend Crash Course from IDG
ISBN 0-7645-4688-0

Last time I looked - $40 from Whitcoulls


Also try MS technet. 		Merlin (503)
116232 2003-01-24 22:12:00 Thanks for the response - I do already use VBA for a lot of stuff, but as you say I do not have the knowledge yet for this level of requirement. I have actually been a programmer for years, but mostly on "old-fashioned" procedural languages - COBOL, PL/1 etc., and readily confess to having some problems coming to grips with the more object-oriented stuff used in VBA. The two books I have used to date have been "Running Access 97" by John Viescas from Microsoft Press and "Access 97 VBA" by Robert Smith and David Sussmann from WROX. Unfortunately neither of those seem to cover what I _think_ I need. (and of course I am actually using Access 2000 :D )

I think my problem is in the methodology/syntax of actually defining/creating/saving the object(s) I want. Once I have that sorted I am reasonably confident I can do the rest. 		tbacon_nz (865)
1