Creating a registration table list based on an existing table
I have an access database that contains transactional tables which I cannot
alter. There is a table called invoice. This has ClientId, ClientName and
ItemNumber. The ClientID is a ten digit number while the ClientName is a
business name. There are no extra fields that I can use in it. I want to
create a form that will enable the staff to keep track of registration. A
registration is initiated when an invoice on a client is created with the
itemnumber being College. Right now, people are keeping track of attendees
using a spreadsheet but I want to create a table that contain...Query from 3 tables
I have three tables that I want to put in query. But this is what I
Articles Stores MinimumQTY
ArticleID StoreID ArticleID
ArticleName StoreName StoreID
What I would like is to have a query that shows all recors from
Articles, and for each article to show all Stores and for each StoreID
to show records in MinimumQTY...Smart list source tables
I'm using smartlist builder to create custom smartlists.
It sure would be easier if I knew what tables teh "canned" smartlists used
or could pull up a * canned smartlist and edit it as my own including adding
additional tables to join.
With soooo many tables in GP It is not a simple task to use the right one
instead of the "close but no cigar" table.
Any table indexing would help.
If you go on customer source you can downlaod some smartlists, that can be
imported with smartlist builder. They are listed for version 8 of GP but they
will work on 9 a...Pivot table chart problem
Can somebody help me to solve one insignificant problem related to
pivot table charts. I want to have grand totals displayed in the chart,
which was created using a pivot table. I tried many different ways, but
couldn't succeed. Is it impossible? If so, are there any other ways to
display the totals in the chart. I really apreciate your help. Thank
you in advance.
Message posted from http://www.ExcelForum.com/
I don't know of a way to include the grand total in a PivotChart. You
can create a normal chart, based on the pivot table, and include the
totals in that.
On Jo...setting caption for table
I have access ADP project.
In the project I have forms bound to table and present it as datasheet view.
Can I change the caption of the table which present? and not the name of the
...Show Pages of Pivot Tables
Excel 2000 had an option called Show Pages for Pivot Tables which created a
copy of the pivot table for each item in the Page category. Ths option is no
longer available (or not appearantly available). Is anyone aware of how to
replicate this option in excel 2003?
On the PivotTable toolbar, select PivotTable> Show Pages
> Excel 2000 had an option called Show Pages for Pivot Tables which created a
> copy of the pivot table for each item in the Page category. Ths option is no
> longer available (or not appearantly available). Is anyone aware of how to
> r...issue with XML and Schema namespace
Hi I am having a hard time with validation of my XML file with given schema.
Here are the files:
<robomss:element name="roboErrorLog" type="errorLogType"/>
<robomss:element name="error" type="errorType"/&...Exchange Domain issue
I have a domain in windows 2003 named "abc.com" which has a AD and DNS
itself inside my company,all the users are logging to this domain,but
my email and wesite is as "xyz.com" which is outside our network.Now we
are planning to install a new server with exhange 2003 inside our
network,can anybody tell what is the best way to install exchange.
I planned to install the exchange as member server of the domain
abc.com as mail.abc.com but when i told my ISP to route the mx record
to my mail server inside the company ,they told that our server
configuration is not correct. ...Table relationships and lookups
Hi guys, I may be a little over my head, I've had some experience in
creating simple access db's. however this one will be extremely
complicated as far as I can tell. Some backround info - i've got an
excel spreadsheet currently that i would like to convert to Access.
The spreadsheet does multiple lookups and calucations.
This is for a Soccer club that i run to maintain roster information,
dollars, scheduling and stats. I'm currently working on the
scheduling pience. Here's what I have so far.
Club - Lists the teams in the club, home field name and ...tables design and forms for setting up scheduling/accompl of clean
I am trying to set up tables, and forms for easy use for Maintenance dept.
for the cleaning of areas of the factory. There is a set required schedule
for each location in the plant. some areas are daily some weekly, some twice
a week, etc. When they click on the location( on the Map of the plant form)
I would like it take them to what is scheduled for that location for that day
- they would also need to check off what has been completed for that day.
Not sure on how to set up tables and form. Some fields I need are
locationid, job#, date, freq? , job desc. etc.
I would also like the o...Creating custom tables in Dex
Is there an easier way to create custom tables through Dex than creating
datatypes, fields, and then the table? I have a table with close to 300
fields, and this seems quite tedious.
Thanks in advance for any help.
You can re-use any of the datatypes and fields in the Dynamics dictionary,
assuming that you are writing an integrating product. If writing a
standalone product you will need to create all the datatypes and fields
You can also created on-the-fly while creating the table definition rather
than creating them all beforehand.
Hope this helps.
David Musgrav...XSLT problem -- namespace issue?
Here's a sample XML file (created by saving a dataset):
<?xml version "1.0" standalone="yes"?>
And my XSLT style sheet:
<xsl:stylesheet xmls:xsl="htt...Outlook Vcard security issue
Exchange 5.5, sp4 using Outlook2000 - users with Vcards and discovering that
if the receipient opens the vcard and goes to the activities tab, they can
view the senders inbox emails. This is internal users only and what makes
matters worse, it is not all of them. They can send the card to me and I
can't see the inbox, but they can send to the person sitting next to them
and they can. I've checked all mailbox permissions and they have not
granted these people access. I'm not sure how to stop or even troubleshoot
this. I feel if it was an Exchange mailbox permission issue, all ...Evaluate String for Value from Table
I have a table [tbl_dc_dx] that contains a field for Primary Diagnosis but
only a semi-colon delimited list of Secondary Diagnoses. The list is variable
in length and the[sec_diag] codes are in no particular order.
[tbl_dc_dx] sample data:
A list of applicable diagnosis codes is available in a table called
[tbl_dx_codes] sample data:
2800 280.0-CHR BLOOD LOSS ANEMIA
2801 280.1-IR...Customization CRM Web References Issue
When I add a new Web References for my project using
http://<mylocalhost>/mscrmservices/2006/CrmService.asmx, I get an error
message as below:
References\CRMSERVICE\Reference.map(1): Custom tool error: Unable to import
WebService/Schema. Unable to import binding 'CrmServiceSoap' from namespace
'http://schemas.microsoft.com/crm/2006/WebServices'. Unable to import
operation 'Execute'. Schema with
invalid syntax. The global element
'...Payment Terms issue!
I am facing a problem with Payment terms.
I create a quote with terms discount applied to it. Then transfer the quote
partially to order & partially to invoice.
Now terms discounts are applied to the invoice that gets created but not to
the order. In the SOP_HDR_WORK table I see the Payment terms ID for the order
but no discount is applied.
Now even when I modify this order the terms discount is not applied.
Is this the system behaviour or am I missing something here?
Thanks & Regards,
I have a few piviot tables that work off a large data
one of the fields I use is "Acct #s" I have about 200
different acct #s. I one piviot table I only need to
show 2. Is there a way to unselect (uncheck) all the
account #s in the drop down so I can go back and just
check the two I need.
Thanks in Advance
There are sample macros here that you can use to show or hide the items
in a field:
Excel -- Pivot Tables -- Show and Hide Items
> I have a few piviot tables that work off a large data
&...CRM integration for GP: reinstall issue
When I uninstall and reinstall CRM integration for GP, I get a message that
"the user specified does not have all the required CRM privileges." The
Integration User in CRM is a system administrator, and the
domain\integrationuser account is a member of the domain admins group.
What other privileges should the account have? Did I uninstall incorrectly?
Is the domain\integrationuser account a CRM administrator?
"Pete Grare" wrote:
> When I uninstall and reinstall CRM integration for GP, I get a message that
> "the user specified does not hav...Cached Mode and GAL Issues
Exchange 2003 SP2 with Outlook 2003 Clients. Running clients in cached mode
and changes to GAL are not upfdating to clients. I have followed some of the
KB articles and "fixes" found in other posts to no avail.
Last tried changing times when Exchange rebuild OAB, deleted .ost from
client and downloaded "new" OAB....still same thing. The only time I can get
an updated copy of GAL is to switch off Cached Mode which then kills spam
filtering. Any suggestions?
"Joe" <none> wrote:
>Exchange 2003 SP2 with Outlook 2003 Clients. Run...Excel 2007
In Excel 2003, if I had a pivot table open, I could go to a new workshhet,
create a new pivot table and one of the choices for the source data would be
another pivot table in this workbook. This would create a new pivot table
using the same pivot table cache.
I can't seem to find the equivalent functionality in Excel 2007.
Can this still be done?
I believe this is now deprecated, sorry
Microsoft MVP - Excel
UK Excel User Conference In Cambridge
November 28th - December 1st 200...String Table #2
I am getting ready to paste hundreds of string table entries into my .rc
file. Could I get some advice on how to proceed with:
. . .
I can't say I truly understand what STRINGTABLE DISCARDABLE does.
"Steve Russell" <firstname.lastname@example.org> wrote in message
>I am getting ready to paste hundreds of string table entries into my .rc
>file. Could I get some advice on how to proceed with:
> STRINGTABLE DISCARDABLE
> . . .
> ...Pivot Tables #7
Before i post my question am I on the correct board to answer my question?
I've a question on pivot tables and want to make sure I'm in the correct
Here is my question.
I have a pivot table that does what I want it to except the category field
that is a column field shows two different figures and I would like the
final column to calculate the percentage of one against the other.
For example extract of pivot table is like this:
Calls answered Calls resolved
100 5...how MFC uses hash table to cache message
i want to find out how MFC uses hash table to cache message,
then i read the CWnd::OnWndMsg.
and the following:
const AFX_MSGMAP* pMessageMap; pMessageMap = GetMessageMap();
iHash = (LOWORD((DWORD_PTR)pMessageMap) ^ message) & (iHashMax-1);
AFX_MSG_CACHE* pMsgCache; pMsgCache = &_afxMsgCache[iHash];
"(LOWORD((DWORD_PTR)pMessageMap) ^ message) & (iHashMax-1)"
is used to generate index. but why "xor" pMessageMap and message?
is it to avoid collision somehow? i don't get it.
I have a pivot table that is doing something strange. When I double
click a data point in the table, to bring through on a new spreadsheet
the relevant data to to that clicked through data point, all of the
numbers (in every column which contains numbers) on the new worksheet
are formatted as dollars, even though on the original worksheet
containing the data, those numbers are not formatted as dollars, but
rather formatted as general.
The data in the pivot table are not formatted as dollars.
The source data are not formatted as dollars (except for just one
Why would the click through...OLE Issues
In Office Excel 2003, when I open a New worksheet, in the
Task Pane under Template when I click on 'Templates on
Office Online' I never get connected and have to close
Excel after getting a msg 'Microsoft Excel is waiting for
another application to complete an OLE action.'