Recent Posts

9876

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

« Last post by tomos on February 17, 2008, 02:14 PM »

Amando, you mentioned error #91 somewhere
did you get any info on it?

I was changing the colours for a grid in options and you have to restart for them to take effect (sometimes anyways) and now it wont start,
well, it starts up but then I get

---------------------------
SQLNotes
---------------------------
Run-time error '91':

Object variable or With block variable not set
---------------------------
OK   
---------------------------

and it crashes...
Tom

9877

FARR Plugins and Aliases / Re: Process Kill Killed FARR

« Last post by tomos on February 17, 2008, 02:08 PM »

I've had that a couple of times - it's when I leave FARR running during the update, it gets closed down & I get that message
Didnt think anything of it cause no problems after

EDIT/ think it is normally closed down so plugins get reloaded on restart & for some reason there's a problem with that.
I've had problems lately with shutting down computer (hangs) and I'm not sure how to find the culprit - just mention it cause FARR still running at that stage

9878

Living Room / Re: about to switch to a Widescreen LCD.

« Last post by tomos on February 17, 2008, 12:49 PM »

Sorry to bother you folks, I've found my answer, DVI-D to DVI-D cable will work just fine. 

-oldfart (February 17, 2008, 08:12 AM)

is there a typo in there
I guess you mean a DVI to DVD adapter works fine...
It's good to read all that, thanks - could save me a bit of time when I finally go flatscreen (I've chosen one but of course it's very expensive so going to have to wait another little while)

9879

Mini-Reviews by Members / Re: List of disc catalogers

« Last post by tomos on February 17, 2008, 08:02 AM »

CD Bank Cataloguer
http://www.qunomsoft.com/
there is development in alpha stage that can be downloaded

-tomos (March 14, 2007, 02:47 PM)

corrected website address
anyone using this one?

9880

FARR Plugins and Aliases / Re: Google Dictionary

« Last post by tomos on February 17, 2008, 06:05 AM »

hmmm,
doesnt work here -
the dictionaries (0 to 10) show
I've tried various numbers/words also default with no number, but when I press return I get no response
eg as in your example
gd 10 school

-tomos (February 16, 2008, 12:27 PM)

Did you type "," to start searching?

-taichimaster (February 16, 2008, 12:41 PM)

nope, that was the problem - didnt realise I had to type a comma at the end
THANKs taichimaster and czechboy of course

9881

FARR Plugins and Aliases / Re: Google Dictionary

« Last post by tomos on February 16, 2008, 12:27 PM »

hmmm,
doesnt work here -
the dictionaries (0 to 10) show
I've tried various numbers/words also default with no number, but when I press return I get no response
eg as in your example
gd 10 school

9882

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

« Last post by tomos on February 16, 2008, 11:19 AM »

that post above is for Version9, tested around March 2007

9883

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

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

actually I dug out Crush's benchmarking file (which I've never uploaded )

he says

Sehr umfangreiches Prgrammen (von den Funktionalitäten und Suchoptionen her) – Aber leider hat es total denn Sinn eines derartigen Programms verpaßt, da die Suchzeit selbst bei einer direkten Suche mit fast keinen Ergebnissen schon bei kleinen Datenmengen seeehr sehr lang braucht und bei größeren Ergebnislisten ins nahezu unermeßliche anwächst. Eine normale Suche mit dem Windows-Explorer wäre tausendfach schneller. Nach 10 Minuten und 36100 durchsuchten Datensätzen habe ich abgebrochen und das Ergebnis hochgerechnet. Vermutlich ist das noch verschönt, weil mit der Anzahl der Ergebnisse jede weitere Suche quadratisch mehr Zeit benötigt. Aber selbst so sind 60 Einträge pro Sekunde absolut unterste Kategorie. Für Kommerzielle Software heftig.

this via google with minor corrections - you get the idea I think

