473,503 Members | 2,105 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subforms - emulating MS Access....

I know that the design itself is not optimal, but the client wants it to
work, look and feel EXACTLY like their poorly-designed Access application...

What I need to figure out how to do is emulate a repeating subform in VB.NET
Winforms.
I don't think I can use a datagrid, because it is a larger section that is
repeated (some textboxes here, some checkboxes underneath, some comboboxes
over to the right...)

All of the controls are currently on a Panel on a form. Can't I just do
something like instantiate a new instance of that panel? Would this be a
custom control? I know just barely enough to be dangerous in .Net--OO
programming is pretty new to me.
If someone could at least point me in the right direction, that would be
great!

BradC
Nov 20 '05 #1
3 3061
IMO if the client wants something that looks and feels EXACTLY like
Access, then the only realistic approach is to use Access. .NET was
not designed to be an Access-replacement, and the rich data-bound
controls that you have in Access simply don't exist in any other
application. Is it possible that you could take the poorly designed
elements of the Access app and fix them in Access? There's lots of
really horrible Access apps out there, but that's not the fault of the
product, just ignorant developers. It is possible to create a
lightweight Access app and still take advantage of its built-in
features. The reason I say this is that IMO you stand a better chance
of making your client happy by taking that approach than trying (and
probably failing) to satisfy them by using another product which you
don't even know very well. Just my $.02.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Wed, 17 Dec 2003 09:34:59 -0600, "BradC" <br********@yahoo.com>
wrote:
I know that the design itself is not optimal, but the client wants it to
work, look and feel EXACTLY like their poorly-designed Access application...

What I need to figure out how to do is emulate a repeating subform in VB.NET
Winforms.
I don't think I can use a datagrid, because it is a larger section that is
repeated (some textboxes here, some checkboxes underneath, some comboboxes
over to the right...)

All of the controls are currently on a Panel on a form. Can't I just do
something like instantiate a new instance of that panel? Would this be a
custom control? I know just barely enough to be dangerous in .Net--OO
programming is pretty new to me.
If someone could at least point me in the right direction, that would be
great!

BradC


Nov 20 '05 #2
Cor
My idea also in this

Nov 20 '05 #3
Just for anybody interested, I made a "repeating subform" by creating a
usercontrol, and manually placing copies of that usercontrol down a panel. I
did run into an error when I tried to put more than 207 of these
usercontrols on a form. I don't know whether there is a control count limit,
or a form size limit, or if it was just a memory issue. I ended up changing
it so that only 6 of the controls appeared on the screen, and as you
scrolled through, it simply populated them with different data. (kinda like
Access!)

UserControls are pretty dang sweet. You can control what properties of the
internal controls are exposed, and even pass events and stuff like that.
This is probably old hat to most of you, but from a VB6 background, I was
pretty impressed with the level of control you have with these objects.
Nov 20 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2974
by: M Wells | last post by:
Hi All, I am developing an Access 2003 project application with the back end in SQL Server 2003. I have a master form that tracks projects, and several subforms on it that track various...
2
2985
by: Jack | last post by:
Hi all, I searched the archives and found everyone happy with Stephen's MouseWheel On/Off code except for those with subforms. Stephen's page indicates that he has added code to handle subforms...
0
2225
by: Jack | last post by:
Gday everyone, I'm dearly hoping Stephen Lebans is going to update his masterpeice to stop the mouse wheel scrolling to work on subforms *he has indicated this to me but of course beggers can't...
3
3832
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
12
1976
by: Paul T. RONG | last post by:
Is it possible to divide a tall subform with 80 records to two subforms each with 40 records? Dear All, What I have: Tables: tblProduct, tblOrder, tblOrderDetail
8
3062
by: Zlatko Matić | last post by:
Hello. How can I synchronize subforms content with current record in master form, if both form and subform are based on DAO code ? I assigned DAO recordset to forms by using QueryDef, on Load...
2
1995
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
4
6018
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
4
5368
by: Rich P | last post by:
Maybe you could try using a query as the recordsource for your subforms and for the criteria field in the query you could use a Form parameter. This way - instead of using the form filter property...
0
7093
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7287
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7467
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5592
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5021
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
0
4685
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
1519
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
744
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
397
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.