PC Review


Reply
Thread Tools Rate Thread

Determining Data Types

 
 
Nancy
Guest
Posts: n/a
 
      25th Sep 2003
In my VBA/Access Application, I am trying to get rid of
null values in a recordset I have just created. What I
would like to do is loop through the recordset and set
the values to "", 0, 12:00:00 AM, depending on whether
the data type of the field is text, currency, or date. I
could do it the long way and go through each field in the
recordset, but I would like to know if there is an easier
way in which I can determine datatype and then go from
there.

Thanks!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Determining the text mode from a variety of data types matt3542 Microsoft Excel Worksheet Functions 17 31st Jul 2008 08:01 PM
determining drive types =?Utf-8?B?R3JlZ1Q=?= Microsoft Dot NET 7 9th Mar 2005 09:45 AM
Dynamically determining C# data types from empty Database tables =?Utf-8?B?RmlzaE5CcmV3RHVkZQ==?= Microsoft ADO .NET 2 31st May 2004 04:01 PM
Re: Determining Data Types Van T. Dinh Microsoft Access VBA Modules 0 26th Sep 2003 12:41 AM
Determining Data Types Peter Microsoft Access VBA Modules 0 25th Sep 2003 09:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:52 AM.