Can anyone please explain very simply for me how I can save my database after sorting it into alphabetic order on names so that it opens with that sequence every time.
Thanks - using cardbox 3.0
I think this can easy:
Cardbox 2.0 had an easily accessible "remember" option, conveniently accessible from the Toolbar, allowing to set it to remember the configuration you wished it to open in. In Cardbox 3 this feature was moved to the File-Worksheets menu, a bit more complex to set up but with added capabilities.
By default, Cardbox 3.0 automatically remembers the exact configuration (opened files, selections/sort orders/tags...)it was in when you last closed it. You can, however, set a default configuration to make Cardbox open as desired (in your case - Level 0 - alphabetically sorted), regardless where it was when you closed. The set up is wery well explained in the "Workspaces" section in the online Cardbox help (or the Cardbox book),. If you need additional help with the set-up, please feel free to send me an e-mail off-list and I will be happy to help.
Iuliana did forget that added records in Level 0 stays at the end of your records.
After sorting, go to FILE - EXPORT. Check the "Cardbox internal" button, and export to a suitably named file.
Delete the original database (after saving a backup copy, of course!) and then import the new file.
I THINK that should work, but take no responsibility if it doesn't.
I would think that Bert's idea is best. The startup macro he suggests is very simple, for example:
You could also add other things to this macro like specifying a particular format
I have been experimenting somewhat but it still baffles me.
The manual says set up your database as you want it so I did, I sequenced it to alphabetic on surname - then it says give this workspace a name, which I did, then it said to tick a box to use this workspace when the database is opened so I ticked it.
But it still opens with the records in the order they were added, not in the alphabetic name order that I had saved in that workspace.
I did manage once before to export it in the order I wanted and then import it into a new file in that order but I have forgotten how to do that now and daren't mess about too much for fear of losing the records I have. I can't get to grips with macros and the manual is like chinese to me in some places.
Although I use the database every day I am not using the program if you see the difference so I am finding it hard to get to grips with; for instance I have a format which I sometimes view and I have changed a couple of boxes in that OK but I can't find out anywhere how to rename the view so whereas I am now looking at a view entitled 'Grades 2010' it is actually showing me the 2011 grades (which is what I want) from my format changes - but I would like to rename the view as well.
Surely it can't be this difficult to get the database to start up with the records sorted how you want them?
Any suggestions for this not very experienced user?
First: all this is perfectly written in the Cardbox book + help file.
If you want your database at start up sorted on one or more fields you can make a startup macro. This is not very difficult. However, new records are always added at the end until you sort the records again (like in any other database).
So I think you better can add a sort macro in your button bar which sorts your records again whenever you push on it.
How to make this?
Change "yourfieldname" in to the field you want to sort.
Your macro is ready now.
The easy start your macro:
With added button you can sort directly any time on "yourfieldname"
I hope this will help you.
Very a pity is the absence of the DOS Cardbox Plus 4.1 sort option "This Record". That allowed you to sort records and after sorting still the same record was active. It was easy for finding out in what alphabetically context a record was.
Thanks Bert, that looks simple enough for me to follow.
I apologise Bert, I forgot to mention that the renaming trick works well, thank you very much for that.
Indeed, manage macro tab is not available in Home Version.
Ok, How to do this in Home Version?
1 Close Cardbox
Adding a button in your toolbar is not possible using your Home Version.
You can also add buttons in your formats.
For later button modifications: If you double click on that button while you are in edit format mode, then you can change all settings of the button afterwards (nice for experimenting with graphics). If you want to write text on your button, use MS Paint, type a text with small fonts, make a selection of it, copy it to clipboard, and paste it as mentioned.
If you want to add that button in every format, there is an easy way:
Thanks for that, I have followed your instructions and now have a button to push but when I push it it comes up with 'Running Macro:SortOnField.CBW - Macro not found'.
As you instructed the file SortOnField.CBW is in the same directory as NCCA.fil and NCCA.fmt.
In the Pushbutton properties I have in the Action window Play a Macro selected and All Macros selected with SortOnField.cbw in the Macro name field.
I must have made an error somewhere but I have looked and looked and can't see anything glaringly wrong.
If this is right, remove .cbw
I have edited the 'action' window as you say by removing .CBW which just leaves SortOnField in there but it still comes up with 'Running Macro:SortOnField - Macro not found'.
By the way when I click on the Select Macro... button in the 'action' window there are no macros listed in there.
Sorry to be a pain
Then you'll see the things different.
Well done Bert, it works, brilliant, thanks so much
|© 2010 Cardbox Software Limited|