Recent Posts

9951

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 04:54 PM »

sounds good...works good too!

so, going back to that filter
this is maybe more an organisational question/thought than an SQL-Notes one...
-
I could really use the same grid for estimates and work-done/Billing
(kind-of what I was doing for the last while, but in a more chaotic uncomprehending kind of way )
estimate items having no startdate
and work done having start/end dates
then,
simply use filter to remove one or the other as required...

doesnt work though cause source is "StartDate" (estimates having none)-
"StartDate or Duration" seems to work okay with filtering for estimates/work-done
any fundamental objections - shout, otherwise I'll try it for a while

off to dreamland, thanks again for help

9952

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 03:50 PM »

you need to set the BillingNo field for each item that make up the invoice.

-PPLandry (February 07, 2008, 03:25 PM)

now they disappear as expected, logical as usual!  - not my strong point at times though

As to the filter syntax, the software is called... SQLNotes... Any idea why?
Answer here: http://en.wikipedia....wiki/Where_%28SQL%29

-PPLandry (February 07, 2008, 03:25 PM)

I think I'll have to look at that again when I'm a bit fresher

9953

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 03:07 PM »

hey, that worked
thanks Pierre!

also figured out why stuff was missing from Billing grid -
the filter was on:-

duration >= 0  and StartDate is not null and BillingNo is null

and I had added some items without start dates


Now, I'm curious -
there's some items here where the job is finished so I've added invoice number to Billing number column -
I wouldnt have thought they'd show with that filter, but they do -
I'm wondering why?

Also wondering is this filter-speak/language something that's unique to SQL or is it something more universal -
and if there's anywhere I can get a few tips with it!!

9954

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 09:01 AM »

hmm,
I thought it had been default -
was there maybe an estimate one and I just changed the name
hey!
it must have been default at some stage - see screenshot here, same columns and name,
http://sqlnotes.wiki...es.com/Time+tracking
that one has "StartDate and enddate and Billing"
which doesnt work here..

gotta go now will try later or tomorrow

9955

Finished Programs / Re: IE7 Classic Menu Enabler

« Last post by tomos on February 07, 2008, 08:25 AM »

dont use IE often but thanks - makes it easier

9956

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 08:24 AM »

THe "journal" idea sounds good Pierre (I hadnt any other fields filled except some html notes on one or two of them)
will go try

-tomos (February 07, 2008, 07:41 AM)

that didnt actually work
(maybe I not using the date filter correctly - no I double checked - followed your instructions exactly..)
but I found them via the IDItem number, they were all fairly recent so it wasnt too painful

I have another problem now - I've lost the three most recent entries in "Billing" too so I tried the same thing
again without success - even though the missing things are visible in "Projects" (so they not "lost" as such..)
But my main problem right now is that I've changed the grid-source in Billing & want to change it back but didnt keep note of what it was...
Is one (=me!) supposed to keep track of that or is there some easy way to get back to last known or default source

9957

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 07:41 AM »

THe "journal" idea sounds good Pierre (I hadnt any other fields filled except some html notes on one or two of them)
will go try

9958

General Software Discussion / Re: SQLNotes...what is it exactly?

« Last post by tomos on February 07, 2008, 07:18 AM »

help...lost a few items from ToDo list -
I deselected box in inbox column
F5 gone

"ToDo or due or FollowUp or inbox"
cause they werent selected as done, I presumed they'd not dissapear!
There wasnt much but I cant remember what exactly they were so cant search..


speaking of ToDo, I'll bump this idea:

As part of the GTD implementation, new quick Add Item form is now available. CTRL-N to open it. A system-wide shortcut is also available to open it from anywhere (CTRL-ALT-N): (see attachment in previous post)

You can enter item text, decide into which folder to put it in (normally, the inbox) and put a due date if required

-PPLandry (January 11, 2008, 11:20 PM)

I'm trying to figure out what they are in the drop down list - are they all yes/no fields maybe/I think - yes, apart from "Adress"
You call them folders (thought there wasnt any of them in SQL )

