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

Darryl Collins darryl at whittleconsulting.com.au
Thu May 3 23:28:36 CDT 2012


A few more tricks - there are a couple of UI features, plus the ability to arrange the icons as you like within the fence - you can also set up where new icons go (ie specify exactly which fence to put them, or by xtn type etc).  I have the pro version too, which I rather like.  Was $9 on sale at the time so I thought "what the hell..."

Here is the official blurb <<http://www.stardock.com/products/fences/information_pro.asp>>:

What do I get with Fences Pro?

Fences Pro(r) is the $19.95 add-on to Fences that allows you to do even more to keep your desktop organized and clean. Fences Pro includes such features as sorting, automatic organization, more visual tweaks, and automatic snapshot taking to ensure nothing ever happens to your desktop's layout.

With Fences Pro, you can specify a default Fence for all new icons to go to. By utilizing rules (as detailed below), you can also customize this setting based on the time of day, day of the week, or what program you are currently using.

Rules: Easy, automatic desktop organization:
Want a fence to help keep track of all your recent documents? Done. Another for your web links? All set. Another for your downloads? A click away, and maintained for you automatically. Fences Pro's organization settings allow you to quickly and easily define rules that govern where new icons get placed. Additionally, you can also have rules that are applied at all times, keeping your desktop organized 24/7.
 	
Sort your fences:
Fences Pro includes the ability to sort icons within fences, by any of the usual categories such as name, type and date modified. Additional options unique to Fences, it can also sort your icons by the date added to the fence, or the number of times used, keeping your most accessed items in front. 
	
Fading Fences:
Now that you've organized your desktop into tidy Fences, you may find yourself using the double-click quick-hide feature a lot. Perhaps you're really using it because you do need your icons, but you don't want them "taking over". A new feature found in Fences Pro looks to make life even easier, allowing you to fade individual fences to be only partially visible, then bring them back by simply mousing over them. Check out the live demo on the front page - this feature scores high on our list for both cool, and everyday-helpful.

HTH a bit

Cheers
Darryl.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Friday, 4 May 2012 2:22 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] How to see what a field contains with Access 2007

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

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