Colby, John
JColby at dispec.com
Wed Oct 13 10:04:34 CDT 2004
Hmmm.... You share Drew's eccentric mind? Is Vlad an alter ego? Or is Drew the alter ego? How many more of you are there in that eccentric mind? I believe this a first for the list, I can't recall ever seeing a split personality here before. John W. Colby The DIS Database Guy -----Original Message----- From: ACTEBS [mailto:actebs at actebs.com.au] Sent: Wednesday, October 13, 2004 10:49 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Recordset to a Continuous Form Drew, They just don't understand how our minds work do they?... ; ) I knew when I posted this that I would be ridiculed, but it's nice to have an understanding soul to the strange workings and motivations of the eccentric mind that we share isn't it Drew?... I liked Susan's solution as it only binds the form temporarily, while the user is viewing it. Once the form is shut down, the app remains totally unbound. One of the advantages of this approach too is that it gives you total flexibility to the path of the BE. No more refreshing the links when the app is started... Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of DWUTKA at marlow.com Sent: Thursday, 14 October 2004 12:07 AM To: accessd at databaseadvisors.com Subject: RE: [AccessD] Recordset to a Continuous Form Ah, the ol' 'Doing it just because you want to know you can do it!' philosophy. Welcome to my domain! <grin> Here's a few pointers on what you are trying to do. Number one, no, you can't. You can't 'trick' Access into using a continuous form, with unbound data. If you create a recordset, and set the form's Recordset to your recordset, you still have a bound form. The 'continuous form' feature of the form, is similar to the navigation buttons. They only work while Access is in control of the data the form represents. (bound). You can, however, roll your own unbound version of a continuous form. What is a continuous form? It's just a form that displays more then one record at a time. To replicate that in an unbound manner, you simply have to make 'copies' of the controls. This is somewhat of a pain, since Access doesn't really allow for control arrays (like VB does), so you have to create the controls you need at design time, and hide the ones you aren't using. Scrolling through the records is simply a matter of keeping track of your 'pointer' record. ie, if you have 6 'rows' of controls, to display a record (one record per row), and you have 12 records to display, at the beginning, record 1 will be in the first row (2 in the 2nd, etc...). Moving down one, now record 2 will be in the first row, and so on. I have done this before, but didn't scroll like that, I put in left/right buttons that let you jump to the next 'set' of records (moving right would put the 7th record in row 1). Why in the world would you want to do this for practical purposes? Well, the time I built my own, it was because I needed to create a dynamic combobox, that didn't work right in an bound form. I needed the combo box to display only the vendors available to buy a particular product from. In a single form, that was fine, but when I went with a continuous form, the combobox didn't 'act' seperately, changing one changed them all (because that's how continuous forms work, it's not really a control array...). With an unbound solution, I was able to set each combo box individually. It took another hour to two to build the form that way, but it accomplished the goal, and quite frankly was just as functional as a bound form. (for what I needed to use it for...) Hope this helps a little in your quest for 'Doing it just because you want to know you can do it!'! <Grin> Drew -----Original Message----- From: ACTEBS [mailto:actebs at actebs.com.au] Sent: Tuesday, October 12, 2004 10:48 AM To: access group Subject: RE: [AccessD] Recordset to a Continuous Form **I originally sent this exclusively to Joe for some reason. I clicked reply without checking the "To" field. Sorry Joe...** Joe/Charlotte, I'm screwing around trying to teach myself some new tricks and am creating a totally unbound app using A2K. I know, I know, everyone is saying, well why not use VB, but that's not the point of this exercise. So basically, I have an FE that basically opens up recordsets as needed from the BE. Problem is I can't figure out how to populate a continuous form which is one of the really cool features access has over other development environments. List boxes and combos are fine as I create a string and populate like a Value List. So any ideas? Vlad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Wednesday, 13 October 2004 1:21 AM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Recordset to a Continuous Form There's not really any such thing as a continuous *unbound* form. The only thing that makes it a continuous form is the bound recordset. You can display a recordset in a grid control, but it won't behave the same as a continuous form. Perhaps if you explain what you're trying to actually accomplish, someone can help. Charlotte Foust -----Original Message----- From: ACTEBS [mailto:actebs at actebs.com.au] Sent: Monday, October 11, 2004 7:17 PM To: access group Subject: [AccessD] Recordset to a Continuous Form Hi people, Does anyone know of a method to display a DAO recordset within a A2K continuous unbound form? Also, is it possible to edit the recordset and save once changes are made? Any help much appreciated... Vlad -- _______________________________________________ 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