Dan Waters
dwaters at usinternet.com
Fri Nov 13 14:08:30 CST 2009
Thanks Charlotte! I'll be getting there next year. :-) Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Friday, November 13, 2009 1:09 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access/SQL There are the properties that John mentions, but you can also specify a controleditor for a grid column and set that to another kind of control. We use customized versions of various controls to keep the UI appearance of them uniform. So we often set the editor to one of our custom comboboxes if we want more control than just a dropdown. This is really useful if we want to set a datetime coumn to one of our customized datetimebox controls or timebox controls, which handle the formatting and behavior automatically. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, November 13, 2009 10:29 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access/SQL Doug & Jim & Charlotte, Can you place comboboxes, checkboxes, etc. in the Grid View? I believe that the grid views I've seen were simply presenting data - like a spreadsheet. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, November 13, 2009 12:04 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access/SQL Dan, A continuous form is only needed because you don't have grids in Access and they don't have anywhere near the capabilities that a true grid control does because of the way bound/unbound fields are handled. Of course the plus side of that is that they don't consume resources like a grid does because of that. Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Friday, November 13, 2009 12:16 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access/SQL Doug - how do you set up a continuous form in VB.net? I use these extensively, and I bet almost all Access developers do too. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Doug Steele Sent: Friday, November 13, 2009 10:22 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access/SQL It's a bit nit picky, but based on my somewhat limited ASP.NET development experience (one web/SQL based app) 1. No multi column comboxes. True, but easy enough to work around. I've been moving away from multi column comboboxes in Access development anyway as I find them fiddly to debug (and this is me debugging my own code). 2. No paging. Gridviews page very nicely. 3. Different form types: Huh? Gridviews, Formviews, detailsview in .net. 4. Labels that move with controls. Who cares? Half the time when I'm working in Access I end up with unattached labels. Again, based on my limited experience so far, it takes me at least 4X the time to develop a screen in C# that it would in Access; but I've got 10+ years of Access experience and 100 or so hours of C#. My fingers are already developing .net habits and I know that in a year or so I'll be way faster. Doug On Fri, Nov 13, 2009 at 8:02 AM, Jim Dettman <jimdettman at verizon.net> wrote: > Doug, > > What would you not agree with? > > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com