473,657 Members | 2,439 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 3077
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********@yah oo.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
2982
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 aspects of the project. On the masterform I have two unbound listboxes that I populate with information regarding the current record in one of the subforms.
2
2995
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 ("Bug Fix for SubForms with ScrollBars. Bug fix for SubForms without visible ScrollBars.") - BUT I still can't get it to work on my app with my subforms. I'm using Access 2000, It works fine on the main forms but not on the
0
2239
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 be choosers here so I have no idea when this would be done*. I'm just wondering if anyone has gotten around the problem some other way? --Original Thread---
3
3837
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, Intake, Financial, Fees, Payments, Bills, Bill Line Items. The design works thusly - Client Main relates to Intake. Intake relates to financial. Financial relates Fees, Payments and Bills. Bills relates to Bill Line Items. On the form, I use the...
12
1997
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
3087
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 event. Thanks...
2
2015
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 project name, one primary point person for it (1:N list from a separate table), other details, and a manually entered tracking number, which is the primary key. Now, I also need to put down the legal entities, business managers, financial...
4
6046
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 this is all very difficult to explain in words, please bear with me as I endevour to explain what it is I am trying to do. It would be helpful if I could attach a graphics file to this posting that would help explain what it is I'm trying to achieve...
4
5395
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 you could set a value in a textbox on your mainform which would filter the query. This way all of your subforms are synchronized. fieldname: fldx Criteria: Like Forms!Form1!Text0 Text0 would be a textbox on your main form (Form1 or...
0
8402
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8734
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8508
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8608
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6172
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5633
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4164
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4323
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1962
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.