Microsoft Works - Database formulas (again). |
- Database formulas (again).
- have works suite 2005,can I install only money???
- Why no answer?
- Open .wps file in Word
- Synchronize trouble with Palm device
- calendar datafile
- Works Database formula for report
- My first Test Post
- Searching a range of dates in works spreadsheet
- Microsoft Works Calendar 8.0
- record limits?
- Works database filter problem
| Posted: 16 Apr 2005 01:23 AM PDT On Sat, 16 Apr 2005 23:31:33 +0200, Erik <com>, in message ID <#phx.gbl>, in the newsgroup microsoft.public.works.win wrote: OK then Erik and the others who posted. I've had a bit of unexpected spare time on my hands and have done some experimenting. The newer formula posted by Kevin (and written by Michael) works for me. It succesfully printed the trailing zero as needed. However, an issue that has not been overcome so far is that blank, number (currency) formatted fields always seem to return £0.00 rather than "" (null string). As my document contains currency subtotals - often null strings - this meant that I was printing £0.00 quite a lot when I would have preferred it just to be blank. When I tried the .csv method proposed by Erik, this fixed that issue. I have heard of .csv before and actually used it for something entirely different some time back but wasn't aware of its possibilities in overcoming some of the print-out issues of higher level software. Anyway, I have decided to dispense with those formulas in the Works database. After each change, I will now save the database twice and merge from the .csv file overwriting it each time with the new .csv file. I haven't quite got the guts to totally remove the original .wdb file (with the formulas) in case something unexpected goes wrong so I will store it somewhere - just in case. Thanks for your input everyone. -- Paul Use the reply by email facility in your newsreader to send email |
| have works suite 2005,can I install only money??? Posted: 15 Apr 2005 12:42 PM PDT Kevin, thank you so very much... have printed off both replies and am now relieved that not only do I have a solution to my query but homepages to help in the future.. "Kevin James - MSMVP Works" <org> wrote in message news:phx.gbl... |
| Posted: 15 Apr 2005 12:28 PM PDT Thanks Erik and Rodney, much appreciated. "Rodney" wrote: |
| Posted: 15 Apr 2005 10:41 AM PDT Hi Mario, Perhaps these help: Works Converters for Word http://www.gmayor.com/Zips/WorksTextConv.zip and Product Updates and Downloads http://www.microsoft.com/products/works/downloads.mspx Also, to discover the version of Works, and the Product ID: How to find the product ID that you must have to register online http://support.microsoft.com/default.aspx?kbid=832799 HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Mario" <microsoft.com> wrote in message news:com... | I've installed the MS Office XP converter pack but still get the following | error when I try to open a Works file: | | Word cannot start the converter WORKS532.CNV | I click on Ok and get: | Word cannot start the converter WORKS332.CNV | I click on Ok and get: | Word cannot start the converter WORKS432.CNV | | This goes on about 5 times and then the file is opened with garbage in it. | | I appreciate your help. | | PS. I don't know the version of the Works file. | -- | Mario |
| Synchronize trouble with Palm device Posted: 15 Apr 2005 08:50 AM PDT Hi Andre5, Perhaps this helps: Works Suite: Error Message After Synchronization with Pocket PC Device: Wkscal.exe Application Error http://support.microsoft.com/?kbid=309501 HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Andrea5" <microsoft.com> wrote in message news:com... | Works hangs during HotSync and and I end up having to CTR-ALT-DEL to shut | down Works, and the data does not transfer. I tried restoring Palm Desktop to | the default, two ways: 1st by uninstalling/reinstalling both Works AND Palm | Desktop. No go. 2nd way I tried was by opening the Custom setting of HotSync | manager, but Date Book and Address Book do not even appear on the list | anymore for me to change them. I tried clicking Default to restore the | default settings, that also didn't work. | | I ended up going to our other, older computer and installing Palm Desktop | there, synced and had no problems. I am working on a Presario R3000 running | XP home, Works 8.0 | | Thanks for the help |
| Posted: 14 Apr 2005 05:13 PM PDT Yes, that is correct Rui. -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Rui Pinto" <microsoft.com> wrote in message news:com... | Just more one question: There is only one file to all users of the same pc? | | "Rui Pinto" wrote: |
| Works Database formula for report Posted: 14 Apr 2005 04:43 PM PDT Hi Tee, I have responded by email and returned your database updated and functioning as requested. The main issue was that the report used two Record lines, one to display the purchase details, the second to show shopper's Notes, if present. The database designer wanted to condition the second line to appear ONLY if there were Notes to display, thus removing blank lines. There is not a feature/function within Works' database to conditionally display Record lines. However, ... I used CONDITIONAL CONCATENATION together with spaces to cause either a single line, containing the field 'Item' to print, or a wrapped line with concatenated fields 'Item and 'Notes separated by spaces to be printed. The spaces cause a line-feed, to place 'Notes on a separate line, as required. A new field, 'Item_Notes' was used to store the concatenation of fields 'Item and 'Notes, using this formula: =Item&IF(Notes>"",REPEAT(" ",128-LENGTH(Item))&Notes,"") Two Record lines, the second containing the field 'Notes, were replaced with one line; the second line was deleted and the first line's entry with field 'Item' was replaced by the new concatented result field 'Item_Notes'. This field was formatted, in List view, to wrap-text and sized so that its width displayed Notes on the second line. In the Report, the column was also set to wrap text, its field width adjusted to cause wrap text and further Formatted to Row Height of Best Fit. Hopefully, I will soon place a sample on my website, for those interested in seeing this in action. HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Tee" <com> wrote in message news:supernews.com... | Hi Kevin. | Thanks, I've taken you up on sending the database. Just sent it out. | thanks for the offer. | Tee | | Kevin James - MSMVP Works wrote: | | > Hi Tee, | > | > If you care to email your database to me, perhaps we can work | > it out together, off forum. | > | > org | > | > HTH, |
| Posted: 14 Apr 2005 04:02 PM PDT Its never too late to have a happy childhood. I'll avail myself of the link to Find a Therapist in My Area link...DavidF "Kevin James - MSMVP Works" <org> wrote in message news:#phx.gbl... is confused |
| Searching a range of dates in works spreadsheet Posted: 14 Apr 2005 03:27 PM PDT Ooops, sorry Spreadsheet :) If your date reference lies in cell C7 =IF(AND(C7>'23/03/2004',C7<'24/04/2005'),"yes","no") | G'day Mario, | | I use MSWorks 4.5a. | | If you have 3 date fields | =IF(AND(date3>date1,date3<date2),"yes","no") | If you have just 1 date field | =IF(AND(date3>'02/03/2003',date3<'01/02/2005'),"yes","no") | | you can transpose the "yes" "no" answer with | whatever you like. | | | HTH | | | | | | Does anyone have or know of the correct formula to see if a cell's contents | | are between two set dates? I am using Works 7.0 | | |
| Posted: 13 Apr 2005 11:45 PM PDT Hi Sandra, Perhaps this helps, a clean before a reinstall. Windows Installer Clean Up Utility (msicuu2.exe) http://www.stationeryisbad.com/movie2.html together with the Works CleanUp Utility Utilities to help with troubleshooting Microsoft Works http://support.microsoft.com/?kbid=297061 Full details, for similar error, included here: http://support.microsoft.com/?kbid=892614 HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Sandra G" <Sandra microsoft.com> wrote in message news:com... |I can open every Microsoft Works 8.0 program I have, except for the Calendar. | When I try to open it, it looks as if it is about to open, but instead i get | the error report message 'Microsoft Works 8 has encountered a problem and | needs to close. We are sorry for the inconvenience' and it gives me the | option to 'Send Error Report' or 'Don't Send'. I can never open it, it never | works. This seems to have happened at some point after I did a System Restore | to my computer. Is there a sepcific file that could have been corrupted? What | could the problem be? I have already tried to uninstall it and reinstall it | and that has not helped. Any suggestions?? Please help! |
| Posted: 13 Apr 2005 10:47 AM PDT Works and Excel are siblings, just copy and paste suits us. MSWorks will happily work with 30,000 records until such time you employ fields with resident formula, the Database then becomes very quickly impotent and you will spend time waiting for it to compute. You will have to work with the matrix you build but for just sorting and filtering pure data the speed remains blinding. We copy and paste 20,000 records to excel at a time, and paste as "text only" excel then deals with the filtering and sorting with speed. The more you become accustomed to excel, you probably will migrate there full time, it's the "Big Daddy" Creating separate databases as you suggest is OK, we refer to it as "segmenting" sub sets. If you get to 30,000 customers, no doubt you will employ your own IT professional :) HTH | hello and thanks for the speedy response! | | I don't quite know how you would shift information to excel, but if things | reached that point maybe I would just create separate databases based on the | customer's last name or something... | | Very encouraging to hear I can work with that many records! | cheers, | kc | | | "Rodney" wrote: | | > 256 fields, 32,000 records. | > | > We still use Works for shuffling records of a 5 million record database, | > so you may not "outgrow it" :) | > We have found though for shuffling a matrix of filters, of dumping | > large blocks of data to Excel. | > | > | > | > | Hello all, | > | | > | I'm starting a small business and right now only have access to Works. | > | Eventually I expect to outgrow it, but can someone tell me how many records a | > | Works database can handle? I'm going to be entering basic customer info - | > | names, addresses, phone and maybe 10 fields beyond that... say 20 fields per | > | record. | > | | > | Also, when I do outgrow it, will I have a problem exporting my information | > | to Access. I don't have the resources to start with Access at this point, | > | unless I use the old Office 95 version. | > | | > | Thanks thanks. | > | kc | > | > | > |
| Posted: 13 Apr 2005 02:59 AM PDT Hi Peter, Could you publish the filter formula, here, please. HTH, -- Kevin James. Tua'r Goleuni Microsoft MVP (Works) 1999-2005 Works KB Links: http://www.btinternet.com/~kevin.james1/WorksFAQ.htm "Michael" <com> wrote in message news:UqY7e.996$lga... | "Peter Strong" <microsoft.com> wrote in message | news:10c201c541b6$071ecec0$gbl... | > I'll try this. At the moment I filter the database with | > Excel. Works fine! But I do not like that I everytime that | > I have to filter have toe export the whole database. I'd | > prefer to filter in Works. | > | > Thanks for your advice. | > | > Peter Strong. | | Peter, one suggestion follows: in your filter try preceding the text | value with a double quote ("), no spaces. I have found that Works 7.0 seems | to save the text field data with a single double quotation mark. By adding | this in the criteria for the filter it may work. I have to do this all the | time. | | mike | | |
| You are subscribed to email updates from TextNData Forums - Microsoft Works To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
