Tech Problem Aggregator

Solved: Access - Closed Date/Time Stamp

Q: Solved: Access - Closed Date/Time Stamp

Ok, here is what I have.

An Access Database that will allow for "Trouble Tickets" to be issued.

The way I have it set up now is a Status. This tells if the Ticket is Open or Resolved.

What I also have is a "Closed Date" Field, what I am trying to do is set it up so that if the Status is changed to Resolved, it will put the "=NOW()" in the Closed Date field.

Any suggestions. Everything seems to work fine, with the exception of this.

Thanx in advance.

A: Solved: Access - Closed Date/Time Stamp

13 more replies
Answer Match 97.02%

Hello,

I have a JVC Everio GZ-HD10U camcorder that I am recording videos to MicroSD card. Upon transfering the video on my computer via sd card, I am unable to make the date/time stamp show up on the video. I have attempted using Windows Live Movie Make and Pinnacle software (Avid Studio) and have had no luck.

I am running Windows 7 64 bit with 4gb of memory. Has anybody figured out how to get the date/time stamp to show up on the computer?

Thanks in advance for your assistance.
 

A:Solved: Date/Time Stamp from Camcorder to Computer

7 more replies
Answer Match 97.02%

I never seem to know where to place the IFs. I yoinked the 2nd part of this code from somewhere, then added it to my existing code. It doesn't work, of course.

Code:
Option Explicit

Private Sub Workbook_Open()
'When workbook is open, if the date is blank, enter it
If Range("qadate").Value = "" Then Range("qadate").Value = Date + Time

'If the workbook is the "template", do nothing
If ActiveWorkbook.Name = "QA-Hosp" Then

Exit Sub

'If the workbook is NOT the template anymore, username & time/date stamp it

' Stores who and when on Record Sheet, column A
Sheets("Record").Select

If Range("A65536").End(xlUp).Row = 1 And Range("A65536").End(xlUp).Value = "" Then
Range("A65536").End(xlUp).Value = Environ("Username") & " " & Now
Exit Sub
End If

Range("A65536").End(xlUp).Offset(1, 0).Value = Environ("Username") & " " & Now
End If
End Sub

I very much appreciate any help!
 

A:Solved: Workbook_Open Username & Time/Date Stamp

Looks like you need to move the End If to the line after the Exit Sub. Otherwise it is effectively exiting before running any further code in any case.

I would also consider changing your code so you are not selecting the Records sheet:
Sheets("Record").select
I would declare Records sheet as a variable instead:
Dim Record as worksheet
set Record = sheets("Record")
You can then change these references:
Range("A65536")

for
Record.[a65636]
 

3 more replies
Answer Match 97.02%

Having a problem transferring the date and time stamp from Cannon ZR90 to DVD. Video and sound transfer perfect. I turn on the data code on the camera, still no transfer. I have tried several software programs such a ULEAD, Pinnacle and others. My computer is a Dell Inspiron 8100 and I am using a Firewire. Help.
 

A:Solved: Date and Time Stamp from Cannon zr90 to DVD

8 more replies
Answer Match 94.92%

I have the following macro below which works great for when any value is entered in Column C, it time/date stamps the adjacent cell in Column D. However, I need it to do the same thing a few columns over (ie, when any value is entered in Column H, it will time/date stamp the adjacent cell in Column J)

For the life of me, and cannot get it to repeat . Any ideas? I'm a bit new at this, but thanks in advance for the help. Feel free to spell it out - I won't be offended.

Thanks! Here's the current macro:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
With Target
If .Count > 1 Then Exit Sub
If Not Intersect(Range("C3:C9999"), .Cells) Is Nothing Then
Application.EnableEvents = False
If IsEmpty(.Value) Then
.Offset(0, 1).ClearContents
Else
With .Offset(0, 1)
.NumberFormat = "dd mmm yyyy hh:mm:ss"
.Value = Now
End With
End If
Application.EnableEvents = True
End If
End With
End Sub

 

A:Solved: Excel Macro - Repeat Time/Date Stamp for Different Column?

6 more replies
Answer Match 93.66%

So I'm pulling in a date in the format (MM/DD/YYYY HH:MM:SS AM/PM) Is there a way that when I use a make table query, it only returns the Hour in the format of a number in the field instead of the date stamp?

So:

submit_date
8/20/2008 10:59:27 AM
8/20/2008 11:00:10 AM
8/20/2008 11:01:27 AM

Would be in the new table as

10
11
11
Is this possible?
 

A:Solved: Date Stamp to Hour Conversion -- Access

10 more replies
Answer Match 90.72%

Has anybody else experienced this problem?

I open Event Viewer - "Admin View" to see what Errors/Warnings are there and in the column - Date and Time only the date is showing. Same goes for all the other views.
The "Time" element seems to have completely disappeared.

Any idea where its gone........... and more importantly, how to get it back?

Thanks

A:Time stamp missing from Date and Time column - Event Viewer

Problem solved - but - I don't know why.

Solution:- I changed the Date/Time format from UK to US, opened Event Viewer and it was as it should be. Date & Time showing.
I then changed format back to UK, opened Event Viewer and , as above, the Time was back up.

If anybody knows what had happened I would be most interested.

My thanks to Bill............. from another site for helping me out with this one.

1 more replies
Answer Match 89.46%

When I take a picture with my Android phone, the date and time when the picture was taken is recorded, in the filename as well as in the JPG picture-file itself; all very convenient. To my horror I noticed that my phone reacts in an idiotic way to the GSM connection being lost: the date of the picture is 'reset' to, apparently, the date the device was manufactured. Subsequent pictures apparently start counting from there. This completely messes up the chronology of my pictures: all pics taken with no GSM connection end up with date/times on the same day, years ago.
I completely fail to understand why this is so and would like to know if this behaviour is particular to my device or if others experienced the same thing. Is it a bug or a feature?
I experimented with various methods to set the time: manual, from GSM-network or from GPS. I would have thought that using manual or GPS would remedy things, but it didn't. (Although it had some effect on Daylight Saving Time issues, but that's another story.)
 

More replies
Answer Match 89.46%

I have photoshop Elements 1. How can I get the date and time stamped on the photos that I want to print. I know that running the curser over the picture, they show up but I want it on my prints. Is there a way to automaticly do this other than using the text tool.
 

A:Date & Time Stamp

15 more replies
Answer Match 88.62%

Anybody else noticed that after the summer-time change, Win XP has changed the TIME STAMP on all files. I think this only happens on NTFS partitions, but the effect is that all backups held on non-NTFS partitions now appear to be an hour old. This is just STUPID, and can anybody tell me if this is intended, and if so what conceivable reason can there be?

better yet, can we do anything?
 

More replies
Answer Match 88.62%

i found some disturbing searches in my google toolbar and i need to know if there is a way to find a date and timestamp for these searches. i'm worried that my children are visiting improper sites when i am not around. any help would be greatly appreciated!!!
 

A:date and time stamp for a search

I am not sure about a search time stamp... but if you check the history of the browser, you'll prolly find the websites they visited.

While ur browser window is active... prest Ctrl + H
Then sites that have been visited will show up at the left side of the browser (this all depends on your browser settings)

hope that helps!
 

1 more replies
Answer Match 87.78%

I'm using XP outlook express and I noticed the other day my incoming emails don't have a date or time under the receive column. Someone please tell me why or how to fix. Thanks.
 

A:No date & time stamp in Outlook express

bump
 

1 more replies
Answer Match 87.78%

