Reconfiguring Notebooks after Migration
I recently upgraded from Vista Pro 32 bit to Win 7 Pro 64 bit, and copied my
OneNote files to the new configuration from a backup.
In the process I lost all the Notebooks, although the Sections are still
I'd like to go back to how things were arranged before the upgrade and
If I search for *.one I find all the sections, a good number of which have
the same name because I try to have one file structure for my notebooks.
If I select one to open, it asked if I want to open the Section Only or the
whole Notebook. I select the whole Notebook.
When I&...Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...Text to columns
Once I use the Text to columns feature in Excel, it seems there is no way to
turn it off.
Anyone know if there is a way to reset this so that newly pasted text will
not continue to get broken up (for example by the space delimiter)
Presently the only way is to exit Excel and restart Excel - then pasted text
all goes into one cell regardless of spaces.
Hope I explained that well enough
I may have been to hasty in making this assumption, it appears that the
problem I described below is only happening on one workstation - this may
indicate that the Excel Registry keys are in need of...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...Can I abbreviate one value in a data series?
I've got a chart where one value (8,300) greatly exceeds all the others. Is
there a way to abbreviate this value so the other data points show better in
One way is to break the Y axis, have a look at these examples of how to
> I've got a chart where one value (8,300) greatly exceeds all the others. Is
> there a way to abbreviate this value so the other da...CRM 4.0 External Connector
Can anyone point me to CRM 4.0 External Connector installation guide?
"Mandy" <Mandy@discussions.microsoft.com> wrote in message
> Can anyone point me to CRM 4.0 External Connector installation guide?
The external connector is a license so nothing you need to install.
thanks for update. would you know if there's any specs on how it integrates
"Robert MacLean" wrote:
> "Mandy" <Mandy@discussions.microsoft.com&g...Document map 05-12-10
The document map for one of my documents has stopped displaying headings from
the beginning of the document and instead displays headings from a point
within it. The headings that aren't displayed are correctly formatted as
Level 1. And I've entered and exited Outline view, with, unfortunately, no
benefit. What might the solution be please?
Are the headings that are shown the document map in the same style? If so,
try reapplying the style to the headings that are not showing up. If not,
make sure that it is the paragraph outline level that you have set to 1 (& if
it ...Scribe Migrate
I am planning to do a reinstall on our CRM server and have purchased Scribe
(didn't come in till JUST now), and was planning to do this over the
weekend. I have a test environment and want to try it here before I do this
on our production. However this isn't as simple as I thought.
I know, I know, read the manual, etc, etc etc. But its near critical that I
get this production reinstalled, and I'd rather not work straight through a
weekend just to learn this thing.
Anways, can anyone give me the basic overview of this? Does this take hours
just to create the migration setup? For s...Integrating Great Plains 8.0 and CRM 1.2 and Windows Small Busines
Integrating Great Plains 8.0 and CRM 1.2
I run a Windows Small Business Server 2003 Premium box along with a Windows
Server 2003 Standard box used for my Great Plains 8.0 and SQL 2000. I’m
considering introducing CRM 1.2 Professional into the mix. From a hardware
stand point I know I’m fine all around. I’ve been researching how I should
configure CRM and am a bit confused. The info I’ve found in KB887153 states
“When you install Microsoft Business Solutions CRM Integrations for Great
Plains 7.0, 7.5, or 8.0, Microsoft BizTalk Server is also installed. However,
BizTalk Server 2000 and B...One Entry to Multiple Rows
I have data that looks like this:
X1 | Y1 Y2 Y3 Y4
X2 | Y4 Y5 Y6 Y7
And I need to get to:
X1 | Y1
X1 | Y2
X1 | Y3
X1 | Y4
X2 | Y4
I can change the 2nd row's entries to more columns, but that doesn't seem to
get me much closer to the needed format (and there are thousands of lines so
I'd rather not do it manually). Any ideas?
should do it. change mc to suit
Dim mc As Long
Dim mr As Long
Dim i As Long
Dim lc As Long
mc = 3 'col c
mr = 1
For i = 1 To Cells(Rows.Count, mc).End(xlUp).Row
lc ...CRM and Blackberry Connector on Exchange
Are there any problems installing both, CRM Connector and Blackberry
Connector on an Exchange-Server?
...Simple Question-How to create more than one transaction on the Acc
If there is a question already posted let me know. The question is: I created
a bank account information on the Account list icon and want to have more
than (one)transactions listed and see each payee displayed separately on
each page so i could have all the months posted with due dates and total
listed. Thank you.
In microsoft.public.money, a.j. wrote:
>If there is a question already posted let me know. The question is: I created
>a bank account information on the Account list icon and want to have more
>than (one)transactions listed and see each payee displayed separately ...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...Thanks Ken Wright but one more question RE saving data from circular references
Thanks heaps for that macro Ken Wright .
I have run it and it works.
However it loops forever. Can I set it up so that it could save dat
from a certain number of iterations?
Thanks again Michae
Message posted from http://www.ExcelForum.com
If you stayed within your thread and did not change the subject
Ken would see your reply as a reply to his reply and would see
it a lot faster than when you start a new thread. Ken would
probably see your post highlighted in RED. Also someone other
than Ken might have been able to help you. (not me I avoid
anything that hints of circul...Office 207 One Note
My One Note has been working fine for at least 2 years. Then a couple of days
ago two pages of my most important information in my main workbook just
I'm not sure but none of the other pages look the same. Does anyone have any
idea what might have happened? Have had no other computer problems recently.
-------- Original-Nachricht --------
> My One Note has been working fine for at least 2 years. Then a couple of days
> ago two pages of my most important information in my main workbook just
> I'm not sure b...How do add another code to a current one?
I have this following code to make the rows changed based on the critea in
column 16, and I need add A "Red, Yellow, Green" for status to only one
column 30 at the end of the spreadsheet. How do I add another code? I keep
getting an error..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, clr As Long
For Each c In Target.Cells
If c.Column = 16 Then
Select Case c.Value
Case "Analyze": clr = RGB(204, 255, 255)
Case "Build ": clr = RGB(204, 255, 255)
Case ...Outlook 03 standalone syncing with network, don't want it
For some reason now on startup my Vista Ultimate PC running Outlook 03
is incredibly slow with lots of disk thrashing. I saw a message about
Outlook synching but I don't recall setting it up to do that. I want
it not to and, more importantly, I want the disk thrashing to stop.
My computer is on a wireless network with a NAS. I have 3 drives
permanently mapped to shares on it. Nothing changed on the NAS, to my
I recall having seen somewhere in Vista sync settings. I can't find it
now and don't know if that's relevant.
I'm confident that my system is secur...CRM 3.0
Any way that we can assign leads / opportunities / other entities to teams
rather than individuals?
All the best
Team ownership is not supported in CRM 3.0. Could you describe your
scenario, and maybe we could provide some alternatives?
Microsoft Dynamics CRM
This posting is provided "AS IS" with no warranties and confers no rights.
"Electronic Workplace" <info@electronicworkplace.LoseThisBit.com> wrote in
> Any way that we can assign leads /...Bulk sending of emails in Outlook being rejected if one address is wrong.
I am sending bulk emails in BCC and they are all being
returned to me because one or more of the email addresses
is incorrect. Is there a way to setup Outlook so that the
emails go to the correct addresses and the incorrect
addresses are bounced back to me?
I use the Mail Merge feature and send out a newsletter
with over 1000 e-mail addresses (who signed up for the
newsletter so it is not spam). My service provider,
Comcast, just put a limit of 10 at a time. It's real fun
sending these out monthly!!
>I am sending bulk emails in BCC and they a...Access 2007 12-17-09
I am building a contact data base for my church. How do I get the phone field
to automatically format like this (xxx) xxx-xxxx when the numbers are typed
in the cell?
In the form design view select the phone control and open the properties
dialog. Goto the Data tab and use the Input Mask to define the format you
wish to use. If you click on the ... to the right hand side on the property
you will get another dialog where there are predefined input mask or you can
define your own.
For instance, I use
to format my telepho...BOM Base Unit of Measure
I have a U of M Schedule ID that contains (Kilograms, Grams, and Milligrams).
My base unit of measure in Item Master is in Kilograms, however we need the
BOM unit of measure in Milligrams. Does anyone know of a way to have a
different unit of measure in Item Master vs. BOM Entry? The problem we are
running into is that when we set the BOM Unit of Measure to anything other
than the Item Master Base Unit of Measure, the calculations for extended
quantity, extended cost and remaining quantity are wildly incorrect. The
system seems to be trying to calculate these values based on the Bas...Quotes, orders and invoices all crash CRM!
I have a post update callout process which I have attached to the
update event on the quote, order and invoice. Having attached the
process whenever I attempt to read an existing quote, order or invoice
or to save a new quote, order or invoice CRM presents its 'an error
has occurred please contact your system administrator' message.
Normally in this case I would check the event viewer but in this case
it is completely empty! The callout process as it's first action logs
a message to a file just so that I can monitor the progress and this
is not happening so it appears that the pro...CRM Security Problems
I have developed a windows service that hits the CRM database everynight to
create some e-mails that need to be sent out to customers in the morning.
Eventually these will be automatically sent, but for now, we want to
manually send them in order to audit what is going out. Here is the problem.
THe service is running under the same account as the installation was run
under, integration account with full sysadmin.
The e-mails are created by this account, however, the activity party xml is
sent in to assign the e-mail to a particular user and even set that user as
the owner of the e-...one company doesn't show $ amounts in payables for one user
I have a user who has access to multiple companies. The access for all
companies is the same. In one company when she goes to
Inquiry>purchasing>trx by vendor, the display shows $0 for all transactions.
Other companies, she sees the correct $ amount. There are no modified
windows and again her security is the same for all companies. Can anyone
tell me why this is happening?
I am having this exact problem and would appreciate a fix. I have to change
users to have the payables inquiry amounts show. I only have this problem
in one company and I am the only user in our of...how to convert a CString variable to unsigned short array one?
In my unicode VC6 app, how to convert a CString variable to unsigned short
unsigned short strOleChars;
strOleChars = strRst; //???
Is ConvertStringToBSTR() what you are looking for?
"David" <David_Wang_Xian@hotmail.com> wrote in message
> In my unicode VC6 app, how to convert a CString variable to unsigned short
> CString strRst;
> unsigned short strOleChars;
> strOleChars = strRst; //???
> Thank you.