Query Access 2007
I have an ODBC linked table (to an AS/400 server). I created a query (make
table) where I inserted a calculated field to know the volume of a marble
Volume:[mextc]*[mextl]*[mexte]. As these values are in Centimeters I need to
complete this with: Volume:[mextc]*[mextl]*[mexte]/100000
Unfortunatly, in my table, the result is not what I expected! I get 0; 1 ;
5;.. don't understand that!
I checked the properties of my new table and for the new field Volume I get
Field Size : Decimal
I tryed to change this but no big results.
Can...Can't install 2007 compatibility pack after uninstalling 2007 test
Hi. My computer came with Office 2007 preloaded but unpurchased. I had a copy
of Office 2003 Student with available licenses, so I uninstalled the 2007
test and installed 2003. Now, when I try to install the 2007 compatibility
pack I get an error message stating the program is already installed. I think
there is some remnant of 2007 stopping the compatibility pack installation.
To be certain, I tried to open a 2007 document and got gobbly-gook. Any ideas?
Did you also uninstall the Activation Assistant?
Do you have an Microsoft Office \ Office 12 folder in your Programs Folder?
...SUBFORMS IN SPLIT VIEW
Is it possible to view a subform as splitform view ?
I tried but view is not available in subform properties ; I also created a
form in splitform view but when I put it as subform to another form it
appears as form view.
Any help will be very appreciated
What is a "splitform" view?
<MS ACCESS MVP>
"CristianTCDM" <CristianTCDM@discussions.microsoft.com> wrote in message
> Is it possible to view a subform as splitform view ?
> I tried but view is not available in subfo...problem with scatter diagram excel 2007
Have 2 data columns with 800 data points . I highlight the data and select
the xy scatter diagram from the chart options. The graph that is produced
plots the y values against the number of data points and not the x values in
the column. However when I click on the "select data" option and "edit" the
series that was created, the data ranges for the x and y axes are the correct
Help will be appreciated
Isn’t that what it’s supposed to do?
I have just put up a scatter chart at:-
It’s item...Using Outlook 2007
I have just installed Office 2007. I prefer to have my emails sent to my user
account rather than the Administrator account. Outlook has to be configured
in the Admin a/c and works OK but when I try to generate it in my User a/c I
get the error message that it cannot connect - is this because of conflict
with the Admin a/c?
Steve Nr Malvern UK
...Select Songs-Get Burn Error-List Disappears
When i get an error that a certain didnt allow the disc to burn- where do i
go to find that particular list again? i have too many songs to have to go
back through each time. Geez. This will take FOREVER. Any help?
...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...Money 2007 E-Pay
Noticed this morning when I was paying my bills this anomaly. Perhaps I am
Paying a credit card bill. In Money 2004 (my previous version of Money) I
would use Credit Card as the category and in the subcategory use the
particular credit card account I was paying. Worked great.
Money 2007, there is a new category named Credit Cards/Transfer. When
selecting this there are no payee categories listed. However further down
the list is another category named Credit Card. Using Credit Card shows the
various payees. Not sure what the difference is between Credit
C...valid xml schema generates "Duplicated declaration" error in DataSet
When reading the following ugly but valid (according to w3c XSV) xsd
into a DataSet I get "Duplicated declaration PossiblesValue" error.
Can anyone tell me why? This is a small part of a large xsd reverse
engineered from an existing xml output from an application so despite
the structure being crap it can't be changed.
Here's the XSD...
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="XMLSchema1" targetNamespace="http://tempuri.org/
XMLSchema1.xsd" elementFormDefault="qualified" xmlns=&...What about DPM 2010 Rc
Anyone use 2010 RC in a production environment?
I've put it on a VM to look at it, and it would be nice to use it in
My Number 1 Reason To Upgrade
>>> Can Disable Daily Tape Backups for Saturday and Sunday
What's your reason(s) for upgrading?
How is it working out for you?
Yes. 6 protection groups, 10 servers, 20 vms on a 6 node hyper-v cluster with
csv. Runs great. A few quirks here and there but overall great. A far cry
from our last backup solution. I basically set it and forget it. Check it
when I get in to the office in the morning.
...How do i set up text to audio in Word 2007?
Can I get Word to read my document to me?
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> Can I get Word to read my document to me?
...Publisher 2007 #25
First and after today probably last time Publisher user!
Can anyone restore my faith in 'user friendly' MS products?
I have a single page to print out as part of a report. When I print it I
get the entire page divided into quarters and each quarter is printed on a
separate page. Or better described as having cutting out 1/4 of a page for 4
pages and a lot of tape!. Is there any way of printing the one page I need
on one page???? Or copying it over to another Office program for printing???
Any help is appreciated.
Are you using standard size stock? If not, have you setup y...Delegate can see my private items doesn't work in Outlook 2007 SP2
We experienced the above problem on two Outlook 2007 SP2 client with manager
and delegates permissions. On the manager side, we give delegate permissions
and editor rights to all the 6 folders plus delegate can see my private items
permissions. On the delegate side, we have added the manager as the
additional / secondary mailbox. When the manager creates an private
appointment, the delegate could not see the details of it (double click
function is disabled). Any ideas would be helpful. Thanks.
When I divide one cell by the other if the answer is zero I get #DIV/0
error. Previously (I just do simple spreadsheets) I just done a
conditional format if no. was less than 0 then format text in white so
it (error) didnt show up but for some reason this isnt working for me. I
seem to recall there was another method by adding something to the
formula. The formula is simple like =B2/C2
Can anyone help please.
Change your formula to this:
Then you will just get a blank instead of the error.
Hope this helps.
On Nov 25, 6:34=A0pm, ss <weel...@h...Outlook can not display this view. Unknown Error
I have 2 mailboxes open in outlook 2007 sp2 mine and another users and
when i try to search on items in the inbox of the second mailbox i get
"Outlook can not display this view. Unknown Error" i am able to search
items in the deleted items and sent items only and not the inbox. I
have uninstalled office and reinstalled it with only SP1 and it worked,
i was able to add the second mailbox and search for items in the inbox.
With SP2 i was able to search another users mailboxes with out the
error but still not search the other second mailbox.
I am still looking in...Replacing a disk in DPM 2007
The host on server 1 corrupts and can't be repaired or hard
Either way need to restore complete host
Q)What do I need to get the server running again?
Do I need to do a complete clean re-install?
Does the agent need to be re-installed?
If so is there additional configurations
I need to do?
...IP Sec with DPM 2007 or DPM 2010
Hi, we are about to implement IP Sec for a group of servers which will be
backed up by DPM. I wanted to find out if there are any restrictions
regarding backing up IP Sec hosts vs non IP Sec hosts in the same domain. Any
info will be appreciated. Thanks!
There is no restrictions on IP sec policies on DPM as IP sec policies
work at much lower layer than what DPM uses. But the policies should be in
such a way that both DPM and Production servers should be able to
communicate with each other, like network share browsing etc..(any windows
applications between these two machines...Outlook 2007 and sending 3 of 3
Why am I always seeing "sending 3 of 3" in my status bar when sending only
This has been happening to me since Office 2007 Beta and now the release
version. I've formatted my laptop before installing the released version of
Vista so it certainly can't be a worm or anything that my AV missed.
Any help would be appreciated.
did the reformat include the old pst? could it be a read receipt?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://ww...Required OS for Exchange 2007
I have installed Windows 2003 R2 Enterprise 32 bit x64. When I try to run
Exchange 2007, I receive "the image file setup.exe is valid but is for a
machine type other than the current machine". Any idea?
On Fri, 2 Mar 2007 22:52:43 -0800, "Xeon" <Xeon@donotemailme.com>
>I have installed Windows 2003 R2 Enterprise 32 bit x64. When I try to run
>Exchange 2007, I receive "the image file setup.exe is valid but is for a
>machine type other than the current machine". Any idea?
So you arent using the 64 bit version of Windows?
No...DPM 2010 RC - DPM could not backup some files
In the DPM 2010 RC, whenever DPM cannot back up some data source's files (ID
32526), nowhere in the DPM Admin Console does is say WHICH server it could
not back up the files for. On the Alerts tab, none of the information for
these failed file alerts indicates the data source or server name. It just
gives the DPM server's name in the Computer column. The View failed files log
gives the path of the failed files, but not even this gives the protecter
server's name. This requires me to deduce which protected server the failed
files are on by looking at the paths of the f...Outlook 2007 support 09-11-06
Are there official informations available concerning the support of Outlook
2007 for the Outlook CRM client ?
Microsoft is working on an Outlook Client release that will be compatible
with both Vista and Office 2007. Currently the bits are under Beta and will
be released shortly after the final release (RTM) of Office 2007 and Vista.
The exact release date is not yet confirmed.
Program Manager - CRM
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2005 Mi...Recovering a file in Word 2007
I have been composing a blog entry on my new HP Mini computer. I
worked several days on the document and several hours yesterday. I
physically saved (pressed the save button) when I finished working on
This morning I only have the material I wrote on the 13^th ..nothing
is left from yesterday.! I'm using a trial version of MS Word 2007
and I have MS XP Opsys.. Any hints on recovering it? I've tried the
typical search function and only get the old doc. LP
lfpevec'...Year End Close: But transactions for 2007/2006 are out of sequence
In Tools>>Routings>>Financial>>Year End Closing
you are supposed to put the first Starting Journal Entry for the next fiscal
year. But we can't do that because the first several entries for 2007 are
followed by more entries for 2006. For example, Dec. 31 2006 last entry is
1000. Then 1001-1010 are entries for Jan 2007. But 1011-1015 are for Dec. 23
How should we proceed to close? Do we need to re-do the entries for the
previous year that come after the Jan 2007 entries?
It isw really NOT a good practice to reset the next journal number to a
special number t...Quick Outlook 2007/Exchange Question
I had a POP3 account in Outlook and then we upgraded it to an Exchange
account with our host. They had me create a new profile for the Exchange
account in Outlook but I can't seem to figure out how to transfer my old
subfolder stored emails from the old POP3 to the Exchange server. When I
pull up the Exchange account in Outlook it doesn't show my POP3 stored
emails and vice versa... Is there an easy way to bring these folders over?
Or have I just configured something wrong?
Within Outlook, open the old data file
"Matthew" <email@example.com> wrote ...DPM to DPM untrusted
I'm trying to find out if in DPM 2010 a DPM to DPM backup is supported
across untrusted domains? From my reading it appears to not be supported but
this is a pretty common/useful scenario for a number of companies.
If this is supported can the one DPM server backup multiple DPM servers from
multiple untrusted domains?
One way to solve this is by establishing a two way trust between the DPM
machines domains. But protecting two different servers without trust between
the servers domains in not supported. We will consider this in future DPM