PM payment stuck and applied
We had a glitch and a maunal payment in PAyables was unposted and showing as
applied. We corrected the problem by changing the CURTRXAMT and entering a
Now I am showing a credit on the account for the same amount as the glitched
invoices because it is still showing as unapplied and unposted - I have
deleted all the temporary tables - ie: PM10000/10400/10801/10300 and it is
still showing on my payables as
Voucher/ Doc Number type Doc AMount
xxxxx 36372 INV 79.00
*xxxxx PMT (79.00)
xxxxx ...Email trouble with New User in Active Directory
Below is a trail of posts that have been made. My
problem has yet to resolved and I need some help
quickly. The only other thing I can think of is to
reinstall Exchange Server 2003. Hopefully someone will
know the answer.
Subject: Re: Email not Setup when new user created in
From: "Bryan Hill" <firstname.lastname@example.org> Sent:
8/15/2004 12:30:21 PM
We have other clients that are working fine. Just when
we try to set up new ones - it will create the SMTP
address but not the X400 address. I tried manually
forcing the X400 but it will...Adding to data to a list
I want to make log, ie add blocks of data to main block. So far i have
very crude method of moving the main block down a few spaces, the
copying the new data to the top. then again when theres more. this i
no way perect.
I would like the be able to copy the new data to the bottom of the lis
via some incremental method, but i cant find one.
Any suggestions welcomed
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
untested but try assigning to a button or worksheet ...Data analysis data from a survey
I need to analysis data from a survey that was recently carried out. Does
anyone know how I could do this and keep a trail of the answers recd from
If you provide some details about the survey structure, and how you're
collecting the results, and what you want to analyze, someone may be
able to help you.
> I need to analysis data from a survey that was recently carried out. Does
> anyone know how I could do this and keep a trail of the answers recd from
> same persons
Excel FAQ, Tips & Book List
http://www.contextur...Registry keys to set HTML format
I am looking for the correct registry key to set the mail
format to HTML and disable word as the editor, on a
Reg <email@example.com> wrote:
> I am looking for the correct registry key to set the mail
> format to HTML and disable word as the editor, on a
> permanent basis
In Outlook, click Tools>Options>Mail Format to set the mail format to HTML
and disable word as the editor.
It's best to use t...set paste option automatically
I'm trying to do a simple copy (ctrl-c) from Word and paste it into an Excel
cell with ctrl-v. Now the 'paste option' button comes up each time and I
have to select 'match destination format' each time. If I turn off paste
options, then the cell contents remains blank. Help!
...Trouble with the template.
I want to reset the 'normal' template to default to "Times
New Roman" 10point font, and the pages numbered centre top.
This seems to work when I set and reopen Word2003 from the
Administrator Template vis:
C:\Documents and Settings\Administrator\Application
But it will not work when I open Word2003 normally from the
I have deleted the "Normal.dot" from the following and
copied in the "Normal.dot" from the Administrator above:
C:\Documents and Settings\All Users\Application
Data\Microsoft\Templates...field data missing
My "user definded fields" are missing information! All of
my Fields are there but the information I put in the
fields is not. The information that I have put in these
fields is very small (sort text stuff).
Q: Could some switch/filter not be showing the
Q: How do a get back an older version of my .pst file
(that I have not automatically backuped). Will "system
Restore" help with data files?
...repeating a data pattern in excel
Im using excel to run a class register for a playgroup. Each pupil is booked
in for a number of days per week. To show their forecast for the year, I'm
manually entering the days they're going to be present each week - is there a
way to do this automatically?
For example, Ben is booked in for Mondays, Wednesday and Fridays - how can I
copy this weekly pattern throughout the year without manually tabbing across
and ticking the relevant days?
Hi, Kel. To do this manually, but easily, type the first 3 "sets". Select
them all and copy down using the fill handle. You coul...trouble with CrmIsapi.dll
I was experiencing the same problem with the SDK as many have posted
to this group ...
"the WhoAmI() call results in a http error 405 when running sample
I followed some of the advice; checked my .srf mapping to CrmIsapi.dll
and re-registered the CrmIsapi.dll.
when I re-register CrmIsapi.dll I get an error 80004005 - unspecified.
I copied it to various places and retried it ... same result.
I got the original from the disk and retried ... same result.
unmapped it from .srf, restarted and retried to register it ... same
Anyone experienced this.
What's up with m...Cash Receipts Apply to
Using IM to import cash receipts. The apply to exceeded the receipt amount
and it was posted - is there a way to unapply part of this?
If I go to the apply to window and try to unapply I receive an error. If I
try to apply anything else for this customer I receive another error.
...unexpected conversion trouble
I wanted to open an Excel file I hadn't been working on for a while, an
Excel couldn't do it.
After some investigations, I found that even if the file still had th
.xls extension, it seemed to be conveted in .doc format (in fact, whe
I open it in notepad, I can see at the end some words that look like
MSWord signature). I don't know how this happened, but I'm reall
embarassed beacause i really need the data in this file.
I tried to change the extension to .doc, open the file in Word and the
import in Excel, but I can hardly see part of the file. What's more, i
is a 3-she...Trouble with Outlook 2003 and PST File
We have a user who is using Outlook 2003 and moves most emails to a PST file
which is considered archived email data.
They have reached the Max limited on this PST file of 1.99GBs and its not
letting them open the PST file.
It is trying to repair it when they try to open the PST file.
Here is the message they receive:
"Can't move the items. The file <path>\<filename>.pst has reached its
maximum size. To reduce the amount of data in this file, select some items
that you no longer need, and then permanently delete them."
I can't even get it open to delete...Show summerised data
I'm using vb.net 2005. I have an app with a Form containing a Tab control
with 5 pages. 1 page records time booked to a particular job using a
DataGridView control. All works OK. The question, how do I place on the same
Tab as the DataGridView a summary of hours recorded.
I have a Group By query with a Sum function that summerises the hours by
job category in the Hours TableAdaptor. Its being able to display query
results on the Tab that I can't do. Guidance most welcome.
...Trouble with Pivot Tables & Named Ranges
Can I use a dynamic named range setup in one file as a range in pivot tables
in another file?
When I have the data source file (with the named range) and the pivot report
files open, the pivot reports update just fine. But the moment I close the
source data, the pivot reports no longer can update and I get a message that
the source can't be found. If I reopen the source, the pivot tables work
fine again - but as soon as I close it up, the reports no longer work.
The source file is very large and I don't want to open it every time I have
to update all the reports tha...I am in trouble
I am a student in Cambodia.I don't have any girlfriend. I tried everything.
I looked at them wrote poem to them it doesnt work. I got an account from
facebook, hi5 friendster myspace. I have 0 girl friend. What should I do? I
am so desperate. I am good looking and 250 kg only. Please help me or at
least send me some foood I am hungry
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __________
The message was checked by ESET NOD32 Antivirus.
You're tr...How do i set up certain message rules using outlook 2003
Just moved from Outlook Express to Microsoft Outlook 2003. However i cant
work out how to make certain message rules.
I'm using three email addresses and trying to create the following rule but
cant work out how to do it. Heres the rule.
Where the To line contains 'firstname.lastname@example.org'
Move it to the "Info" folder
Would really appreciate some help here!!
> Just moved from Outlook Express to Microsoft Outlook 2003. However i
> cant work out how to make certain message rules.
> I'm using three email addresses and t...Re-set picture property for each continuous form
I'm sure this will have been asked before:
I need to change the picture property of an image control on each generation
of a continuous form. Basically, I am creating a list, each row of which is
one generation of a continuous form, and want an icon alongside each row
which relates to the content of the row.
Unlike reports, there is no OnFormat event for the detail section of a form.
I need to use a form and not a report as I want interactivity - effectively
One of many solutions. I would keep your images tiny as this will be a
performance hit on a contin...Format of data import from a database
I have a spreadsheet that has data imported from SQL Server or even MS
Access that has dollar amount fields. The field is coming over as a text
field and even if I format the cells as currency it won't apply the
formatting until I actually double click in the cell and press enter.
Is there a way to fix this for the entire spreadsheet so I don't have to
click in each cell to force the formatting to work? This spreadsheet as
over 1500 rows of data. I get this every time I export data from either SQL
Server 2000 or Microsoft Access Database.
Any help or information is greatly apprecia...How to retrieve real data type of function's parameters
I have a function which accepts some parameters. When I call this function,
I used some casting operation and In this function I want to get the real
data type name of these parameters. Can I do it? If I can, how should I do?
Please help me.
If you are looking for something like .NET reflection, you won't find an
identical equivalent. But look up "Run-Time Type Information" and "Accessing
Run-Time Class Information" on MSDN.
Nish [VC++ MVP]
"Nguyen Van Binh" <binhnv@...linking column data in sheets to a summary sheet
I have four sheets, each with a column of data.
I want to link the informtion in each of these sheet
columns to a corresponding column in the summary sheet.
Using copy and special paste with link I can link each
cell in the column individually to the corresponding
summary sheet cell.
I can not figure out a way to do it with the entire column.
Any suggestions. I have Excell 97.
"mhsacks" <email@example.com> wrote in message
> I have four sheets, each with a column of data.
> I want to link the informtion in ...Loop to cleanup data
I have a spreadsheet that is a dump from a survey. Problem is,
sometimes the dump puts data that should be in one row on two. I need
to write a macro that will see there is a second row, and if there is,
move it up one row. It's easy to identify which rows need to get moved,
because the data starts in column D rather than A. Problem is, I'm not
good with syntax as you can see. I need the column name to stay the
same, but increment which row I am on. I want i and p to keep track of
that so that when I say Ci it equals C3 if in row 3, C4 if in row 4,
etc. Excel reads it though as co...How to set up filter for related entity in a lookup
We have customized the Account entity to include 1:N relationships
with Employees. How can we make sure, on the Service Case form, when
we look up an Account, that, when we subsequently do a look up on
Employees, it filters just to the Employees of that Account?
Daniel Johnson, Jr.
Paste this onload of the entity that has the look up for employess.
Replace "field" with the name of the employee lookup id.
if (crmForm.FormType == 2 && crmForm.ObjectId != null)
var name = crmForm.all.name.DataValue;
crmForm.all.field.additionalparams = 's...How to set modeless dialog styles programmatically
Trying a simple(?) experiment with modifying styles of
dialogs. This fails to add the resizing border to the
Thanks in advance for your time.
IDD_DIALOG1 DIALOG DISCARDABLE 0, 0, 186, 95
STYLE DS_MODALFRAME | WS_POPUP | WS_CAPTION | WS_SYSMENU
FONT 8, "MS Sans Serif"
int CTestDlg::OnCreate(LPCREATESTRUCT lpCreateStruct)
// style == 0x80c800c4 here
lpCreateStruct->style |= WS_THICKFRAME;
// style == 0x80cc0...Missing public data store
I've recently taken over the sys admin duties for a customer site. After
looking through the event logs I discovered that the Exchange 2003 public
data store would not mount because the store itself was missing. When I
looked at the backups I found that inadequate backup processes were in place
and there was no backup for me to use. I fixed the backup problem. Now,
I've googled time after time looking for a way to regenerate the public
folder without success.
Does anyone have a pointer to a process for regenerating the missing public
store and all it's system folders?