[AccessD] VBA Unbound data entry / update form

jwcolby jwcolby at colbyconsulting.com
Tue May 27 21:10:49 CDT 2008


LOL, I know what you mean about Rocky's code.

I tend to try and do things in an orthogonal manner such 
that the solution will apply again and again.  I have a 
distinct distaste for writing the same code over and over.

John W. Colby
www.ColbyConsulting.com


William Hindman wrote:
> ...lol ...Rocky has posted some points and he should know ...way back I 
> reviewed some code he sent me and I was simply dumbfounded by his use of 
> unbound code to do even the simplest things ...took me hours to decipher 
> code that was a simple update ...one line with bound forms ...reams unbound 
> ...but he had it down cold and it certainly worked without some of the bugs 
> we bounders take for granted ...I'd bet that if you had a look at some of 
> his code it would answer most if not all of your questions.
> 
> William
> "The truth is incontrovertible, malice may attack it, ignorance may deride 
> it, but in the end; there it is."
> 
> --------------------------------------------------
> From: "jwcolby" <jwcolby at colbyconsulting.com>
> Sent: Tuesday, May 27, 2008 9:20 PM
> To: "Access Developers discussion and problem solving" 
> <accessd at databaseadvisors.com>
> Subject: Re: [AccessD] VBA Unbound data entry / update form
> 
>>> It's beginning to sound like nobody really does it.
>> LOL.  It does sound that way doesn't it.
>>
>> Access' bound forms are magical, and most developers who
>> grew up in Access use them.  OTOH, old hard core programmers
>> from the bygone era didn't have magic solutions and grew up
>> hard coding solutions.
>>
>> Back in the good old days of the great bound / unbound
>> debate, the secret society of the UHU made all kinds of
>> claims about how unbound was better because.... So I just
>> assumed that now, when I actually needed to do it I could
>> call on some of them to show some code...
>>
>> It is remotely possible that the UHU are all still sleeping
>> off their memorial day celebrations.  ;-)
>>
>> John W. Colby
>> www.ColbyConsulting.com
>>
>>
>> Jennifer Gross wrote:
>>> I have no idea how to create an unbound form in Access.  I always use 
>>> bound
>>> forms.  Though I would be interested to know how it's done.  Unless I've 
>>> got
>>> it wrong, that seems to be the basic question here - For those of you who 
>>> do
>>> it, how do you create an unbound form?  How do you populate the textboxes
>>> initially and then how do you save the information back to the tables?
>>>
>>> It's beginning to sound like nobody really does it.
>>>
>>> Jennifer
>> -- 
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com 
> 
> 



More information about the AccessD mailing list