What I would love to see:-
want to organise my ToDo by Projects & maybe a couple of miscellaneous or whatever
If (in this Crtl+Alt+N box) I could save stuff in ToDo grid - but also choose an item (Project) and make the note a sub-item of this item

So then when I go in to ToDo I can look at a particular project or two, or naturally I can sort in some other way if preferred

Then, even better, if I could number them in some way that if I drag an item up the line the number changes
I suspect that's not likely possible - I'm trying to think of some way that I can easily change the order of the items - in order to make them show in order of importance. eg. new item that I want to slot into place three in a list of ten items
Then I could hopefuly show the top few from each project by filtering

-tomos (January 20, 2008, 05:58 AM)

9959

Living Room / Re: Latest DC demo poll: When were you born?

« Last post by tomos on February 07, 2008, 04:18 AM »

you got company there Zaine in the 1961 to 70 bracket

9960

Living Room / Re: Seeking free photo organiser that uses gmail to email photo's

« Last post by tomos on February 07, 2008, 02:22 AM »

Just like Picasa, that isn't working anymore 

-karlyRana (February 06, 2008, 09:19 PM)

what's wrong with it?
seems like a good solution to fix it if possible?

9961

Living Room / Re: OK - lets get to know each other... who are you, what do you do, where from?

« Last post by tomos on February 06, 2008, 10:32 AM »

hi Denny and Dave! Welcome and all that!
Mitzevo, you relax now-hear?!

9962

FARR Plugins and Aliases / Re: Character Table

« Last post by tomos on February 06, 2008, 04:21 AM »

mouser!!
give that man a plugin medal 

9963

General Software Discussion / Re: I wish there was a way to trade software licenses.

« Last post by tomos on February 05, 2008, 07:23 AM »

I know Adobe had a transfer option on their software -
dont know if they still do.. then you know it's officially yours at least

9964

Living Room / Re: Mold your RSI

« Last post by tomos on February 04, 2008, 12:38 PM »

This is very cool. Lite-On, known for being one of the top optical drives manufacturers, recently won the Red dot award for the "Best Design Concept" with its "Moldable Mouse" proposal, that just does what it suggests.

-Lashiec (February 03, 2008, 08:05 PM)

I'd go for it in a shot...
"covered with nylon and polyurethane blend fabric." -
wonder if it'll be machine washable too - or maybe I should go for the waterproof inflatable one 

9965

Living Room / Re: How do you repair screw holes in computer case after too much use?

« Last post by tomos on February 04, 2008, 12:10 PM »

Cooler Master
CM 690 ATX Mid Tower
...
Has anybody used one of these before? Did you like it?

-tinjaw (February 04, 2008, 07:23 AM)

no, but had a look at Geizahls.de - mixed but generally positive customer reviews - probably absolutely super at that price but not at full price (complaints about the details/finishing)

9966

Living Room / Re: Brush the dust from your computer

« Last post by tomos on February 03, 2008, 11:42 AM »

wonder what the bristles are
guess it's important that they're natural -  (not so "staticy")
I've never used shaving brushes - I know the more expensive ones are badger hair but after that ...
must look see whats on offer here

9967

Mini-Reviews by Members / Re: FastStone MaxView Mini-Review

« Last post by tomos on February 01, 2008, 07:41 AM »

what I miss in most viewers is the option to zoom into a selected area of image

-tomos (February 01, 2008, 07:07 AM)

Oh, but MaxView won't let you down on that! Try pressing ctrl and dragging with left button!

-jgpaiva (February 01, 2008, 07:24 AM)

ahhgh SUPER!! -I'm sold!

and
@Perry, repeat continuously works nicely -
I did like the warning in imagine but can imagine that [in imagine ] getting annoying too

9968

Mini-Reviews by Members / Re: FastStone MaxView Mini-Review

« Last post by tomos on February 01, 2008, 07:07 AM »

Thanks for the review jgpaiva !!

I been using Imagine very briefly lately. as reported by Lanux

this came up in gHacks recently: Imagine. looks good but haven't tried it yet..

-lanux128 (January 18, 2008, 02:34 AM)

