How do I save data on a form to my database?
in [Forms]
|
Prev: Could somebody please tell me what this means.
Next: Open form with specific record, but other records accessible
From: adamskiii on 16 Mar 2010 20:08 I just believe that I have more control with an unbound form. "Jack Leach" wrote: > What kind of backend are you using? I assume this is an MSAccess database as > nothing has been noted otherwise... if this is in fact the case, then there > is no reason whatsoever to be using any recordset an all, let alone using ADO! > > As Al said, you are going the looooooong way around. If you have a standard > ms access table and form, just use the wizard to make a form that is bound, > and all of this is taken care of for you (using Access's native DAO, not ADO). > > -- > Jack Leach > www.tristatemachine.com > > "I haven''t failed, I''ve found ten thousand ways that don''t work." > -Thomas Edison (1847-1931) > > >
From: John W. Vinson on 16 Mar 2010 23:20 On Tue, 16 Mar 2010 17:08:01 -0700, adamskiii <adamskiii(a)discussions.microsoft.com> wrote: >I just believe that I have more control with an unbound form. Sure, but that means that you must do Every Single Little Thing that Access does for you automatically. Unbound forms are in fact useful; they are also slower, much more complex, and far more difficult to create and maintain. Your choice! -- John W. Vinson [MVP]
From: Al Campagna on 16 Mar 2010 23:41
adamskii, What "control" would that be... that couldn't be done on a bound form? And... how do you plan to edit or delete your existing records? -- hth Al Campagna Microsoft Access MVP 2007-2009 http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "adamskiii" <adamskiii(a)discussions.microsoft.com> wrote in message news:00811906-9BD3-41D2-84E2-D8452284D273(a)microsoft.com... >I just believe that I have more control with an unbound form. > > "Jack Leach" wrote: > >> What kind of backend are you using? I assume this is an MSAccess >> database as >> nothing has been noted otherwise... if this is in fact the case, then >> there >> is no reason whatsoever to be using any recordset an all, let alone using >> ADO! >> >> As Al said, you are going the looooooong way around. If you have a >> standard >> ms access table and form, just use the wizard to make a form that is >> bound, >> and all of this is taken care of for you (using Access's native DAO, not >> ADO). >> >> -- >> Jack Leach >> www.tristatemachine.com >> >> "I haven''t failed, I''ve found ten thousand ways that don''t work." >> -Thomas Edison (1847-1931) >> >> >> |