Populate a form with a recordset
Wed, 22 Mar 2006 05:36:13 -0800
I've got three books on programming ADO, and I don't see a clear cut and
dry way to populate a form with a recordset.
I have populated a test form. but I'm not sure how it happened. I used:
For Each Ctl In Me
vartemp = Rst.Fields(Ctl.Name).Name
If Ctl.Enabled Then
...
|
China ZhongZhan Aids Mei Mei
Tue, 21 Mar 2006 04:48:19 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
China ZhongZhan Aids Mei Mei
Tue, 21 Mar 2006 04:48:13 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
correct code please
Mon, 20 Mar 2006 08:55:14 -0800
I apologise if this is considered a repost, I posted below about the method
of Object... I got a response and spent the past 4 hours trying every
combination to not get that error and the only way is to omit the criteria.
This is the code I have that I think should return one record and is giving
me the e ...
|
Trap SQL Server Error 4060
Mon, 20 Mar 2006 07:07:49 -0800
I'm using Access 2003 and conneting to a SQL Server Database.
When the database first opens, a vba function is called and creates the
dns-less connection and it works great if the server name and database name
exists.
If I change either the servername or database name to a non-existant one,is
there a way ...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 18:08:34 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 18:08:26 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
|
|
Obtain Autonumber value after record creation.
Sat, 18 Mar 2006 17:23:27 -0800
When adding a record to a table whose key field is an autonumber field how
can I obtain it's value with 100% confidence.
Sure immediately afterwards I can read the last record in that table and 99%
of the time be sure it's the one I have just created but there is still a
slight posibility that another pro ...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 08:55:24 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
China ZhongZhan Aids Mei Mei
Sat, 18 Mar 2006 08:55:12 -0800
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|