Search results for query: *

My data is arranged in the following columns. Rows over 2000 but less than 3000 Sorted by Item number within Category. A B C D E Catg ItemNbr Desc U/M Price 20ws 11111 AAAA BX 5.00 20ws 22222 BBBB BX 5.50 20yl 11111 AAAA BNDL 7.00 20yl 22222 BBBB BNDL 7.50...

Hello: The code below works and will send my document to all contacts in the contacts folder. What I'm really trying to do is send the document to only those people in my distribution list. The distribution list is called marketing. Public Sub SendDocToEmailList() Dim olapp Dim mynamespace...

Hello: I have attempted to write a function in Excel 2000 to convert a date coming from a legacy system in YYYYMMDD format to a valid date using the mid function with no success. Of course I can do this in a cell and copy the formula to the end of the region and then convert formula's to values...

Hello: Column A of my spreadsheet has the beginning of the month date. The work week is from Monday through Saturday. I would like to have a formula take the beginning of the month date and increment column B with the next days date skipping all Sundays in the month. Holidays are not important...

Hello: I have a spreadsheet that subtotals by customer and also breaks page by customer. Does anyone know how to reset the page number to one on group break, or is there a way to place your own page number in the header and how do you do this. Thanks Gary W. Hill

Hello: I have my headings such as date, page number etc in the header section. My data is sorted by customer number. I have the subtotals set to page break between groups. I need to reset the page number to 1 when the group breaks. Thanks Gary W. Hill

Hello: I'm importing a file into Excel 2000. Column A comes in as a text field with numbers. I need a formula to right justify the number in column B and add leading Zero's. This must remain a text field for further exporting to another application.

Hello: Windows 2000 Explorer is configured as follows: Excel comma seperated values file Open Print Confirm Open After Download Checked. WindowsXP is configured identically. When downloading a file from the Bank in 2000 the dialog box would appear asking for the file name to save as. This is...

Hello: My report is a Sales Tax report for the state. Below are the fields. Gross Sales Expempt Sales Net Taxable Sales Reportable Sales Tax Tax Liability Discount Net Amount Due The Net Amount due is Calculated =sum([Taxamt])-[Discount] For this week that amount is 5277.34 The State wants you...

Hi: I am using Access 2000 to link to our Accounting Software data tables that are stored in Pervasive SQL. The Customer Number field is text and 12 positions long. I have written a parameter query so people can look up certain data but I don't know how to avoid having to type in leading zeros...

Hi: Cells c17 through c20 are formatted as number with 2 decimals. c17=16,773.86 c18=c17*0.009 c19=0 c20=c17-c18+c19 The answer in c20 is 16,622.90 and needs to be changed to the value of 1662290 so the array can sum the digits. Using edit copy,Paste Special,Values changes c20 to 16622.89526 If...

Hi: I'm using Terminal Services at our remote location. They have an HP2200 Local Printer attached to their Computer. Everything prints fine but one annoying problem persists. None of their print jobs will disappear from the print spooler. The user has full permissions of the printer. Every...

I have an Item Database that is defined in Pervasive SQL. I have linked to the tables in Access. The field for the Item number is called key_fld. When I do a select query to pick up items that match the first two characters of the key_fld the query works fine. It is defined this way: key_fld...

I'm trying to create a rule that will delete E-mail where my name is not in the TO: box. I receive all types of junk mail with names like "suspicious" etc in the TO: Line. When I create the rule "Where my name is not in the TO:" field Outlook deletes all my E-mail even the...