I am searching for a little freeware utility that will let me insert the date and time into an MS Word, Wordpad, or Notepad document. Does anyone know of a utility like this? Thank you in advance for any reply.
 

A:Need freeware date and time stamp for Word

You don't need any additional software for this.

For Word and Wordpad:
Just select Insert Date and Time. Then select the format you want to use

For Notepad press F5
 

3 more replies
Answer Match 87.78%

Using VISTA, why is the time and sometimes the date incorrect on the temp file log. How do you fix it? the laptop clock is correct, the comuter is dell vista laptop, ...whne I did a file recovery I noticed that many files were "accessed" on a hour time delay, say I was on internet at 9pm, it lists it as 12am. I checked many other days and this problem was everywhere. why and how to fix. thanks

A:fix time date stamp on temp files

What/ where is the "temp log file"?

Are you sure that you are looking at "last access" date vs. modified, or other dates?

Please post that log.

jcgriff2

.

2 more replies
Answer Match 87.78%

Hi,

I have a situation where a new user has managed to set all 2000+ emails in their bosses inbox (in Outlook 2003) to Read - the boss is not happy. I have explained until I'm blue in the face that there 'may' be better ways to organise their emails...

Does Outlook record a time / date stamp for WHEN an email was marked as read / unread, and is it possible to filter by this so we can effectively select & set all emails not Read before a certain date back to UNREAD.

And save a trainees job.

OldRedEyes
 

A:Date/Time stamp for Read in outlook

nothing? anyone?
 

1 more replies
Answer Match 87.78%

Hi there,

Thank you in advance for checking out my query.

I rarely have the opportunity to use VBA so I apologise for my ignorance in advance

In the attached file I am trying to setup a few things ... tried several different codes from other sources, but weren't successful ... so I deleted the codes to avoid confusion (I am already massively confused.. I have been at this for the last 6 days and nights ... and I'm getting stressed out!).

Since there are a few things that I would like my form to do, I realise that if anyone is going to help me out, I will need to just ask for the most urgent items that are essential and have to wait with the other fixes.

There are 4 main fixes that I'd be immensely grateful for are;
The User enters a 4 digit code into a textbox named txt_SAC_No when that has been entered I need the textbox txt_SAC_Address to perform a Vlookup a named range (SiteNameADDRESS) and display the data in the textbox.
The reason for the result to be displayed in the textbox is because some codes are not listed and users will need to enter in the information manually.
I do not want the information that the user manually enters to be added to the named range.
If it is possible to have the next available Security Incident # (which is setup in Column A on the Incident Details spread sheet) when the user opens this form
Setup a Date and separate Time stamp to activate after the user has entered their name into the lbl_INC_Recorded_By textbox -... Read more

A:How to do a Vlookup in Userform, Date & Time Stamp

OK... it was all about size

I have taken all the unnecessary stuff out of the file ... so there is only the bare minimum in there... which should not affect the form or fields etc.

Small win for me today

Please let me know if you need any further clarification or information
Thank you again

Shybutterfly
 

1 more replies
Answer Match 86.52%

Hello,

I have a new computer with Windows 7 on it - and I want to copy the files from my old computer to my new one. I'm looking at copying about 300 GB worth of data.

When I copy all files and insert them onto my new desktop, I notice that all of the date/time stamps are changed to today's date.

Is there a way to preserve the date/time stamp for each file, so that it keeps the original one?

Thanks!

A:Preserving date and time stamp on all files copied?

If you right click the folder, then select properties It should show:

Created: (This will be the date you copied it over)

