Pages

Search

Microsoft Works - MS Works 2000 vers. 5.0 database problems

Microsoft Works - MS Works 2000 vers. 5.0 database problems


MS Works 2000 vers. 5.0 database problems

Posted: 08 Jul 2008 08:40 PM PDT

AnnE,

Open a blank database.

Get the Sort Records dialog window.

Point your mouse to the words Sort by:

Right click, a help widow should display with the follow information.

"Lists all the fields you have included in your database or report. Click
the arrow to display a list of all the fields, and then click the field you
want Works to use first as it sorts. For example, you could sort a report
alphabetically based on your customers' last names by choosing the field
that contains the last names."

Point your mouse to the words Then by:

Right click, a help window should display with the following information.

"Lists all the fields you have included in your database or report. Click
the arrow to display a list of all the fields, and then click the field you
want Works to use second as it sorts. Then, if Works finds duplicates in the
first sort field (two customers with the same last name, for example), it
will look next in the field you specify here."

Do you see the same information?

If so, create a Last Name field and a First Name field.

Input some first and last name records. be sure to have some duplicate last
names.


Sort the records using, Last Name field then First Name field.

Do it both ascending and descending.

What is your result.

Ken


"AnnE" <proof.com> wrote in message
news:com...
|
| "Ken" <Thanks> wrote in message
| news:phx.gbl...
| > Hi AnnE,
| >
| > Open your database, on View menu, choose List.
| >
| > Then on Records menu, choose Sort Records.
| >
| > Sort Records dialog window should display.
| >
| > In the Sort by box (click down arrow) select your Last Name field.
| >
| > Next, in Then by box (click down arrow) select your First Name field.
| >
| > Click OK.
| >
| > Here is what is suppose to happen.
| >
| > The last name field is sorted alphabetically, if there is duplicate
| > (multiple) last names, then first name field is sorted alphabetically.
| >
| > Ken
|
| Isn't happening that way, Ken. Thanks for responding. I am amazed that
| it doesn't. I've been using this database for many years and it's
| always been this way. I did have maiden names in the same field as Last
| Names like this: (name) so I decided to make another field with those
| names. Still it doesn't work. I have moved those names that are out of
| order and still it goes back to the wrong way in alphbatizing. Maybe I
| have a 'foreign' copy! <G>
|
| AnnE now what?
|
|
|
| >
| > "AnnE" <proof.com> wrote in message
| > news:com...
| > | Here you are........I was in microsoft.public.works and no one was
| > | there. <g>
| > |
| > | Sheesh, am trying to make a simple report and here's what happens:
| > |
| > | I have a database of 282 names. I have them in alphabetical order
| > | except for the ones which will NOT go in order. Strange. I have
| > | Andersons and then first names are mixed up ie., Ken, Tom, Barb.
| > I
| > | want Barb first.
| > |
| > | Suggestions?
| > |
| > | Also, when I am making a report several names get put in a spot
| > where
| > | they are not supposed to be. I am doing sorting. I noticed that
| > when
| > | it sorted the deceased they are not in alpha order. (this is a
| > class
| > | reunion database <G>)
| > |
| > | This is getting very confusing.
| > |
| > | AnnE in MN any help will be very much appreciated
| > |
| > |
| > |
| >
|
|

prefix

Posted: 07 Jul 2008 10:50 AM PDT

thank you , you actually made me think apart from product Id , it just needed
a ms works, as a prefix .
isabel

"isabel" wrote:
 

converting wdb files to other formats

Posted: 06 Jul 2008 03:54 AM PDT

Hi, thanks for the information....

Ken

