By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

Runtime Controls in Access

P: 10
Hi,

I am new to Access,

I have a form which contains 2 text boxes. I want to generate more text boxes, in runtime, based on the number of records in my recordset.

I know how to do this in VB but that code dont work in Access,

Can anybody help me in this. its urgent so prompt reply will be highly appreciated.

Thanks

Keyur
Dec 27 '07 #1
Share this Question
Share on Google+
4 Replies


Minion
Expert 100+
P: 108
Hi,

I am new to Access,

I have a form which contains 2 text boxes. I want to generate more text boxes, in runtime, based on the number of records in my recordset.

I know how to do this in VB but that code dont work in Access,

Can anybody help me in this. its urgent so prompt reply will be highly appreciated.

Thanks

Keyur

Keyur,

Why exactly do you need to produce more text boxes at runtime? From the sounds of it you need to display the information in multiple records on one form as more records are added. If this is the case then you might looking at creating a Continuous Form that will show multiple records on the same form.

If this sounds more like what you need I would do a search on Continuous Forms in help, on this board, or google as there are tons of information out there. However, if you truely need to dynamically create the form at runtime I'm sure one of the helpful individuals present will be able to assist you in generating the necessary code.

Hope this helps.

- Minion -
Dec 27 '07 #2

P: 10
Keyur,

Why exactly do you need to produce more text boxes at runtime? From the sounds of it you need to display the information in multiple records on one form as more records are added. If this is the case then you might looking at creating a Continuous Form that will show multiple records on the same form.

If this sounds more like what you need I would do a search on Continuous Forms in help, on this board, or google as there are tons of information out there. However, if you truely need to dynamically create the form at runtime I'm sure one of the helpful individuals present will be able to assist you in generating the necessary code.

Hope this helps.

- Minion -

Hi Minion

Thanks for your reply..

Here is what exactly I am looking for..

I want to create a form which will show the names of all the employees on the form, based on the number of records in the recordset. Along with this I also need to show a text box for each employee, beside his/her name on the form for putting in some information about that employee. Now if i create a contineus form, it will automatically generate the bonded control, but the text box that I want to put beside employee name is not bounded.

I changed the form property to Continuous form and its generating the controls automatically. However, there is another problem in this way. When I entere data in unbounded text box, it takes same value in all the instances of that unbounded textbox. How to solve this problem? and how can I store values entered in each instances of the unbounded text box in the database?

Thanks...

Keyur
Dec 28 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
If you want information for a given employee to be part of his/her record then the textbox has to be bound to your underlying recordset! How else would you expect Access to keep track of which comments go with which employees? For data to be stored it has to be bound to a table!

Linq ;0)>
Dec 28 '07 #4

Minion
Expert 100+
P: 108
Hi Minion

Thanks for your reply..

Here is what exactly I am looking for..

I want to create a form which will show the names of all the employees on the form, based on the number of records in the recordset. Along with this I also need to show a text box for each employee, beside his/her name on the form for putting in some information about that employee. Now if i create a contineus form, it will automatically generate the bonded control, but the text box that I want to put beside employee name is not bounded.

I changed the form property to Continuous form and its generating the controls automatically. However, there is another problem in this way. When I entere data in unbounded text box, it takes same value in all the instances of that unbounded textbox. How to solve this problem? and how can I store values entered in each instances of the unbounded text box in the database?

Thanks...

Keyur
My apologies Keyur, but I still seem to be failing to understand why it is you need to have an unbound text box. Would it not just make more sense to create a new field in table and bind it to the new text box? Perhaps I'm not understanding where the text box is going to store its information, if at all.

Ultimately I guess the problem is we're not understanding why the text box has to be unbound in the first place.

- Minion -
Jan 10 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.