Modified ( aslong as it hasn't been modified on the new machine, IT should read the date it WAS last modified?

Accessed: It should show when the folder was last accessed (opened)

In regards to "perserving the date/Time Stamp. I'm not sure this is possible.
You can always try checking the Modified Time/date ( mentioned above ) then add the date to the file/folder name. SO you always have a refferance.

3 more replies
Answer Match 86.52%

I have a program that runs on a XP platform on several computers.
There is one computer that has a weird problem.

The program shows the time and date of the computer, which is the actual time and date.
The program can create bitmap images and text images.
When I click on the export button, the program will save the BMP and TXT files to the Harddrive with a total different date/time stamp.
The program wil export the BMP and TXT files with not only a filename, but also a date/time stamp (the correct one).
It will be exactly one hour and one day earlier.

This is not correct, because the computer has the current date and time, but Windows labels the files with a wrong date/time stamp.

If I open Windows Explorer, I can see the files listed as:

filename200908201250.BMP Bitmap Image 12KB No 302KB 97% 8/19/2009 11:50 PM

It will not impact the problem if I change the BIOS and Windows time.

Did anyone have this effect ever before and can it be a virus ?
The problem is, once in a while, I will loose BMPs and I cannot find them anymore.
 

A:Time/Date Stamp in XP shows 1 day and 1 hour difference

The problem is not the time difference itself.
The big question is, how is it possible that the program takes the time from Windows, displays it correctly in the program, saves the files with the correct time and date, but shows in Windows Epxlorer to be created on a total different moment ?
The exact same program is installed on many more computers and they don't have this problem.
I have replaced the program, Windows, HDD and the computer motherboard without success.
Could it be a virus causing this ?
 

1 more replies
Answer Match 86.52%

When I create a file in Windows 7 and save it I get the current date and time stamp but when I edit the program at a later time and date and save again it doesn't change the date and time stamp it stays the same as the original file! I feel like a moron but how can I change this?

A:Change date and time stamp on file save...

Hi Dave,

Presuming you have made changes to the file that require saving, the date and time should indeed change. See the image below : do you have the Date Modified, or Date Created option showing?

3 more replies
Answer Match 86.52%

platform: skype, desktop program, not the win8 metro app

ok..buddy of mine, her skype for some reason seems to think its december 8th of all things, we've confirmed the computer's date/time settings are correct...any ideas? I'm quite confused here.

A:skype displaying incorrect date/time stamp

I don't use skype (desktop or metro) but it appears this thread addresses how to change the date/time in a Windows desktop client environment:

date time set - Skype Community

2 more replies
Answer Match 86.52%

I've got the date/time stamp ON in the menu, but a date/time stamp does not appear for a video recorded. Is it only for pictures? I have the extended user guide, but it hasn't helped.

Thanks.
 

More replies
Answer Match 85.68%

This just started.

If I create a new folder in Outlook and move emails there, the date/time stamp of these emails change to the date/time I created the folder.

Doesn't happen when I move them to existing folders though, only new folders.

To see if it's specific to my Outlook, I connected to another on a terminal session and the same problem occurs.

Help!!!
 

More replies
Answer Match 85.68%

HELP!! Does anyone know HOW to customzie the Date and Time stamp on emails in Outlook 2010? I want each and every single email to show up in my Inbox (whether read or un-read/new) as the DATE, i.e. 6/19/2012 9:24am I do NOT want the words "Today" or "Yesterday" or "Tues" - AND - I want the entire DATE to appear and the TIME to appear on every message. I find and sort emails by time and date. I used to have that as a default in Outlook 2003. How do I change the default in 2010 to be what I want?

 

A:HELP!!! OUTLOOK 2010 - Date&Time stamp on emails - can I customize?

9 more replies
Answer Match 85.68%

Hello!

I joined this forum for just this one problem...

My line of work requires that I take before and after photos of everything I do or photos to support the bidding of work to be done. The resolution is required to be 640x480 and the compression set to normal. Most of the time I am taking 100+ photos per job site. Sometimes completing 3-4 job sites per day. Past cameras I have used (Nikon CoolPix) allow the Date/Time Stamp to be a part of the image which is also required by my line of work.

I have been frustratingly searching for the instructions on how to get the Date/Time Stamp to be a part of the image when it is taken for the Olympus Stylus Tough 8000.

I understand that this information is recorded with the image and that I could use a program of some sort to add the Date/Time Stamp myself but due to the volume of images a software solution would no be viable.

Is there anyone that has used or can help find the instructions for enabling a Date/Time Stamp for this particular camera?

Any help is greatly appreciated!

Thank You.
 

A:Olympus Stylus Tough 8000 Date/Time Stamp

8 more replies
Answer Match 85.68%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft® Windows Vista™ Home Basic, Service Pack 2, 32 bit
Processor: Pentium(R) Dual-Core CPU T4200 @ 2.00GHz, x64 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 3002 Mb
Graphics Card: Mobile Intel(R) 4 Series Express Chipset Family, 1308 Mb
Hard Drives: C: Total - 152624 MB, Free - 101762 MB;
Motherboard: Wistron, 3612
Antivirus: Symantec Endpoint Protection, Updated and Enabled

I had my laptop hard drive replaced and part of the agreement included the installation of MS Office Professional. When I went to pick-up the laptop I asked for the MS Office product Key Codes for my records and registration. The store owner said he had already registered the software and it was set to go, just bring it back if I ever needed to reinstall for any reason. I was suspicious as a legal installation would include this information.

When I got the laptop home and started it up, I checked to see the licensing information on MS Office Professional and it was registered to IUWare (University of Indiana), I have reported this to their ITC Support and other security and policy departments. Long story short I am in process of filing a FBI claim against this vendor and a VISA dispute as well. I want to know how I can access the time/date stamp on the initial installation of MS Office Professional on my hard drive and all changes made since that initial installation. The first night I had run time errrors and took the lap... Read more

A:Root Record of Software time/date stamp of installation/changes

If you go Control Panel > Progarms and Features, you can see the date of installation of all software. If the date column isn't showing, right click on the column headers and checkmark "Installed On'.
 

2 more replies
Answer Match 84.84%

I apologize for posting to the "general" forum here - even though my issue concerns gmail, it may have something to do with file handling in Windows 7, so I'm shooting for the broader audience in this forum.

How do I save an attached file from my gmail account, such that the date and time stamp, once saved to my local computer, remains the same as that of the original file?

That's how I just always assumed it was being done, and yet with gmail, the files are saved to my local computer with their save date/time, not the date/time of the actual file.

This is just wrong! If I send a file to 15 people, I want each recipient to have a saved file with the same date/time - not 15 different times based on when they saved them.

What am I missing, to force gmail/Windows to preserve the original file date and time stamp?

BTW, I posted this question to a gmail user forum, and the only answer I got so far is unhelpful, and likely wrong, gobbledygook.

A:Saving gmail file attachments without changing their date/time stamp?

Hi,
I doubt that can happen
At best there might be a universal Date Created or Date Taken on all of the files.
The camera it's self would enter that info "if" the time and date were correctly set on the device.

3 more replies
Answer Match 82.74%

I have a Date/Time field that I need converted to just a Time field.

It comes back with 2/11/12 0:00:00

I need just the 2/11/12

I thought about changing it to a text field but I think there will be an issue with the month because it does not bring back a 0 in from the months with only 1 digit.

This table that I am creating is being sent to a txt file and that is where I see the issue. It looks good in Access, but not the txt file.

Any suggestions?
 

A:Solved: Access - Convert Date Time to Date

10 more replies
Answer Match 78.96%

How do I date stamp with the Canon EOS 550 D? I can find nothing under all five menu tabs. I can set the date and time but I can't put the date onto recorded images. Thanks in advance.
 

A:Solved: Date stamp

14 more replies
Answer Match 78.12%

I've tried to send a delayed email using the "Do Not Deliver Before" function. Hoping the email would be date/time stamped when I wanted the recipient to receive the email. For example, sent the email on a Tuesday and scheduled the email to be delivered the next day (Wednesday) at 10am. The function did delay sending the email, but the date/time stamp was when I originally hit sent on Tuesday. What is the purpose of this feature if the date/time stamp will not indicate the date/time I wanted the recipient to receive the email?

When using this function, is there a way for the exchange to track the date/time stamp of the email when it actually leaves the Outbox instead of when you click send? I understand the exchange keeps track of the date/time stamp of when an email is sent, but why couldn't the exchange keep track of when the email leaves the outbox when using this function? Is there any exchange setup that will make this function work the way it is supposed to? Thank you
 

More replies
Answer Match 78.12%

From viewing previous posts I understand that it is advantageous to disable the titled function. Please tell me how that it done. Thanks.

P.S. What is a poll?
 

A:Disable NTFS Last Access Time Stamp

11 more replies
Answer Match 77.28%

In Excel 2007, Is there a way show a date stamp of when data was entered into a cell? So when you hold the cursor over the cell it shows you the date the data was entered?
 

A:Solved: Excel 2007 date stamp

7 more replies
Answer Match 77.28%

Canon 2SIS

I've figured out how to set the date on the camera and can put a Date Stamp on images after I download them to a computer. I have to run the camera software to do that and then the file is changed from JPG to an album. Don't want to do that.

Does anyone have idea how to set the camera to put the Date Stamp on the image taken with the camera?
 

A:Solved: Put Date Stamp On Original Images?

10 more replies
Answer Match 76.44%

I have a table with a Date/Time field called Date Created, it is in the General Date format, and it is a time stamp (EX: 12/3/2004 3:00 AM). I know that if you have a date field that is formatted as a Short Date you can easily pull records in a query based off of a current date (EX: Date() as the criteria). I have tried using the Date() criteria as a parameter for a query, but I am unable to pull the current date's records. The query will work if I test the "Between #12/1/2004# and #12/4/2004#" parameter range, but I would like to be able to pull records for the current date without having to change the date range or even the date field to a short date in the main table. I've even tried converting the date within a query to display the date as a short date, by adjusting the field properties in the query, but the Date() criteria still doesn't work. Is there any other type of syntax that I could use within the query to make this work? Your help would be greatly appreciated.
 

A:MS Access 2000-Pulling Current Day's Records From Time Stamp

6 more replies
Answer Match 75.6%

Hi.
On a Access form, I'd like to have a control that identifies how long the database has been in operation.
I'd like to be able to say that today is so many years, months & days since a specified date. Better yet, would be to include hours and minutes, or hours to 2 dps.

At present I can only count days, using:
=Date()-#13/02/99#+1 & " days"

I know I can use the DateDiff function as an alternative, and then I can specify the interval, e.g. I could specify hours as the interval and it would return the number of hours that have passed since that date.
But is there a way to specify multiple intervals?
I want it to return:

2 years, 1 month & 6 days

but certainly not:

2 years, 25 months & 761 days

which I imagine it would, if I entered all arguments into a single text box, using yyyy,mm,dd.

Someone on the Access Programmers site said that I should use DateDiff and then compute what I want from that result.

Does this mean I need to do separate controls for each interval?
And how would I 'compute' them?
Gram
 

A:Solved: Access: Elapsed Time Since Specified Date

16 more replies
Answer Match 74.76%

Somehow some time back I set Word 2010 to show a date on every saved page that I have. The date shows up on the bottom of the page on the left side. It also shows on a saved document for an envelope that I made. I want to delete that particular date stamp but when I open the envelope, I cannot figure out how to delete it on this item.
Any suggestions would be appreciated.
 

A:Solved: Word 2010 Want to Delete a Date Stamp on one Saved Item .

11 more replies
Answer Match 74.76%

I have a field that is date/time, formatted to display the long date (which starts with the day of the week). This has been extremely useful for some append, update and delete queries.

However, I would like to be able to do an update query based on the day of the week for each record. I know that the date/time field is stored as a number so I can't search for any string of letters. But, is there a way to take the long date format and copy what's there as a string so I can then extract the day of the week out of it? Otherwise, I guess I'm stuck with adding a separate field for day of the week, and manually inputting it. Seems like such a waste.
 

A:Solved: Access, Date/Time Field to String -- is it possible

7 more replies
Answer Match 74.76%

The company I work for has asked me to work with the DB (as you may well guess in this economy I now have to learn how to work with Access DB. This DB was created by someone who had a book “Access 2000 for dummies” in 2002, I have since then converted the 2000 DB to 2007 accdb format. That being said, in a form that is used to track records-TS# is the primary key, they want a YES/NO or actual name- Completed *check box for yes and blank for no*. I created the check box as you may know that was easy enough. The problem comes in when I go to the next record the box remains in whatever state it was on the previous record and does not show up anywhere else. I am sure this is likely because there are steps that I am omitting or not aware of. Any help offered would be amazing as I continue to work on this train wreck.

-Mike
 

A:Solved: Access 2007 YES/NO field with time/date

Mike, the Check Box field has to be in the Table that the Form uses as it's Record Source. The Check box has to be "Bound" to that table's field, i.e. it's "Contorl Source" of the check box in design view must be the table field.
 

2 more replies
Answer Match 73.92%

Hello guys,

I have a report which has (User, Office, Problem, Date time open, Date Time Close, and Total Date time of job.) TotalDateTime calcultates the time from when it was open to when it closes.

The report shows the total of all jobs so i can print it out. At the bottom of the report i want it to tell me the total time of all the TotoalDateTime records, i.e:

Joe Bloggs Open-11/06/2011 10:30:00 Close-12/06/2011 11:25:00 Total- 1 Day, 55 Mintutes
Jack Black Open-11/06/2011 10:30:00 Close-12/06/2011 11:25:00 Total- 1 Day, 55 Mintutes

TotalOverPeriod - 2 Days, 1 Hour, 50 Mintues

I cant seem to make it total up...Anyone know how to do this?

Thank you
 

A:Solved: Access 2010 Total Time and Date Values

16 more replies
Answer Match 73.92%

Hi,
I run a 24hour business and need to follow monthly trends in product
sales. I would like to differentiate sales during regular hours (Mon-Fri, 8am -5pm) from non regular hours. How do I put that criteria in a query? I can do it for one day, but not those hours over an extended period. I am not techno savvy. Thank you.
 

A:Solved: Defining time and date queries in Access 2003

11 more replies
Answer Match 73.08%

Hi there,
I have an MS Access database (2000, but primarily operating on PC with Access 2010). The database logs wagons coming to and from our site. Mostly, these wagons are in and out in the same day, but it is possible for them to park up overnight, for which we charge a small fee.

The situation has now changed slightly, in that we now accept wagons staying on site for longer periods (usually a weekend), so I've been asked to introduce an Exit Date field as well, and correct the existing calcualtion of time on spent site.

Currently, the following fields appear in the main table (called Stays):

Arrival Date
Arrival Time
Exit Time

There is also a field called Duration, which (for some reason) is autofilled by an Update Query, with the Update To value set to:

IIF([Arrival Time]>[Exit Time],1440+DateDiff("n",[Arrival Time],[Exit Time]),DateDiff("n",[Arrival Time],[Exit Time]))​

This is clearly inaccurate - it assumes that if a wagon's exit time is earlier in the day than its arrival time, then it must have stayed for 1440 minutes + the (negative) difference between the two times, and if the exit time is later or equal to the arrival time, the wagons has been in and out of site in the same day.

As wagons could be on site for multiple days (so the 1440 mins figure could be wrong) and could leave x amount of days plus x amount of minutes after arriving (so the assumption that it's exited the same day as it arrived could be wrong),... Read more

A:Solved: MS Access modifying a date and time calc in separate fields

8 more replies
Answer Match 72.24%

Hello and thank you for your time and help!

On my friend's computer, I am having the exact same problem as described in this post:

Time Stamp Wrong

The last reply says:

It is obvious that your ISP is messing around with time stamps. In that case, I guess you can't do much. It doesn't matter whether you use dial-up or cable.

All that you can do it call up your ISP customer care and try to confirm that they actually are doing this.Click to expand...

I have contacted the ISP and they assure me that it is not the case. They have proven it to me by sending me a test email from them to me and that email has all the correct times on it. However, when I send a test email from [email protected] to [email protected] the time difference is exactly 3 hours behind when I receive my own email back.

I asked to speak to a supervisor and he assured me that the problem is within the settings of Outlook Express - for which they don't give support. I believe him as my test email and his test email prove that the times are not being changed on their servers.

The actual clock on the computer is perfect.

How do I change the time settings within Outlook Express so that the incoming emails will have the proper time stamp please?

My friend is using Outlook Express 5.0 and his computer is older - an e-machine - so we do not wish to update the Outlook Express.

Thanks
Jocelyne
 

A:Solved: time stamp problem

9 more replies
Answer Match 68.46%

Wasn't their a discussion recently here about digitals that would stamp the date right on the picture? Someone is asking me this and I could have sworn a few models were given that did this but I can't find the post.
 

A:Date stamp on photos

13 more replies
Answer Match 67.62%

I understand there is a way to change the " when became a member " on yahoo profiles : i want to look as tho the id i am using is older than the actual date i received it. How can this be done?

A:date stamp, when became a member at yahoo

Where did you hear this??
I seriously doubt that this is feasible. Yahoo (and plenty of websites) add this to be informative, and perhaps to add credibility to a post. Changing this would require hacking the servers...

1 more replies
Answer Match 67.62%

Hi,

A family member took many great pictures while on vacation but used the date stamp mode. I noticed in XP the date stamp does not appear on the icon when set to thumbnail view. However, it does appear in Windows 2000 thumbnails. Somehow the JPG holds more than one layer of info, but I've been unable to find them with Paint Shop Pro 7. The camera is a Sony Mavica CD-2000 and the picture format is jpg. I checked the archives and looked on the Net for information but have come up empty handed. Is there a photography expert that knows how to divide the layers, if that's the case?

Thanks,

Dave
 

A:Removing the date stamp from a photo

9 more replies
Answer Match 67.62%

Are there any photo editors that would allow me to enter a date imprint on multiple
pictures(not individually) already in a folder on my computer?
 

A:Photo Editor, Date Stamp

I don't know but look at this thread.

http://forums.techguy.org/digital-photography-imaging/480310-solved-put-date-stamp-original.html
 

2 more replies
Answer Match 67.62%

Hello all. I work around Outlook 2000. My question to you all is I have one account out of like 50 that is receiving e-mails late. Ex. Today 1/19/05 I am getting e-mails stamped 1/1/05 about three weeks after they were sent. I looked at the basic, Delay e-mail but it is happening from more then one person. I also thought about the whole time zone thing but I checked the time zone on the computer and it is set up right. And the funny thing is that it is not happening to all e-mails just the impartment ones.

Any ideas, any help

Thank You
 

A:outlook 2000 Date Stamp

16 more replies
Answer Match 66.78%

Hello. Here is my issue short and sweet.

When I use ANY of the web based emails (Yahoo, Gmail, Comcast) on computer A, all of my emails are stamped an hour earlier than real time. By real time, I mean the clock on the computer AND the analog tick-tock clock on my kitchen wall. Both display the correct time accurately.

When I use ANY of the web based emails (Yahoo, Gmail, Comcast) on computer B (or C or D), all of my emails are stamped with real/correct time that matches my kitchen and computer. These computers ALSO reflect correct time.

With either computer, any file created or saved has a date and time stamp that is correct and reflects real time. Whether saved with a web app, a windows app or a cmd line app.

On all computers my time zone is set correctly. The "adjust for DST" box is checked. I also ran TZEDIT to confirm that my DST dates are correct.

One revelation (and I believe herein lies the key). If I look on computer A at the bottom of the "Date and Time Properties box: the current time zone says : Eastern *STANDARD* time. If I look at computers B, C or D. The "Date and Time Properties box says: current time zone: Eastern *DAYLIGHT* time. I can not find any way to change the "STANDARD" to "DAYLIGHT".

Now for the big question. How is this resolved?

Thank you.

PS. As mentioned in other posts, Adjusting the clock on computer A an hour ahead resolves the email issue, but now any file created or modified has the incorrec... Read more

A:Web based email Time zone issue wrong time stamp

Double click your clock, click on "Timezone" tab and tick the box for 'Daylight savings'. If need be adjust your timezone from there.
 

2 more replies
Answer Match 66.78%

Today I was advised by a friend that my date stamp on my email came in a couple hours ahead of what time it actually was. I noticed the same thing on my incoming mail. The thought was my clock was off, but it was fine. When I open the mail the date stamp is correct. I believe I took in an update from Microsoft yesterday that addresses the fact that Daylight Savings Time is coming three weeks earlier this year than XP is expecting. I there any word out there of this being a flaw in the download?
 

More replies
Answer Match 66.78%

Windows 7, Windows Live MailWhen I print out an email there is a date stamp at the bottom of every page. How do I stop the date being added to the email?

More replies
Answer Match 66.78%

I took several pictures with my digital camera and failed to insert the correct date after batteries were charged. the computer now reports the images taken on the wrong date. Is there a way to correct the image file date stamps using the registry or one of the XP power tools?

More replies
Answer Match 66.78%

I have spoke to someone who is dependent on sending customers' emails. It is vital that the email dates are correct. I think the problem started when the clocks went ahead.I have instructed them to do all updates for outlook 2003. I verified that the problem is not related to their email host. The date stramps are correct when they send out email usijng webmail. Her computer is free of viruses and spyware and is maintained very well. She did a detect and repair as well.She has Mcafee as her antivirus scanner and no firewalls that I know of.I spoke to her email server and they have not any such issues regarding their server.Maybe someone out there has dealt with thiis before. My hunch is that maybe by upgrading to outlook 2007, this problem would get resolved. She doesn't want to use outlook express, which has it's own problems and is not supported any more.I am clueless to what would be the next step.

A:Outlook 2003 has wrong date stamp

I made sure the time, dsate and region was correct in the control panel and even in the bios. and it was correct.

9 more replies
Answer Match 66.78%

Is there a way of finding out when a picture that has been sent to me via an attachment on an email was taken?
TY in advance.
Nick.

More replies
Answer Match 66.78%

Here is a weird one.
 
I have Photoshop CS 5 running in win 7.
 
When I save jpgs to a particular folder itn saves the wrong date stamp in 2013 with exact same time and date.
If i save outside this folder it saves out with correct time stamp.
 
Folder is shared on both Dropbox and GoogleDrive as is the location i saved  a test jpg which gives correct time stamp.
 
Any ideas? Its odd as it only this folder and only jpgs ...
 
I opened the file info and it seems to be reading the 'date taken' not the 'date created' info . 
 
I created an image from scratch and saved it out as a jpg- looks like PS is picking up a photo texture on one of the layers data as its date taken. must be still in the data part of the image. 

A:Date stamp wrong when saving files...

Does this only happen in Photoshop?  

5 more replies
Answer Match 66.36%

Dear tech experts,

I can't access date/time adjustment, and control panel. I even have smily at the right of my clock. Can u pls help me? I have HijackThis and ComboFix log file. I appreciate your help.



OS: XP SP2
Normal Mode

-------Hijack This Log File---------------------------

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 3:58:35 ('_'), on 4/7/2008
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Intel\Wireless\Bin\EvtEng.exe
C:\Program Files\Intel\Wireless\Bin\S24EvMon.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\Intel\Wireless\Bin\ZcfgSvc.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\System32\igfxtray.exe
C:\WINDOWS\System32\hkcmd.exe
C:\WINDOWS\SOUNDMAN.EXE
C:\Program Files\QuickTime\qttask.exe
C:\Program Files\Java\jre1.6.0_05\bin\jusched.exe
C:\Program Files\Eset\nod32kui.exe
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\Messenger\msmsgs.exe
C:\Program Files\Skype\Phone\Skype.exe
C:\Program Files\Google\Google Updater\GoogleUpdater.exe
C:\PROGRA~1\Yahoo!\MESSEN~1\ymsgr_tray.exe
C:\Program Files\TypeItIn\TypeItIn.exe
C:\WINDOWS\system32\SupportAppXL\cdrom_mon.exe
C:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exe
C:\... Read more

A:Can't access CP and date/time, pls help

See if this gets back your control panel..

Copy the text the in the code box to notepad. Save it as fixreg.reg to your desktop.
Be sure the "Save as" type is set to "all files"
Once you have saved it double click it and allow it to merge with the registry.



Quote:




REGEDIT4
[HKEY_CURRENT_USER\software\microsoft\windows\currentversion\policies\explorer]
"NoFind"=-
"NoFolderOptions"=-
"NoControlPanel"=-

18 more replies
Answer Match 66.36%

I have an Access 97 database on the network, in which about 10 users share. There is this one form that updates returned goods, for some reason I have one computer that adds the time and date to a date field. I want to get rid of the time, and leave short date. It looks like this, 2/5/2001 10:47:50 AM
Data is missing when I query the database using date ranges. I'm sure it's something that I'm missing. Any suggestions? TIA

This is the table input mask 99/99/0000;0;_
Table Format mm/dd/yyyy
 

A:Access 97 Date And Time

Check the user's regional settings for time/date...that's my guess.
 

2 more replies
Answer Match 65.94%

10 - 20% of incoming emails get a WRONG Received date stamp in the navigation pane. On 15 Dec 2012 some emails got '25/01/2000', on 16 Dec 2012 some were stamped 26/01/2000 and a few hours later in the day '27/01/2000'. The emails originate from different senders including one from management software in this computer. That software sent me 5 emails at much the same time, four of which were stamped correctly but one '27/01/2000'.

Most emails are date/time stamped correctly but those stamped wrongly end up right at the bottom of the chronological list in the Navigation pane because of the old date. They are easily unnoticed.

The 'sent' date/time stamp in the email header always seems correct.

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Professional, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i7 CPU Q 740 @ 1.73GHz, Intel64 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 4023 Mb
Graphics Card: ATI Mobility Radeon HD 540v, 512 Mb
Hard Drives: C: Total - 359228 MB, Free - 213201 MB; E: Total - 15359 MB, Free - 3001 MB; F: Total - 2035 MB, Free - 1261 MB; I: Total - 953867 MB, Free - 215174 MB; S: Total - 99998 MB, Free - 94349 MB;
Motherboard: Hewlett-Packard, 1471
Antivirus: Microsoft Security Essentials, Updated and Enabled
 

A:Outlook 2010 Navigation Pane Date Stamp

check time & date on your computer
 

2 more replies
Answer Match 65.94%

I'm working on a date/time calculation to put on a MS Access form. My database field names are start and end and what I am looking for is the difference between the two. The start and end is a date/time format. I'm also interested in putting this in a report. Any help would be greatly appreciated.
 

A:MS Access Date/time Calculations

12 more replies
Answer Match 65.94%

Last week in a database I was developing I had 2 Date/Time fields set with General Date format. It was working perfectly last week where I would type in 10/24 12a and it would expand it out to 10/24/2007 12:00 AM for me.

Fast forward to today and it is now only recording the Date and not the time. I have changed nothing and on a rare occasion can get it to recognize the date and time in the datasheet view but never from the form.
Anyone else ever witness this and know the fix?

Thanks

DPH

Edit: Well I found what I believe is the issue.

If I type 10/26 11p it will convert to 10/26/2007 11:00 PM so the user can short hand the entry.
If I type 10/26 12a it will only show the date. So 1 minute around the entire clock will error.
 

More replies
Answer Match 65.94%

I'm using Access 2K.

Kindly let me know how I can log the date/time of the the last time a record was edited.

To log the name of the last user that edited a record, I created field in my table named "LastEditedBy". In the form's "BeforeUpdate", I'm using the following code:

Private Sub Form_BeforeUpdate(Cancel As Integer)
LastEditedBy.Value = CurrentUser()
End Sub
 

A:Access 2K: Date/Time Of Last Edit

8 more replies
Answer Match 65.52%

My wife's cousin has a Sony FD 73 camera. I don;t know how old it is but it uses a 3.5" floppy disk to record the pictures.
The instruction book I downloaded says the recommended OS is Windows 3.1 Windows 95 or later, so it is sort of an antique I suppose.
He needs to have the date embedded in the pictures I can't find a setting for this in the manual. Is there a way to change settings so he can do this?
Thanks.
 

A:Setting date stamp to display on photos in older camera

10 more replies
Answer Match 65.1%

I run a query for a quarterly report that has 8 fields, 2 of which are dates. The dates have to be in the mm/dd/yyyy format. When I run the query everything displays correctly. when I save the data to a table everything displays correctly. However, when I export it to a comma delimited txt file, the time also displays: mm/dd/yyyy 00:00:00. I checked the formatting for the 2 date fields, and they are both the 'Short Date' format with an Input Mask of 99/99/9999;0;" ". I also tried using other placeholders, which didn't work.

I can get rid of the 00:00:00 if I export it as a tab deliminated file, but then I lose the commas, which are a requirement. The report has to be a .txt file, with strings wrapped in quotation marks, dates (no time) in the mm/dd/yyyy format, and fields separated by commas with no spaces in between.

Are there any other places I should try to change the format, or tricks to make sure the date and only the date print? Or is it an Access glitch and I need to do a re-install? Thanks for any help.
 

A:Access 2K Date/Time Format problem

Add a column using the expression left([date],10) and export the query.
 

1 more replies
Answer Match 65.1%

Hello,
I'm setting up a database and have several date/time fields, which I'd like to have in a custom format - Short Date (UK) plus Short Time format, with a hyphen separating.

I'm trying the Input Mask:
00/00/00" - "00:00

I also tried editing the Date Format to:
dd/mm/yy - hh:nn

But either option (or both) gives me an error message that "The value you entered isn't valid for this field".
I've tried a couple of variations, but I'm evidently missing the principle of how this works.

I'm sure I've done this before, but can't remember how to fix it - oh, and I can't really mess with the PC's regional settings.

Thanks
Gram123
 

A:MS Access 2002 Date and Time format

Sorry I cannot work out how to do it either. I can suggest that you use seperate fields to
input the date and time if you have to input them, why not just use the system time?
 

3 more replies
Answer Match 65.1%

In moving from Access 97 to Access 2002, my Date/Time filter doesn't seem to work. In Access 97, I could select a particular record using the a field with a Date/Time format using the Advanced Filter/Window as follows:

Field: Begin_Time
Criteria: =#03/26/2007 1:06:18 PM#

This date/time was copied directly from a record, so I know it exists, but the filter produces no records. If I substitute any other logical operation, like >, >=, Between, the filter works ok. But = does not. All of this works in Access 97.

Any help would be appreciated!

datasmith
 

A:Access 2002 Date/Time problem

13 more replies
Answer Match 65.1%

Is there a way to cut the "time" function from the "Short Date" format? When I set up a table export the 00:00:00 keeps showing up next to the dates. I can move the column demarcation lines (fixed width markers) to drop the zeros but get the "export errors" message.
 

A:Access 97- edit time from Short Date?

6 more replies
Answer Match 65.1%

Have set the correct time zone, set the date and time, and within half an hour, the time jumps ahead significantly. Time then continues jumping periodically, and date as well. Any patch available for this?
Thanks.

A:Date/Time jumps after correct setting of date/time/timezone?

Welcome to the Seven Forums

Perhaps a change of cmos battery is needed. What is happening is a sign of the battery having packed up.

2 more replies
Answer Match 64.68%

I have this problem. When I save an email with the option "save as" from windows mail IT will print the current date without maintaining the mail by default, but if you drag the email with the mouse and loose it in a folder now. I'm trying to fix this with this, but, did not work:
1) the .eml files change to the present date when they are indexed by the search indexer; this is, a few seconds after creation. Thus, backup/restore/sync will not work properly, but indexing.
2) if you delete that mentioned registry key, then the indexing of .eml files no longer works, i.e. you cannot find them in a full-text search. However, backup works now.
3) it is unknown whether the other solution, proposed by alecamiga, to link .eml to thunderbird and write lock the files, does the same or works better.

