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
4 1543
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 -
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
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)>
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 -
Sign in to post your reply or Sign up for a free account.
Similar topics
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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 :)
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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)...
|
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...
|
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....
|
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
|
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...
|
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...
| |