How to Convert UTC to localTIme(C# )
I have got the value of user account's lastlogon time. Its type is Int64.
This value is stored as a large integer that represents the number of 100
nanosecond intervals since January 1, 1601 (UTC)(Refer to MSDN).
I don't know how to convert this value to localTime.
The following is my code.
DirectoryEntry deUser = new DirectoryEntry(ldappath);
DirectorySearcher src = new DirectorySearcher(deUser);
src.Filter = "(&(objectClass=user)(SAMAccountName=" +
accountNa...questions on drop down list
Hello all!!im filling a dropdown list with results from a query as th
code shows (i fill the drop down everytime i open the xls file), BU
this dropdown keeps all information when i close the file and when
run the code again the result is merged into the older, i need to clea
the dropdown in this code before i fill it again!!! i tried .Clear bu
excel says it doesnt belong to the object class..i dunno what to do
> Sub Auto_Open()
> Const strActiveConnection
> "DSN=TURMALINA;Description=TURMALINA;;;APP=Microsoft Offic
> 2003;WSID=GENERATOR;DATABASE=JDE_DEVELOPME...Printing list of emails in Oulook Express
I am trying to find a way to print, an entire list of email reciepts, so I
don't have to keep them. Can anyone help?
>I am trying to find a way to print, an entire list of
email reciepts, so I=20
>don't have to keep them. Can anyone help?
These Newsgroups address issues regarding MS Office
Outlook. Outlook Express is a component of Windows/Internet
Explorer. Post your question where the OE gurus hang out:
...Mailbox store dismounted automatically
Exchange 2003 server/w SP1, Windows 2003 STD with latest patch,
Both of Exchange mailbox stores dismounted automatically, with event ID
1159, source: MSExchangeIS Category General
Database error 0xfffffd9a occurred in function JTAB_BASE::EcUpdate while
accessing the database "First Storage Group\Mailbox Store
For more information, click http://www.microsoft.com/contentredirect.asp
Click the Microsoft link on the event ID,
got the following details:
Component: Information Store
Symb...Convert text to time value
I have a series of time values in a 'General' format. They are of the
Which is 18:45:25 or 6:45:25 pm.
A time which is am would be of the type:
Which is 1:23:45 am.
Is there a way to convert those 'General' values to an Excel serial so
that I can figure out the difference between two times? I've seen a
bunch of examples on the net, but none of those that I have found deal
with this format that I can tell.
"Andy" <email@example.com> schrieb...how to convert date
I'm looking for some method to convert mail date, in format:
eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
I tried CTime but without resoults.
Have you tried COleDateTime::ParseDateTime()?
> I'm looking for some method to convert mail date, in format:
> eg. "Sun, 18 Sep 2005 20:57:08 +0200", to computer local time.
> I tried CTime but without resoults.
>I'm looking for some method to convert mail date, in format:
>eg. "Sun, 18 Sep 2005 20:57:08 +0200&qu...How do I convert dates to text keeping the format?
I'm trying to convert a column of data in date format *m/d/yyyy to a text
format without converting to serial numbers. Ie: I want to retain the
mm/dd/yyyy format. Is there a way to do this?
"sprlarry" <firstname.lastname@example.org> wrote in message
> I'm trying to convert a column of data in date format *m/d/yyyy to a text
> format without converting to serial numbers. Ie: I want to retain the
> mm/dd/yyyy format. Is there a way to do this?
That ...Excel: Auto converting text to numbers
I am downloading an Excel sheet, and the numbers come in as text. It
basically comes in as "33 %" but Excel registers this as text, not a
I have a cell that will be used to add the numbers, but since they are
text it doesn't work.
Given this information, is there a way to convert the imported data
into numbers. I would prefer to include this into my formula. The
potential numbers are:
0, 1, 2, 3, 4, 0 %, 25 %, 33 %, 50 %, 67 %, 75 %, 100 %, and N/A
I would prefer a function, again if possible, that could convert any
number. Please note, the space between the nu...how to convert excel's .cvf file to .csv file
...Color Coding Email Listings
Without using the Followup function.
Is there a way to color code the email listings.
Mac's are good for this, and Eudors on PC.
I may want to highlight an email with color codes... and the entire listing
being highlighted is a better visual then the followup flag. And these items
really aren't being highlighted for followup.. just for more important
Dave Bar <email@example.com> wrote:
> Without using the Followup function.
> Is there a way to color code the email listings.
See if these help:
http://www.howto-outlook.com/howto/colore...Convert Access97 to 2000
Hello, we're currently running access97 and would like to convert it to
2000, but we don't know what is the administrator password for this
database. Also this database is running on multi user and have difference
permission for diffence users. Could someone help me how to do make this
happen but keep the currently permission retaint. Thanks
...Creating custom list with a comma in it
I need to sort a list of cities. I know how to creat a custom list however
there seems to be a bug in it. I am hoping somebody knows how to work around
Creating this list is simple:
The problem comes when the same city is in multiple states so that the cell
because internally the item separator is a comma, the custom list changes
these entries to:
Obviously when you do a data sort it doesn't find any of these va...Convert 2000 Calendar to web page
When I convert my calendar for 2005 to a webpage, the page is off by 1 day.
Is there a template or fix available to fix this?
I can edit the html file but this should not be the case. Fixes?
Suggestions...other than use Apple?
"Duane Perry" <firstname.lastname@example.org> wrote in message
> When I convert my calendar for 2005 to a webpage, the page is off by 1
> Is there a template or fix available to fix this?
...Distribution Group problem
I have exchange 2000 running on a 2000 server. I have several domain
distribution groups which until recently worked fine. Now if you send a mail
to a group it appears to go but is never recieved. But if you expand the
group it lists it's members and will then deliver the email. What has
happened does anyone have any ideas???
Just a thought I applied the latest security updates to the windows 2000
server that exchange is installed on and the problem has appeared since.
> I have exchange 2000 running on a 2000 server. I have several domain
> d...Mailbox Manager Settings
If I add a group to a mailbox manager policy, will the policy act upon the
group itself (it only if it's a mail-enabled group) or will it act on all
mail-enabled users who are a member of the group?
I want it to do the latter to save me adding loads of individuals to the
It should apply to the individuals within the group.
"K" <@.> wrote in message news:O7JFN6cbGHA.3320@TK2MSFTNGP04.phx.gbl...
> If I add a group to a mailbox manager policy, will the policy act upon the
> group itself (it only if it's a mail-enabled group) or will it a...XML Note convert to DataSet
I have this function:
object acmResponse = acmLogin.acmString("4001", "", paramFormLogin +
paramUserBasics);System.Xml.XmlNode acmNodes =
What I have todo, to convert the XML Object in the DataSet Object?
...how do i restart a mailbox store?
how do i restart the mailbox store? Is this a service? I only see
informaiton store. is this the one?
You can dismount and remount an ind. mailbox/public store or stop and
start the Information Store which essentially controls all the stores.
On 30 Jan 2005 17:38:35 -0800, email@example.com
>how do i restart the mailbox store? Is this a service? I only see
>informaiton store. is this the one?
...Problem converting from Quicken to M2005
My Quicken files are mostly investment related, and generally
converted fine. However all bonds (regular and muni's) converted as
Investment type: Mutual Fund, not Bond. (1) How do I prevent that, (2)
How do you change the Investment Type for an item? Thank you.
In microsoft.public.money, Mike wrote:
>My Quicken files are mostly investment related, and generally
>converted fine. However all bonds (regular and muni's) converted as
>Investment type: Mutual Fund, not Bond. (1) How do I prevent that, (2)
Money typically converts custom data types from Quicken into funds.
I thou...Can I import a windows explorer list of files into an Excel sprea.
I was wondering if it is possible to import the list of files within a
particular folder that one sees when using Windows Explorer, into an Excel
spreadsheet? I am using WinXP and Office2003.
modify to suit
Dim iCtr As Integer
.LookIn = "c:\aa"
.SearchSubFolders = True
.Filename = ".xls"
If .Execute > 0 Then
For iCtr = 1 To .FoundFiles.Count
Cells(iCtr, 1).Value = .FoundFiles(iCtr)
donaldb@281....permission to create mailbox in Ex2K3
our desktop support creates user account in AD OUs. They have full
permission for OUs as OU Admin. Now, we need to give them permission to
create mailbox when set up new user account. As for the permission what
should I do? I looked at Exchange Delegation but no quite clear about
mailbox creation permission. Can someone let me know what to do and how to
There are several AD attributes that this delegated accounts needs
write access to. I have tried previous suggestions in the past by
creating a delegated account in AD giving him account management role
and giving the...Convert
Is it possible to convert a Money file created in the USA version to that of
the UK version?
Thanks in advance
The general way is QIF Export then Import. It's involved and has limitations
like loan accounts don't QIF. See http://www.bollar.org/msmoney/#Q1.
"Crispy" <firstname.lastname@example.org> wrote in message
> Is it possible to convert a Money file created in the USA version to that
> the UK version?
...how do i refresh a pivot table drop down list in excel 2003?
when i remove data from my source tab, the entries still show in the drop
down list for the field in my pivot table. i am trying to figure out how to
remove them. i tried removing the field from the pivot table, refreshing the
pivot table, and then placing the field back in. that only works sometimes.
...Inventory list columns
There needs to be more columns avaialble in the inventory and other lists.
It would also be nice to be able to print from the inventory lists.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en...Numbers converting to decimal
I a trying to figure out why when I type 11 and
automatically converts it to .11, if I type 11. it will
stay 11,if I change all the cells to text then back to
number they willstay.
I have checked the formatting of the cells, it even
happens when I open a brand new worksheet.
Tools>Option>Edit, uncheck Fixed Decimal
Microsoft MVP - Excel
"DawnP" <email@example.com> wrote in message
> I a trying to figure out why when I type 11 and
&...Converting Quicken 2004 to Money
Quicken 2004 has many bugs, and I have had it. The most
recent being that it doesn't work AT ALL now that it is
the year 2004. I have had to change the date on my
computer today to open it. I want to get Money instead,
however I do not know if Money can get my data from the
2004 version. Does anybody know for sure?
Yes is the answer to the question you posed. No is the answer to the
question you are getting to but didn't pose. M04 imports Q03 and earlier. If
the past predicts the future M05 will import Q04.
"Colin" <firstname.lastname@example.org> wrote ...