thaks

More replies
Answer Match 64.68%

Looking for a utility that will allow me to locate files created/modified/accessed using TIME from/to also...as i want to locate those related to a specific occurance. When using just date, I get hundreds of files so would like to isolate further.

Is anyone aware of any such program? Shareware might be ok depending on cost but free is preferred. THANKS!
 

A:Solved: Freeware to find files by date and TIME? Time is the key!

10 more replies
Answer Match 64.68%

Hi,

I am running XP Home SP3 on an Asus 1005HA netbook

Every time I boot up I get a message to say that either I can press F1 to enter setup to set date/time or press F2 to load default values

If I choose F1 and enter the correct date/time and press F10 to save and exit - XP then starts up normally but the next time I boot up, the same problem occurs.

[If I select F2, then XP loads normally]

What can I do to fix this?

Thanks for any help in advance
 

A:Solved: CMOS Set date/time message every time I boot up

Your motherboard battery is dead. You can get a new one at any drug store for about $5.
 

3 more replies
Answer Match 64.26%

Hi all,

This is probably a serious newbie question, but I found myself banging my head against the wall last night and still couldn't figure it out. It concerns the Date/Time datatype. I've been developing a media database and I've included a field of this datatype to hold the Year that my books are published. However, all I want is the year. I don't want the day or the month. But this datatype requires that I punch in the day and month as well. I don't want to do that. I just want to punch in the year. How do I alter what's required in the field?

