Automatic Appling AR documents
- I'm looking for a routine that can be scheduled to run through all
unapplied payments and auto-apply them for all customers within a GP10
Company. Any/all assistance is appreciated.
I believe the Microsoft Professional Services team has a tool for sale that
will do this. Your GP Partner should be able to help you with details and
pricing on this.
Dynamics GP MVP
Want to use Crystal Reports with GP?
"JColesby" <firstname.lastname@example.org>...Outlook 2000 #176
Customize Outlook Today Button not responding. Any ideas?
"JMARA" <email@example.com> wrote in message
> Customize Outlook Today Button not responding. Any ideas?
www.google.com - you'll find THOUSANDS of hits about this.
...Attach Rows with Row Data
I am trying to sort by Data/Time in a Column, but if I sort by Date/Time,
Just that changes, the other columns don't change with it.
How can I either LOCK or ATTACH the Rpw data together so when I sort,
Everything changes, not just the Date/Time?
just select the entire data range (all columns) prior to sorting your
"Admiral_Kirk_1" <Admiral_Kirk_1@discussions.microsoft.com> schrieb im
> I am trying to sort by Data/Time in a ...create a roster
How can you create a weekly roster in which functions can be assigned to more
than 10 people. The roster should be updatable, so that when holidays and
days off are marked on the weekly roster they will be taken account of it
...Generating a document from Opportunity
Opportunities for us are the center of the sales cycle. What is the "best
practices" solution to create a document that is launched from an Opportunity
that pulls in the relevant data of the Company name and address, and stock
and custom Opportunity fields?
In a perfect world it would automatically post an activity in the Opp's
history and attach the said merged document to that activity.
Any thoughts or direction, much appreciated.
I have the same question.
I actually wonder what are the "best practices" for creating a document from
a...importing or creating reference footnotes
I am trying to import a word document into publisher and it has reference footnotes within the document. The reference footnotes are not coming into the publisher document with the reference footnotes.
Correct, they will not up to Publisher 2003.
In Publisher 2003 depending on which version of Word you are using if they
will or not.
"If you don't know where you are going,
any road will take you there!"
...Inserting rows with Data, Formula's and Validation
I posted this twice earlier today, but it hasn't appeared so if it triple
post please forgive!
I have a spreadsheet that starting at row 18 contains the following
B18= Datavalidation indirect ($M$2)
E18=IF(ISERROR(VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info"))...Mailbox not created when AD account created
A couple of days ago I noticed that I created a user account but the 'Email
Addresses' tab of the user properies did not list any email addresses.
Subsequent new user accounts have all experienced the same. I researched the
knowledge and tried the recommended solutions to either manaully start the
recipient update service or rebuild te recipient update service. Neither
recommendation has resulted in a mailbox being created for this particular
user or any additional user that I have created since this error first showed
I performed a Windows update last Thursday and so I bel...VLookup in other document
Here is my problem. Please help
I have two documents A and B.
In document A I have a table existing of codes and descriptions
Range A1: B100 Column A contains codes, Column B contains
In document B I want to lookup the description for a given code.
I have a cell C10 containing the code and a cell C11 containing a
Till so far it works !!
But I use this formula many times in my excel sheet and in many Excel
documents, so if Ithe lokation of document A changes, I have to change
all the for...Exchange 2000/2003 Public Folder item Permissions Problem
I've been having an issue with Public Folder permissions for some time now. The folder contains contacts for all company employees (most of which aren't on the company network), and is maintained by HR. Brief history is:
Had Exchange 2000 on Win Server 2000, and a previous administrator modified public folder permissions on the M drive in explorer (a no-no). This resulted in the ESM "Invalid window handle" error.
Managed fix these by following KB 270905 (permissions nuke), and deleting and re-creating the public folder. The latter was a problem, as most users were ...Task Create - Status
I'm trying to make a simple task, when a user owner is assigned a task in
CRM, it receives an email letting it know it has one. I have the following
below, but it is not generating one when i assign one manually in the CRM.
What to do?
I've tried both the following:
When task is created
E-Mail to:[owner];Subject test
As well as:
When task is created
Task activity status = Open
E-Mail to:[owner];Subject test
I've checked the mailserver many times over, and I can send emails manually
from the CRM so you can rule that out
Tested out ok on our end.
Some ideas:...ms ACCESS 97 error 2645
The error occurs at:
Option Compare Database
Function CalcRate(frm As Form)
Dim Mydb As Database, Myset As Recordset, Cd As String, Intrp As
Dim IRR As Currency, IAHR As Currency, ITR As Currency, Strcriteriaint
Set Mydb = CurrentDb
Set Myset = Mydb.OpenRecordset("LangRate", DB_OPEN_DYNASET)
>>>>> Cd = frm.Lang_C <<<<<<<<<
The exact error is :
Run-Time Error 2465
Application-defined or object-defined error
See whether using
Cd = frm!Lang_C
is any better.
Doug Steele, Microsoft Access MVP
http:...Help Creating XmlNode / XmlAttribute Elegantly
I am creating a configuration class to read / write a standard configuration file.
<?xml version="1.0" encoding="utf-8"?>
<add key="ConnectionString" value="server=(local);" />
I am using a XmlDocument for my base implementation.
I am looking to see if there is a better way to add a new node / attribute than using
XmlDocument.InnerXml. I would consider this to be a hack but couldn't really see another
way of doing this without definin...ALT-TAB not working with excel 2000
My problem is, as in the subject, that pressing ALT-TAB to switch among
the files opened in Excel 2000 doesn't work anymore. I tried to
re-install withouth success. I can only use CTRL-TAB because you haven't
multiple sessions running (as usual in Excel 2000) but only one task
of Excel. So, it's impossible to use ALT-TAB.
Unfortunately, CTRL-TAB isn't useful as ALT-TAB because you can't switch
from the current worksheet and the last used but you have to pass
cyclicly through the files opened...
It seems to be related to the fact that the same worksheets had been
opened...Convert two separate Word documents into one
Anybody know how to merge/convert two separate (one page) Word document into
one (two page) document?
CAOWEN <CAOWEN@discussions.microsoft.com> typed:
> Anybody know how to merge/convert two separate (one page) Word
> document into one (two page) document?
Open one of them. PUt the cursor at the very bottom (CTRL-END keys works
well for that). Click Insert File. Save the resulting combined file to a NEW
NAME to avoid losing either of the two originals.
...Create external database
I need to create an external database (file). On a site I found this code:
Function CreateLinkedExternalTable(strTargetDB As String, strProviderString
As String, strSourceTbl As String, strLinkTblName As String) As String
'strTargetDB = Source Database Name
'strProviderString = Not used, currently hard coded
'strSourceTbl = Source Table name in the database we are linking too.
'strLinkTblName = Table name we would like to see in the Access Database.
Dim catDB As ADOX.Catalog
Dim tblLink As...Access Denied error while edit some of the GPOs in Windows 2003 AD
We are unable to edit some of the GPOs (Default Domain Policy, etc) and
getting Access Denied error. We checked the permission of SYSVOL folder and
found Administrators (Domain), System and Authenticated Users have full
control share permissions. Full access has been provided to Administrators,
creator owner & System and read & execute permission has been provided to
Authenticated users in Security tab.
Can anyone help me to resolve the issue and also any doc is available to
check the correct permissions with SYSVOL.
Thanks in advance for help
-...How to enter a colour in a cell & not data ?
I have a sheet where i have a combo box function on various cells. In these
cells there values, 60, 601. These represent in house functions. I want to
input this data into another part of the sheet
61=blue and so on
Within the combo box i want the data as well as its colour but i only want
the colour to used elsewhere on the sheet.
...Accesing an Access Databse from Excel
Please, how can I access an Access database through ODBC from VBA.
Where an I find the documentation needed.
First, you don't necessarily need to use VBA to bring data into Excel from a
database, whether from Access or another DBMS. Two easy ways are to use a
pivot table (Data, PivotTable and PivotChart Report, and specify External
Data Source in the wizard's first step; then, follow the prompts), or Data |
Import External Data | New Database Query. Some of these menu items will
differ according to the version of Excel you're using.
The pivot t...Getting data from Several Work Books
After some advis here,
I have several workbooks all with different names but in the same
In each of the above I want to get out the value for say A2.
And put it in a totals.xls in the same directory.
I started to do it and I got this as my value ..
='[Excel1.xls]Expense Report'!$R$20 <-------- This returned the
When i opened the document again it asked if i wanted to "update" the
workboog ... whick i did want to have the updated info, the pro...How to create pie chart with %
I have got a problem that I don't if excel could help me to calculate the %
within a column and draw a pie chart.
My case is I have a column containing a series of numbers. e.g.
I want to draw a pie chart that showing 1-3 , 4-6, 7-9, >9 with the
corresponding % inside that column.
Can anyone tell me how can I make it ?
You need to calculate the frequencies in your data.
Let's assume your data is in A1:A12. In B1:B3 enter these numbers, the
upper limits on the groupings:
You can enter ">9" into B4 witho...How can I use strikethrough in a Publisher 2007 document?
I want to use strikethrough on some text within a textbox in a Publisher 2007
document, but I cannot find that option under formatting font. Under the Edit
tab, I see "Edit Story Using Microsoft Word" and this takes me to a screen
where I can get at the MSWord strikethrough formatting, but when I close that
window, the strikethrough disappears.
The only way to have strikethrough in Publisher is to select the line tool
and draw a line through the text.
"JoAnn" <JoAnn@discussions.microsoft.com> wrote in message
news:49640...Outlook 2000 Inbox not displaying contents.
I run Outlook 2000 on XP Home.
I get a message "Unable to display the
folder. Errors have been detected in the file
C:\Documents and Settings......\outlook.pst. Quit all
mail enabled applications and then use the inbox repair
When I run the inbox repair tool it goes through to phase
7 or 8 and then says I need to run SCANDISK.
I have run the disk checker tool and also ran CHKDSK
after a re-boot.
I ca copy the contents to another folder and view them
fine, just can't view the default Inbox.
Could I delete Outlook, re-install and correct my problem?
Is there an ...Newbie: Return a xml-document to client
I have a webservice that generates a xmldocument when you call it either
from a .aspx-site or with http-GET.
I now want to present this xmldocument for the user i his/her webclient (eg
Internet Explorer). I cannot return the xml-document as a dataset since
The same table (ContactAddress) cannot be the child table in two nested
A problem with the datasets. Hence my xmldocument isn�t compatible with a
My question is how i should solve this problem. I can retur...Stagnant cell for counting filtered data
I want to keep one cell that houses the count of the data depending on how it
is filtered and that cell remain visible despite how it is filtered. I can't
get the formula =COUNT(C9,C1:C100) to work or get it to stay visible if I
change the filter.
Place the formula in row 1 that contains your titles...........assuming you
=SUBTOTAL(2,C2:C100) the 2, means count
If you don't have titles in row 1, place the formula after a blank row below
Note: you use COUNT in your original. COUNT only counts numerics.
Maybe you want COUNTA which would be =SUBTOT...