Pages

Search

Microsoft Works - Works8.5 Database Report Preview

Microsoft Works - Works8.5 Database Report Preview


Works8.5 Database Report Preview

Posted: 24 Dec 2005 07:35 AM PST

I think Computers make great Boat Anchors !

Rodney wrote,
After initiating the report / cancel / select "copy report output", and
paste into another blank Database.
Oops I forgot to read your “cancel”, to get out of print preview mode,
sorry, that’s why I couldn’t find “copy report output”.
Have now tried everything you said it works great. Thank You.

Rose advised,
Copy to spreadsheet,
Great that works just fine also. Thank You.

Rodney wrote,
Yep, you can even paste to a Word Proc document.
Tried that too, it works great also, Thanks Again.

Ken wrote,
After selecting Report View, click Edit on the top menu bar, on it's menu
you will see "Copy Report Output", this will copy the report to the clipboard
for pasting into other applications.
Thanks Ken, I have done that now.

Rodney wrote,
but shouldn't Grumpy "cancel" from Report View first then the option for the
"edit" / "copy report output" becomes available.
Pedantic is good for me, I did not read Rodney’s original post correctly,
and couldn’t find the “copy report output" link, but now all is ok.

Kevin wrote,
In Report Preview Mode, Hold down Alt while holding down the N key.
No good, does nothing unfortunately. Thanks for the advice, I tried Alt+C,
Alt+P also no good.

Rodney wrote,
In MSWorks 4.5a just hold down "pagedown" button whilst in Report Preview
Mode, as long as appropriate It scrolls through the pages.
No good for Works8.5 does not scroll, each click advances one page, so 430
clicks gets me to the page that I wanted to Print Preview before Printing, I
was actually only printing out that single page.

Problem-Headers and Footers,
are only showing in PDF’s, which are generated from the Print Preview Page,
using either PDF995 or PDF2Go (aka Virtual PDF printer) the other “copy
report output” to Database, Spreadsheet or Word processor is not giving me
headers or footers.

So for the purpose of quickly going to any report page to preview it, I am
only using PDF’s generated from the Report Preview Page.

Also some big database’s reports won’t copy into Works Word Processor, I
have to use other Word Processor, even with 1GB RAM on the machine, and Works
has been given more allocated memory space than normal, this is a bit too
technical for me.

Bill Gates, Why don’t you just scrap MS Works, and have a Home version of MS
Office with a simple version of Access included. Then a MS Office
Professional for business users. MS Works internals really have not changed
much since 1987 only new GUI’s for each version.

Remember the Rich Kids have Office, the Poor Kids have Works, but the Poor
Kids say but we got Works Database, which is much simpler to use than Access,
so There !


"Rodney" wrote:
 

Search disc for words within Works files

Posted: 22 Dec 2005 01:16 PM PST

Hi Mike, thanks for the information. Was wondering why my WindowsMe
operating system could search wks files where other couldn't.

Guess this is another situation where features are lost when upgrading to a
newer version, similar as to what is happening with Works, many post in this
news group indicate to me that upgrading to a newer version past Works 4.5
is actually a downgrade.

Ken

"Michael Santovec" <net> wrote in message
news:phx.gbl...
| Windows XP won't search for text in a file unless it has a handler for
| that file type. There are workarounds for that.
| http://www.kellys-korner-xp.com/xp_s.htm#search
|
| --
|
| Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
|
|
| "Ken" <ne> wrote in message
| news:phx.gbl...
| > Hmmmmmmm,
| >
| > The search feature of my WindowsMe operating system finds text in wks
| > files
| > I have?
| >
| > Ken
| >
| > "Loren Green" <com> wrote in message
| > news:%phx.gbl...
| > | Thanks Ken,
| > |
| > | Yes, this seems to work for wps docs, but not wks. I fear that the
| > info
| > may
| > | be not be in "text" form within the spreadsheet files.
| > |
| > | Loren
| > |
| > |
| > | "Ken" <ne> wrote in message
| > | news:phx.gbl...
| > | > Hi Loren,
| > | >
| > | > I have WindowsMe operating system.
| > | >
| > | > Opening a folder where my files, like wks and/or wps, etc are
| > stored, I
| > am
| > | > able to find files that contain a specific word.
| > | >
| > | > After opening the folder where the files are I click Search on the
| > menu
| > | > bar.
| > | > In the "Search for File and Folders" dialog I input the specific
| > word
| > into
| > | > the box "Containing text:", then click Search Now. Notice the
| > "Look
| > in:"
| > | > box contains path to folder.
| > | >
| > | > Ken
| > | >
| > | > "Loren Green" <com> wrote in message
| > | > news:OFoJ$phx.gbl...
| > | > | Is there a desktop type search engine that will look inside of
| > the
| > wks,
| > | > wps,
| > | > | etc files to find specific words.
| > | > |
| > | > | I would like it to present a list of all Works files that
| > contain the
| > | > word
| > | > | "computer" or whatever.
| > | > |
| > | > | Thanks,
| > | > |
| > | > | Loren
| > | > |
| > | > |
| > | >
| > | >
| > |
| > |
| >
| >
|
|



It's Almost Christmas

Posted: 22 Dec 2005 12:23 PM PST

..........and it's a Nadolig Llawen to you too, Kevin.
Again, thanks for your assistance over the past year.
Best Regards
Rodney.

| I shall be shutting down my computer for a few days.



works help feature "file not found" error message

Posted: 22 Dec 2005 07:03 AM PST

I opened a blank Spreadsheet, Works 6.0, clicked Help on the menu bar, then
clicked Works Help. A Works Help dialog box appeared on the right hand side
of the screen.

Another way to get help in most programs is to use the F1 key on the
keyboard, so I tried that. Opened a blank spreadsheet, pushed F1 key, was
greeted with the same Works Help dialog box appearing on the right hand side
of the screen.

Guess, like you mention, perhaps the help feature is not loaded on your PC.

What I would try is to uninstall Works, then reinstall.

Ken
PS: the version of works you are using can be found by clicking Help on the
spreadsheet menu bar then clicking About.......

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

| Just by going to Help in the menu bar and clicking on Help feature and I
was
| looking for help on page numbers and I got the error message, tried
looking
| for help for other things and still got error message as if the Works Help
| files/feature was not even loaded on the PC. Thanks!
|
| "Ken" wrote:
|
| > Hi BNice,
| >
| > Can you provide a specific thing that causes the error message. I will
try
| > to see if it duplicates on my system.
| >
| > Ken
| >
| > "BNice" <microsoft.com> wrote in message
| > news:com...
| > | when in Works (spreadsheet or word processing) I cannot open the Help
| > feature
| > | to search for help on certain things. I keep getting an error message
that
| > | "file not found". Do I have to be connected to the internet to use the
| > Help
| > | feature in Works?
| >
| >
| >


specified module could not be found

Posted: 21 Dec 2005 10:41 AM PST

I can't find anything specific on clip art in Works 8.

You mention reinstalling Works. Did you select the Complete Install? I
believe Clip Art is an optional feature.

Also, have you tried the menu item: Insert, Picture?

And under Insert, Object, is Clip Art listed as an available object?

--

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


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


Works Website & Feedback - Repost

Posted: 21 Dec 2005 12:03 AM PST

1. Which versions of Works do you use?

Works 7.0

2. Which Works Applications do you use most frequently and
for what purpose?

Database - for different address lists and word processor for
documents. I also use the spreadsheet to keep track of some loans that I
have.

3. Have you visited the new Works Website recently?

Yes.


4. What topics and templates would you like to see in the future
on the Works Website to enhance your home productivity.

Using formulas in database to improve merge function bugs.

5. ANY other comments you would care to make regarding Works
or the website?

Formatting in merge fields is so buggy that most users would be
discouraged or they don't have the savvy to use formulas in the database to
correct the bugs. The bugs that I am referring to concern Currency and
Date/time values.


Works 6.0 Spreadsheet Column Width Question

Posted: 19 Dec 2005 09:22 PM PST

That's kinda what I thought. Not the end of the world though

Thanks for the prompt reply and have a great holiday.

Joe

"Kevin James - MSMVP Works" <org> wrote in message
news:phx.gbl... 


Microsoft Works Word Processor ver 6.0 not working

Posted: 18 Dec 2005 06:33 PM PST

Thanks for your suggestion, I thought it would work. But I reinstalled
Microsoft Works and the problem remains. Since it started with the
installation of Front Page 2003 and Office SP2 I'd like to remove both, then
reinstall Front Page without SP2.

But documentation on the Microsoft Support site says I can uninstall SP2
only by uninstalling Microsoft Office 2003.

My problem is I don't have Microsoft Office 2003, only Office Front Page
2003. Will removing that also uninstall SP2? Or will I create more
problems? This is too much for an old man to figure out. Thanks for your
help.
--
Wherever you go, there you are


"Jim Macklin" wrote:
 

pasting numbers into works database

Posted: 18 Dec 2005 04:12 PM PST

Hi Martin,

That is correct, the formula is contained within a second
companion field.

I understand you to mean that ERR appears for records that
do not contain a value for the telephone number field? If this
is a possibility then the formula should be revised to cater for
such an eventuality. See initial IF in the formula given below:

=IF(Field1="","",IF(Field1>0,"0"&STRING(Field1,0), IF(LEFT(Field1,1)="0",Field1,"0"&Field1)))

HTH,
--
Kevin James.
Tua'r Goleuni
Microsoft MVP (Works & Word) 1999-2006
Works Help & KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm





"Martin" <microsoft.com> wrote in message
news:com...
| PS I think I understand now that the formula should be applied to a second
| field eg Phone Number and that the data should be pasted into Field1. So for
| every field that I want to show a phone number I need to have a companion
| field for entering the data - is this right? How do I stop blank cells from
| showing ERR?
|
| PPS Homer that idea works great when you are typing the data in but not when
| you are pasting in numbers. As far as I understand it the database treats
the
| number as a number even though it is a text field and deletes the 0 and
| moves it to the right. Kevins method is to have a second field with a
formula
| that converts the number in the first field into text in the second field. I
| think!
|
| "Martin" wrote:
|


Request for Hitlist Contributions

Posted: 18 Dec 2005 11:05 AM PST

Kevin James - MSMVP Works zei het volgende op 18-12-2005 20:05: 

Kevin,

I looked up your hitlist and find it very informative. I am glad that
some improvements have been made. It is a good thing indeed that you
keep it and update it.

Thanks,

Erik.

Cell Lock

Posted: 13 Dec 2005 09:06 AM PST

From Works Help file :


Cell protection is turned off Starting in Works 6.0 and
Works Suite 2001, the Spreadsheet no longer supports cell
protection. When you open a spreadsheet from a previous
version of Works that contains protected cells, the cells are
no longer protected.


To protect an entire spreadsheet, you can make the spreadsheet read-only.


1. Save the spreadsheet.


2. Open My Documents.


3 Locate the file in the folder where you saved it.


4 Right-click the file name, and then click Properties.


5 Click the General tab.


6 Under Attributes, select the Read-only check box.


7 Click OK.


The entire spreadsheet is protected. You cannot make changes to the
spreadsheet unless you clear the Read-only box.



"solex" <microsoft.com> wrote in message
news:com...
| Michael:
| Thank You for that info. Anyone have a way to lock cells in 7.0? Don't
| understand why they eliminated it in the first place, 8.0 doesn't allow it
| either.
|
| "Michael Santovec" wrote:
|
| > According to the Help in my Works 6
| >
| > "Starting in Works 6.0 and Works Suite 2001, the Spreadsheet no longer
| > supports cell protection. When you open a spreadsheet from a previous
| > version of Works that contains protected cells, the cells are no longer
| > protected."
| >
| > --
| >
| > Mike - http://pages.prodigy.net/michael_santovec/techhelp.htm
| >
| >
| > "solex" <microsoft.com> wrote in message
| > news:com...
| > > Which version of Works was the last to allow cell locking?
| >
| >
| >