FYI, I did figure out how to make it display only the year using Format, but I still have to put in the day and month. . .

Many thanks in advance. I'm sure the answer is right in front of my face and I'm just not seeing it.
 

A:Access 2002 Date/Time datatype question

It seems straight forward...just make a 4 digit field for year forget about the date/time data type, just use "Number or text type".

if you stick with the Date/Time datatype you can use the "Year" function in an expression to extract the year from the date field.

eg. YEAR([YourDateField])
 

2 more replies
Answer Match 64.26%

I'm working an Events Management Database with a table for Events.

The table contains a field for EventDate (date field) and StartTime (time field).

My problem is I need to come-up with a way to prevent users from double-booking on the same day. In other words, prevent them from entering the StartTime of a date twice - on the same day.

Is there code I could use on a form for this?


On another note I love the new layout of the website... Good job!
 

A:Access 2003: Prevent Duplication Of Date/Time

16 more replies
Answer Match 63%

I would like to "Build" an expression for a date/time field that will query the date and display my query output as "01/01" or "January, 1st", and leave off (omit) the year.

Im trying to print a report of my employees birthdates without displaying the year, so i can post it publicly.

the name of the column is dob (date of birth) and the format is standard date/time, displayed normally as 01/01/2009 etc ....

The best idea i could come up with so far is