"tobyjug_008" <microsoft.com> wrote in message
news:com...
| Ken
|
| 1. my version is wks 8.5 in french - pre-installed on locally sourced
pc -
| how was I to know that everything was cut down when it was stated that
this
| had latest version of works on board?????
|
| 2. response to yr questions
|
| a. spreadsheet has saves to exls versions 97 - 2003, txt and csv
|
| b.text has saves to rtf, txt, csv, HTML, word 6, word 97-2002, and works 4
|
| c. db saves to txt and csv
|
| caveat emptor as they say
|
| other thing to note re MS - I see they are changing the business model in
| the US to license Office monthly - if that works then they will lose Works
| completely 'cos Office will seem to be cheaper - what a shame imho since
not
| everyone needs or wants the overblown complexity of Office and people are
| realising that OpenOffice is a better value product than Office anyway -
free
| and with most facilities of Office
|
|
|
|
|
| "Ken" wrote:
|
| > Hi, you are correct about MS running Works down, some say Works 4.5a was
the
| > best version, any version after that is a down grade of a very good
product.
| >
| > Seems strange to me though, the articel "File formats that are supported
in
| > Works", clearly states.
| >
| > APPLIES TO
| > . Microsoft Works 8.0
| > . Microsoft Works 7.0
| > . Microsoft Works Suite 2005
| > . Microsoft Works Suite 2004
| > . Microsoft Works Suite 2003
| >
| > Out of curiosidy. does the article match your Works 8:
| >
| > For files you can save in the formats in the Works word processor
module.
| >
| > For files you can save in the formats in the Works spreadsheet module.
| >
| > For files you can save in the formats in the Works calendar module.
| >
| > Ken
| >
| > "tobyjug_008" <microsoft.com> wrote in message
| > news:com...
| >
| > | sorry Ken but it is works 8 which is very limited
| > |
| > | MS are clearly running works down unless someone knows otherwise since
| > | facilities previously available are no longer there (<
| > |
| > | "Ken" wrote:
| > |
| > | > File formats that are supported in Works.....
| > | > http://support.microsoft.com/kb/884182/en-us
| > | >
| > | >
| > | > My Works Database can save a database in any of the following files:
| > | >
| > | > . Works 4.x and later Database (.wdb) files.
| > | > . Works for Windows 2.0 and 3.0 Database (.wdb) files.
| > | > . Works for MS-DOS (.wdb) files.
| > | > . Unformatted comma-delimited text (.csv) files.
| > | > . ASCII unformatted tab-delimited text (.txt) files.
| > | > . DBase III and dBase IV (.dbf) files.
| > | >
| > | >
| > | >
| > | > "tobyjug_008" <microsoft.com> wrote in
message
| > | > news:com...
| > | >
| > | > | Mike thanks but version Ive got does not allow save as except csv
or
| > txt -
| > | > | b*mmer (<
| > | > |
| > | > | "Michael Santovec" wrote:
| > | > |
| > | > | > A CSV file only contains data. No formulas or formatting.
| > | > | >
| > | > | > You could try one of the dBase formats. That will keep some of
the
| > | > | > formatting. But you'll still likely lose some of the formulas
and
| > any
| > | > | > reports.
| > | > | >
| > | > | > But I'm not optimistic that you'll be able to move to another
| > program
| > | > | > without redoing a lot of things.
| > | > | >
| > | > | > I've found that even moving a Works spreadsheet to Excel, I have
to
| > go
| > | > | > through and redo some of the formulas.
| > | > | >
| > | > | > --
| > | > | >
| > | > | > Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
| > | > | >
| > | > | >
| > | > | >
| > | > | > "tobyjug_008" <microsoft.com> wrote in
| > message
| > | > | > news:com...
| > | > | > > I have a db that has evolved from works 3 and now is works 8
| > | > | > >
| > | > | > > its become quite sophisticated over the years with all the
| > formulae
| > | > | > > and
| > | > | > > calculations i have inserted and contains 9000+ records
| > | > | > >
| > | > | > > does anyone know how i might convert it to a 'proper' database
| > | > | > > - I have tried csv but it cannot cope with the formulae
arithmetic
| > | > | > > etcetera
| > | > | > > and I am looking for some sort of tool
| > | > | > >
| > | > | > >
| > | > | >
| > | > | >
| > | >
| > | >
| >
| >
| >
| >

Word processor doesn't print multiple copies

Posted: 04 Jul 2008 11:45 AM PDT


"Scoot" <microsoft.com> wrote in message
news:com... 

If other suggestions don't work you might try this: I have Works 4.5a. In
order for me to get it to print multiple copies, I have to go into the
"advanced" option of the printer dialogue and select the number of copies
desired there. In addition I also change the number of copies in the
regular printer dialogue, but I'm not sure if that is necessary.

When using Windows 98, I did not have to do this, but now I have Windows
Pro. XP and that is the only way I've found to make it work. I tend to
think it may be because I have to use the printer driver supplied with
Windows XP with my old HP Deskjet 712C instead of the original driver. I
have also lost the ability to customize some margins or print jobs, and
therefore can no longer print 3x5 index cards or custom sized envelopes.
Well, actually I can, but have to go through a convoluted process of
printing to Adobe Acrobat and then printing.



Upgrade Works Database files from 4.5 to 9

Posted: 29 Jun 2008 10:44 AM PDT

Thanks Tom. I got a copy of ver 6. Going to try that thursday and see it will
then upgrade to 9. Appreciate any help.
Dave

"Tom" wrote:
 

PROBLEMS WHEN TRANSFERRING MSWKSCAL.WCD FILE

Posted: 29 Jun 2008 07:31 AM PDT

Thanks Dave. I'll give it a try. Unfortunately, I received your reply after I
recreated 6 months of entries but I can still save some time.

"DaveLovesTrains" wrote:
 

writing direction

Posted: 24 Jun 2008 06:56 AM PDT

sharon wrote: 
Hi Sharon;
The only thing to be careful of when sharing files you create with
OpenOffice.org is that OOo saves in the ISO Standard ODF format and
someone with Microsoft Word will not be able to open it without an
add-on. There are a couple ways around that. If you are sending it by
email then save as a standard odf file and use the File/Send/Email as
Microsoft Word option; or you can do a File/Save as and then file in one
of a number of Microsoft Word formats and then send that file.
There is excellent peer to peer support for OOo both thru forums on
the OOo website for which you need to register for and through a mailing
list at org which you can send mail to without
registering, but you do need to register to be assured of seeing all
replies. This is a very active list. In excess of 100 messages a day is
not unusual. There is an alternative to read the list through a
newsgroup; gmane.comp.openoffice.questions on news.gmane.org.

I Hope This Helps
Keith

Inprove works for a release works 10?

Posted: 23 Jun 2008 12:09 PM PDT

On Jun 24, 5:09*am, Vincent. <microsoft.com>
wrote: 

Make a mobile version that can be used on most cell phone browsers/

Works 8 Calendar won't open

Posted: 23 Jun 2008 07:08 AM PDT

I don't have access, but I think it can be downloaded as a 60-day free
trial... will look into that. And, yes I am going to do a backup of the file
and hopefully that will contain the info I am trying to recover. Thanks so
much for all your help and I will let you know how it turns out. Have a great
day!

"Ken" wrote:
 

MS Works 9 - compatibility with old databases

Posted: 22 Jun 2008 09:01 AM PDT

I can't open the files, so I tried to "Send" a file to drive C and then open
it. Didn't work, I still couldn't open the "sent" file. I can open MOST of
the databases, there are only a few that won't open. Most of the ones I
can't open are rather large, but I CAN open one that is almost identical to
one I can't open. They can ALL be opened with MS Works 6 - (even one created
with MS Works 9).

Thanks for your thoughts!
--
Tom


"Michael Santovec" wrote:
 

Corrupted File

Posted: 21 Jun 2008 11:29 PM PDT

Re: do not have an option named 'Recover text from any file'.


Sorry to hear Works Word processor version 8 has removed that feature.

It seems with each newer version of Works something is removed. I have
version 6.0 and it does everything I need, some say version 4.5a was the
best version, every version after that is a downgrade of a very good
product.

I do not have another suggestion.

Ken


"phoenix_5" <microsoft.com> wrote in message
news:com...

| I can open works but in the 'files of type' drop down box i do not have an
| option named 'Recover text from any file' just a list of different types
of
| files eg rtf, html etc.
| is there something i can download to recover my documents?
|
| "Ken" wrote:
|
| > Are you saying you cannot open Works Word Processor?
| >
| > 1. Click Start, point to All Programs, point to Microsoft Works, and
then
| > click Microsoft Works Word Processor.
| >
| > 2. Click File, and then click Open.
| >
| > 3. In the Open box, locate the folder that contains the file that you
want
| > to open.
| >
| > 4. In the Files of Type box, click Recover Text from Any File (*).
| >
| > 5. Click the file that you want to open, and then click Open.
| >
| > Or.... at step 5, the file will not open?
| > ------------------------
| >
| >
| > Another thought... is the file marked Read Only?
| >
| > Ken
| >
| > "phoenix_5" <microsoft.com> wrote in message
| > news:com...
| > | Hey Ken,
| > | Thanks for ur reply.
| > | I have microsoft works word processor 8.0 and the link u gave me talks
| > about
| > | a text converter?? I cant open it at all, how do i use the 'text
| > converter'?
| > | Is there sum sort of document recovery i can use for this version of
| > works??
| > |
| > | Chloe
| > |
| > | "Ken" wrote:
| > |
| > | > See if one of these apply......
| > | >
| > | > http://support.microsoft.com/?kbid=940003
| > | >
| > | > http://support.microsoft.com/kb/841219/en-us
| > | >
| > | > "phoenix_5" <microsoft.com> wrote in message
| > | > news:com...

| > | > | Help!! Suddenly for some reason i cannot open some of my documents
a
| > | > message
| > | > | comes up sayng "Works cannot open file.. format may not be
supported
| > by
| > | > any
| > | > | of the installed converters, or the file may be corrupt"
| > | > | When i open it in wordpad or notepad it comes up with all garbage
| > writing,
| > | > | and only parts of my original document can be read.
| > | > | I dont kow why it only happened to 3 of my saved documents?
| > | >
| > | >
| >
| >

Works 8.0- labels, manually

Posted: 21 Jun 2008 12:51 PM PDT

Thanks Ken,
I'll pass this along.
She'd told me that she had chosen the multiple address option, and it wasn't
allowing her to enter the data one label at a time.
Best.


"Ken" wrote:
 

Where are Calendar files?

Posted: 18 Jun 2008 01:07 PM PDT

That web site doesn't mention it, but you should also grab wkcalcat.dat. If
you don't you may find that appointments disappear when you open them on the
new machine.

"Ken" <Thanks> wrote in message
news:phx.gbl... 

microsoft works not opening

Posted: 18 Jun 2008 12:06 PM PDT

Thanks for the info.... good to hear problem solved.

Ken

"nithawk57" <microsoft.com> wrote in message
news:com...

| Hi Ken: Just wanted you to know that i figured out my problem with works
| 2000. I could not delete works thru add/remove in control panel but i did
| reinstall it by using the add new programs button on left side colume in
| control panel and everything is working properly now. Thank you for your
help
| and advice i really appreciate it. Ken
| --
| KEN
|
|
| "Ken" wrote:
|
| > See if item 2 applies.....
| >
| > Works: Top error messages when you run program
| > http://support.microsoft.com/kb/256229/en-us
| >
| >
| >
| >
| > "nithawk57" <microsoft.com> wrote in message
| > news:com...
| > | Hi Ken thanks for the reply. my version of works is 6.0, win xp. the
word
| > | processor and calendar will not open but the database and spreadsheet
will
| > | open. I have uninstalled all of works 2000 but when i reinstall it
says
| > the
| > | same thing files either moved,renamed, or deleted i have not
| > deleted,removed
| > | or renamed anything. works worked fine about a month ago when i last
used
| > it
| > | but why its not now i do not know. Again thanks for the help its much
| > | appreciated. Ken
| > | --
| > | KEN
| >
| >

Microsoft Works Spreadsheet Problem

Posted: 18 Jun 2008 08:57 AM PDT

Re: getting a notification box which says "Out of Memory"

You didn't say which version of Works you have......

See if this applies.......

You receive an error message when you are working in Works 8.5 or earlier
versions of Works: "Microsoft Works 8 has stopped working" or "Out of
Memory"
http://support.microsoft.com/kb/933828/


Microsoft Works 8 Spreadsheet and Works 8 Database Printing Update
http://www.microsoft.com/products/works/downloads.mspx#9SE

Ken

"Jer" <microsoft.com> wrote in message
news:com...

| I purchased a computer which came preloaded with a Microsoft Works package
| which was a special deal between the computer mfg. & Microsoft. I have
| generated a customer list using the spreadsheet software and have been
| getting a notification box which says "Out of Memory" whenever I hit the
| print preview key. Once I click "OK" to goes away & print preview opens.
| Suddenly, the software has decided not to show me one entire column of my
| document - the column closest to the right margin of the document. Why is
| this happening? I don't know where this is originating from. I've even
| tried going back using system restore in order to know if I had entered
some
| sort of command into the document which caused the problem. That does not
| help. Why won't this program show a column of the document? It won't
show
| it on the screen or print it. Thanks in advance for your good advice.
Jer
| Jerry

Install Microsoft Works on Multiple Computers?

Posted: 17 Jun 2008 01:32 PM PDT

Sara-Maria Sorentino wrote: 
Possible, yes; legal, no.

Can't use .wps files, what should I do?

Posted: 16 Jun 2008 06:59 AM PDT

Hi Jean,

Thanks for letting us know you have sorted it out.

Ken


"Jean D." wrote

| Thanks very much. The rtf files now open with Works. Thanks to
all
| who helped me!
| So long for now,
| Jean
|
| --
| Jean D.
|

<snipped>

Works tries to save as .doc files

Posted: 15 Jun 2008 06:48 PM PDT

You are welcome and thanks for posting back.

--

Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm



"LAH" <net> wrote in message
news:phx.gbl... 

clipart for works

Posted: 15 Jun 2008 04:25 AM PDT

Yes; have you tried the the Clipart gallery?:
http://office.microsoft.com/en-us/clipart/default.aspx?lc=en-us




"Sue" <microsoft.com> wrote in message
news:com... 

Export a database form

Posted: 13 Jun 2008 05:58 PM PDT

Hi Dave,

Great to hear cute PDF helped, thanks for letting me know.

Ken

"Dave" <net> wrote in message
news:phx.gbl...

| Ken,
|
| Down loaded the cute PDF the other day. Thanks so much it is exactly what
I
| needed for a couple DB reports.
|
| Thanks, Dave
|
| "Ken" <Thanks> wrote in message
| news:phx.gbl...
| > Here is a couple ways to do what you want.
| >
| > Someone emailed me and said to go to
| > www.acrosoftware.com and try the free program Cute PDF Writer. What it
| > does
| > is create a PDF file of your Works output so that when you go to print
it,
| > it puts it in the PDF file of the name you choose. This way I can send
it
| > to
| > someone who doesn't have Works and look at it or print it.
| > Try it.
| >
| >
| > You could also display the recipe on your monitor, use Print Screen on
| > your
| > keyboard, paste it into Paint program, then save as .jpg
| >
| > 'Paint' program.... Start ==> Programs ==> Accessories ==> Paint, select
| > Paste on it's Edit menu, then Save As on it's File menu, choose .jpg as
| > file
| > format to save.
| >
| > Hope this helps,
| > Ken
| >
| > "King Cole" <microsoft.com> wrote in message
| > news:com...
| >
| > | Works 7.0: I have a cookbook in a database file. The recipes were
| > keyed
| > in
| > | manually on a database form, using a Microsoft Works cookbook template
| > which
| > | I doctored up a little. I have designed several reports to
| > index/categorize
| > | the recipes. I can print a single recipe in the form format easily.
| > A
| > | friend asked me to email a single recipe to her. I assumed it would
be
| > easy
| > | to just export a single recipe in JPG or some other standard format,
| > save
| > it
| > | and send it to her as an email attachment. I couldn't find any simple
| > way
| > to
| > | do it. Surely there is a way. Help, please.
| >
|
|

Problem accessing my documents after formating c:

Posted: 11 Jun 2008 04:01 PM PDT

I would think that you would have to move your properties again to the
target drive to point to d: again to the path to your documents on d:.

Go to Start.
Right click on My Documents.
Click on Properties.
Click on the Move button.

Good Luck, hope it works for you.

Ed.

"Michael Santovec" <net> wrote in message
news:phx.gbl... 

works 7.0 calendar - cannot print - cannot export calendars!

Posted: 11 Jun 2008 12:05 PM PDT

 


Thanks, Ken.

I tried every procedure with no success. Alas!

After reinstalling works 7.0, the new mswkscal.wcd file, although lighter
than the previous one, still retains the old <<crowded>> calendar list of
tasks and appointments (like the works suite never really removed including
all remnants).

I believe the problem I'm experiencing with exporting and printing works
calendar may be due to IE7 installed on my machine. I have tried removing it
(rollback to IE6) and after that works calendar still wouldn't export and
wouldn't print: in any case, I haven't tried remove and reinstalling works
after rolling back to IE6 (it may have worked that way -- who knows...)

It seems works 7 is conceived to work with IE6.

I will try to make a backup copy of the mswkscal.wcd file and install on a
different pc with same OS but IE6 browser (never installed IE7 down there
yet...) and let you know as soon as i find a minute. Thanks guys.

Please feel free to drop me any suggestions or impressions on all this, many
thanks. 

can't open anything with .psw file "works 7"

Posted: 07 Jun 2008 03:01 PM PDT



"Kevin James" wrote:
 
 

Chrisntony