Very extensive Prgrammen (on the functions and search options ago) - but, unfortunately, it has  missed the total sense of such a programme because the search time even with a direct search with almost no results even for small amounts of data needs very veerrry long  and result in larger lists nearly immense grows. A normal search with the Windows Explorer would be a thousand times faster. After 10 minutes, and searched 36100 records, I stopped and the results extrapolated. It is likely that the still beautifies because with the number of search results each additional square needs more time. But even then 60 entries per second absolute lowest category. For commercial software violent.

I like that image - "violent" software -
brutal prob fits better

9884

Mini-Reviews by Members / Re: List of disc catalogers

« Last post by tomos on February 16, 2008, 09:57 AM »

Holy wowze, there has been a lot of discussion around about CD cataloggable-izerators.  So, there are a kajillion different ones, including some free ones, but if you have had your eye on CD Catalog Expert, today might be your day to snag it at Bits du Jour, http://www.bitsdujour.com/software/280/.

-jiffener (February 16, 2008, 09:33 AM)

9885

Found Deals and Discounts / Re: CD Catalog Expert on Bits du Jour today for $17.97

« Last post by tomos on February 16, 2008, 09:56 AM »

got your links all right there jiffener 
doesnt seem to be any comments around about this one though
are you familiar with it yourself?

9886

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

« Last post by tomos on February 16, 2008, 09:45 AM »

changed the screenshot in last post...
changed "checked" column to "changed" (try saying that fast!)

9887

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

« Last post by tomos on February 16, 2008, 09:14 AM »

Pierre
I changed "Done" field to new one called "FIN" cause I dont want things marked "done" in other grids going funny colours..
Added a "File" yes/no field, now source of grid
When I add things to grid this automatically selected = RED (= to be done)
can resend you the file if you want

I can't wait to see what you did tomos... 
Inspiration...

-Armando (February 16, 2008, 12:00 AM)

eh  dont think I'd go that far Amando!
I've never been one for using search or filters much and I guess I'm very visual, so,
with lots of files being worked on, I can see progress at a glance (colourwise) and sort by column heading to see what has to be done/checked etc
With files taken from my screenshots folder:



SQLnotes09.png  just added,  (File box gets automatically ticked*) = Red = To be done!
SQLnotes08.png  finished,  FIN = Blue = sent on for approval/return
SQLnotes07.png  ChangeRequest ticked = Yellow + DateRequest (date added automatically)
SQLnotes06.png  Changed ticked (changes implemented) = Purple + DateChanged (date added automatically)
SQLnotes05.png  as #06 but Approved ticked = Dark Blue
SQLnotes04.png  Approved (without any changes requested)

again:-
if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

* I've hidden this column/field, just show it here for clarity (I hope)
[edit] changed the screenshot: "Checked" box now called called Changed, (changes implemented)

9888

Living Room / Re: about to switch to a Widescreen LCD.

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

Now I seem to recall a grid type program discussed on here that let you chop up regions of the screen. i will have to search that out. :Thmbsup

-PaladinMJ (February 16, 2008, 04:52 AM)

GridMove
http://jgpaiva.dcmem...rs.com/gridmove.html

9889

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

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

Isn't it great tomos?

-Armando (February 15, 2008, 01:47 PM)

tell me about it !!
I've been struggling for years trying to organise this stuff and finally I can see the light

9890

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

« Last post by tomos on February 15, 2008, 02:02 PM »

thanks for the tips Pierre
you say -

>I'd rename the grid and change the source to enable many projects shown in the grid.

I'm unsure of the best approach
This grid actually started off within the Billing grid which has a yes/no "Projects" field as the source
Now theres naturally going to be an overlap with projects here, but I dont fully understand how to approach that

Maybe if I had a yes/no "Drawings" field, I could include "projects" and exclude any NON-drawings thereby include various other projects too
That would be done in the filter presumably?
Speaking of which I cant seem to filter yes/no fields atall -
for "Checked" I get nothing
for "Checked is null" I get everything

Checkboxes are a little different than you might expect (unless you know SQL). For example, for the Checkbox field Followup you would use Followup if you want to search for checked or Followup is null if you want to search for unchecked.

-from the wiki

