Bizarre Sales Tax Table Issue
I have four taxes set up in my system, and confirmed in the TAX table in the
ID Description Rate
1 Sales Tax 0%
2 VAT 15%
3 VAT-EX 0%
4 VAT-ZR 0%
If I create a new item, and select VAT, then check the ITEM table, the TaxID
= 3 for that item. You would think that the system would apply the VAT-EX
taxation on the item. However, when i do a transaction, it puts the 15% rate
on the item and everything seems work out okay, including the reports, which
show that VAT was collected. The TransactionEntry table has the proper sales
...count a pair of numbers in row in a table
my question is:
we have the following table:
34 29 13 15 7
15 8 40 11 24
13 6 8 21 38
9 17 23 1 4
22 38 42 37 16
1 18 11 37 41
5 42 18 33 45
9 1 21 41 15
41 1 27 23 42
23 29 7 38 18
42 12 26 34 36
and this one in another sheet
1 2 3
I want to fill the second table with the sum of how many times the numbers
if each row and column appear in the same row in the first table. for
example: how many time the numbers 2 and 3 appear together in the same row
on the first table
Assume t...i can change the font on the screen to be large but can't print t.
i am trying to make the print on my spreadsheet larger. i can change the
font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
Maybe in the Page Setup you have this setting
"fit to1 by 1 page"
Regards Ron de Bruin
"tj" <firstname.lastname@example.org> wrote in message news:244325C6-A407-4CD8-BE76-75AB3C93A78A@microsoft.com...
>i am trying to make the print on my spreadsheet larger. i can change the
> font on the screen but it still prints the smaller font?????help!!!!!!!!!!!!!!
...Add the same field twice to a pivot table but filter one of them?
In my datasheet, I have a "cost" column and a "date" column so each
cost has an associated date. In my pivot table, I've added the "cost"
as a field, which shows the total and this is fine. However, I'd like
to add the "cost" as a field again and this time selecting which dates
to include in the cost number so that I have two cost fields side by
side. Is something like this possible?
That is not possible in the same PT.
You will need to set up a second PT based upon the same data set as the
first but do NOT use the same Pivot Cache to save ...Problems with Access 2000 reports in Access 2003
we have a sent out a 2000 format access database to a
client running Access 2003. When trying to open any of the
reports they get an error - "the openreport action was
cancelled" - Not sure if they get this by running the
report from the database window or if it's only when done
through a form (buttons that run docmd.openreport when
Is anyone aware of any issues that may be causing this? I
couldn't find anything elsewhere on the MS site.
P.S. the reports work fine in 2000 and XP.
...mail merge in word 2000
Been trying to link a simple 4 column excel db to do a mail merge in Word.
Tried following the help instructions, and finally reached the point where I
could "insert a merge field" after realizing they left out a number of steps
in the instructions. However, when I do enter the mergefield, the only thing
I get is "Error! No bookmark name given." There is no mention of "bookmark"
in the instructions, no explanation of what a "bookmark" is in this context,
and now way I can figure out what the blasted software is talking about.
Anybody go...Anyway to open a Publisher 2002 file in Publisher 2000?
I need to open this file for a project tomorrow. I have Publisher 2000, but I think the file sent to me was done in Publisher 2002 or 2003? The person who sent it to me is out of town until Thursday, so I can't have them resave it or resend it. Any ideas
buck <email@example.com> posted:
> I need to open this file for a project tomorrow. I have Publisher
> 2000, but I think the file sent to me was done in Publisher 2002 or
> 2003? The person who sent it to me is out of town until Thursday, so
> I ...Change QuickFind to search contains
Is there a way to change the QuickFind to use the contains operator
rather than begins with? Custom dev or third party recommendations
simply put a wildcard * in front of your search term in the query box and it
will match the defined search fields for that entitiy type on a 'like"
...can comment indicator color be changed?
Hi when you put a comment in a cell the indicator is red but I have cells
that are conditionally formatted to come up red if out of spec and can't see
the indicator. Can the color be changed and if so how please. Thanks Karl
AFAIK, no, you can't change this. Maybe you can change your CF color. Bright
On Wed, 27 Oct 2004 16:27:02 -0700, "Karl" <Karl@discussions.microsoft.com>
>Hi when you put a comment in a cell the indicator is red but I have cells
>that are conditionally formatted to come up red if out of spec and can't see
>the indic...Outlook 2003 with Word 2000 Editor
Does anyone know if you can use Word 2000 with Outlood
2003 to edit messages...
I couldn't find a download on the web...
If you are trying to use, inside of Outlook 2003, Word 2000 as the
"editor" ... not possible. Need to use the same "family" together, e.g.
Word 2003 with Outlook 2003, or Word 2000 with Outlook 2000.
There is nothing to download.
Hope this is useful to you. Let us know.
Brendan Shaw wrote:
> Does anyone know if you can use Word 2000 with Outlood
> 2003 to edit messages...
> I couldn't find a download on the web...
...How do I turn the pivot chart into a list with all cells filled?
I have the pivot chart and would like to copy and paste it so that all fields
Select the pivot table.
Select the cell where you'd like to paste the copy
Choose Edit>Paste Special
Select Values, click OK
There are instructions here for filling the blanks:
> I have the pivot chart and would like to copy and paste it so that all fields
> are filled
Excel FAQ, Tips & Book List
...How to remove contacts when email changes
If I receive an email from a sender not on my list, that sender's email
address is not automatically added to my contacts but will appear on the
automated list when I enter the first letter of the sender's email address.
If that sender changes email address I cannot delete the old email address.
Instead I am left with two email addresses for that sender both of which will
appear on the automated list. How can I remove the old email address?
You seem to be confused. Receiving an email does not add an address anywhere
in Outlook. Sending an email might, a...Readonly a linked table
I have a table that gets generated every month, and we use as a source
of data for other databases. We link this, but I was wondering if
there is a way to make that linked table read only.
Thanks so much,
> I have a table that gets generated every month, and we use as a source
> of data for other databases. We link this, but I was wondering if
> there is a way to make that linked table read only.
Either make the back-end read-only or use a pass-through query instead
of a linked table.
--> stefan <--
...Best tool for adding a pivot chart like chart to a report?
Is it the PivotChart form or should I used the MSChart OCX?
Which is easier to set up/configure to display the data properly? (A
multi-column, multi-entity bar chart)
Which is the most flexible?
And where can I find tutorials on using both?
...Using tables created in 2003 IN 2007
My office has recently upgraded to 2007. I enjoy new features such as the
ability to highlight a few words within the table without the ENTIRE table's
font changing; unfortunately, this only works in tables I have created since
the upgrade. My old tables that were brought over from 2003 do not have this
capability. Is there an add-on out there? I do not have to resort to
re-typing and creating all new tables. PS. Copy and pasting into a new table
does not work. Convertting the file using the office button does not work.
I think you talking about what is called...Totals For a Pivot Table??
I have a pivot table with data linked to an access database.
I went to pivot table options and checked the box under the format options
area "Grand Totals for columns" so that my colums would have totals at the
When it is on the Title all the way to the far right appears but none of my
columns have totals at the bottom?? CAN anybody tell me why?? How can i
resolve this, i'm i checking the wrong format box?
...Placing the results within a table
I have a form where I would add how many openings there are for each
position. Once I get the total I can see it on my form but I am not able to
transfer that total into my table.
My code for this text box is
it adds up the number from each of those fields. What I wanna do it to get
that sum placed into my table. I have tried
Please help me. I am at a lost.
Please and Thank you,
It is not correct to put the total i...Excel 2007
We have a spreadsheet that was set up to link to a database via a
system DSN. To simplify deployment of this, I'd like to change this
to connect via the connection string below:
I've done this for another spreadsheet, and it was easy (Data tab-
>Connections->Properties), but in this next spreadsheet the Connection
Properties for one connection are greyed out/disabled, so I can't
change the string.
Does anyone have any ideas how to enable these values again so I can
change the connection string?
A simple question
On a form, I have a button that create a table when someone click on
it "DoCmd.open query "
But I want to add something that will stop the code if the table
If the table exist then
msgbox "The table already exist"
DoCmd.open query "...."
So what is the right sentence for "if the table exist"
You could use for instance the following function:
Public Function tableExists(strTableName As String) As Boolean
Dim dbClient As Database
Dim tdf As TableDef
Set dbClient = CurrentDb
For Each...Where to change my own internet adress in "FROM:" field?
I am using Outlook 2003 with Exchange server.
My own eMail address is presented to recipients as
Note: mixing of capital and lower letters
I want my email address completely changed to lower letters:
Where in Outlook can I change this?
or is this a setting in Exchange Server ?
This is a setting in ADUC/Exchange. I would guess that everyone is set up
with the same format throughout the company.
Kathleen Orland - MVP Outlook
Outlook Tips: http://www.outlook-tips.net/
"Joe deAngelo" wr...97 to 2003
Converting an Access 97 db to 2003, I got a message "conversion errors
encountered - look in conversion errors table".
In the table is a single row--
Object Type: Table
Object Name: MSysObjects
Error Description: -1611: Could not find field 'Description'.
This database contains only tables, queries and reports.
Any idea what this means? All I can suppose is that some query or report
refers to a column called Description in a table that does not contain it.
But how to find out which one?
This message probably represents a corruption in the original Access 97
data...Unable to restore MS Money 2000
My computer crashed, i had to use the recovery cd.
Now when i try to load my back up from a floppy, i receive
a message that says "unable to restore, can't locate or it
might be a read-only attribute."
Hoe to i restore?
See if you can copy it to the harddrive and restore from there.
"Dan" <firstname.lastname@example.org> wrote in message
> My computer crashed, i had to use the recovery cd.
> Now when i try to load my back up from a floppy, i receive
> a message that says "unable to restore, can't locate ...Running sql server 2000 and/or sql server 2005 on sbs 2003
My ultimate questions will be: Can SQL SErver 2000 and 2005 run on the same
ssbs2003 server? and, regardless, Should I/ can I uninstall SQL Server 2005
and go back to SQL Server 2000.
Moving from SBS2000 Premium to SBS2003 Premium on a new server. We were
using SQL Server 2000 on the old server for a few things: Backup Exec, Prolog
(construction mgmnt software), Great Plains (MS financial), etc. During the
install, I kind of just followed directions and installed R2, which I guess
installed SQL Server 2005. I wasn't really aware of options. Since then I
have had a number ...How do I refresh the selection listboxes on a pivot table?
The field-level (column) selection boxes used to select the data to be
included in a pivot table include old and new values. How do I refresh these
list boxes so they only include values that are present in the current source
data? The list box continues to show values that are no longer in the data
Click in the Pivot Table to bring up the Pivot Table toolbar. (If that
doesn't bring it up, rt-click a toolbar and select it from the list.) Click
the button with the ! icon to Refresh the Pivot Table.
Hope this helps |:>)
> The field-level (colu...SQL Table SOP40500 Sales Master Number Setup
Can some rows be deleted from Sql Table SOP40500 to improve performance?