Money 2003 Report Problems
When I look at reports (in Money 2003) I can see all my
withdrawls, but not my transfers. For example if I pay
$100 on my credit card, its not there. Should I set it up
as a catagory instead?
You don't say what reports you are referring to. Depending on the report
type, it doesn't make sense to show transfers. E.g., Income and Expenses.
Transfer is neither. In some other reports, you can include or exclude
Transfers from the report customization. E.g., Category Spending.
"cschear" <firstname.lastname@example.org> wrote in message
&...Mail Messages HTML Viewing
I am using win XP and Office 2002. When I receive
messages with html format i can only see the url's and
not the pictures. I have checked all the settings, I
have the box in options/mail format/internet
settings/html format checked to receive pictures and
still just the url. I runn norton and zone alarm but
can't see any settings in these that would restrict the
downloading of pictures. Any thoughts?
What are your IE settings?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to the
Swen virus, all e-mails sent to my actual...the webpage you are viewing is trying to close the window
We have an internal web interface for our helpdesk system. When we finish
working with a "call" it attempts to unlock the call and we get the message
as above. More often than not, we need to say YES to the message. Any ideas
how to get it to not appear?
Which security zone does the page/popup load into?
Hint: Is IE configured to automatically detect sites in the Intranet zone?
What 'call' software are you using? Have you attempted to contact the
"Keithmeister" <Keithmeister@discussions.microsoft.co...Checkbox border on report
I have a checkbox field on my report. Whether the checkbox has been checked
or not, the black border still shows on the report. Is there a way to show
ONLY the check mark if yes and blank NO border if no?
Format Check boxes on reports: size, color, unbox, conditionally format
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Stockwell43" <Stockwell43@discussions.microsoft.com> w...Restoring Organizational Unit
Is there a way to recreate the Organizational Unit? It
was accidentally deleted. I was upgrading from SBS 2000
to SBS 2003 when it occurred. I had to rebuild my SQL
Server 2000 and do have the db backups for the four CRM
Once I've restored them, I know need to rebuild the
Organizaiton Unit that was deleted. Hence, this is my
Any ideas would be appreciated.
unfortunatly there are no supported way of doing this.
My first idea was to use the Redeployment manager but you
need to know the GUIDs of the items in the old AD to make
Ben...Using custom document peroperties to creat views in Public Folders
How do I use custom document properties to create views in public folders? I
came across an article for Outlook 2000. I tried doing this for Outlook 2007
but I am unable to. Please assist.
The article I came across was
http://office.microsoft.com/en-us/publisher/HA010549541033.aspx However this
only appears to work for 2000 not 2007. Hopefully someone can help.
> How do I use custom document properties to create views in public folders? I
> came across an article for Outlook 2000. I tried doing this for Outlook 2007
> but I am unable t...linking charts to one database
I want the same chart from the same database to be linked to two different
worksheets so that any changes made will transfer to both charts.
...Using Access Reports in other EXE file
I'd like to use access reports from any access version XP, 2000 or 97;
because of the easy way to build such reports.
Have you ever found or built any solutions permitting to reuse such access
reports objects in other exe files, developped in Visual Basic, Visual
Studio or even Delphi....
Thanks a lot for your suggestions
Most programming languages support launching an executable, so the Snapshot
Viewer executable would be a good choice for viewing reports exported from
Access as Snapshot (*.SNP) files. Access would not need to be installed on
the computer in order to view ...m_pDocument Doc/View unique id for each view
I'm using the standard mfc mainform with a doc/view. While I'm in the
view portion I need to track the actions taken individually and
separately for each view. So when when I click on view one I track
that in a separate place than view two.
I there a unique id or index for each view? Something like
<email@example.com> wrote in message
> I'm using the standard mfc mainform with a doc/view. While I'm in the
> view portion I need to track the actions taken...Mailbox management Deail report data
I find that the output of the mailbox management detail reporting has a
little too much detail for my liking. I would like to see a list of the
folders containing old/big mail. I really don't care about all of the
folders with no items that qualify for my criteria.
Is there any way to get at that information that does not involve me parsing
the text report? The data is there. It's just not in a very usable form.
It a perfect world I'd love to use crystal reports to query exchange and do
some of my own reporting.
Got any ideas?
How can i view a HTML page in Excel, it should also be automatically update
in 60 seconds. Is this possible?
Please note that, that page contains images
That webpage is on our intranet website.
Though I am not certain this is exactly what you are looking for, try the
Data, Import External Data, then New Web Query...
In the dialog box that appears, browse the site. You will notice that at
certain areas of the page you will see an arrow. Just click the ones that
you want to import. Click import. Select the cell you want to import the
data into and click OK.
Hope...Forms in two differant views
Is there a way to use the same sub form showing two differant views within
the same Main Form. For example: Can I show on one tab a datasheet view and
on the other a regular form view.
Create a button on your form and under the "OnClick" event put
'Me.DefaultView = Datasheet
Alternatively you could use a checkbox
If me.checkbox1 = 0 then
Me.DefaultView = 2 ' Datasheet
Me.DefaultView = 0 'Single Form
This should flick the form between datasheet and form views.
> Is there a way to use t...GP Detailed Trial Balance Report
Hello all, we are getting some strange numbers from the trial balance detail
report.. Here is what's happening.
we do a section or accounts and by date select just posting accounts and
the report then shows only 2 decimal places so for instance an account was
posted with a credit value of 144.702 and a debit of 1281.96 which if you
calculate gives you a value of 1137.258 which great plains in the account
number footer shows as 1137.25 for the net change. On the the report total
for net change GP shows 133,964.83. when you actually calculate the total of
net change am...merging spreadsheet with reports
I'm a teacher who uses an Excel spreadsheet to average
grades. I'd like to merge each students row of grades and
average into a Progress Report in Word. Do I need an
object link and a mail merge or what?
You could do a main merge in Word. Set up your table in Excel with a
heading in each column, and rows of student data below, with no blank rows.
In Word, set up your report, then use the Mail Merge wizard to connect
to Excel. Add the fields to the report (e.g. Name, Score1, etc.), and
merge the document with the list.
Sherry McAllister wrote:
> I'm a teacher who use...Forcing all outbound mail through one account
I have two ISP's, NTL and BT, so I have to IMO accounts, NTL and BT, in my
I only ever connect through BT these days, so I can receive NTL mail
(password authenticated) but not send NTL mail (IP address authentication).
Is there a way that I can force replies to mail that came in via the NTL
account to go out through the BT account? I would expect the origin of the
replies to be my BT email address, and that is fine.
I can force this change manually, by selecting the account once I'm in the
reply, but I'd prefer to automate this task.
http://ww...How can I format a cell on a specific date?
I have a spreadsheet that has the following:
Column 1 = Person's name
Column 2 = Amount due
I need cells to change colour if the amount due is not paid by the 20th of
the month. I have managed to figure out the date bit but unsure of what to
put for the value as the amount due for each person is different.
I hope this makes sense.
Any help would be greatly appreciated.
I think you must have other columns apart from the 2 you refer to. For
example, do you have an Amount Paid column, and a Date Paid column? If
you don't, then how will Excel know if the debt has been...Laying out a Report
I have a database with two tables called Fillers and issues linked. I want to
make a report on issues under two different sections of the filler.
Model = 6000 S/N 235 J/N 12 Date started Date complete
Date Part issue drawing issue bill of material issue assingned to plan
Date Part issue drawing issue bill of material issue assingned to plan
Any suggestions would be appreciated
What field is linking Fillers and issues?
It looks like you want two records from issuses for every filler record. Is
this correct? If so, h...Forcing a view to be the active view
I have an SDI application that has a splitter window with two views. The
first view is an CFormView and the second is a CView. I want the CFormView
to always be the Active view. Even if the user selects the CView.
How do I accomplish this?
Anders Eriksson wrote:
> I have an SDI application that has a splitter window with two views. The
> first view is an CFormView and the second is a CView. I want the CFormView
> to always be the Active view. Even if the user selects the CView.
> How do I accomplish this?
> // Anders
I'd ...Excel cut/paste prob: Adds one day and changes year to 2009
When I cut and paste a date into another worksheet, one day is added and the
year is changed. For example, 2/5/05 will change to 2/6/09. I am using
Office for Mac. How can I avoid this problem. It is compromising my reports
and giving false information.
The workbook you're copying from uses the WinXL default 1900 date system
while your destination workbook is using the MacXL default 1904 date
You can change the destination workbook system (Preferences/Calculation,
uncheck the 1904 date system checkbox). Alternatively, you can enter
1462 in an empty cell. Copy the cell...How retreive specific data from 1st Sheet and placing it on 2nd Sh
Looking to search a range of cells in Sheet1, find specific data and place it
on Sheet2. Does anyone have a way of doing this.
Range of cells in sheet one will be updated periodically and cell range will
grow with it.
Need more information: are you looking for some value such as a name and want
to return another value based on the name?
What ranges are involved, and what type of data is involved?
Is the location on the second sheet always the same or will it also be
changing over time?
Sample of "before" and "after" usually helps bigtime!...OL98 start up view
I recently had to reinstall my WInXP and now my OL98 has a couple of
issues I'd like to fix.
I've set up my mail account (with POP3 and SMTP servers) but when I
try to use it I get a message saying that internet mail is not
registered properly. What do I need to do to fix this?
Also, I used to start up OL98 so that the first view was not Outlook
Today. How do I change that?
I guess I can't remember how to do things that I only do once every
Thanks for any suggestions!
You might want to have a look at this MS KB ...Changing View -- All Folders
Using Outlook 2007, Windows XP Pro. I have dozens of mail folders in
Outllook. I would like to change the view (to the right of the folder
tree) on all folders. There seems to be no apparent way to do this.
Any ideas? Thanks,
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EAS...Can't open more than one Excel file.
I'm using Excel 2002, W2k with all recent patches. When
I'm working on an Excel worksheet and I attempt to open
another Excel file the first one is closed when the second
one is opened. What do I do to retain the first one open?
Are you sure the first one is closed or just taken off the Taskbar?
If you go to Window(on the menu) do you see one or more files listed?
You may just need to go to Tools>Options>View and check "windows in taskbar".
Gord Dibben Excel MVP
On Fri, 30 Jul 2004 08:17:44 -0700, "Eppie"
I have been given a new work station and for some reason my custom view is
not highlighted and is not working.
I don't think it is as add-in feature. Excel heip has not been of any (help).
Does someone know how to enable this feature?
Custom Views will be disabled if you have more than one sheet selected.
Do you see [group] behind the filename on title bar?
If so, right-click on a tab and "ungroup sheets".
Gord Dibben MS Excel MVP
On Wed, 11 Jan 2006 06:28:03 -0800, "Michael"
>...Macro to put data in a new column following specific characters
I need to create a macro that goes through a single column, and ever
time a specific character set such as 3 periods "..." occurs anythin
after the "..." is put into a new column.
So say I have all of the following in column A:
I go...to the...store
I need it to turn into:
Thanks in advance, any help is GREATLY appreciated!! :
asf's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1493
View this thread: http://www.exce...