microsoft outlook date and time incorrect
Please guys everyone knows about the date settings on microsoft outlook so
this fault is alittle harder than that to locate.
Emails while in your own computer or sent to yourself have the correct date
When opened in the receiving computer it has the correct date and time.
But as listed unopened in the receiving computer it has the incorrect and
date might be the previous day or the next day.
Tme has no relationo time sent.
This Microsoft outlook using office 2000 or office 2007 on the same
Any advice appreciated.
It would be best to ask this...getting a list of permissions on a folder
using 2008r2 now. I need to get a list of users permissions by folder and
We have a shared folder called Public and under that is subfolders with many
different folders and different permissions for each folder.
Does 2008R2 have an easy way to list the permissions for a folder?
I don't know how to use powershell so what else would be available to do this.
Thanks in advance for your help on this.
"Sher" <Sher@discussions.microsoft.com> wrote in message
> Hi all,
> u...find next number in list
I am using excel to maintain a list of dvds I rent online, and the order
in which they are sent to me. There are three columns: first the number
the dvd has in my list, then the title, and lastly the number of when it
was sent, something like this:
1 dvd1 3
2 dvd2 1
4 dvd4 2
Now, when I receive a new dvd (in the example: dvd3), I want to add the
next number (here: 4) to the 3rd column. When the numbers get higher it
gets harder to find the next number manually. Is there any way to
automatically find this number, without using macros (for which I am too
...searching a column for duplicate, then replacing the row.
i have a userform that pulls in information from a row on
workbook(1).sheets(1) column A contains a list of numbers.
userform1.listbox1 has a list of all the numbers in column A
when the listbox1 is clicked it fills in all the appropriate control
with what is in the other columns on the same row. column A number i
placed in textbox1 on userform.
right now, after changes to the form and the user clicks th
commandbutton to save. it creates a whole new row with the same numbe
in column A, so i have duplicates.
is there a way to replace the entire row instead? with a msgbo...Counting only uppercase letters with wildcard in column/row
I'm working with columns and/or rows containing both upper and lower case
letters with wildcards. I only want to count upper case letters with
wildcards. Any help to this problem will be greatly appreciated. BTW I'm
using excel 2007. Thanks!
Post the formula that you are using now that counts all cases
"TJA" <TJA@discussions.microsoft.com> wrote in message
> I'm working with columns and/or rows containing both upper and lower case
> letters with wildcards. I only ...Hiding columns
Hi there all,
I've got a tiny table in excel, I've hidden all the rows
below the used ones to make it look nicer.
Why can't I hide all the columns I don't want to use?
"Peter Fossey" <firstname.lastname@example.org> wrote in message
> Hi there all,
> I've got a tiny table in excel, I've hidden all the rows
> below the used ones to make it look nicer.
> Why can't I hide all the columns I don't want to use?
You should be able to do this. What happens wh...Date Format #18
I got a workbook that was done on English PC, but the ender user wil
be using thier PC with Spanish setting, the issue is the date format i
English is (mm/dd/yy) MONTH, DAY, YEAR but in Spainsh it's (dd/mm/aa
DIA, MES, ANO . . . the main problem is the "YY" (YEAR) vs "AA" (ANO
if a spanish PC is used and a date is entered it will cuase a erro
like this "JAN-01-YYYY".
1- If there a way to force an English date format in this workbook an
turn back Spanish.
2- Is there a VB solution to this.
3- I should I resort to a DATE forumla, e.g. drop box...Make rows be columns & vice versa
I have a spreadsheet that I need to make the columns into rows and rows
into columns. Does this make sense and if so, how to I do it?
Message posted from http://www.ExcelForum.com/
not quite sure but have a look at 'Edit - Paste Special - transpose' to
transpose a copied range
"rebeccaford >" <<email@example.com> schrieb im
> I have a spreadsheet that I need to make the columns into rows and
> into co...List and data storage
I'm creating a new site where many of the fields will reference OTHER
lists - for example a list of clients, a list of employees, a list of work
Is there a best practice for "storing" these standalone lists that will be
referred to by OTHER lists but not exposed directly to the end users?
For example, is it common to create a "hidden" site with lists and data that
is used this way but not exposed?
Many of these lists will be referenced from multiple "applications" on the
"Gavin Steiner"...List control Full Width Selection
How would I enable 'full width selection' in my list
control? I.e. when in report mode, clicking in any column
will select the item and the selection highlight spans
the entire list control rather than just the first column.
Sorry, a little more investigation and I found it...
// Get the list view and control
CListView *pLV = (CListView*)GetDlgItem ( IDC_RESULTS ) ;
CListCtrl &rLC = pLV->GetListCtrl() ;
// Set full-width selection
rLC.GetExtendedStyle() | LVS_EX_FULLROWSELECT );
This is a multi-part message in MIME format.
Windows XP, Office 97 (or Office 2003)
Trying to track and record the number of visits a person has made. =
Plus, record the date of
all their visits. Here's what I'd like to do. =20
Have Column D record the last date a person attended, and Column E to =
show the total visits.
I want to enter the latest date in Column D, visibly replacing that =
date, but retaining history for
all dates visite...date data type is not a date??
Following is code I am running. I intend to compare two dates. One date
(orderrg.value) is from a spreadsheet and is defined as a type date. The
other date is the system date. However when I check to see if the
orderrg.value is a date via ISDATE, it fails. Following the code is the
prinout from the immediate window. It looks to me like it should be able to
recognize it as a date, but yet it doesn't. Does anyone have any ideas?
Private Sub Workbook_Open()
Dim wscommission As Worksheet
Dim nindex As Integer
Dim lastorder As Integer
Dim sheetname As String
Dim orde...Blocked Senders List 12-29-09
I put an e-mail address on my blocked senders list, but now I want to take it
off-how do I do that?
Tools | Junk E-mail Options | Blocked Senders. Find the address and remove
Imperial Beach, CA
"5hulses" <firstname.lastname@example.org> wrote in message
>I put an e-mail address on my blocked senders list, but now I want to
> off-how do I do that?
"5hulses" <email@example.com> a ...two servers shut down at the same time?
I have two new HP ML 350 servers, one has been up a couple days, the other
has been running for a couple months. Yesterday, they both went down at 2:40
PM, within 20 seconds of each other. It looks like a power failure, but they
are in different rooms, each with it's own APC SC1500 UPS. There was no
power interruption at the time, machines not on UPS never went down. Log
files only say unexpedted shutdown possibly due to crash or power failure.
What in the world could have caused that? Do I have two defective UPS's?
"dlw" <firstname.lastname@example.org....Calculating Days Between Dates
I use the following formula to calculate the days between dates and to
return zero when dates are the same �
How would I also allow for the eventuality where the date in cell A2 is
earlier than A1 and where the result would then be a minus figure ?
At present the formula returns a "Num" error when this happens
martins's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31616
View this thread: htt...top menu shows two 'file' headers and dropdowns
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
when I open Word, the top menu bar shows <br>
apple word file file view insert etc <br>
in other words, two file headers and the dropdowns beneath them. <br>
the dropdowns differ slightly from one another <br>
otherwise, Word seems to be working fine, <br>
I don't like the look of it, though. <br>
Any solutions gratefully received. Am happy to send a screen shot to illustrate the point, if that would help. <br>
First, try a "Power-off rest...Two copies of same ON 2007 notebook open
Onenote 2007 SP2
Windows 7 Home Premium 64-bit
Login is an admin account
Sometimes when changing sections within a notebook, Onenote is bringing up a
dialog asking whether I want to open the whole notebook, or just a section.
The notebook I would be opening is the same one I'm already in. Choosing to
open the whole notebook, I get another copy of the same notebook listed in my
Notebooks bar on the left of the screen, which then starts synchronizing..
apparently with itself.
Checking the properties, the location of my original notebook is what I
expect it to be, in C:\Us...Keeping past appointments longer than 3 months?
After three months, my outlook is removing past items in my Calender and this
is causing me real problems as I'm a contractor and need to know the days I
worked for upto a year (or more). I cannot find the settings in Outlook to
leave the appointments in the Calender. I don't want to archive them, simply
leave them in the calender indefinitely.
Any help would be much appreciated!
Thanks in advance,
"V" <V@discussions.microsoft.com> wrote in message
> After three months, my outlook is re...Where to get Excel spreadsheet listing all GP tables for v10
Is this spreadsheet on the sdk? Is there a way to get it without
installing the sdk? That is, from a download off MS site or
PartnerSource or CustomerSource ?
The spreadsheet is available from the DynamicAccounting.net site or
via direct download at http://www.box.net/shared/jc90kdsh2k.
I built it. It's a re-presentation of the information found in Tools-
>Resource Descriptions->Tables in GP. There are version for GP 9 and
GP 10 and I'll have one for GP 2010 once it is final.
On Feb 3, 2:01=A0pm, hdjim <hdji...@yahoo.com> wrote:
> Is...available columns in ADUC
In ADUC, from "View" -> add/remove columns I can't see some useful columns
such as mobile number and fax number for user objects. How can I add them to
the available columns list?
On 11.03.2010 04:35, tree leafs wrote:
> In ADUC, from "View" -> add/remove columns I can't see some useful columns
> such as mobile number and fax number for user objects. How can I add them to
> the available columns list?
Paul has a good article on this:
http://pberblog.com/post/2009/06/21/Add-extra-columns-to-Active-Directory-U...FORMULA HELP! Find all values in column at random rows and perform calcutlation.
1000 Total of formula here.
I don't know what row a % number will show up on col A but it is before row
1000. I would like row 1000 under column A to have a formula that says
look for any row in column A and if you find a number, add 1 to that number
and then find the next one and add 1 to that number and then multiply those
two together and then find the next one add 1 then multiply to the last
Bascially, A100 would have the formula (1+A3)*(1+A6)*(1+A9)*(1+A12)...e...Money 03, how to extend date range for cash flow scenario?
Hi guys, as above.
I am presented with only a 2 month timeframe when I try the
cash flow scenario.
How can I set it so I can have a 12 month timeframe?
If, by cash flow scenario, you mean the forecast cash flow graph, go to
Forecast your cash flow and manipulate the Time Period just above and to the
right of the graph. This allows a whole bunch of choices up to Custom.
"Buck Rogers" <email@example.com> wrote in message
> I am presented with only a 2 month timeframe when I try the
> cash flow scenari...Update field w/ string based on service due dates
I have a form that provides a listing of various instruments that are
serviced on a monthly to annual basis, with general info about the
instrument, last and next service dates, etc.. What I am trying to
is create an On Open event procedure that will identify all
instruments that are listed with a string of either "Past Due" or
"Schedule Vendor" based on whether each of their respective 'Due'
dates have already transpired or not from the current month.
The code I initially created for this was as follows:
Private Sub Form_Open()
Dim myDate, myDue
I have 10 columns with 30 entry cells. Some cells have a single word other
I want to copy all words to a single colum and them alphabetize them
try this it copies the first 10 columns to column 11 omitting blanks
Dim NewRow As Long, NewColumn As Long
Dim X As Long, Col as Long
NewRow = 1
NewColumn = 11 'Change to suit
For col = 1 To 10
For X = 1 To ActiveSheet.Cells(Rows.Count, col).End(xlUp).Row
If Cells(X, col) <> "" Then
Cells(NewRow, NewColumn).Value = Cells(X, col).Value
NewRow = NewRow + 1
...alphabetize entire rows by first word of first column
I want to make a list of names and addresses putting name, address, city,
state, zip across in separate columns. Is there a way to attach these so
that when I alphabetize the names each of the cells in the row stay with the
When you go to alphabatize, aka sort the data, make sure you select ALL of
"Cindy Sue" <Cindy Sue@discussions.microsoft.com> wrote in message
>I want to make a list of names and addresses putting name, address, city,