Is it possible to make Publisher 2003 continue a table onto the next page if
too large for one? I know you can do this in Word, but don't seem able to
find a way in Publisher. It would be good to be able to link tables together.
On Tue, 3 Jan 2006 09:58:02 +0000, carljh wrote
(in article <CD8D49D0-B49D-4B58-9B9E-FC7AC37ACBDC@microsoft.com>):
> Is it possible to make Publisher 2003 continue a table onto the next page if
> too large for one? I know you can do this in Word, but don't seem able to
> find a way in Publisher. It would be good to be able to link table...GP6.0 Tables
The BM00101 table is primarily used for BillOfMaterials. Is there a table
similarly used for Kits?
IV00104 is the Kit Master Table.
Richard L. Whaley
Author / Consultant
btw....there is considerable information on tables and their relationships
and how data moves through them in our book Information Flow and Posting.
Check it out on our web site.
> The BM00101 table is primarily used for BillOfMaterials. Is there a table
> similarly used for Kits?
...Vlookup cells in combination of two columns (both in the lookup value AND table array)
I am trying to match information in multiple columns (lookup value) to
the same multiple columns in the table array. If the combinations
don't match then I'd like the return to be #N/A. I think an example
can better clarify what I'm trying to accomplish because I haven't a
clue whether I can do it...
On the lookup worksheet I have...
12345 First Fill
22233 First Fill
On table array worksheet I only have one entry.
22233 F...Recreate Chart of accounts
We created the chart of accounts for a new company and there are a few
transactions went through and posted.
Then later we designed to change the segments of the GL accounts.
That means a new set of COA is needed.
The transactions posted is not a concern for us and they can be reentered.
But GP won't allow us to delete if posted transactions exist.
Is there any way to delete the old set of COA?
In the same company you would need to purge the history and reconcile to
clear the account summaries. Alternatively, you could create a new company
and copy the setup to it, if there'...import data from access table into a existing table
I need to map data from an existing access database into a existing staging
database. The access database only has the data I need, so the mapping is not
a one to one, The SQL table many more columns so I need to do some manual
mapping. Is there a way to do this throiugh the import wizard or do I need to
write some type of query to manual insert the data?
Thanks in advance.
Message posted via SQLMonster.com
...Pivot Table "stdev" summary
I have a pivot table which reports mean and standard
deviation for my population (obtained as external data
from SQL Server).
Instead, I would prefer to be reporting the maximum and
minimum values within 2 standard deviations of the mean.
ie. mean = x
standard deviation = o
How do I get my pivot table to show
x + 2o
x - 2o
I have posted this question before. Somehow it ended up
in the microsoft.public.exchange.misc newsgroup instead of
...Need Inventory Tables
Where can I find a better reference for Inventory tables (field descriptions)?
GP SDK does not seem to explain Inventory that clearly.
Any guidance to the reference would be great.
For GP 9; in GP go to Tools > Resource Descriptions > Tables then hit the
elipsis icon (box with 3 dots). Select Microsoft Dynamics GP as the Product
and Inventory as the series. You'll then see a list of all inventory tables
and from there can get details on each.
Don't know if the navigation is the same for GP 10 but it should be similar.
Accolade Pulications also ...Table Import no longer shows tables
In GP 10, if you go to any screen and then try to go to Table Import, it just
goes to Table Import and it no longers shows the tables that are being access
by the form. Is there anyway to get this feature back?
Table Import does still work as before. The difference now is the new
security model is pessimistic. Unless the user you have been using has been
granted access to the tables, or is a POWERUSER, you will not see the tables.
Hope this helps.
David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific
Microsoft Dynamics (f...Pivot Table
I have a Pivot Table based on data that gets imported.
The number of rows in the Pivot Data varies depending on the underying
Below the Pivot Table are some calculations and then a couple more
I'm building a Profit & Loss report and each Pivot table summarises the
relevant report sections (e.g. Sales Pivot Table, Cost of Sales Pivot
The problem is, when the pivot table refreshes, it can overwrite
formulas and tables below it if the table increases in rows.
Any ideas/suggestions please to prevent this.
I don't know if you can preven...Export Word table to Excel
I created a table in Word 2002 which I now want to export
to Excel 2002. I want to keep the cells of the table
intact in Excel so I can sort the table. How can I
You can copy the table by the copy and paste method. Hold down Alt, double
click on any cell in Word to select the entire table, then hit Ctrl C to
copy. Open a new Excel workbook or sheet tab in an existing workbook; click
on cell A1 and hit Ctrl V to copy. Save your work before proceeding. You may
have to do some reformatting, and may have to rework any formulas that
appeared in the Word table. You will also h...Add New Contact > More Actions > Sharing...
I add a new contact. Then I share the contact with a team using More Actions
> Sharing > Read, Write, Delete, Append...
Which database table is this information stored in?
...When will HQ send store information to store?
We have installed HQ with 3 stores. Two shoes stores, and another one is
shirt store and it will not see shoes products. We have run this for a
while. Now we want to clear everything in 1st shoe shop because we found some
problem with item information. So we try to delete database at 1st shoe shop
and then restore database from store blank database. After that we send 101
and 203-205 206 worksheet and then 401, we found that this shop cannot see
other shop, because HQ didnot send store information. We would like to know
how HQ detect and decide to send or not send all ot...Copy Website Tables into Excel 2007 Spreadsheets
I work in a government office. Our computers are imaged to provide
certain software and none other for office use. The task described in
the Subject caption above is found within blogs.howtogeek.com/
mysticgeek/ ... and the instructions start with "Open Excel 2007 and
under the Data tab select Get External Data and From Web."
Problem: our image of Excel 2007 doesn't have these selections under
the Data tab. What we have is
Presumably there is an alternate way of accomplishing my task. Can
someone clue me? T...How do I Recreate Schedule+ Free Busy public folder
Had 2 Exchange 5.5 servers. Was in the process of a migration. The first,
primary, Exchange server crashed. Having problems restoring databases.
New server works fine, but continually receive Unable to update public
free/busy data. The contents of this public folder are currently
The Schedule+ Free Busy public folder was not replicated to the new server.
Is there a way to create it on the new server since the first, primary,
server is unavailable.
Hello All, I am trying to find out what the RECONUM field is in the
CM20200 table. I looked everywhere and can not find out what the
numbers actually mean. I did notice that when you select the checkbox
in the Reconcile screen it makes that Field 135 not sure if that is the
standard everytime it is selected or not. TIA
...Importing nested tables from HTML to Excel
I've got something like the following table:
<th bgcolor="green">First Row</th><th bgcolor="green">Second Row</
th><th bgcolor="green">Third Row</th><th bgcolor="green">Fourth Row</
<td>A test again</td>
<td>Yet another Test.</td>
<td>How many tests can I possibly do? Enquiring minds really really
really really really really really really really really want to know!</
<td rowspan="1" style="white-spac...Inserting calculated fields in Pivot Table
I am working in pivot tables and created the table below
The market share is created by calculating the % of column on the unit volume. I am trying to insert another column all the way to right to calulate the change in market share. When I tried to insert field, but the market share fields (which are calculated) do not show up in order to create a formula. I tried to do it as a calculated item but the insert item is grayed out and it won't let me execute. Any ideas
Sales Mkt Shr Sales Mkt Shr Mkt shr Ch
BAYLINER 547 7.5% 685 9.8%
CARVER 1...How To Add Rows and Cells in The Table Using IHTMLTable
I am currently working on the DHTML Dialog Based Application. I have been
stucked due to a problem, which is that my HTML Page contains a HTML Table
element and a button, i want my application to add rows and cells on the
click event of that button. I have captured the event of the button but i am
unable to add rows and cells in the table. Can anyone tell me how to acheive
that by using the IHTMLTable interface.
Thanks in advance.
"Ghazanfar Ali" <email@example.com> wrote in message
news:uMq8CiCjFHA.1416@TK2MSFTNGP09.phx.gb...How to analyze data and output it in table form?
I am a beginner in MS Access and would like to try some data analysis.
I have a database like this:
And I would like to analyze the data and output a table like this:
Please let me know what I should use(e.g. query, functions, reports, etc.).
If possible, please let me know the corresponding tutorials so that I can
understand what's going on. I wonder if crosstab query is the answer. Thank
...recreate a window
a CComboBox and CQControl derived control shall recreate itself, if
the styles given in resource not match the style required for toe
control (here: CBS_OWNERDRAWFIXED must be set). As CComboBox is unable
to correctly modify this style with ModifyStyle(), the recreation is
called and works.
// recreate the underlying hwnd to match required styles
bool CQControl::QRecreateWindow(DWORD dwStyle, DWORD dwStyleEx)
CWnd* pWnd = CWnd::FromHandlePermanent(m_hwnd);
ASSERT(pWnd != ...Two table in one query
I have 2 tables and unit them in a query but no join them.
Why I can't update the records inside the query/form?
Is that impossible to update the records in this condition?.
> Hi All,
> I have 2 tables and unit them in a query but no join them.
> Why I can't update the records inside the query/form?
> Is that impossible to update the records in this condition?.
> Thank's all
No. Many multi-table queries produce read only results. This varies depending
on the number of tables, number and type of joins, and which f...Flagging
I did something stupid and now I am in the soup. My
boss's boss called me while he was traveling on business
to check his e-mail messages because his assistant was out
to lunch. When I opened his mailbox he had literaly 15 of
those pesky flagged message pop-up reminders. I dismissed
them because I find them annoying and wanted to get to his
messages. It turns out those pesky reminders are a
valuable mnemonic device for him. How do I restore the
active pop-up messages without changing the original due
date? He wants the original action date to remain. When
I try to put in b...filter pivot table
How do I filter out the items that say NO CASH in the source spreadsheet
basically those fields are Blank. In the table properties for now I have
box checked IF EMPTY put in NO CASH. I would like the items that are
blank or NO CASH just not to appear in the table. Can this be automatic
each time I go into this pivot table? Basically the source spreadsheet is
Sum of RECEIVED
DAYS Account RECEIVED FROM Total
6/1/2004 1074 Loan Payment $203,544.08
1080 G.Homes $200,000.00
1091 1st - CL $1,500.00
B&C - CL $3,...Pivota table and excel session
when a select some values from the drop down menu of a
pivot table field, additional excel session is created.
how to avoid that? why does it occur?
If you double-click on a value in a pivot table Excel does
a drill-down which means it opens another worksheet
showing the values that make up the value that was double-
clicked. If you want to avoid this just don't double-click
the pivot table value.
> when a select some values from the drop down menu of
>pivot table field, additional excel session is cre...Any way to perserve Pivot Table formatting
At least the borders? We have a pivot table that has many columns of
data (18 months) and it is very useful to have an underline or row
shading to help follow across this large table.
We can set the borders and it works OK, but as soon as the data is
updated, the format is removed. Even as simple as selecting one of the
categories from the drop down clears the formatting. This doesn't seem
What are we doing wrong? Should the formatting be set immediately
after creating the table? Or is there some trick to this?
Tried to pick a report style, but picking one seemed change the table...