Need to convert 2002 back t0 while laptop is fixed
My laptop with Money 2002 died and had to be sent in for
service which will probably be about a month. The good
news is that I backup up all my data files the day before
and burned them to CD. My office machine is running
Windows 98 SE and Money 2001 but it will not read the
2002 files. I can't install XP because the machine will
not support it.
I used a friend's machine and can open my backup file but
I don't want to leave my financial data there. Is there
some way I can transfer the data to Excel or save it in a
backwardly compatible format? I tried to synchronis...customizing spell check
Anyone know how to set spell check so it DOESN'T check spelling in the supject?
I reply with the same subject, which often contains email names & user ID &
spell check picks them up as misspelled.
Not an option.
Mike - http://TechHelp.Santovec.us
"dialfred" <email@example.com> wrote in message
> Anyone know how to set spell check so it DOESN'T check spelling in the
> I reply with the same subject, which often contains email names & us...How do I fix this?
I used the Startup tool to setup my application but I unchecked the Menu Bar
and the Shortcut Menu Bar checkboxes. I need to make some changes but I can't
get the Tool menu back.
Hold down the Shift key when you open your database.
"Ayo" <Ayo@discussions.microsoft.com> wrote in message
>I used the Startup tool to setup my application but I unchecked the Menu
> and the Shortcut Menu Bar checkboxes. I need to make some changes but I
> get the Tool menu ba...IM - Payables
We have recently upgrade a customer from 7.5 to 9.0.
They have a number of integrations that take invoices from a front end
system into GP. The data to be integrated is on SQL tables and the
transactions to be integrated are conntrolled by various SQL views and
There appears to be issues with the payables side - the sales is fine.
When the transactions are previewed -the header information is correct but
the distributions are in random order. When the integration is run - the
distributions are incorrect - can be one-sided or even missing. When a
restriction is placed on the...How to add keyboard shortcut to macro un add-in ?
How to add keyboard shortcut to macro un add-in ?
I just have a function and I save it as excel addin.
and copied it to addin folder.
I want to execute the macro with a keyboard shortcut for example ctrl-r
preferablely I want to list the macros and select because later on I
make other macros.
two cases, I need
Thanks in advance.
You can't execute a function with a keyboard shortcut - you must call
it from another macro or from a worksheet formula like:
in which case it will return the result to that cell.
Hope this helps.
On Apr 7, 3:26=A0pm, "...opening a filedialog window
i am trying to get a commandbutton_click to open a filedialog box for
maybe a filedialog box is not what i think it is.
and should show all the files in that folder?
Thanks in advance for any help.
Message posted from http://www.ExcelForum.com/
Dim fd As FileDialog
Set fd = Application.FileDialog(msoFileDialogFilePicker)
fd.InitialFileName = "c:\greg\bids\"
you will need to tell what it must do with the selected file thoug
Message posted from http:...How do I add a base to a graph in Excel?
Most ghraphs need to show the base. Is there a simple way to add that in or
do I need to create a text box each time. And why do those inserted text
boxes sometimes not copy across with the rest of the graph?
You can use the x or y axis titles if not already being used.
Make sure the chart is active when adding textboxes other wise the textbox
will not be embedded within the chart object.
Andy Pope, Microsoft MVP - Excel
"Monitor01" <Monitor01@discussions.microsoft.com> wrote in message
news:8712C653-9D73-4CEF-BE41-66680AC4...Fixing column width
I have a spreadsheet in which I have set the widths of certain columns
using Autofit. The problem is that I often have to add to the
spreadsheet by importing data from a text file. Every time I do that,
the column width changes to the width of the new data (which is
usually narrower than what I wanted). Is there a way to prevent that
Assuming you're using the Data, Import Data command, when you get to the
final "Import Data" dialog there is a "Properties" button (in Excel 2003 at
least). One of those properties is Adjust column w...Add Newsgroups
There is any possibility to add newsgroups to Outlook 2007?
I mean the newsgroups from outlook express, using nttp servers.
Thanks in advance
> Dear all
> There is any possibility to add newsgroups to Outlook 2007?
> I mean the newsgroups from outlook express, using nttp servers.
> Thanks in advance
Outlook does not have and never has had support for NNTP (Network News
Transfer Protocol). There are add-ins, like Newshound and Mapilab's add-in,
to add NNTP support but they aren't free whereas there are lots of free NNT...Voiding a check in a closed year or period
How would I go voiding a check and the voucher in a closed period? Because
this is prior year I do not wish to reopen a closed year.
Any help will be great!
Void them in the current period.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com
> How would I go voiding a check and the voucher in a closed period? Because
> this is prior year I do not wish to reopen a closed year.
> Any help will be great!
&g...How do I add a Formula Auditing Toolbar in Excel
Which version of Excel?
On Sat, 19 Feb 2005 13:41:09 -0800, pinkspyce
Hello I'm just running this simple macro through a button to move to a
folder of a shared mailbox.
Dim MyFolder As MAPIFolder
Set MyFolder = GetFolder("Postfach - SharedMailbox\FolderA") Sue's function
Set Outlook.Application.ActiveExplorer.CurrentFolder = MyFolder
The macro works fine except in a case: when clicking on the button and until
that moment the user didn't had no interaction with the shared mailbox. If
this condition happens then the user goes to the folder but no preview pane
is available, it becomes grey. You ca...PR Integration to Payables
In the Payroll Vendor Setup window, you can select Federal Tax for the
Transaction Type. I've tested this and the payables transaction that gets
created is for the FICA Medicare Withheld amount only. Shouldn't the amount
be for the 941 tax?
...The great disappearing hot fix
Has anyone experienced anything like this?
Yesterday, one of our users complained to me about some quirk in GP eConnect
processing that I had thought we fixed in December of 2007 via a Hot Fix to
Well, when I checked our server it was as if the hot fix was never installed
(the eConnect release version was the basic 18.104.22.168, instead of 22.214.171.124). The
Hot Fix was also missing from Add/Remove Programs.
I went to reinstall the hot fix, and when the install program started it
gave me the option to either Repair or Remove the hot fix. So, something was
still present tha...How to prevent window from minimizing when "Show Desktop" is press
I'm Richard from China. And I am writting an application that is always
running at bottom of all other applications and at top of desktop. It seems
something sticked to the wallpaper. It should not be minimized, even "Show
Desktop" in Quick Launch is pressed.
But i don't know how to prevent the window from minimizing when "Show
Desktop" is pressed, because i can not intercept any messages except 0x3e0.
But 0x3e0 is a DDE message, I have add some code to it but it did not work. I
don't know how to handle.
What should I do? Is there any suggestions?
...Add new fields to a form
Access Newbie here.
I created a simple little Contacts database and emailed it to my data entry
person who is in another city.
She has already entered quite a few records.
Now I would like to add a couple of new fields to the form.
Whats the best way to do that?
Is it possible for me to email her the new form and she can import it into
The database should be split into a front-end (containing the queries,
forms, reports, macros and modules), linked to a back-end (containing the
tables and relationships). In that way, anytime you need to make an
application ch...Cell Box - one of the 4 cell lines is open
What was the set of search "words" to find the answer... please? I have
spent an hour. ( I don't want to tell you that I spent more time -
mentioned). Oh yea!
The lines are call borders and are part of cell formatting.
Format > Cells... > Border > Outline > OK
Gary''s Student - gsnu200826
> What was the set of search "words" to find the answer... please? I have
> spent an hour. ( I don't want to tell you that I spent more time -
> mentioned). Oh yea!
No worky. Excel 2007 - home tab - cells (ins...Add legend to trendline?
I am charting total cash income 1530-1650 for a foundation against the left
axis. Against the right axis is the constant (uninflated) value of this
income. As these two lines intersect frequently, the chart is too busy, so I
have inserted a 10-year moving average trendline for the latter line, and
“cleared” the actual constant value line. Now there are only two lines on my
chart—total cash income and the trendline of its constant value, which is how
I want it.
The problem is that when I “cleared” the constant value line, the
corresponding line in the legend also disappeared, but the le...Add a Contact lookup field into a Case entity
I'm sure this is probably possible, but not sure how. Firstly, there is no
contact field to begin with in the Case entities. Reason I need this is that
when creating a case, want to link it against a particular contact from an
account. Everything I try to create a Many-to-1 relationship to add a contact
into the Case entity, it says that there are no custom entities created, but
mainly I want to add an existing one. Any help would be greatly appreciated.
My fault, did not notice the responsible contact attribute
...Opening Excel-file in new window
I would like to be able to open an Excel-file in a new window through
shortcut. I know I can do this by putting the path to excel before th
path to the file in the target for the shortcut.
ex) "C:\Program\Microsoft Office 2000\Office\EXCEL.EXE" C:\MyFile.xls
This way I need to know the path to Excel all the time and also kno
which version is installed. As long as I have the file on my computer
know all these things but since I'm creating this shortcut via a
installationprogram I don't know what's installed on the client
Have any suggestions
Message po...NEW BUG in Outlook 2007!!!
Few days ago Windows 7 installed some updates and Outlook 2007 started to
report stupid errors on attempt to look into a mail folder. In particular -
instead of folder content it displays a message:
"Cannot display the folder. There is not enough free memory to run this
program. Quit one or more programs, and then try again."
I have tried to close programs one by one and every time checked if it able
to display folder - did not help. I have tried to stop all non-critical
system services (like IIS, Ftp, SQL) - did not help.
Only after I have closed Outlook an...Error importing dates from fixed width txt files
I'm trying to revise an existing Import Spec to include new fields added to a
fixed width text file. If I import without making any revisions the dates
import correctly. They are on the file as CCYYMMDD and the data field in the
Spec is Date/Time and I've deselected 4 digit year. My new date fields were
added to the text file as YYMMDD and I select Date/Time data field for the
new fields. However, with the revisions made adding the new fields none of
the date fields import now with the revised spec.
Another user created the spec and we're both using Access 2003 with th...PM_Journal_Distribution in Computer Check Posting Journal
I need to show document description instead of document type on the
'Computer Check Posting Journal'.
I will be grateful if anyone of you could let me know the way to
replace document type field in above temp table with document
Thanks in advance
Which description do you want to display on the journal report. The posting
journal returns the cheques numbers not the transactions.
> I need to show document description instead of document type on the
> 'Computer Check Posting ...Emailable public folder bug
Does anyone know why sometimes a public folder won't receive emails until you
go in and manually change its SMTP address to something other than the
NDR just reports "failed".
Took me an hour to fix this one, very annoying as it doesn't happen all the
Did you have special characters in the name of the public folder? SMTP
address with certain special characters is not supported by SMTP.
On Fri, 2 Jun 2006 11:32:03 -0700, mcast12
>Does anyone know why sometimes a ...Fix
What does the word FIX mean on Excel 2000? It is in the lower right
hand corner 3 boxes away from NUM, 4 boxes from CAPS.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
It means you have turned on fixed decimals places under tools>options>edit,
so if you have 2 fixed decimal places and enter 20 in a cell it will change
into 0.2 Just uncheck it if you don't want it