Pages

Search

Microsoft Works - Is this legal?

Microsoft Works - Is this legal?

Is this legal?

Posted: 23 Jun 2006 06:59 PM PDT


"Brian Robertson" <com> wrote in message
news:449c991e$0$9820$teranews.com...
 

Yes, although they'd do better to run an ad there for either the free .Net
Visual Studio tools or their own for sale products.

copy and pasting problem in word processor

Posted: 23 Jun 2006 11:11 AM PDT

debbie ... just wanted to say thank you for info about using the paste
special and "unformatted text". it does work going about it that way , which
is still a couple more clicks to get it done , but is a little less work than
what i found as far as copying into the portfolio first and then going back
to paste special . i am still confused as to why this happened in the first
place , considering before all i had to do is right click and paste , which
was simple . considering i am new at all this computer stuff , i hope you all
know the help you gave was very appreciated . much thanks to you all !!!

"Debbie Rydberg [MSFT]" wrote:
 

entry bar line

Posted: 23 Jun 2006 09:35 AM PDT

Hi Dave,

Perhaps this helps:

Whilst the formula/data entry bar is not user changeable, it can expand
to display the contents of selected areas of the document.

http://its.gcsnc.com/resource/techinstruct/dbdir/dbdata_bar.htm

Other maximum limits given here, though some changes have been
made since this article was written:
http://support.microsoft.com/default.aspx?scid=140110

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





"Dave" <net> wrote in message
news:rLUmg.52$news.pas.earthlink.net...
| News Group,
|
| Is the "entry bar line" length determined by your page length? Or by what?
| Can I change this length?
|
| Thanks, Dave
|
|

My ongoing agony with database

Posted: 21 Jun 2006 06:09 PM PDT

Great day -- EXACTLY what I wanted!!!! Thanks so much, my problem is now solved!
"Ken" <Thanks> wrote in message news:phx.gbl...
Hi Jeff,

The following from my Works 6.0 Database Help on WindowsMe.

Ken
Copy report information to another program
What happens when I copy report information to another program?
You can copy a report to another Works program or another Windows program. Works copies the same information that you would get if you printed the report. It performs all report instructions, including any calculations, and then copies the report output to the document in the other program.
When you copy a report to a Word Processor document, Works separates the columns with tab marks and ends each row with a paragraph mark.

If you copy a report to a Spreadsheet document, Works places the contents of each entry in a report row into a separate cell (the intersection of a row and column that can contain text or numbers) in a spreadsheet row.

After copying the report to another document, you might need to adjust column widths to display the report information properly.

1 On the View menu, click Report.

2 Click the report you want to copy.

3 Click Modify.
The report definition (displays information about a report in rows and columns) appears.


4 Select (move the plus sign to the beginning of a cell or heading, click and hold down the mouse button while moving the plus sign over the cells or headings you want, and then release the mouse button) the part of the report you want to copy.
If you want to copy the entire report, don't select anything.


5 On the Edit menu, click Copy Report Output.

6 Open the program and document into which you want to paste the report.

7 On the Edit menu, click Paste.

Tips


a.. If you are copying into a Works Word Processing document, you will have to align the information using custom tabs. This is done by selecting (No edited glossary term defined) all the information in the report, selecting Tabs on the Format menu, and then selecting the options you want under Custom.

b.. If you are copying into a Spreadsheet document, you can change the column width in the spreadsheet by clicking the column heading, and then dragging (select the information, click and hold down the mouse button, move the information, and then release the mouse button) the edge of the column heading when the pointer looks like this:
.

"Jeff Needle" <com> wrote in message news:supernews.com...
| Hello all. I'm using Works 6.0, Win XP.
|
| I have a need to design and print a report in database, but I need to print
| it to disk. I've set up a printer in Windows to print to file, and I've set
| everything to be as plain vanilla as possible. But the disk file is pretty
| messy -- all kinds of control characters, little boxes all over the place.
|
| Is there a trick to do this? I'm getting pretty desperate.
|
| Thanks.
|
|

VLookup Vers 4.5a

Posted: 21 Jun 2006 03:30 PM PDT

Hi Rodney,

As mentioned by others, and from Works help:

Works searches the first column for the largest number that
is less than or equal to the Looked-up value.

Therefore, you would be incorrect to believe that

"if my lookup is say 810 then the result should be "ERR"
it gives me -1"

since,

-800 is the largest number that is less than the Lookup up value
and it therefore returns the value -1, from column 2.

rephrased, this equates to:

if the LOOKUP value is greater than or 'contained' within the range
of values of the LOOKUP-Column (column 0), then a value will be
returned from the requested column (column 1, 2nd column in the
VLOOKUP range in your example).

Only if your LOOKUP value is less than ALL the values in the lookup
table will the ERR value be returned. Therefore the same applies to
the checking function ISERR. If, as above, an ERR 'value' is the result
of the VLOOKUP function then ISERR will return the zero (0) value.

However, with VLOOKUP if you have a "nearest" matching value, as
defined above, (which may not necessarily be the ACTUAL value that
you wish to locate), then column 1 (or other nominated) will be returned.

The above answers your question, "... why the original query doesn't
work when I have used it in the past?" ?

In your original example, looked-up values between -2000 and -1001
will return ERR. Lesser values ( not used by you) would also return ERR.
Values greater than -1001 will return a value from the LOOKUP table.

Therefore, to summarise:

A B C D

1 -1000 1 -2000 ERR
2 3 2 6 4
3 4 3 1001 5
4 5 4 3 2
5 999 5

Suppose we have a LOOKUP table A1:B5
with LOOKUP values; C1, C2, C3 and C4
and their respective returned values; D1, D2, D3 and D4
then these are the results for the values shown

C1 (-2000) is less than the range of the LOOKUP values and returns ERR
C2 (6) is 'contained' within the range of the LOOKUP values and returns 4.
C3 (1001) is greater than the range of the LOOKUP values and returns 5.
C4 (3) has a matching value in the LOOKUP column and returns 2.

Only C1 would present the zero value as a result of the ISERR function.

Finally, there is not an error in the formula you are using. There may be
a misunderstanding in how the VLOOPUP function operates?

For us to understand what you want to achieve, and to be able to help
you resolve this, we would need to;

a know what range of values the LOOKUP column (col 0) will contain

b know the range of values that the looked-up value can be.

c understand what returned values you expect for the four cases where
the LOOKED-up value is:

1 less than the range of column 0 values.
2 'contained within' the range of column 0 values - no match.
3 exists as an exact-matched value in the column 0 values.
4 greater than the range of LOOKUP column 0 values

The N-356 can trigger the return of the ERR value, since text comes
before numbers (including negative values) in the VLOOKUP hierarchy
of the Looked-up column. Therefore N-356 is less than the lookup
range and will return ERR.

Again, from the help file, the hierarchy is that
"the values in the first column must be in ascending order
(text from A. Z first, and then times, numbers, and dates)."

I find that mixed data types in the lookup column can "confuse".

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





"Rod" <com.au> wrote in message
news:u$phx.gbl...
| Thanks Michel,RRR and Kevin,
| this is the formula I have been employing.
| Can you spot any error?
|
| =IF(ISERR(VLOOKUP(H344,$O$2:$P$338,1)),0,(VLOOKUP( H344,$O$2:$P$338,1)))
|
| (perhaps the zero?)
| I have circumvented the problem by simply adding an alpha character
| to the beginning of the number eg "N-356"
|
| However, I'd still like to understand why the original query doesn't work
| when I have used it in the past.
|
| If not, I'll try and pare down the original SS
| and post a copy on the NG
|
| Cheerio
|
|
|
|
|
| "Michel Maman" <microsoft.com> wrote in message
| news:phx.gbl...
| > Hi,
| >
| > It may look strange but It works as the Works's Help explain the fonction.
| > "Works is searching the biggest number less or equal to the value"
| >
| > Regards.
| >
| > Michel
| >
| > "Rodney" <com.au> a écrit dans le message de news:
| > %phx.gbl...
| > > Been using this for years,
| > > now a glitch.
| > > Need to VLookup a list from -2000 to +2000
| > > A mock up I use works fine,
| > > The original SS, keeps giving me result of -1
| > > for every example, any ideas why?
| > >
| > > eg: list may read
| > > value
| > > -1000 -1
| > > -965 -1
| > > -800 -1
| > >
| > > if my lookup is say 810 then the result should be "ERR"
| > > it gives me -1
| > >
| > > Ta muchly
| > >
| > >
| > >
| > >
| >
| >
|
|

