microsoft money #10
I tried to open Money on my computer (version 2003) The original page was
replaced by Microsoft. How did this happen? How to I get my original files?
What "original page"? What makes you say it "was replaced by Microsoft"?
Have you tried opening your original files? (Money File|Open or double-click
on them from Windows Explorer.)
"DR support" <DRsupport@discussions.microsoft.com> wrote in message
>I tried to open Money on my computer (version 2003) The original page was
> replaced by Mi...SQL Reporting Services and GP 10
Is it possible to associate SQL Reporting Services reports with SOP invoices
in GP 10.0 rather than with Report Writer?
I know that Accountable Software has Forms Printer, but I believe that that
only works with Crystal.
And, I know that there are SRS reports written to display data from GP but I
do not think that these reports will work in terms of printing invoices or
orders from SOP.
No not really.. The problem is that when an SOP or POP document is printed,
GP needs to be updated. Accountable does that with their Crystal interface
but I dont kno...sending attachments in rich text format
This is a multi-part message in MIME format.
Can anybody tell me how I send an attachment with an e-mail from within
Microsoft Office 2007 in rich text format please
R0lGODlhEwAfAPcAAP8ICP8PDv8VFf8dHP8kI/...Outlook 2002 on Exchange 5.5 -- RTF to Plain Text issues
The owner of our company wants ALL email sent to him in Rich Text
Format so he can use an abbreviation program he has that works with MS
Word when replying. I created a document telling people how to change
their settings for Outlook to ensure all messages are sent in Rich
Text. My problem is that since he travels so much he wants to be a
POP user on our server. If I send him a message from my PC directly
connected to the Exchange server he receives it in RTF. If the
President of the company (who is also a POP user) sends him a msg in
RTF he receives it in Plain Text. He wants me to expla...only the first 5 columns of a 10 column excel spreadsheet sort
How do I get the whole spread sheet to sort? There is a blue lox for the
first 5 columns that limits the range of the sort. How do I remove it?
Using Office 2003.
Maybe if you remove the Data|list
Select a cell in that blue box.
Data|list|convert to range
> How do I get the whole spread sheet to sort? There is a blue lox for the
> first 5 columns that limits the range of the sort. How do I remove it?
> Using Office 2003.
...Hide columns according to background fill color
I am having trouble understanding how Excel handles colors.
I have a public sub that sets a public variable, "TermColor" using the RGB function. TermColor is of type MsoRGBType.
In another module, I use the TermColor variable as follows:
Sub WeedColsByColor(ByRef Clr, ByRef WS)
Dim LastCol, i As Long
LastCol = ActiveSheet.UsedRange.Row - 1 + ActiveSheet.UsedRange.Rows.Count
'hide columns if they have one of the forbidden colors
Debug.Print (CBool(.Cells(2, i).Interior.Color = Clr))
...Attachments convert to text format
When I send a message with an attachment in Outlook XP some receivers claim
that all they receive is a text mail.
My default mail format is plain text. If I change it to HTML I fear some
recivers would not see the content at all.
How can I solve it ?
Note: I change the format of a particular mail if it contains an
attachment, but sometimes I miss to do that.
> When I send a message with an attachment in Outlook XP some receivers claim
> that all they receive is a text mail.
> My default mail format is plain text. If I change it to HTML I fear some
> recivers ...copying text on sheet 1 to corresponding cells on sheets 2 to 5
I want the text entered in A8 on sheet 1(named Productivity) to automatically
transfer to A8 on sheets 2 thru 5. I used the simple formula
=Productivity!a8 in the corresponding cells but when there is no data in
Productivity A8 I get a 0 in the corresponding cells. I would like the
corresponding cells to remain blank if there is not text in Productivity A8.
I am really new to excel, like only used it two weeks! Is there a simple fix
newbie at large!
A formula will always return 0 if it's refering to an empty cell. This
formula will let the cell look empty if no...Can there be variable size columns in one report?
I want to create a report that has 3 sub-reports of different column widths.
Is this possible?
-The 1st sub-report has 1 column that occupies the entire width of the page
-The 2nd sub-report can fit 2 columns in the page width
-The 3rd sub-report can fit 3 columns in the page width
Subreports can have any number of columns that don't have to be the same from
one to another. Typically your columns should display across then down in
order to render properly as a subreport.
Microsoft Access MVP
> I want to create a r...text in cell shows up as ####
Operating System: Mac OS X 10.5 (Leopard)
Text in cells in a coumn shows up as ####, apparently because there is a large amount of text. When I mouse over, the text shows. It also shows up in the formula bar. How can I copy and or print the text in these cell? <br><br>When I try to save these cells as text and transfer to Word, they continue to print as ###.
text in cell shows up as #### <br>
I am totally new to this whole environment! A new iMAC and this software. <br>
However, in trying to learn how to use EXCEL, I found that...Hide text box
I am trying to hide a text box on a subform if a check box is = to false. I
am close in doing so, but not there yet. This is what I have
In the AfterUpdate property of the check box I have the following:
Private Sub RevisedGrant_AfterUpdate()
If Me![RevisedGrant] = True Then
If MsgBox("Are you sure you want to revise this grant?", vbYesNo) =
Me![RevisedGrant] = False
MsgBox "Grant will NOT be revised", vbOKOnly
Forms![DataEntryFrm]![ItemSubFrm]![Total$ofItemsRequestedSubfrm].Form![Revised Total Approved].Visibl...Figures locked in text format
I imported data from a web page and used the feature that allows me to post
the info to Excel with the destination formatting of the file I am posting it
to. However, when I try to manipulate the data, as I have done in the past
with other data, it will not let me reformat the text to number- no matter
what I do to it. I've tried everything! I want to be able to sum the column,
Give us an example of the data you are working with. And what have you tried
to "do to it"?
"Marcia" <Marcia@discussions.microsoft.com> wrote in ...List number of permutations for text nums
I've got 4 digit text nums in A1 down
In B1 down, I would like to list the corresponding number of permutations,
Game for any formula, udf or other vba solution
Thanks for insights
Dim I As Integer, J As Integer, Rng As Integer
Rng =3D Cells(Rows.Count, "B").End(xlUp).Row
J =3D 1
Do Until ActiveCell.Value =3D ""
For I =3D 1 To Rng
Cells(J, "D").Value =3D "'" & ActiveCell & Cells(I, &qu...GP 10.0 Fails to install .Net Framework 2.0 not installed
I'm trying to install GP 10.0 on server. We have .net framework 2.0 sp1 and
3.0 installed. We have windows sharepoint services installed on framework
3.0. When we try to install, it is returing error .Net framework 2.0 not
installed and ending prematurely.
I've tried the workaround provided in Partnersource (KB ID 947538) for .Net
2.0 sp1. However it is not working.
Jack - unfortunately, unless you write out the command line scripts exactly
as they say in the KB, it will continue to bomb. Microsoft is costing us
hours and hours worth of unbillable time to work aroun...Excel 2003: How to make transparent columns in Excel chart?
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.
I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy -> paste.
But i wonder what is the slider for if you can't use it?
Does anybody know have an idea?
In Sheet 1 I have a certain amount of data, I want to select some cells and
copy them to Sheet 2 keeping the same format. When I do this, the fonts and
the colours remain unchanged, but the column width don't. I have tried paste
special, but couldn't figure it out. Is this possible?
Thanks in advance
--Select the target cell and right click >PasteSpecial>All>OK
--Keeping the target selection right click>PasteSpecial>select ColumnWidth>OK
If this post helps click Yes
"Emece"...Simple question about text within a cell
I can't seem to find the option that prevents text from
covering the adjacent cell.
For example if I type the folling in cell A1:
All I want for Christmas is my two front teeth.
Obviously that will overflow over the cell B1 (if there
is no data in B1). I don't want to resize my column, I
only want the cell to show as much text in A1 as possible
without covering cell B1.
I believe I've seen the option to do what I'm looking for
but I can't seem to find it and I can't figure out how to
look it up in the HELP file.
Thanks in advance.
My simple solution ha...Convert Text to Number on 4,508 excel files.
I'm faced with a rather unique problem.I have a large amount of
improperly formatted excel files. They all have various cells formatted
as text, yet they contain numbers and perform calculations on the
cells. I now need to get these in a proper state.
What I need is:
Conversion of all text boxes containing numbers over to proper format
Do it automagically. I don't relish the thought of opening each one
individually and fixing it.
Any thoughts, tips or ideas on this?
It could possible if you process that works by Scripting .
In Scripting engine 5.6 Filesystem...Is Auto Expansion (i.e., wrap text) of a cell possible when the cell's contents are based on another cell?
I am trying to display the results from one tab (Tab 1) in another
So, for example, tab 2 contains the formula "=Tab1!A2".
However, when the results are too large to fit the cell in tab 2
(i.e., the cell that contains a formula that draws from a cell in tab
1), the wrap text feature does not work unless i first double click in
the cell in tab 2.
Is there any way around this? Can the wrap text feature work
automatically somehow? Or will i need to double click in every cell
that contains text that doesn't fit into the cell.
Thanks for any suggestions, or VBA code, th...Conditional text field Total
In the detail section of a report I have a text box that based on a condition,
it will be either a 0 or a 1.
I want to total the control at the end of the report. I did this in another
report a couple of years ago but it is not working now.
In the previous report, the ControlSource of the total is =
[TextBoxNameFromDetailSection] and it sums correctly.
What am I doing wrong??
Message posted via AccessMonster.com
Thanks but I see what was missing - "running sum over ...Auto Filter 03-10-10
When I use Auto Filter and select the criteria I want to filter by and then
go back to select all criteria certain rows are hidden, it does show all
rows. Anyone know why?
Did you mean "it does NOT show all rows"?
If yes, then I'm guessing that you have more than one field/column filtered.
In xl2003 menus, I'd use:
On the xl2007 ribbon, I think it's:
Data tab|Sort & Filter group|Clear
> When I use Auto Filter and select the criteria I want to filter by and then
> go back to select all criteria cer...Add values in a column according to value in another column
How can I add the values in a column according to values in another
column? If there is any value in a row in column B, I want to include
the value of the corresponding row in column A. I'm flexible as to
whether this is ANY value (i.e. not empty) or greater than zero.
Maybe something like this =IF(B1="","",IF(B1>0,B1+A1))
"Paul Kaye" <email@example.com> wrote in message
> How can I add the values in a column according to values in another
> colu...WMDC in Windows 7 Ultimate 05-17-10
I installed Windows 7 Ultimate (32 bit version), and now I can't sync my HTC
smartphone with my PC. Worked fine previously with Win 7 Home Premium, but
now whenever I try and use/install Windows Mobile Device Centre, I get an
error message saying WMDC can't be installed because one or more Windows
components are missing.
restarting and reconnecting my smartphone
rebooting my PC and reconnecting phone
installing windows updates
donwloading WMDC 6.1 and re-installing - all with same result
where do I find the missing Windows components to make WMDC work?
...How do I make a column be my default column in Access
I need to make my desricption field my default field. How do I do that? Right
not it defaults to my items field.
or in macro
>I need to make my desricption field my default field. How do I do that? Right
>not it defaults to my items field.
Message posted via AccessMonster.com
Or, if you don't want to use events, simply set your tab order from the form
R...<no subject> 04-27-10