Payment date issues
Is there a way to avoid the irritation of Money 2005 refusing to make
an electronic payment because it thinks there is not enough time to
make the payment deadline specified in a recurring payment? Having to
edit the occurrence is a real pain in the xxxx.
Pls reply to mail address. Thanks.
Money gets this information from the financial institution making the
payment -- so perhaps they can help you with the deadlines.
<firstname.lastname@example.org> wrote in message
> Is there a way to avoid the irritati...change x axis date scale on multiple charts quarterly
Have multiple charts to update weekly during a calendar quarter, need to
change the x axis date scale on every chart quarterly.
Can the x axis date range be changed on multiple charts simultaneously ?
If your x axis range comes from a series on your spreadsheet, changing the
values in the spreadsheet will change all the charts which use that series
to define the x axis.
> Have multiple charts to update weekly during a calendar quarter, need
> to change the x axis date scale on every chart quarterly.
> Can the x axis date range be changed on multiple...Outlook 2000 Import addresses
I am trying to import a group of addresses into Outlook
I can see the import / export options on the menu but
they are not available.
The file I want to import is in a .csv format, but that
wont help me if I cant get the import option started.
Maureen <email@example.com> wrote:
> I am trying to import a group of addresses into Outlook
> I can see the import / export options on the menu but
> they are not available.
> The file I want to import is in a .csv format, but that
> wont help me if I cant get the import option started....Fixed Assets Import (6 months ago)
It really is a moot point. The situation is over, my clients are happy, and
I am able to import fixed assets just fine.
But, six months ago and right before service pack 1 for GP 9.0 was released,
for the first time ever I was unable to import fixed assets.
The FA Import Tool would show--on the "surface"--that all of my assets
imported. But, the fact of the matter was that the assets did NOT import.
And, there were no error messages givens to why!
I had opened up a case with Microsoft, at that time. They admitted that
they could not solve the mystery. And, they s...math question
Is there a way that I can force values in a table to be divisible by
12? This might be a simple question but it's more than I can figure
out. Any help is much appreciated!!!
Use Data/Validation - with Custom option. Select your column (say, H) and
Hope this helps.
<firstname.lastname@example.org> wrote in message
> Is there a way that I can force values in a table to be divisible by
> 12? This might be a simple question but it's more than I can figure
> out. Any help is muc...import store 2.0 to hq failing
After upgrading store ops from 1.2 to 2.0 (no problems) we are trying to
implement hq 2.0 by bringing in the biggest store db through the hd admin.
However, it fails on an invalid column category. Any ideas?
We are thinking of implementing MS' Pt of Sales. But have a couple of
1. Can we link specific items to GL codes (Revenue)?
2. How hard is it to extract data from it so we can import it to MS Great
Plains at the end of each day?
...Fill date series in table
I have an attendance sheet that 1 day per week. I want to extend a series
across the top row. (I.E. Jan 1, Jan 8, Jan 15, Jan 22, etc.). The sheets are
formatted as tables. When I grab the handle to copy the cells it will only
copy, not fill the series.
How can I get a weekly series?
In A1 enter:
In B1 enter:
=A1+7 and copy across
Gary''s Student - gsnu200909
If you put Jan 1 in the first cell, Jan 8 in cell next to it and then select
**both** of these cells... you can now copy this selection across the row
and the series will fill in automatically for...Design Question #2
I am currently tasked at writing the code for an app that will have a lot of
owner drawn buttons in it. There are two ways I figured I could go about
a)Just use multiple dialogs for all the buttons and options and have them
popping up then closing and more popping up.... this seems like an
unacceptable method based on user interaction confusion and that it would
just look sloppy.
b) One giant dialog that handled all of the subcatagory buttons and then
center it in the middle of the screen and call it a day. I guess it could
be done, but again would kind of seem unprofes...CDialog Simple Question
Please provide simple example how to create CDialog instance from code
and add one button on it.
Thanks for posting in the group;
You can test the following code to create a pure CDialog dialog and a
CButton button dynamically:
CDialog* pDlg; //define them globally, and don't forget to delete
pDlg = new CDialog(); //somewhere in your program
pDlg->Create(CAboutDlg::IDD); //use the About dialog's template
p...import from express is missing 90% of messages
I'm trying to move to outlook 2003 from express 6, and no matter
which way i try to move the mail messages (from express -> 2003 or
pull into 2003 from express) its only grabbing 60ish messages of
1726 total. They range from may to july of this year when the
whole file has mail from today back to sometime in 2000.
Anyone know any other way I can migrate mail from express into
thats the correct way, export OE > OL, are the msgs in seperate identities
"Holden" <email@example.com> wrote in message
Hi, when I use the insert feature to insert more rows in my
spreadsheet, I can only do one row at a time. Is there a way to
insert, say 5, or 10 rows at a time?
First select 5 or 10 rows, then use the insert. It will insert as many rows
as you select.
"spilparc" <firstname.lastname@example.org> wrote in message
> Hi, when I use the insert feature to insert more rows in my
> spreadsheet, I can only do one row at a time. Is there a way to
> insert, say 5, ...Auto Archive Question
I wondered if there is a way to allow auto archive to archive old messages
that are already read and not flag for follow up?
As far as I know, no. Auto-archiving just checks the age of the message
based on the modification date
"Gus T" <email@example.com> wrote in message
> I wondered if there is a way to allow auto archive to archive old messages
> that are already read and not flag for follow up?
...miscellaneous payroll questions
Upon having to enter a reason for changing an employee's position or
changing the employee's salary, you can only enter one reason a day. In
other words, if you try to enter a second reason for him or her in the same
day, Great Plains HR will not allow you to. It says that you can only enter
one reason for that day. So, you have to change the date in the reason box
in order to enter a reason.
Is there a way to "fix" this? It's disappointing to a client.
Speaking of this client, she says that Great Plains was forcing her to fill
in all of the five org...Workflow Process Questions
Can anyone who has worked with workflow processes for a while answer these
questions for me:
1. How do I implement an "OR" condition? I have used nested IFs but is
there a better way?
2. Is there any way to print out or otherwise create a copy of your work
3. How do you backup/restore workflow rules for disaster recovery?
not being able to printout a workflow is a pain..especially a sales process.
It may be possible to do this either using the sdk or crystal reports. CRM
1.2 has a export tool for workflows. I cannot remember whether it is on t...Need to change date in field to whatever I want
I have a database for my research. I need to change the date, so that I do
not have any restraints on my admissions. I have checked the data field for
date of admission and it looks exactly the same in the data field, but for
some reason, the date will not allow me to move forward with 2010. I am not
sure what to do. Can you please help. This seems to be the only field that
does not change to what I need it to change to. I currently am able to use
the date for 2010. in other date fields except for one field. Please any
suggestions. I am very new in setting or using access.
...Import data from the web
I am trying to import large amounts of data from the web
onto a spreadsheet. After about 200 updates, I start
getting an error message that indicates the site and then
informs me that "the connection to this internet site took
longer than the allotted time". I assume this is because
I am hitting the site too many times in a few minutes. IS
there any way to fix this? Can I put some sort of spacing
line into the spreadsheet so that it gives the site a
take a look at ENBLEEVENTS
Granite Shoals, TX
"mi...Importing MYSQL databases into CRM 3.0
Our website portal - an ecommerce store that offers consumer electronics
are built on a MYSQL database.
We will like to import our Website customer database into CRM 3.0 on a daily
1) When customers email us, we can check the history of its purchases
(mapped to email address), time of purchases, date of shipment with a click
of a button.
Is this possible with Microsoft CRM 3.0; if so, is it a easy task that can
be dealt with on a daily basis or can be scheduled and automated?
Only possible by either buying a 3rd party solution like those from
...Question about file location
Hello again everyone,
I'm developing an application that depends on an external data file. I've
created a new folder within the project and then added the data file to it.
I called the folder resources.
Now, I'm trying to create a StreamReader to use the file. This is the code
Dim reader as New
Catch ex As Exception
MsgBox("Could not open file")
Now, you would think that this would work, right (maybe...importing a large word document into Publisher XP
I am having a horrible time trying to figure out how to import a 24 page word
document into a booklet format. I have been trying for two days to no avail.
Please help me, this really shouldn't be this difficult!
On your booklet's first page arrange the margins, create a text box to fit
within your margin, with the text box selected, right-click, click change text,
text file, browse to your Word file. Publisher will automatically create text
boxes and pages.
Mary Sauer MSFT MVP
"theworkin...Average time from date time column?
I have a column that is in general date format, 6/19/2007 5:34:23 PM.
In another column I have a value between 10 and around 50. What I have to do
is get the average of this number by time in a day.
So if the number is 10 all day, then the average is 10. If the number is
changed during the day, say its 5 for half the day then 10 for the other half
of the day, then the number I'm looking for is 7.5.
If the number is 5 for 1/4 of the day and 10 for the other 3/4 of the day
then the number would be around 8.5..... if you follow what I'm trying to say.
So far I have been a...Automating emails and importance / color
I have a program that sends out automatic emails to company personnel
use OLE. My basic code looks like this:
m = new OLEAutoClient("Outlook.Application")
item = m.CreateItem(0)
item.to = 'John.smith
item.subject = database field
item.body = 'Reminder'
I would really like to adjust the subject color to red or to set a flag
based on importance. Please describe what item.commands are needed for
me to accomplish this. Example code would be most welcome.
Set a flag using the FlagDueB...Importing from access to outlook
Since upgrading, i've found that i'm unable to complete a
successsful import into outlook. I bring the data in
through access and import it to outlook. I never had
these problems before...
I've also heard that with 2003 you can link access and
outlook - bu can't find a details on this.
...import .QIF-file with category information
I'm trying to import a QIF-file with transaction-information. The
import completes succesfully, but I cannot find any category
information. Does anyone knows a solution ?
...IF and THEN question
I have a spreadsheet where a certain column display what is to be done
with the information. For example:
A B C D
123 456 789 DELETE
987 654 321 ADD
What I'd like to do in column E is to make a formula that says:
If D1 equals DELETE, then put the value DEL in E1
If D1 had been ADD, then I would want the value PUT in E1
Does this make any sense?
Thanks for any help!
Message posted from http://www.ExcelForum.com/
put the following in E1: