[AccessD] How to see what a field contains with Access 2007

Tina Norris Fields tinanfields at torchlake.com
Wed May 16 06:38:48 CDT 2012


Me, too.
T

Tina Norris Fields
tinanfields at torchlake.com
231-322-2787


On 5/4/2012 12:05 AM, Charlotte Foust wrote:
> Me three on Fences, although I use the Pro version.
>
> Charlotte
>
> On Thu, May 3, 2012 at 7:46 PM, Rocky Smolin<rockysmolin at bchacc.com>  wrote:
>
>> Second that on Fences - I use it and it's wonderful.
>>
>> Rocky
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darryl Collins
>> Sent: Thursday, May 03, 2012 5:25 PM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] How to see what a field contains with Access 2007
>>
>> Yes, Fences is great - I also used Stardock's "Tiles" at work, which is
>> real
>> handy for grouping 'stuff' together etc.  Tiles is not free, but it has
>> been
>> worth the $9 US or so I paid.  I am not sure I would like it some much on a
>> small, or even single monitor, but I have two great big monitors at work
>> with gobs of spare screen space.
>>
>> Cheers
>> Darryl.
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
>> Sent: Friday, 4 May 2012 8:12 AM
>> To: Access Developers discussion and problem solving
>> Subject: Re: [AccessD] How to see what a field contains with Access 2007
>>
>> Steve,
>>
>> Thanks for the idea.
>>
>> I just finish writing the data to a flat file and then using  NotePad2 to
>> view the flat file.  It turns out that the two bytes are CRLF.
>>
>> There are probably easier ways to do this.
>>
>> Brad
>>
>> PS.  Notepad2 is a freebie - I don't use it a lot, but it does come in
>> handy
>> once in a while.
>>
>> PSS.  Speaking of freebies - "Fences" is free and it is great! - even my
>> kids like it.
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Goodhall
>> Sent: Thursday, May 03, 2012 5:08 PM
>> To: 'Access Developers discussion and problem solving'
>> Subject: Re: [AccessD] How to see what a field contains with Access 2007
>>
>> I would write code to walk through it character by character and display
>> the
>> ASCII equivalent.  Bear in mind that this is untested "air code."
>>
>> For i = 1 to len(sValue)
>>         debug.print asc(mid(svalue,i,1))
>> next
>>
>> Regards,
>>
>> Steve Goodhall, MSCS, PMP
>>
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
>> Sent: Thursday, May 03, 2012 5:44 PM
>> To: Access Developers discussion and problem solving
>> Subject: [AccessD] How to see what a field contains with Access 2007
>>
>> All,
>>
>> We have an Access 2007 application that reads data from a Firebird database
>> via ODBC.
>>
>> There is a field that appears to be spaces but it is not spaces.  We did a
>> "trim" and it went from 10 bytes to 2.
>>
>> We have tested for spaces and it appears that the two bytes are something
>> other than spaces.
>>
>> We would like to see what is in these two bytes.
>>
>> In a prior life (IBM Mainframe) we had utilities to "view in Hex".
>>
>> Is there anything like this for Access?
>>
>> Thanks,
>> Brad
>>
>> --
>> 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
>>
>>
>>
>> --
>> This message has been scanned for viruses and dangerous content by
>> MailScanner, and is believed to be clean.
>>
>>
>> --
>> 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
>>
>>
>>


More information about the AccessD mailing list