Move Project Server 2007 to new domain
We just acquired another company that has a Project 2007 server. We will be
using the ADMT 3.0 tool to help with the domain migration. Everything will
stay the same with the server, just the domain will change. Will using the
ADMT tool work for this?
we've migrated a project server to a new domain some time ago. We've used a
tutorial for the migration:
We've only migrated the users and groups (with SID-History) ...Create database based on 24 hour time; 15 minute increments
I need to set up a MS Access Database that stores test data that was
performed at certain times (rounded to the nearest 15 minutes).
I need to produce a query that shows each 15 minute interval within a 24
hour period. Any 15 minute increment that doesn't have test data needs to be
represented by a -1.
Any suggestions on how to do this?
If you first create a table which has one row for every 15 minute interval
over a suitable period you can then LEFT JOIN this to your table of test
results to return a row for every time regardless of whether there is test
data for that time....Moving Journal Entries
I recently changed computers and also upgraded Office from
2000 to XP. My problem is that I don't know how to
transfer my Outlook journal entries from the old computer
to the new computer. Any help would be greatly
Dan McMillan <email@example.com> wrote:
> I recently changed computers and also upgraded Office from
> 2000 to XP. My problem is that I don't know how to
> transfer my Outlook journal entries from the old computer
> to the new computer. Any help would be greatly
Journal entries, like all other entries in Outlook, are i...mail format issues winmail.dat
I just got my iphone and Apple acknowledges problems with attachments sent
from Outlook. I emailed my clients to make sure that the mail format options,
are set to HTML and to double click my email address in contacts to change it
to: Let Outlook decide. It works.
However, I have 7 email addresses and sometimes I use an email which is not
in my client’s address book. I they use reply, and I double click my email
address in their reply, it shows up as rich mail format, which now explains
to me why these emails show up as winmail.dat in the iphone. Even if I open
these email us...Move a column up or down
Sometimes i need to move a specfic column one line up or down, m
quetios is how ro do it? of course i know how to insert o delete
column but the column itself one line up o down
MLOO55's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2504
View this thread: http://www.excelforum.com/showthread.php?threadid=38564
I assume you mean you want to move a ROW up or down? You can copy the row
and insert it back where you want it.
"MLOO55" <MLOO55.1rv1uc_1120842307.6...Two Momey 2007 Issues/Suggestion
I recently upgraded to MS Money 2007 Deluxe from Money 2004 and found two
issues that MS has never seemed to resolve.
The first is the frequency that bills are set at in the Bill Minder. The
list of options in 2007 is still the same as in 2004. I would have figured
that MS would finally allow you to set custom recurrent times. For example,
I have a subscription that is billed every 3 weeks - not possible to do in
Second, is what I believe to be a bug that I found to be pretty prevalent,
but apparently has not been fixed. The issue that that when I am entering a
transaction and ...Sample CRM Data Install Issue
Installed test version of CRM fine running as a web site on its own IP
Try to run the sampledata wizard on CD1 but it fails at the first dialouge -
enter the address of your crm server. Mine is running locally on
192.168.0.91 - accessible fine thnrough a browser - so I enter this and get
back an error message saying crm server not found or not got sufficient
priviledges to do this. Am logged on as Administrator account?
Any advice on what needs to change to make the wizard work?
...VBA code not working on other PC
I am using Excel 2003 and I have been using the VBA code below on my computer
for a long time and find it extremely useful and which has never result in an
A colleague asked if he could also have in on his computer and so I copied
it over. The strange thing is it doesn't seem to work on his computer and I
not sure why. I stops on the line 'Dim Result As New DataObject' that I have
higlighted with the *********. and a dialogue box appears saying: Compile
Error: User defined type not defined.
Does anyone know the answer why it works on my PC and not on his? I...Use the ctrl+t to move from tab to tab in a form
I have a department that would like to be able to use the keyboard instead
of using the mouse to select a different tab in their form.
My form consists of the following;
In the Detail: I have a Tab Control (TabCtl211) that consists of 3 tabs and
with in the tabs there are several fields that they add/update
Case Entry/Update (0), Legal/Closure (1) and Restitution (2)
I want to use the ctrl+t to move from tab to tab, because they use the tab
key to move from field to field and then to new record.
How do I make this happen for them?
"Penny Miller" <Penny.Miller@CO....Linking CRM/SQL Server to External Database
I am looking for information of someone to talk to about how to "link" data
from an external non-SQL Server d/b to the CRM SQL Server d/b. In our case
we need to link our Oracle ERP database to SQL server (CRM database) as it
contains about half of the info we need in our CRM.
We can obviously create an interface between the two db's and "load" the
data periodically but what I would rather do is use ODBC to map / connect the
data in the Oracle db to the schema in CRM/SQL server so we don't have
duplicate data (I would really prefer to have the Oracle be ou...HELP..Tax exempt issues
hey there kind of stuck..I have a client and she needs to use the indian
status tax exemption. I have it set up that when everything is done that she
can select the HST tax or the Tax Exempt (meaning pay only PST) i
When we do this for some reason it goes to $0 in tax which isnt correct..I
tried it like 5 times and all same thing..i rechecked everything and i know i
am doing it correctly because i ave done it other clients..this one has
become a mystery..plz anyone help me asap
...Moving & hiding worksheet groups
Is there a way to:
We want to have a summary worksheet for each day (i.e. Monday, Tuesday,
etc.) and those are the only worksheets you see. But we want to have
multiple hidden worksheets "grouped" with each day so that when you click on
the worksheet for a day (e.g. Monday) then the worksheets "grouped" with the
Monday worksheet are listed after that tab. Then, when you click on
Tuesday's worksheet, the Monday "grouped" worksheets are hidden again and the
worksheets "grouped" with Tuesday's worksheet are shown after that tab.
Can this b...Setup was unable to create the Microsoft CRM databases.
CRM = Windows 2003 Server
SQL 2000 = Windows 2003 Server
Exchange 2003 = Windows 2000 Server
Trying to do a new install, no databases currently exist. Right after I
begin installation, it "quickly" pops up a window saying:
"Setup was unable to install Microsoft CRM Server.
Setup was unable to create the Microsoft CRM databases."
Logged in as domain\admin, can ping the sql box, etc...
...Issue with Discover Card in RMS
Last week we had a problem with the Discover card tender type on the X, Z,
and Discover statement. The scenario is, We had 2 discover transaction on
register 1. One was for $25.68 and the second was for a credit of $64.20.
This would create a difference of $38.52. The X report displayed $38.52 in
the Shift but when the Z report was ran it displayed $38.52 for the close and
$77.04 in the shift. If you do the math $77.04 is double $38.52. We checked
what Discover received from us from the Settle EDC batch and it was $77.04. I
checking into the TenderEntry table for the t...Database 11-25-07
I created a database for an archery tournament and I would like to assign
people to a team and have the scores add together automatically for a
combined total. My problem is some people may be on more than one team and
their individual score needs to be used on multiple teams. Is there a way to
do this? I would need to be able to assign more than one team number to a
"Dave" <firstname.lastname@example.org> wrote in message
>I created a database for an archery tournament and I would like to assign
> people to a te...Odd Webmail issue
When you use a favorites shortcut to our e-mail server spell check does not
work. We get an error that says The spelling in this item cannot be
checked. When you type the webmail address in the browser spellcheck works
find. Does this have something to do with SSL?
...Publisher 03 -how to move parts of brochure to a another brochur.
how do I merge panels of info from one pub. brochure to another
> how do I merge panels of info from one pub. brochure to another
Copy paste from one Publication to another. Line the two publications side
by side vertically on the page.
Microsoft Publisher MVP
Windows Marketplace Moderator
This posting is provided "AS IS" with no warranties, and
confers no rights.
...Another question regarding Dates..
First, thanks to the replies to my previous post.
How can I work out the day & month when I only know the Year and Day Number?
Year = 2004
day number = 302
The answer I'm looking for is 28/10/2004
Again, taking into consideration the leap years
Thanks again in advance
"Anthony Slater" wrote:
> First, thanks to the replies to my previous post.
> How can I work out the day & month when I only know the Year and Day Number?
> Year = 2004
> day number = 302
> The answer I'...To be able to copy the format of the report to another report
Modify two different invoice forms and also two different forms for
HISTORICAL invoice printing. A number of modifications have been done and it
would be very much helpful if there's a way to copy the format of one to
report to another.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree"...rename Exchange 2003 database files?
Exchange 2003 + SP1 on 2-node A/A cluster. We originally created 8
databases, 4 on each node, to balance the number of mailboxes. We named
the databases based on the first letters of the users' last names:
"AthruC", "DthruG", "HthruK", "LthruN", etc. We have now had to move
the "M" and "N" mailboxes to another database to re-balance the number
of mailboxes on each server. We'd like to rename the databases to be
more generic, but haven't found a way to do it. I can't find anything
on the MS Knowledgebase either.
Can an...offline defrag did not reduce STM database size
Exchange 2003 Mailstore archiving all inbound/outbound messages into a custom
Offline defrag reduced EDB size (from 7Gb to 1.8Gb) but STM size stayed the
same at 110Gb. There're only MAPI clients using this store, and no Mac
Entourage clients. Reported from the Store are
MailArchiver 25 items / 287 Kbytes
System Mailbox 402 items / 363 Kbytes
i.e. the target MailArchiver is reported with 287Kbytes, so where is the
discrepancy between this size and 110Gb?
Resetting "Deletion settings" on Limits tab to zero value for both "Keep
deleted items for ...Exchange 2003 SMTP issues
This is a multi-part message in MIME format.
I am having sporadic issue where my Exchange 2003 SP1 server has =
problems sending to certain domains. Event ID 7004 is logged, such as:
This is an SMTP protocol error log for virtual server ID 1, connection =
#231. The remote host "220.127.116.11", responded to the SMTP command "rcpt" =
with "554 <email@example.com>: Relay access denied "
Usually, I ask the sender to retry sen...Database similarity
I need to lookup a value based on a looked up value. Can this be done
in Excel? Example cell contents (range P1:R5) [I hope this is
=0 ="" =""
=IF(Q2=Q1,P1,P1+1)[result is 1] ABC Hello
=IF(Q3=Q2,P2,P2+1)[result is 1] ABC Goodbye
=IF(Q4=Q3,P3,P3+1)[result is 2] XYZ Jump
=IF(Q5=Q4,P4,P4+1)[result is 2] XYZ Sit
Second range (Y1:Y2) also defined name PickListOne
=VLOOKUP(ROW(),$Q$2:$R$5,2,0)[Result is ABC]
=VLOOKUP(ROW(),$Q$2:$R$5,2,0)[Result is XYZ]
a1: Validation Allow=List, =PickListOne [This lets me choose betw...Cleaning up the databases 11-12-09
Hello all you Project Gurus out there... Thank your for taking the time to
read my post, this community is always so helpful!...
I just have a question about manually cleaning up rogue database entries.
What I mean by 'rogue' may be slightly off from the traditional definition...
I've noticed if a user creates a timesheet line and deletes it, data analysis
never loses that timesheet line. DA does not report the line directly, but
if you use the checkboxes from the "Task" field's drop-down list, all the
previously deleted task names still show up. Si...Concern with SQL database size
Since we are only allowed to disable users, business units, teams and etc
from MSCRM database, what will happen to the SQL database size at the end of
the day? Is there any house keeping meachanism to pervent database from
Thanks for helping.
Over time the database will continue to grow as a CRM solution will keep
adding data daily. Over time I expect to see an archive feature but this may
not appear for a few more versions. Becuase if this you should always
specifiy way more data storage than you need for SQL. of course determining
the amount of storage needed is an art in ...