Entry point not found in Works Suite 2005

Posted: 20 Jun 2006 11:48 AM PDT


"garfield-n-odie [MVP]" <microsoft.com> wrote in
message news:%phx.gbl... 

NOW you tell me.

The way I have it is since i have a dual boot installtion of Vista have
works running under xP and Office running under Vista.

Transfer database files from Works Suite 2003 to Works Suite 2006

Posted: 20 Jun 2006 11:42 AM PDT

I tried 'mail merge' in that document-didn't work. Then I downloaded the
evaluation copy of 'Quick View Plus', and I made some headway--however, Step
5 states 'create a new database file in the Works database'. There was no way
I could find to just open up and save a new file in MSWorks database--one
first has to actually enter in all the fields and field sizes, as were in the
original, lost file, then save it.Only then could I go to the next step in
the instructions.
Am I missing something here? Any way to just open a new file without all the
above?
This method appeared so promising!
kimjor


"Michel Maman" wrote:
 

Unable to print v4.0 .wps documents

Posted: 19 Jun 2006 04:07 PM PDT

FWIW, I've just "upgraded" from 4.5a (that's 4.0 with the Y2K update) to 8.5
and I've had no problems with my older documents, except I get a warning
that Works needs to use a filter and that there might be a security issue.

Once I've opened them, I just save them in the new format. Of course, all my
old documents are already backed up!

To answer your point, Erik, they all seem to print OK.

HTH Tony.

multiple print

Posted: 19 Jun 2006 07:00 AM PDT

Hi Zeb,

My printer is HP 812C, it does not have a 'Impression de Enregistrement
actif uniquement' selection. As that option is displayed for you then
suspect it is associated with your type of printer.

Perhaps someone else can help with your Registry query.

Ken

<zebhulon@(enlever)wanadoo.fr> wrote in message
news:phx.gbl...
| Yes, it's a solution !
| But, is it possible to have 'Impression de Enregistrement actif
uniquement'
| as default ?
| (I always print pages one by one).
| Is there something to change in windows registry (regedit) ... ?
| Thanks !
| Zeb
|
| "Ken" <Thanks> a écrit dans le message de news:
| eG$QT4%phx.gbl...
| > Hi,
| >
| > I have Works 6.0, HP printer 812C.
| >
| > In my Works Database if I click the Print icon on tool bar, the print
job
| > goes directly to the printer, however if I choose File then choose Print
| > on
| > it's menu the Printer dialog box displays where there is a box to select
| > what pages to print.
| >
| > Ken
| >
| > <zebhulon@(enlever)wanadoo.fr> wrote in message
| > news:eqwaZf%phx.gbl...
| >
| > | The parameter is not a printer parameter but a Works8 parameter.
| > | The box is a Works8 box and the job is going immediatly without
| > | dialog box.
| > |
| > |
| > | "Brian Robertson" <com> a écrit dans le message de
news:
| > | 4496a43a$0$9814$teranews.com...
| > | >
| > | > <zebhulon@(enlever)wanadoo.fr> wrote in message
| > | > news:phx.gbl...
| > | >> Hello, with a '.wdb' file, in 'formular mode', when i want to print
1
| > | >> page,
| > | >> Works 8 print all the pages. In the setup 'print all' is ON and
| > 'print
| > | >> unique' is OFF.
| > | >> How can i have 'print unique' ON by default ?
| > | >> Thanks
| > | >
| > | > Do you see a box that says something like "print pages"? This box
| > should
| > | > allow you to select the page numbers to be printed. To print only
one
| > page
| > | > enter the start and end number as the same (i.e. start =6, end =6).
| > | >
| > | > Try right-clicking on your printer in the Control Panel, and select
| > | > properties. Perhaps there is a setting that will toggle unique
| > printing
| > on
| > | > or off.
| > | >
| > | > Also try updating your printer's drivers. Check either the Windows
| > Update
| > | > site (select custom), or the manufacturer's site.
| > | >
| > | >
| > | > --
| > | > Posted via a free Usenet account from http://www.teranews.com
| > | >
| > | >
| > |
| > |
| >
| >
| >
|
|

