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

Rocky Smolin rockysmolin at bchacc.com
Thu May 3 23:21:43 CDT 2012


What does pro do? 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Thursday, May 03, 2012 9:06 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] How to see what a field contains with Access 2007

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
>
>
>
--
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