473,323 Members | 1,570 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Runtime Controls in Access

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
4 1543
Minion
108 Expert 100+
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
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
3,532 Expert 2GB
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
108 Expert 100+
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

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

Similar topics

3
by: Bob Dydd | last post by:
Hi Everybody I have an Access 2000 db with a setup for inserting images in records. I am using the image path only with the actual images stored elswhere on the hard disc. This works perfectly...
4
by: Jozef | last post by:
Hello, I have an application that I have been deploying with the Office 2002 / XP Developers Edition Package and Deployment wizard. The package that it creates is 180 MB in size. I would like...
5
by: Andrei Pociu | last post by:
Inside a method some controls are created at runtime. I added an event handler to one of these controls: tracker.Scroll += new System.EventHandler(this.tracker_Scroll); So in the event handler...
6
by: Earl Teigrob | last post by:
I am writing an application that dynamically loads user controls at run time based on user options. I would like to give my users the ability to build their own user controls and add them to my...
0
by: DotNetJunkies User | last post by:
Hi All I am developing a site using ASP.Net I want to develop a site that generates forms ( textbox,check boxes etc) automatically ie is from database itself depending on the no of rows in the...
3
by: Eric Sabine | last post by:
I've created a custom control (ascx) which contains a tree view, a drop down list, and a listbox. The custom control is included in a web form and at runtime, won't compile (I get the...
1
by: Mian Mahboob | last post by:
Nicholas Paldino in my application a have an Windows form on that i place an Panel Control. in Form load event i ganerate an Form in Panel Control on Runtime then get an design time create...
7
by: Varangian | last post by:
Hello is creating controls at runtime the same as designtime ? will a page be faster if controls are created at designtime rather than at runtime ? If so why ? thanks :)
2
by: tfsimes | last post by:
Hi, I am a long time ASP developer learning .NET, so please bear with me. I am trying to find an article or such that will help me understand how to change control properties at runtime based on...
0
by: porksmash | last post by:
I'm developing an app here that uses ActiveX controls to connect to industrial cameras over Ethernet. I want to be able to dynamically create those controls at runtime based on how many cameras are...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.