We have a multi-server setup with SQL Server 2005 and GP 10.0 on
How do I go about...
1. creating a new 'test' instance of the production system (on the
2. renaming the production instance.
I know there is a KB (878449) out there that explains how to transfer
and existing GP install to a new server. How do it do it on the same
Any help will be appreciated!
Follow the instructions on KB Article 871973, with one addendium: when you
are naming your company in Dynamics GP Utilities, give it the same name as
the production company with &...Inventory transactions not clearing open tables when posted
I'm seeing a number of inventory adjustment and transfer transactions remain
in the open tables after posting. Any ideas on what could cause that? Is
there any reason that the same transaction should be in IV10000 and IV30200;
or IV10001 and IV30300? Thx.
Are you using single use Inventory batches?
This posting is provided "AS IS" with no warranties and confers no rights.
Do not send e-mail directly to this alias. This alias is for newsgroup
"Jim@TurboChef" <JimTurboChef@discussions....New Hardware
We are in the process of looking at purchasing new hardware and a question
has come up that we are getting conflicting information on
We have a choice of getting Windows 2003 server or SBS 2003. We understand
that SBS 2003 has the functionality of Windows 2003, with additional bells
and whistles. The main question is do we need the SQL server that is
included with SBS or is the SQL server software & lic purchased with GP what
we need? (We are on SQL 2000)
Additional background -- the hardware we are purchasing is a replacement
server for our existing server and we will be migra...Problem with 'New' Reports !?
There are no reports in my Reports Section, and when I try to 'add' them via
the 'New' command (and following the help file directions), I get the
"An error occured while trying to add the report to microsoft CRM. Try
adding the report again. If this problem continues, contact your system
I'm just trying to upload the 'stock' CRM reports to take a look, but nooo.
you can uppload your reporting-server-report by using the report-server ui.
klick on you...Word Hangs on File, Open
My Word 2008 hangs everytime I do a File, Open. It is ok when I do
File, Open Recent or any other menu item. I tried deleting the plist
file in preferences with no luck.
Is there a way to reload Word for Mac?
It is more than annoying because I forget about the issue periodically
and lose open work in Word due to having to force quit the app.
First & Foremost: Do Not reinstall Office. The files & issues that cause
such problems are not a part of the installation & don't get repaired or
replaced by reinstalling. That is a "l...How do I copy a graph to new worksheet and get data from new sheet?
When I copy a worksheet with a graph or just copy a graph and paste in
a new worksheet, the source data is still linked to the original
I've tried editing the sorce data to remove the sheet name to try to
make it relative to the current sheet, but that gives me "Error in
Is there a quick way to get the graph to link to the data in the new
worksheet? Even a macro would help, if that's what it takes.
Thanx in advance...
If the chart is embedded in the worksheet, you should be able to copy the
worksheet elsewhere, and the copied chart will point t...Open files from Access Form
One field of my table contains a link to an attached file. This file may be
a word doc, pdf, or other.
How could get Access to open the file using the appropriate program (ie
Word, Acrobat..etc) automatically when I click a button.
I know how you could specify a particular program, say word, to open a
link... But not sure how I could do a pdf. And how I could get it to
determine default program settings.
Thanks for your help.
On Mon, 30 Apr 2007 19:13:02 -0700, kMan wrote:
> Hello all,
> One field of my table contains a link to an attached file. This file may b...Shortcut to open an excel file
I need to create a shortcut on the desktop to open an excel file in a
folder. The first part of (about 10 characters) the file name is always the
same but the rest is changed each file. Is there any way to create such
shortcut? I tried to use xxxx*.* without success. Your advice is
Are you trying to open multiple workbooks having similar names all at the
Since the file should exist when you create a shortcut to it, why not just
use the actual file name?
"Ray" <Ray282828@Yahoo.com.HK> wrote in message
news:%239y2Y7rqDH...Sorry I am a new user
I need to change the drawing scale on a project. When I place a wall and get
the lenght it usually comes up with over 100' for a 8.5 " X 11" canvas. Can
you tell me how to change the scale to reflect a 40' by 30' area on a 8.5" X
11" canvas. Also can I scale images from stencils. Thank you in advance.
...External IIS smtp server set to send through new exchange server
I have a situation at a client where they have some in house mail programs
that send mail through the SMTP in IIS on the server to an outside pop3
They did all their mail through this pop3 provider and decided to put in a
new mail server.
I set them up on exchange 2003 and then found out afterward about this
application. So I had them change the SMTPVS to send mail every minute and
not 10 min. It eliviated some of the pain.
They are still saying that the mail is stacking up in the queue in the IIS
smtp server. How can I set it up to send the mail out faster? do i need to
c...Importing objects in new db fails partly
I have the following peculiar problem. When I import my database objects
into a new database there are some forms which are not imported complete.
The import completes without errors.
Those 'problem' forms are visible in the database window, and the VBA code
is also present. Only the actual form object is missing. It is not possible
to open the form, even not in the design mode.
When I import those forms again there are no problems and the forms can be
opened without problem.
Exporting the forms from the source database (with an add-in / VBA code)
causes no problem.
I use Acces...Applying Hyperlink in Access Genrated Email
I am trying to apply a hyperlink to an email that is generated out of Access
and sent to Outlook
The message body needs to say something like this:
The Report is now posted on the server:
I need the \\Server\Test to be hyperlinked above
Below is what I have so far
On Error GoTo Err_cmdEmail_Click
Dim StrTemp As String
StrTemp = Format("\\bhihnbwfa01\Groups\HRR_WFA\300_General Employee
Can this be done?
Dim strDocName As String
Dim strEmail As String
Dim strMailSubject As String
Dim strMsg As St...Lost Emails
Stupidly, I was writing a note on top of my keyboard the other day. By the
time I was finished I managed to make my screen look stretched out, lost 15
days of emails, and randomly lose emails even now. Things I sent 5 minutes
ago aren't in the sent folder. Emails I received 5 minutes ago aren't in the
inbox. I can't even find them by searching. Any help?
Contact 'WindowsLive Solution Center' (http://www.windowslivehelp.com)
about the lost emails/msg`s in your windows live id inbox - they will be
able to restore your deleted emails / messages
DrI...Create Lead from Email #2
I have setup a queue to receive incoming emails from leads. I am able to use
a workflow to create a new lead for each incoming email.
The issue that I have encountered is that the data for these leads are
collected by outside vendors and contain additional information. Each vendors
format is consistent. I would like to be able to parse the body of the email
and populate fields in the lead.
I would prefer to do this using CRM but if you know of some good 3rd party
tools please let me know.
We are developing a solution to address our client requirements, reading the
email ...Export all email addresses to file?
I've been tasked with producing a file that contains ALL SMTP addresses in
our organization. I've looked at the ListEmailAddresses.vbs file from Bharat
Suneja (thanks Bharat!), but it keeps failing with the following error:
Needless to say, I do not know VBScript so that error means nothing to me.
Can anyone tell me what the problem may be?
Thanks for the feedback - let me look into it - have used the script for a
few years now, and has been posted on the blog/site for quite long but
haven't come across any...New account with new Domain
Operating System: Mac OS X 10.5 (Leopard)
I am trying to set up a new entourage email account using a new recently purchased domain. I am putting in firstname.lastname@example.org for incoming and out going mails but when i verify details it tells me both are not right. Do I have to have set up the hosting for the website before being able to set up the email account or do I need to set up the email address at somewhere like GMail first and then will I be able to do it???? Any help appreciated.
> This message is in MIME format. Since your mail reader does not understand
this f...Email Accounts #13
How do I make outlook default to a particular email
account (I have 2) when I reply to an email, no matter
where the email came from?
> How do I make outlook default to a particular email
> account (I have 2) when I reply to an email, no matter
> where the email came from?
The default setting of Outlook is to reply to an email using the account to
which it was sent. You cannot change this default setting (AFAIK), but you
can change the account used to reply when in the reply screen.
...New to Excel
Hey all, I'm sorta new to excel, and I was trying to create a drop down
list box. So i made the cells with the data in them I want, and I put
a background color on them., when I actualy create the drop down in the
cell, I have the words appear, but not the color, can anyone tell me if
there is a way to keep the cell formating.
klick_'s Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34714
View this thread: http://www.excelforum.com/showthread.php?threadid=544798
The...SQL server full text indexing, ranking and joining to other tables
i searched the net about sql server full text indexing and ranking and got
this sample sql statement and it works using 1 table only:
SELECT myTable1.id, myTable1.Title, fulltextSearch.Rank
FreeTextTable(myTable1, [myField1], 'awesome ranking') fulltextSearch
myTable1.id = fulltextSearch.[KEY]
ORDER BY Rank DESC
what i do not know is how to make it to work when it is joined to another
table. how do i do that if i have these sample tables?
I don't see sample tables, merely one...new
Hey !!! I just be a new guy .
SO AM I
"ocean" <email@example.com> wrote in message
> Hey !!! I just be a new guy .
...Outlook XP (2002) Fails to check for new mail when started
Client PC XP SP2 with Office 2002 SBE SP2.
When launching Outlook the user must perform a "Send/Receive" as the
client does not check for mail when first started.
However, automatic check will occur as configured and does check every
two (2) minutes.
None of [my] Google searches have turned up with any remedies.
Thanks in advance.
M <firstname.lastname@example.org> wrote:
> Client PC XP SP2 with Office 2002 SBE SP2.
> When launching Outlook the user must perform a "Send/Receive" as the
> client does not check for mail when firs...New essay: threads in console apps
In my attempts to alleviate klostiphobia (the morbid fear of threads), I've added a new
essay, based on one of the questions that came up earlier in this newsgroup. It shows how
to do a non-polling solution to the problem of getting data from multiple pipes in a
console-based app, by using threads to handle the synchronous I/O.
Joseph M. Newcomer [MVP]
MVP Tips: http://www.flounder.com/mvp_tips.htm
Good essay, Joe.
"Joseph M. Newcomer" <email@example.com> ...email with attachment.
i have a problem receiving email with attachment from a
user using outlook express. i am using outlook 2k. when
i receive the message, the attachment seems to be embedded
into the message and is illegible.
...match . (dot) to include new lines
how can i get the . to include new lines as well?
i tried something like this [.`n`r]* but it doesnt seem very happy with
basically i have a file as a string and i need to pull two parts out of it
with it scanning through new lines.
Can you share your code?
Justin Rich wrote:
> how can i get the . to include new lines as well?
> i tried something like this [.`n`r]* but it doesnt seem very happy with
> basically i have a file as a string and i need to pull two parts out of
> it with it scanning through new lines....New record being added
When I am going thru my records in a form, I get to the end of the
records(the last record) and usually it would have a blank primary key. But
not anymore, it creates a new number since the primary key is AutoNumber. I
created a VB procedure in the On Current property, would that be the reason?
How can I avoid this? Is there a way to stop the user to going to the New
Thanks for your response. The code was actually populating a field which was
making the autonumber react. I took that off and now it is ok.
> What is the code in your On...