= Format (Date(), "dddd, mmm d")

but this displays todays date and not the date stored in my column lol.
 

A:Access 2003, want date/time to show day and month only (& no year) in query

7 more replies
Answer Match 63%

I would like for my Access 2007 database to automatically record the date/time when the data in a SPECIFIC field is modified (not when any data in the record changes).

Here is a simplified explanation of my scenario. This database keeps track of cases in my office. A data entry form named "Cases" feeds a table named "Cases." The form includes text boxes that correspond to the fields in the table. Three of these are: "Case_Notes," "Case_Status," and "Date_Status_Change."

I would like for the "Date_Status_Change" field to automatically reflect the current date/time whenever the data in the "Case_Status" field changes. I do not want the date/time to change when information in the "Case_Notes" field is modified.

What code would accomplish this?

The following code will enter the date/time for a change anywhere in the record:

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me![Date_Status_Change].Value = Now()
End Sub

But I want to limit it so that it dates changes ONLY in the ?Case_Status? field.
 

More replies
Answer Match 62.58%

Has anybody been able to figure out Microsoft's time/date stamping. Many times I have looked at the properties of a file and the modified date is before the creation date. Another thing that I can't figure out is why the access time is the immediate time, I mean the now time, I know I am accessing it right now, I want to know the last time it was accessed. Is there anywhere else in window that does this better than just right clicking on a file and going to properties or did Microsoft fail horribly.

