date taken for photos copied
date taken for photo copied, actually modified date on any documents copied
in explorer tends to changed to the Now (date and time of copying).
especially annoying for folders
anyway to change this default behaviour?
On 5/25/10, GS posted:
> date taken for photo copied, actually modified date on any documents copied
> in explorer tends to changed to the Now (date and time of copying).
> especially annoying for folders
> anyway to change this default behaviour?
Use the value in the metadata (tags)?
Gene E. Bloch (Stumbling Bloch)
anyway to cha...Differences between MFC, Win32 API and .NET?
Hello, I am new to windows development. I was curious if someone could
give me a brief summary of each of the topics? .NET, MFC and Win32API.
Also, someone told me that not many people use the MFC anymore, and
everyone programs with .NET. is that true?
My two cents:
Win32 API is the interface (functions) that Windows exposes so you can
create your applications (Application Programming Interface). This was the
way to program apps back in the day with C. To make programming easier,
Microsoft developed MFC (Microsoft Foundation Classes) to make Windows
programming easier, and it worked...Conditional formatting: How to set condition "formula" with is "date" formatted
I want to use Conditional Formatting. I opt for "formula". The
condition should be that a cell F9 that is formatted to Date 14-Mar-07
(see cell format) need to be filled with a date (any date). If empty
What is the formulah I need to fill in. DATE(F9<>0) failed for me.
This is the condition that is set for cell H9.
(there's no email, no snail mail, but somewhere sho...Why is printed page different than print preview?
I have a newsletter that I mail merge with an Excel file. Last month it
printed fine but this month several things change when I print. I previewed
one of the merged newsletters and it still looks fine. But when I actually
print SOME of my indentations have increased causing me to lose wording.
Since everything looks fine in Publisher program I don't know what to do to
correct, changing spacing won't help. Any suggestions?
Microsoft Office Publisher 2003 and older are critical about printer
drivers. Usually upgrading (or downgrading in some cases) will fix
the problems you ar...setting notice to group (large company, recipients in different cities)
I'm sorry for the multiple groups. I don't understand Outlook well enough to narrow down my groups to just the right one or two.
Here's my situation and my question -- there are certain deadlines and tasks that are due on a monthly basis, all revolving around
certain business days (related to closing the corporate books). Presently these deadlines are on an excel based calendar located on
the intranet, and a monthly email reminder is sent out restating the deadlines. As you can see it is somewhat awkward to force
people to navigate through the intranet and then print out th...choice from a drop down list returns a result to a different cell
in the drop-down box when you make a selection such as "repair" "customer
service" or "rental" I want it to return contact info that would be different
for each possible choice but to display in the adjacent cell. Seems that
that this should be easier than it is turning out to be. Any suggestions???
Use a lookup formula in the cell with contact information, so it looks up
the appropriate value from a table based on the selection in the dropdown.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - ...annualize sales for remainder of year
I have a figure for YTD Sales and am trying to calculate estimated annualized
sales off of this. And, this will change monthly as sales managers update
their YTD sales to actual for the prior month end. Mathematically, the
formula would be: YTD Sales + ((YTD Sales/# whole months passed) (# whole
months remaining in year)).
You have not given us any clue as to how we know the number of month's of
data that has been entered.
a) if this is based on the current date; let N moths have passed then your
=ytd +(ytd/N)*(12-N) which is the same as 12*y...Save in different folder
I want to save a workbook in a different folder. The folder already exists,
and I want to use the same file name. What is correct code to do this?
Try code like the following:
Dim NewPath As String
NewPath = "D:\Temp\" & ThisWorkbook.Name
Change the "D:\Temp\" to the full folder path to which you want to
save the file.
Microsoft Most Valuable Professional,
Excel, 1998 - 2010
Pearson Software Consulting, LLC
On Sat, 22 May 2010 13:2...different fiscal periods
Set different fiscals period template for dfferent users.
I understand that CRM can set the fiscal period but i cant set a different
fiscal period for a second user.
Coz users have differnet fiscal period quota
Please tell me that there is a way around this??
...Difference in behavior or ProjectPercentCompleted and ProjectPercentWorkCompleted?
I'm sure of the implications, but not sure about how these two
attributes actually differ from each other in behavior in project
server. Are they basically the same? When would you use one
column over the other in the reporting database?
These two fields correspond with the Percent Complete field and the Percent
Work Complete fields you see in Microsoft Project. Percent Complete refers
to the percentage of the Duration completed for a task or for the project,
and is calculated using the formula:
Percent Complete = Actual Duration/D...Date() Not Working in 2007
Anyone know why Date() does not work in 2007 Access and what has replaced
I don't have ac2007 but I suspect Date() works as it always has. Do you have
any reference problems?
Does it throw an error?
>Anyone know why Date() does not work in 2007 Access and what has replaced
HTH - RuralGuy (RG for short) acXP WinXP Pro
Please post back to this forum so all may benefit.
Message posted via AccessMonster.com
...Date and Timestamp in Filename
I have a spreadsheet that is modified several times a day
and by several people.
Is it possible to somehow insert the date and timestamp
(perhaps with a macro?) into the filename?
It is very difficult to get users to use
abbreviations/version numbers etc to show when the last
modified spreadsheet was used - many "forget".
If there was a way that automatically put the date and
time into the filename then users will know which is the
most recent document to use - and not have any excuses!
many thanks peeps!
ActiveWorkbook.SaveAs Filename:=sFilename &...X axis collapsing to date on hourly data
I have a spreadsheet I am trying to chart that has values by date and
9/17/07 20:00, 1
9/17/07 21:00, 2
9/17/07 22:00, 4
9/17/07 23:00, 1
9/18/07 00:00, 2
9/18/07 01:00, 1
9/18/07 02:00, 0
When I highlight all of the above and select "Insert Chart" and choose
line chart, it creates the chart as if it had the following
It also looks more like a bar chart then a line chart. Anyone have an
idea on why this would happen and how to fix it?
I am mistaken, it is collapsing into all 24 series...One Bank, 2 Accounts, 2 Different logins
Hope this hasn't been posted before. I did a search and
did not find it.
I have 2 accounts with the same Bank but I have a
different login id and pass for both accounts. How can I
set it up to download for both accounts? It seems the
program is set so that it assumes that if your dealing
with one Bank online that you will be able to access all
your info though one ID.
Thanks in advance for any help.
In microsoft.public.money, JDickens wrote:
>Hope this hasn't been posted before. I did a search and
>did not find it.
>I have 2 accounts with the same Bank...Month display to show in the Inbox
Do you know of a way to diplay the month at the top right
of the screen while in the Inbox? Thanks
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 account will be deleted
"DC" <email@example.com> wrote in message
| Do you know of a way to diplay the month at the top right
| of the screen while in the Inbox? Thanks
>Milly St...How do I sort by month and day
I want to sort multiples dates by day and month, but NOT year. Basically to
put all of our birthdays in order for the year.........
Let's assume that all your dates are some column, say column B
In another column, enter the formula =MONTH(B1) and copy down.
In a third column, enter =DAY(B1) and copy down.
Then sort the data by month and then by day.
> I want to sort multiples dates by day and month, but NOT year. Basically to
> put all of our birthdays in order for the year.........
> I...addendum to 'Monthly Budget 2006 Retail', Post
MS MONEY 2006 - RETAIL
Every step of the way - an adventure !!
Under the ACTUAL TOTAL INCOME figure of the "Monthly Budget Report",
there is a greyed out figure of $500 which does not figure in to the
Grand Totals of the Budget Report. I found out the source but I don't
understand why, or how to get rid of that "ghostly" figure.
These are the actual entries I made:
ACCOUNTS - CHECKING
OTHER INCOME - Credit $527.
OTHER INCOME - Debit 500.
Balance in OTHER INCOME ...emails appearing after 4 years, again! #5
I've recieved an email that was sent to me 4 years ago, in
my Inbox. What causes this? The Sender is still working
with me and he definitely does not have a copy of the
...Contacts' Modified Dates Change After Opening
This problem popped up 3 days ago, I don't know what triggered it.
After I double click on a contact, to open it, the modified date for this
contact is updated to the present date and time, although I did not modify
the contact. Right after I open it, its modified date is altered.
I want to avoid this as I often use a "sort by modified date" view.
Please help me solve this problem
If you open something in OL the modified date is changed, its default/std
"grendi" <ufoREMOVErobotTHISgrendizerusTO@CONTACTyahoo.MEcom> wrote in
messag...Date in forms
I would like to have a command button that I could use to insert a date in a
the date would be for scheduling events at the beginning of each week, hence
I would like the dates to be for the beginning of each week. First date
could be 04-mar-07 the next record in the date column would be 11-mar-07.
Each record would have the beginning of the week date.
Message posted via AccessMonster.com
...Differences between Tasks and Reminder/Meetings
from the moment I started using Outlook I have used the Calendar to
store my personal activities (i.e. "backup", a reminder which repeats
However, I read that tasks are more suitable for personal activities.
What's the difference between tasks and reminders/meetings? How do you
which version do you have?
Here are some tips about how to post questions:
Trainer and Consultant
There are various articles about using Outlook here:
Ca...Auto input days of week
Hi, I'm looking to set up a spreadsheet where users enter new months
date in cell A1, I have worked out how to auto input dates down the
rest of column A but need to fill in days of week in column B. I'm
trying to automate process as not all users proficient with excel. It
needs to work for any month. Any help would be much appriciated.
brom0910's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27416
View this thread: http://www.excelforum.com/showthread.php?threadid=49...Allowing only Date and Integer for user form
I have a user form and as part of the procedure when I click OK is the
'Make sure a number is entered
If TextName1 = "" Then
MsgBox "You must enter a number."
'Transfer the number
If Range("M5") = True Then Range("O5") = TextName1
If TextName2 = "" Then
MsgBox "You must enter a date."
'Transfer the date
If Range("M5") = True Then Range("P5") = TextName2
1. I would like to make sure that only an integer is...OUTLOOK firstname.lastname@example.org frustrating day
my pop3 password verification on msn.com isn't working today. msn denies
there is a problem (email email@example.com). So I switched from pop3 to http. and
my mail is coming in fine. only problem is that when I read the mail each
message is automatically moved to the deleted folder and I can't, for the
life of me, figure out how to stop that (Newest Outlook with all service
pack upgrades. "Old pop3" did not delete message upon read).
thanks in advance.
This is a multi-part message in MIME format.
charset=&q...Difference within HTML/Rich Text/Plain Text
Could anyone explain me the difference between the three mail format (HTML,
Rich text and Plain text) and wich do you recommend the best?
Use plain text unless you want to set the format of your text, as in
specifying the font, using italics, etc, in which case you'd probably use
HTML. Generally, you'll only use rich text if you're on an Exchange server
and sending messages to others in the same organization.
Having said all that, I admit that I prefer using rich text as it just works
better in Outlook 2003. The real answer is use whatever you prefer.