9891

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

« Last post by tomos on February 15, 2008, 01:34 PM »

Got it thanks! Very very interesting ! Some advanced stuff in there... you're progessing well!  :Thmbsup

-PPLandry (February 15, 2008, 01:16 PM)

thanks
it's a joy to get off the ground a bit,
especially now I'm going back to this job with hundreds of drawings after a long break (and I thought I left it in an organised state but I didnt have anything like this programme then..)

Re the grid I sent -
I forgot to add notes describing what happens when field clicked or whatever
[edit] I mean in the Manage Fields box

9892

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

« Last post by tomos on February 15, 2008, 01:34 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected

-tomos (February 15, 2008, 01:28 PM)

Sure, but you need to use user-code for that! 

-PPLandry (February 15, 2008, 01:30 PM)

oh-oh

9893

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

« Last post by tomos on February 15, 2008, 01:28 PM »

but going back to the colour thing is there a way to say:

change the colour when ticked IF "Approved" is NOT selected

9894

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

« Last post by tomos on February 15, 2008, 01:14 PM »

how it looks here



The presumed sequence is:

Done = Blue
ChangeRequest = Yellow + DateRequest
Checked (changes implemented) = Purple + DateChanged
Approved = Custom colour (dark blue)
[Working left to right]

if a box is unticked it goes back to logical previous colour, except for
Approved - this goes back to Blue when unticked

[edit] think some colour advise is required to make pretty! [/edit]

9895

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

« Last post by tomos on February 15, 2008, 01:11 PM »

No rush.

You can make a copy and delete most (or all) items

-PPLandry (February 15, 2008, 11:20 AM)

sent it to Support@ - before I make it unintelligible !!
you'll have to extract it from the database -is that difficult to do?
-
I made a temp database to experiment and was surprised by some of the goodies in there
I wouldnt mind getting some stuff from it to my current database if not too difficult

9896

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

« Last post by tomos on February 15, 2008, 12:01 PM »

only thing is I'm running out of colours

Blue is DONE
Yellow in Change Requested
Purple is changes made (still has to be approved)

Red could be in Progress or To be Done.. or maybe no colour for that
Then a separate Tick box for Approved/Finalised I guess (Hows about a green colour for that ?)

I guess when an item has a colour it can only have one..
what I mean/thinking is:
it's not usually a problem but if you tick something by mistake that changes the colour*
and you then untick it -
it would be nice if it automatically went back to previous colour - is there an equation for that in the “Auto-assign rules”

(just added 85 files ..wooHoo.. )

[edit] this can happen for example, something is approved and they then decide to change something else
gotta deselect approved, but then I guess it goes back to change rrequested colour. Ahh, logical as usual (I think) [/edit]

9897

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

« Last post by tomos on February 15, 2008, 11:27 AM »

3- You can drag-drop as many files as you wish. Try it on a scrap item first (or better still in a temp database)

-PPLandry (February 15, 2008, 10:12 AM)

second time today:
whooHoo!!!

works a treat, each is gets it's own item

9898

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

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

Great! If you think that this solution can help other, do not hesitate to send it to me, I'll put it in the download area.

-PPLandry (February 15, 2008, 10:12 AM)

seems like this could be useful to others
How would I send it to you? (not the whole database )
I'll probably make a few changes to it over the next week as it gets more used

9899

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

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

Now I have this setup

I add files as I start working on them
When ticked Done they go blue
When Change Requested is ticked they go Yellow and the date gets added to notes field
When I tick Checked (i.e. changes made) they go Purple and the date gets added to date field

which I'm quite happy with

some queries

when filtering do I use the Actual name of field or the column heading?

In the “Auto-assign rules” how do I change the date to just date as opposed to date/time?

Is it possible to add many files at once ? Say select 20 in filemanager, drag n drop to grid -
I'm afraid to try that in case it really screws things up

9900

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

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

It is a Feature. (multi-row display of headers)

-PPLandry (February 15, 2008, 09:42 AM)

I cant figure out how it's activated?