thanx
 

More replies
Answer Match 62.58%

See attachment.

This mail came with the time, 8:34 AM, on it. Exactly what does this time signify (emphasis on "exactly").

Is this time obtained from the sender's computer at the time it was sent (in which case it could be incorrect if the time on the computer is incorrect)?

Is the time obtained from the sender's SMTP server at the time it was received by the SMTP server? And, if so, is it adjusted to the sender's time zone if the SMTP server is in a different time zone from the sender's computer?
 

A:Exactly what does this time stamp mean?

8 more replies
Answer Match 62.16%

Since there are two actual times that are unique for each single piece of email, time sent and time received, and they can not possibly be the same.

Is the time that an email leaves your PC, . . which is the time born on the email record in the sent file, . . the same time it bears when received by the recipient ?

A:Time Stamp on Email ?

Depends on a lot of things. First and foremost the way the sender and recipient mail servers are set up. Do they use UTC time or do they use local time? If you have that information then you can calculate time differences.

Other factors play into it such as when you send does your mail server have a malware scan queue so there is a delay? Is the mail sever set up to send in bulk at specific intervals. Like wise on the receiving end.

As I said many things can come into play when you hit the send button and dispatch your email to the ether.

4 more replies
Answer Match 62.16%

I used to have an @function which recorded time so that it did not update. Any ideas? I've tried @timevalue(@time) but it still updates. There is a way to freeze it but I can't remember how I did it!.
 

More replies
Answer Match 62.16%

windows xp was working fine and it just froze so i restarted it
and it went to the disk checking and it came up with
invalid timestamps and it scrolled through a list fast i could not catch most of it and then went to the windows xp click your user name login screen

and the mouse moves until i click on the place to put my password and it freezes . . i've tried going back and restarting using safe mode, and even restore previous settings but it doesn't work

is my files screwed or is there any way of salvaging it?

i know this is kinda vauge and i could try to get more information if it is needed. some of the work i have on my computer is very valuable.

More replies
Answer Match 62.16%

We've converted most of our pc's from XP to Vista 32 bit but have an issue when viewing shared pdf files from our FTP server. On every existing xp machine the date created time is correct. On every Vista machine the (date created / modified) time is off by 6 hours. I've checked my time zones and they are correct. Any ideas?

More replies
Answer Match 62.16%

When the user receives a voicemail on the land line, they are sent an email via a voicemail-to-email tool. The email has a copy of the voicemail, duration, phone number, etc. The time stamp within the email is correct. However, the time stamp that Microsoft puts in the message is incorrect. It is off by approximately one hour. Both the time and date settings and Outlook settings appear to be correct though. The time stamp that I am referring to is below the Respond Group within the Message tab. It is directly above contacts name and the subject of the email. In Outlook options, there is only one time zone selected, which is: UTC-5:00 Eastern Time US & Canada. The data and time settings for the computer are correct too. When I forward the original email as an attachment and subsequently open it on a different workstation, it has the incorrect time displayed too.

I have rebooted the workstation, performed a repair to Office, and opened the affected emails on another workstation (same problem). Any ideas how to resolve this problem?

A:Time Stamp Incorrect

Have a look at this MS website, which mentions Daylight Saving Time as being a possible cause.

https://support.microsoft.com/en-au/kb/2466942

1 more replies
Answer Match 61.32%

if someone changed the date and time on a document, is there any way someone could go into a hard drive and tell that it had been changed

A:Any Way to tell when someone changed document time stamp

Here is a start.has time and date been changed on a documenthttp://is.gd/Se55y3http://www.techrepublic.com/article...http://windows.microsoft.com/en-au/...http://tsr-soft.com/products/copy-c...http://dottech.org/104563/windows-r...

2 more replies
Answer Match 61.32%

Let me start by saying this is for a good reason. I have very nosy in laws who ask to many questions.
I have a simple question that seems to have a hard answer. Here it goes.
I would like to know how to change the time on my email from yahoo,Google or Hotmail account to say a time from a different time zone when i email my in laws. I thought it was as easy as changing the clock time on my pc, but they still get my real time not the one i want them to get. I wonder if there is a better way or if there is a real way to change the time.
 

A:How to change time stamp on my email

Hi, and welcome to TSG.

There isn't a way that I know of, as those services are running through webmail servers.....and truth told, I can't see any valid reason to deceive anyone regarding the timestamp of emails, so I'm going to have to close this one.

thanks for understanding,

v
 

1 more replies
Answer Match 61.32%

I have a new surveillance system at a home I bought to flip and I have been having all sorts of problems understanding its setup. I have called Samsung's tech support many times for various problems and their universal solution for every problem is to reset the unit to factory defaults before working on any problem. I've been through that so many times that my frustration with their tech support has now turned to anger. The re-setup of all my users and other customizations after their lame tech support costs me hours of work afterward.