what I miss straight away in Faststone (compared to imagine) is that it wont go from last file in folder back to first ("Jump to the first file?" box pops up)
also miss the modifiable shortcuts..
but I'm finding Imagine either a bit buggy or else it has very strange defaults with regard to zoom - havent looked into it enough yet
[edit - what gets me most about imagine is no pan you hae to use arrows - edit]

Faststone does give a lovely full view of images - no messing around with windows etc!
so think I'll try it a bit

what I miss in most viewers is the option to zoom into a selected area of image
e.g. in adobe and other graphics products:
-
Ctrl+Spacebar and click/drag to select area to zoom into - add alt for zoom out
Spacebar for pan -
(mind you thats all a bit broken in Acrobat 8 - changing from zoom to pan doesnt work properly)

9969

Mini-Reviews by Members / Re: WikidPad - an IDE for your thoughts

« Last post by tomos on February 01, 2008, 04:43 AM »

OK, I'll attach a very quick wink of some editing in WikidPad. You basically just
1. Type your thoughts
2. Select the word/s that you want to become a link to a new page
3. CamelCase them or surround with square brackets (which will turn them into a link)
4. Access the link by double click (which will take you to a new page)
5. go to #1 and start typing again (if you think that's cyclic, wait till you see the wink  )

-Perry Mowbray (January 31, 2008, 09:38 PM)

Perry: you're a star

Will go off now to find the infinite loop

9970

Mini-Reviews by Members / Re: WikidPad - an IDE for your thoughts

« Last post by tomos on January 31, 2008, 04:47 PM »

can someone help me get going here!! (as said earlier I've no wiki experience so far)
-
I've created a new wiki
currently there's "WikiSettings" as a link in there

eh, do I just start typing or what
help is alphabetical which might be helpful to someone but it's no quick-start-guide

I understand the basics of linking (I think) but dont understand how info is displayed -
are there different "notes" or "pages" - if so how do i create a new one?

thanks,
Tom
[edit] under plugins I found "create new page" - I guess that's it ??

9971

General Software Discussion / Re: https by default?

« Last post by tomos on January 31, 2008, 03:07 PM »

But GMail is https by default...

-Lashiec (January 31, 2008, 10:44 AM)

you got me there Lashiec - maybe it was written for when it wasnt
or maybe it's because of this: Even SSL Gmail can get sidejacked

9972

General Software Discussion / Re: https by default?

« Last post by tomos on January 31, 2008, 04:22 AM »

IIRC there is a greasemonkey script that will switch to https for all sorts of sites from google. Maybe that can be extended to include your forums.

-housetier (January 30, 2008, 02:04 PM)

I have Better Gmail 2
https://addons.mozil...S/firefox/addon/6076
which allows you to force https for gmail

I think I got it via Lifehacker though

9973

Living Room / Re: What kind of tagging system would be appropriate for DC?

« Last post by tomos on January 31, 2008, 04:15 AM »

For example, in the Coding Snacks board, ideas that have come to fruition and have sprouted fully-fledged, named applications _{(mixing my flora and fauna metaphors there)} are still to be found in threads titled "IDEA: description of idea".  It would tidy things up a lot to rename these threads with something like "DONE:" and the application/script name.

-suleika (January 30, 2008, 06:49 PM)

GridMove (IDEA: drag window to edge automatically resizes it), TitleLog (IDEA: Very simple timeclock utility) come to mind straight away...

9974

Mini-Reviews by Members / Re: WikidPad - an IDE for your thoughts

« Last post by tomos on January 31, 2008, 04:13 AM »

sounds great Perry (great review I mean too )

Looking forward to installing it this evening, thanks!

9975

Found Deals and Discounts / Re: DirectAccess - Text Expander program for free today at GAOTD

« Last post by tomos on January 30, 2008, 03:43 AM »

So, Tom, how are you finding DirectAccess, then?

-Darwin (January 29, 2008, 06:29 PM)

ehh...
the last week I've been totally bogged down with PDFs that look and print perfectly on my machine but not on others (I've actually found a solution but now have to redo them) so I havent even looked at it - I saw it in the context menu once though

will reply again when things calm down !