Works 2000 Spreadsheet Month names

Posted: 17 Jun 2006 12:53 AM PDT

Re: If I open the csv with Works S/sheet, it converts the names to
date-names. I suppose there's not much I can do about it - or is there?

Hi, not that I know of, you might be interested in the following knowledge
base article, the same happens to me when opening with Works Spreadsheet a
saved S/sheet .csv file.

I have Works 6.0

Ken

http://support.microsoft.com/kb/138733/en-us


Q. When I type a person's name in a cell or field, why does Works change it
to the name of a month?

A. To increase speed and ease of use, Works is programmed to make some
assumptions. Sometimes those assumptions may be incorrect. If you type data
that resembles the name of a month into a cell or field, Works assumes that
it is the name of a month and modifies the data accordingly. This can happen
with some people's names. For example, Works may abbreviate the names April,
Marc, and June to Apr, Mar, and Jun. Names like Marc and Jan may be
automatically expanded to March and January.

To avoid this problem, either type a quotation mark before the month name,
for example, "April, or format the cells as text. With cells formatted as
text, Works places a quotation mark in front of all new names that you type.

NOTE: The quotation mark indicates that the data in that cell is to be
treated as text. The quotation mark itself does not print, just the text.


"Marsh" <net.au> wrote in message
news:zS6mg.13440$bigpond.net.au...
| Thanks Homer. I found out where the problem occurs - the names go in OK,
but
| then I save the S/sheet as a .csv file (for various reasons).
| If I open the csv with Works S/sheet, it converts the names to date-names.
| I suppose there's not much I can do about it - or is there?
| Thanks anyway!
| "Homer J Simpson" <com> wrote in message
| news:QfPkg.65678$..
| >
| > "Marcel" <net.au> wrote in message
| > news:JxOkg.10895$bigpond.net.au...
| >> I have a mailing list on Works 2000 Spreadsheet, Version 5.
| >> I type in names - the given name has its own column.
| >> When the name is, for example , Jan.
| >> Works nSS has the annoying habit of converting it to January.
| >> Likewise, Marc becomes March!
| >> I don't want to have to remember to type a quote mark before the name
| >> whenever I make an entry like the above.
| >> Is there a way that I can permanently disable the expansion, which I
| >> never need. If I want a full monthname, I'll type it in full.
| >> PS the same applies to Works Database.
| >> Any help would be appreciated.
| >
| > Have you tried formatting the column as text before entering data?
| >
| >
| >
|
|

Is this the full WORD?

Posted: 16 Jun 2006 08:38 PM PDT

Thanks, Jim!

Fred

sort text

Posted: 15 Jun 2006 01:14 PM PDT


"old dad" <old microsoft.com> wrote in message
news:com...
 

Select what you want to sort and then use Table : Sort Data

Thunderbird and Works8

Posted: 14 Jun 2006 05:15 PM PDT

Ok - thanks folks :-)

"Brian Robertson" wrote:
 

No Gridlines in Database

Posted: 13 Jun 2006 03:01 PM PDT

Thanks, Ken. and now I will make a WORKS folder for my file cab and
shall add all the notes you've given me on all of this. Thanks. I
had read the info you posted but didn't think it applied to me. lol
AnnE


"Ken" <Thanks> wrote in message
news:eEyCog$phx.gbl...
Hi AnnE,

Thanks for your feed back.

You might be interested in the following from Database Help.

This is if you are using Report View.

Ken

Database Works 6 & 8

Posted: 12 Jun 2006 10:55 AM PDT

Try two approaches -

1. The method suggested by Micheal below.

2. To eliminate networking problems just open notepad in the source
machine and try to save in the other machine.

This will help you narrow down the problem. Hope this helps.


Michael Santovec wrote: