Messages - J-Mac [ switch to compact view ]

Pages: prev1 ... 520 521 522 523 524 [525] 526 527 528 529 530 ... 566next
2621
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: December 16, 2007, 03:15 PM »
Jim, I don't know  if that's what you want to know but :

To create a new grid :
view-->Grids-->New grid

To select which columns/fields should appear in the grid :
Grid-->displayed columns

To manage/create new fields (which can eventually be showed as columns...) :

View-->Manage fields
Right click on colum titles -->Manage fields (but that doesn,t seem to always work<


EDIT : Sorry... PPLAndry was here first... Anyhow.  :)


Armando, Pierre:

I had another thread I had started about the availability of a simple/easy-to-use database application.  SQL Notes was strongly suggested in that thread and it sounded promising. But I mentioned there also that without pretty easy-to-understand manuals or tutorials, I am lost when it comes to databases!  Spreadsheets - as complex as you like: I can create them in my sleep.  Digital photo and video authoring and editing - I started that and created my first project for an American Idol finalist who needed it for their first meeting with an agent after being booted - and have improved since then. Again, that just seemed to come naturally without reading hardly anything about it. No manuals needed!

But that has never worked with databases! For some reason I just cannot work intuitively with a database application - at least none since I used to use the old dBase III+ a million years ago. I really lose focus - and then interest and efficiency - as soon as I try to create databases without reading a whole lot! Just a mind-block? I don't know. All I know is that wading into a database app doesn't work for me!

As for what I was looking for in the first place - I think we discussed this here in my other thread, Pierre. No notes. A database to track my correspondence and other documentation from certain insurance companies. It started out simple enough and I tracked everything with spreadsheets, pivot tables, Look-ups, etc. Easy - about 100 or so documents. Now, however, it is up to several hundred, and the companies have a way of asking you to confirm data you supplied last year. If it doesn't match exactly - sometimes word for word - we go off to arbitration. A truly weird system! Anyway, I need the documentation readily accessible, and searchable by multiple keywords so I can access the correct documents quickly. The spreadsheet system has gotten truly bogged down!

I have MS Office 2003 with Access but every time I start anew in Access and try designing my tables, forms, etc. as soon as I try to run a report or pull out data I am presented with the VB Editor - which completely confounds me!!

Thanks.

Jim

2622
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: December 16, 2007, 02:59 PM »
Awesome Pierre - a USB version will be fantastic...

OK, cards on the table - I was in the same boat as Jim, but hadn't posted/contacted you to that effect  :-[ - your instructions to him above have enabled me to start using SQLNotes  :Thmbsup:

I'll try to be a productive member of the beta team from now on!

I was wondering how you got up and running so quickly - I was starting to think you must be a database wiz kid too!!   ;D 8)

Jim

2623
OK. I just thought it sounded really weird for the PC to hard reboot after clicking on a shortcut, and that it might be something in the shortcut itself that was somehow corrupted.  That error is what I found for the last several days, in my Event Viewer - and I haven't been having any noticeable issues with Firefox recently.

Glad it's all sorted out!

Jim

2624
General Software Discussion / Re: SQLNotes...what is it exactly?
« on: December 16, 2007, 12:35 PM »
Wow!  Just installed the latest beta - looks pretty powerful.

Shame I have no earthly idea what I am doing with it, though. Create a new field and all I can do with it is give it a name and say it's text or number, etc. Field length? Can't find where they're assigned & I just searched for it for an hour. I read through the entire thread and see that no one else has questions like that.

I think I'm not ready for this one.
Hi Jim,
Think of it as a notepad. Create a grid (View > Grids > New grid). Name it and start entering information in this notepad. Everything you put in this notepad, gets put in a field with the same name
To view what you've put in these notepads, either open them (view>grids>Notepad xx) or double-click on the field with the same name (in the properties pane -- F4)

These is much more to it, but this will get you started

So I shouldn't have been in the Fields settings area? That's where I tried creating the fields I need for the database I need to build. As I said, you can't do anything there except give a new field a name and attribute, i.e., text, number, etc.

I read through the Documentation section and didn't see anything on how to create new fields, etc. Did I miss it?

Thanks.

Jim

2625
General Software Discussion / My Stupid Windows Question for the Day!
« on: December 16, 2007, 11:47 AM »
I know that certain folders, namely My Documents, My Pictures, My Music, My Videos, etc. are actually system folders.  However they can be relocated within Windows and have all shortcuts, etc., still point to them.  For example, I immediately relocated all to my D: drive after installing Windows XP Pro on this PC. I wanted the C: drive to contain only the OS and program files.  All data and media files are on my D: drive, and my E: drive (and a couple external USB drives) are for backups and synced folders only.

But....

Can these folders be renamed without causing issues? What I want to do is remove the stupid "My" from the folder names! Who in the heck ever dreamed that concept up anyway? It just sounds so darn childish for some reason - My Pictures, My Music, etc., etc.  Of course they're mine!!  And I know that!!  I don't need to remind myself and the world that these are MY very own folders!  It just makes them look kind of stupid among all my other data folders.

But can I take that possessive adjective away without any dire consequences?  I thought I would ask before just trying it and then asking you all how to get out of that mess!

Thanks.

Jim

Pages: prev1 ... 520 521 522 523 524 [525] 526 527 528 529 530 ... 566next
Go to full version