Problems with reading date/time format from SQL server
I made a pivot table. I get data from external source - SQL server. On
of the columns is date/time type. For some reason unknown to me, Exce
doesn't read this dates correctly. Instead of dots between months an
days it puts little squares .. ?!? I opened the same file on m
coworkers comp. and it works just fine.
If anyone has already encountered this and knows how to fix it ..
Message posted from http://www.ExcelForum.com
There may be some difficulties getting external data properly into
Excel. If not done correctly you cannot use the data in formulae e....Outlook Web Access attachment problem
We have a program that will generate a .snp file and then email it to
whatever recipient it needs to go to. If they receive the email in Outlook
it will allow them to open the file properly with the Snapshot viewer.
However, if they go to the same email in OWA and try to save the attachment,
it attempts to save it as an .mdb file. Why would OWA ignore the original
extension and try to give it a different one?
"Joe Giddings" <email@example.com> wrote in
> We have a program that will genera...mail sending problem
I am very new in the exchange server just now I have deployed
Microsoft Exchange Server 2003 at my organization now i have some
problem in that .
I am able to send mail outside the domain except yahoo .whenever I am
sending mail from my exchange mail id to any yahoo mail id it is
showing me mail has been sent but on yahoo id it is not delivering
even I am not getting the DFR, second I wants to know that can we
take the backup of single mail box (boxs) and please tell me step by
step how can we take backup (at least the location )
Thanks in Advance
The most probable reason is t...Windows Welcome Screen Login Looping Problem
Up until now no startup problems whatsoever with my system. Today, I press
the start button and it boots fine to the Windows' Welcome Screen. When I
click on my account icon (no password ever entered) it tries to login (I see
my desktop for about 4-5 seconds) but it comes back to the same Windows'
Welcome Screen after about 5-10 seconds. My significant other also has an
account icon and when she tries to login from the welcome screen she can't
get pass the screen either and gets the same 5-10 seconds looping problem
that happens to me. System specs: Dell Deminsio...keeping page, insert etc dropdowns open & having page below it
how can i keep the drop downs open & have the page below it. It was that way
& I must have hit the wrong button or something.microsoft word 2007
"billy" <firstname.lastname@example.org> wrote in message
> how can i keep the drop downs open & have the page below it. It was that
> & I must have hit the wrong button or something.microsoft word 2007
Ask in a discussion group for Word. Here's how to find it.
In the...Incoming mail server problem
I use supanet for the internet and recently had to clear off a load of
viruses and worms from my computer. Computer is clean now. I've run up to
date spybot. adaware and cleaned all viruses with Mcaffee internet security
as well as running stinger. Sasser, and W32 pate.b were included. Have also
completed all windows updates.
Everything is working fine now except my email. When I restart the computer
my incoming mail server keeps changing from pop.supanet.com to a strange
number. 9eg 17.02.01.10 or something similar) It also changes the user name
from 3612 to email@example.com (It adds su...Calling the Page Setup PopUp from VBA..
I am using Access 2003 and I have a button on my form that I will have the
user click to bring up the Page Setup popup screen just like you would do if
you chose File -> Page Setup. Does anyone have the VBA code to accomplish
Also, do not forget to trap error 2501 should the user cancel the operation.
Hope this helps,
"Brett Davis" wrote:
> I am using Access 2003 and I have a button on my form that I will have the
> user click to br...Problems performing a restore to a SAN drive
We recently move our message stores to SAN. I've tried to perform a restore
to a recovery storage group on the SAN and am not able to do it. We use
Ultrabac as our backup application, but I've tried NTBackup also and am
getting the following errors in the App logs:
Information Store (3576) Callback function call
ErrESECBRestoreGetDestination ended with error 0xC7FE1F42 Database not found.
Failed to find a database to restore to from the Microsoft Active Directory.
Storage Group specified on the backup media is
Database speci...How do I create a summary page from multiple worksheets
Trying to roll-up information from multiple worksheets within the same
workbook to a summary page. These worksheets are copies of each other. For
example: each worksheet has a column labeled "defect number". The users can
record multiple defect numbers within a cell (e.g. 897, 992, 1001)
So sheet1, row1 = 897, 990
sheet2, row1 = 992
sheet3, row1 = 995, 1001, 1012
sheet4, row1 = empty
How do I (or can I) rollup this information to a summary page where sheet5
is the summary worksheet and row1 = 897, 990, 992, 995, 1001, 1012.
Here's what I have so far
[=Sta...IN EXCEL, WHEN I CLICK ONA SINGLE CELL It HIGHLIGHTS WHOLE Page
"confused" <firstname.lastname@example.org> schrieb im Newsbeitrag
> please help
Just click on a cell and nothing else?
Or perhaps you mean click on a cell then as you move the cursor around other
cells are selected like the cursor is stuck?
If the former, you must have some event code which selects the cells or you
are clicking on the gray box at intersect of rows and columns(top left above
ro...XMLA .NET connection problem
Hi, After install msxml 4.0 and XMLASDK 1.1, i proceed to configure the datasource.xml file, as follow:
<DataSourceDescription>Microsoft Analysis Server 2000 on local machine</DataSourceDescription>
<ProviderName>Microsoft XML for Analysis</ProviderName>
</ProviderType>...Problems with DATE data type
I've got a little problem with the next macro in Excel.
The problem is that I must look for some information in a data bas
using as filter a specific day an hour in the year.
I get the date and the hour using a form and then the macro calle
"Busqueda" receives the value.
I've programmed the macro using MSQuery just to see the necessary cod
and the problem has appeared when I've tried to include the para
called "Dia" in the SQL code.
I've tried using " & Dia & " but it doesn't work and I don't know ho
to include my param...Publisher 2003
I'm attempting to print a calendar and I keep getting the message, "Cannot
load the printer driver." I have no idea what that means other than I'm
unable to print my calendar. Anyone have any ideas? I get the same message
whenever I try to print a card I've created. HELP!
The computer has been chucked out the picture window and the birds are
nesting in it. *sigh*
> I'm attempting to print a calendar and I keep getting the message,
> "Cannot load the printer driver." I have no idea what that means
> other than I'm una...Paging Size set up for sql 2005 best performance
erver windows 2003 sp1. 64 bits,
Paging file size for selected drive C is (custom selected) Initial 2046 MB,
and maximum 4092 MB. It is currently allocated 4081 MB. Computer RAM memory
Server functions as a database MS SQL 2005 server, and it is used under
heavy insert database operations
The problem is that it can be seen on windows task manager there is on PF
usage and Page File Usage hHstory around 8.2 GB paging file size not 4081 GB
as it is given on virtual memory page set up.
DoleBludger (DoleBludger@discussions.microsoft.com) writes:
> erver windows 200...Export CRM-contacts to Outlook Global Contact (CRM 1.2)
I want to export all the contacts in CRM to the Outlook Global Contact, so
all the non-CRM-users can find contacts with there phonenumber etc. There is
no support for this at all in CRM 1.2
I can do this manually. First export all the contact to Excel and from there
back in Global Contact. Now the problem is the 'Save as'-field. You can only
set this field by opening the contact, set the field and save it. For one
contact is this no problem, for 5000 contacts it is.
When I import the contacts I can't set the value of this field. It has a
default value, but I need anoth...Reinstall problem
I have a CRM 1.2 MSDN installation. I ran add/remove programs to
un-install. Everything seemed to uninstall just fine. I then ran the
installer again to reinstall. I wanted to use the existing database. I
select the: "Connect to an existing database" options, click next then select
my SQL server from the list. I then get a message:
Setup could not find any valid Microsoft CRM databases on the server you
have specified. You must select a different server.
I know the databases are there. I can see them in enterprise manager. The
system was working fine except for ...Problem w/ Task Manager
This is a multi-part message in MIME format.
I am running a laptop with WIndows XP SP3. I am not sure what changed or =
happened but my task manager now only shows the processes tab. The tabs =
are mising for me to change views as well as the title bar for my task =
manager windo and the menu bar i also gone.
How can I correct it?
charset="iso-8...Mac problems opening excel files when connected to two windows shares
Operating System: Mac OS X 10.5 (Leopard)
I'm noticing a strange problem when I try to open excel files when I connect to a second windows server share. I'm getting a cannot open excel file error. Not sitting at my work mac computer at the moment so not quite sure that was the exact error. <br><br>This error is occuring on both leopard and snow leopard with Office 2008 for mac. <br><br>The two windows servers are being connected to by smb://server1/common and smb://server2/common. <br><br>If i connect to each one i...An error number : 424 problem
I'm having trouble with an attachment field.
On a report I can see the picture and the filename of the selected attachent
Now in a SQL UPDATE string that i'm making I always get the error 424 Object
Here is the line where it happens :
'mySQL = mySQL + ", scan_g = " & prn_du_pied_g.FileName
scan_g is a Text field
prn_du_pied_g is an attachment
All I want to do is to use the filename of the attchment.
How do I solve this
Thank you for the help
"ericb" <email@example.com> wrote in message
news:9A...How can I change order of pages in a fold brochure in publisher
When I work on the pages on the screen it shows pages 2 & 3 and the page
preview shows 2 & 3 but when I go to print page 3 comes out as page 5.
Is your publication setup as a booklet? When you go to print are you checking
current page or typing the page number? What version Publisher are you using?
> When I work on the pages on the screen it shows pages 2 & 3 and the page
> preview shows 2 & 3 but when I go to print page 3 comes out as page 5.
"Mary Sauer" wrote:
> Is your publication setup as a booklet? When you go to prin...Concatenate multiple rows and columns into 1 cell
I have a spreadsheet using 3 columns and n number of rows worth of data. I
am trying to create one long string of this data by concatenating in the
The only way I know how to do a large range is to individually click on each
cell and that will take a very long time.
Is there an easy way to concatenate a range such as (A1:C500)?
You are aware that a cell can take in limited number of characters. Any more
than that number, the result will be truncated please.
"mj44" <firstname.lastname@example.org> wrote in ...VB.Net: how to carry SessionID(its value ) from 1 function to othe
If I get SessionID in 1 function how do I carry that SessionID(value of this
SessionID) to another function or another form within the same project
Winforms or webforms?
In Winforms, u can make the SessionID a public or internal property of the
form and in WebForms use the Session object to hold this value.
"XML newbie: Urgent pls help!"
<XMLnewbieUrgentplshelp@discussions.microsoft.com> wrote in message
> If I get SessionID in 1 function how do I carry that SessionID(value of
> SessionID) to ano...Mail and Catalog merge problems
This is a two part question. The first part concerns an error and the second
part is seeking advice.
First the error:
I am trying to create a data source for use in a catalog merge. No matter
what method I use, even using "Create Address List" from Publisher's Tools
menu, I get an error dialog saying:
"The operation cannot be completed because of dialog or database engine
failures. Please try again later."
What causes this and how do I correct it? I would like to be able to
connect to a SQL 2005 database for merge data.
Now the request for advice:
I am cr...Publisher 2007 printing problem
I have a publisher file 6x4 template. When I try to print on a 4x6 photo
paper instead of 1 page landscape it prints 2 in portrait. No mater what I do
seems to change this.
Build your project
Don - Publisher 2000�
"tomincolorado" <email@example.com> wrote in message
>I have a publisher file 6x4 ...2 data ranges shown on 1 line with 2 axis
Is it possible to have 2 data ranges plotted on one line against 2 value axis??
The X axis will be a dateline.
I need to be able to look at a point on the line e.g., 3/07/05 and see a
value on the Z axis and a different value on the Y Axis... but on 1 line not
I didnt think it was possible, but I have an engineer who believes this is
Help please !
Excel does not do 3D charts well. Maybe someone else can point you to ways
to kluge this.
"Nadia" <Nadia@discussions.microsoft.com> wrote in message