So, here's my problem: I want to use the DVR's synchronization with an internet time server; but I can't find the correct settings. When the DVR's console displays the correct time, the time stamp on alert e-mails is several hours off. If I adjust the GMT, so that e-mail alerts have the correct time stamp, the time displayed on the DVR's displayed time is several hours off.

I'm in the CDT zone (USA) and I use a futurequest.net mail server ( [email protected] )

Can anyone help me with this?
 

A:Having Trouble with GMT, E-mail Time Stamp, etc.

16 more replies
Answer Match 61.32%

I create many new temporary folders every day. I am looking for a quick way to paste a time/date stamp for each new folder name. Wondering if there is a way I can link the time stamp to a windows hot key and use a paste rule?

Don't want to use excel/word/cmd prompt and copy paste over to slow.

Google turned up useless so I knew I could turn here for some assistance!

Thank you.

A:Place Time Stamp as a folder name

You can use the %date% and %time% environment variables in a DOS prompt.

Based on this, you could edit the registry to place an Explorer context menu shortcut to a command that creates a new folder in the current directory, along the lines of mkdir "Temp created on %date% at %time%".

Unfortunately this won't be of much help - I just realized the date includes slashes "/" and the time uses colons ":", both of which are invalid characters in a file/folder name.

7 more replies
Answer Match 61.32%

I have a system image created today at 9:58am according to Windows Explorer. When I boot the Repair Disk and select that image, it shows the time as 6:59am --3 hrs earlier.

I checked my BIOS and it shows the correct time.

Anyone have any idea why this difference?

Thank you.

A:System Image Time Stamp

When you used the boot (rescue) disk, were you prompted to enter your timezone at one point after Windows booted up?

I suspect this may simply be a matter of setting the correct timezone when the disc-based Windows prompts you for it.

2 more replies
Answer Match 61.32%

Receive an email at 5:24 PM (outlook express verifies time on my computer)

(from the header)
Received: from fep3.cogeco.net (smtp2.cogeco.ca [216.221.81.29])
Received: from 236MM (d221-84-244.commercial.cgocable.net [216.221.84.244])
by fep3.cogeco.net (Postfix) with ESMTP id ED17545F
for <[email protected]>; Fri, 13 Apr 2007 17:24:27 -0400 (EDT)

My clock is correct, senders clock is correct ... I go to forward the message at 5:24.
See below the time sent: 1 hour ahead (6:24)

Where is this time coming from, headers and clocks are all OK ... I'm stumped,
and it appears to be causing a spooling backlog on certain mail servers.

Any suggestions or thoughts, as to why this is happening?

----- Original Message -----
From: Sender
To: 'Me'
Sent: Friday, April 13, 2007 6:24 PM
Subject: RE: mail test
 

A:Email Time Stamp Problem

1. Check to see if you are in the correct time zone; not only if your clock says the right time. (same area as you would go to change the time)
2. Check through the settings of Outlook Express to see if there is a place you can change the time zone.
 

3 more replies
Answer Match 61.32%

Since version 7 Internet Explorer changes the "modified" time stamp of a *.url (favorites / bookmark) file when used. It changes it to the current date, so that you can see when you last used the link.

I want to disable this function because it interferes with my file synchronisation program. My synchronisation program sees it as if the url was changed, which is awkward as it isn't changed, only the modified attribute is updated.

Can this be done?

A:Disable URL time stamp change with IE7

Find your Favorites and click on the top folder and set the "Read Only" attribute for all files and sub folders.

1 more replies
Answer Match 61.32%

My computer clock says one time and my Outlook received mail says another....about three hours earlier. I sent myself a test mail at 7pm and it read that it was sent at 3 pm.

Please advise!

Thanks
 

A:Time Stamp In Outlook Express

Check ALL of your settings.

Check your location and time zone in Control Panel - Regional Settings. That on the assumption you are running Windows.
 

2 more replies
Answer Match 60.9%

Hi All,

Man its been long since i asked a question but ever since i ran into this problem i remembered you guys, as you have helped me out before! i think to give a title to this problem would be "Automating of pressing keys for timestamp on a cell"

Ok here is the problem i am facing ............
I have to record so many stock trades in realtime when client makes a call etc. As this timestamp would be neat for feedback to tell the client when the trade was made and helps me remember when i executed the persons trade. On my spreadsheet i have a buy, sell , quantity, price, account number and time of execution column.

First off i know the ctrl+ shift+ : [and now() ] function to get the timestamp on a cell. Now what i cant figure out is a way to get the current timestamp in cells multiple times while making trade orders without having to press those keys all the time!!!

How can i quickly get the current time stamp of a trade executed without having to use/press the ctrl +shift +: command function???, if i get that formula/macro i can do a copy paste function on the remaining of the column so i dont have to do it all the time and just focus on entring the buy and sell details of the trade. I dont have too much time to stickon one entry as i have to move on to the next trade! plus if i continue doing this as is, i'll have carpaltunnel syndrome in a week !!!

Hope this makes any sense? please help!!!!!!!!!!!!!!!

Thanks.

P.S.....Someone showed me this but made... Read more

A:Excel Time Stamp formula (for stockmarket)

faisal_ahmad said:

P.S.....Someone showed me this but made no sense on how to use it or if its any good to me.

Private Sub Worksheet_Change(ByVal Target As Range)
Range("A" & Target.Row) = Now()
End Sub
'Specify AClick to expand...

This is an event procedure. It goes in the worksheet module. Rightclick the sheet tab & select View Code to get to the worksheet module ; you would paste it in there.

When you make a change, it timestamps in col A of the row you're changing. So:

(a) you need to specify which column should be timestamped (if not A)

(b) it will update if you make subsequent changes anywhere, which you may not want.

Here's one that'll stamp in A when you first enter in D ; it'll also blank A if you blank D. It's a question of how you want it to work.

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 4 Then Exit Sub
If Target = "" Then
Target.Offset(0, -3) = ""
ElseIf Target.Offset(0, -3) = "" Then
Target.Offset(0, -3) = Now()
End If
End Sub
 

2 more replies
Answer Match 60.9%

A user of mine is running Outlook Express on WinXP.

He accidentally set his time to the correct date, but in 2008, ie. one year ahead.

He quickly fixed the issue by setting the date back to 2007, but still all the received mails are stamped as if they were received in 2008.

Is there any way to revert this to a correct state?
 

More replies
Answer Match 60.9%

I am positive this wouldn't be possible in Explorer (XP) or (Win 7), so I'm wondering what utility would be possible, or would it need to be a specially written program?

I didn't change the clock on my camera and want to change the timestamp on my photos to add 6 (or 7) hours to batches of photos.

Thank you.

More replies
Answer Match 60.9%

Hi,

Im using this code to timestamp cells. I have just picked up the code from the internet and dont do VB. It works great but I want there to be 3 columns as opposed to the 1 this is for.

ive attached the excel sheet, the protection password is assure
Private Sub Worksheet_Change(ByVal target As Range)
Application.ScreenUpdating = False
ActiveSheet.Unprotect Password:="assure"
If target.Column >= 11 Then Exit Sub
Range("D" & target.Row).Value = Format(Date, "mm/dd/yy") & " " & Format(Time, "h:mm:ss AM/PM")
ActiveSheet.Protect Password:="assure"
Application.ScreenUpdating = True
End Sub
 

A:Excel time stamp mutiple cells

16 more replies