Computer Support Forum

stop date being entered if older than last entered date

Question: stop date being entered if older than last entered date

Sub datepaste1()
'
' datepaste Macro
' unprotect sheet
Sheets("SCARD").Unprotect Password:="sillybilly"
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
With Sheets("SCARD").Range("R1" & ":R" & nxtRow)
Set d = .Find(Range("K6"))
If d Is Nothing Then
If MsgBox("Is the Competition Date Correct?", vbYesNo Or vbInformation, "Date") = vbYes Then
' Date is Copied and pasted into this range of merged cells
Range("K6").Copy _
Destination:=Range("D5:E5")
' date is pasted into the next blank cell in column R
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & nxtRow)
' protect sheet
Sheets("SCARD").Protect Password:="sillybilly", DrawingObjects:=True, Contents:=True, Scenarios:=True

Else
MsgBox "Please re-enter the Correct Date", vbCritical Or vbOKOnly, "Date"
End If
Else
MsgBox "Date Already Exists. Please Try Again", vbCritical Or vbOKOnly, "Date"
End If
Else
MsgBox "Date is BEFORE last Date entered. Please Try Again", vbCritical Or vbOKOnly, "Date"
End If
End With
End SubThe above Vba works very well. I have added the last message box as I need for the date NOT to be entered if it IS OLDER than the last entered date. I am missing a line of instruction and cannot seem to work it out.Any ideas, ?????

Relevance 100%
Preferred Solution: stop date being entered if older than last entered date

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: stop date being entered if older than last entered date

I believe that this version will do what I think you want. (How's that for confidence?)It's a bit shorter than your version because it basically does 2 fairly simple things:It checks the Date that was entered in K6, then either presents a MsgBox that the date is invalid or it copies the date to the 2 cells, D5 and Column R.You will also notice that the code does not Unprotect the sheet until it has been determined that the date will be copied. Besides being ineffcient to Unprotect the sheet before we know if the sheet will be changed, it is also more dangerous. Let's assume that the Unprotect instruction is placed before the instruction that checks the date. Now let's assume that the user enters an invalid date. The MsgBox will appear and the code will pause while it waits for the user to click OK. During the pause the sheet is Unprotected because the Unprotect instruction has already been executed. If the user hits Ctrl-Break while the MsgBox is on the screen, he can stop the code. The sheet will then be left Unprotected. However, if the code doesn't Unprotect the sheet until just before the Date is copied, it would be next to impossible for the user to hit Ctrl-Break during the very brief time that the sheet is Unprotected.
Sub datepaste3()
'
' datepaste Macro

'Determine last row with data in Column R
lastDateRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row

'Date is compared to last date in Column R
If Sheets("SCARD").Range("K6") <= Sheets("SCARD").Range("R" & lastDateRow) Then
'If Date is invalid, inform User and Exit
MsgBox ("Date is BEFORE last Date entered, or already Exists. Please Try Again")
Sheets("SCARD").Range("K6").Select
Exit Sub
End If

' If Date is Valid...
' Unprotect sheet
Sheets("SCARD").Unprotect Password:="sillyboy"
' Date is Copied and Pasted into this rangef merged cells
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("D5:E5")
' Date is Copied and Pasted into the next blank cell in column R
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & lastDateRow + 1)
'Protect sheet
Sheets("SCARD").Protect Password:="sillyboy", DrawingObjects:=True, _
Contents:=True, Scenarios:=True

End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

13 more replies
Relevance 105.27%

Hi,I have the following problemI enter a date into cell "K6"I then have a command button with an assigned macro to paste the date to two locations on the same worksheet, "D5:D6" (merged cells) and to the next blank cell in Column "R"What I require is to ensure that the date entered cannot paste to the desired locations if the date already exists in Column "R"I attach the macro as followsSub datepaste()
'
' datepaste Macro
If MsgBox("Is the Competition Date Correct?", vbYesNo Or vbInformation, "Date") = vbYes Then
' date is entered in to this cell
Range("K6").Select
Selection.Copy
' date is pasted into this range of merged cells
Range("D5:E5").Select
ActiveSheet.Paste
' date is pasted into the next blank cell in column R
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & nxtRow)

Else
MsgBox "Please re-enter the Correct Date", vbCritical Or vbOKOnly, "Date"
End If
End SubAny ideas as I think the check between the Date entered in "K6" and what exists in Column"R" must take place before the first line of the above macro.Any assistance or ideas of how to overcome this would be greatly appreciated.

Answer:stop date being entered if it already exists in a column

First, there is no need to Select the ranges you want to perform the Copy and Paste operations on.You don't do it for the Copy/Paste for Column R, why do it for D5:E5? I have modified that section of your code.The following code will check Column R for the Date in K6 before presenting the confirmation message box. You will note that I moved the instruction to determine the last Row in Column R to the top of code so that it can be used to set the Range that .Find will use.Sub datepaste()
'
' datepaste Macro
nxtRow = Sheets("SCARD").Range("R" & Rows.Count).End(xlUp).Row + 1
With Sheets("SCARD").Range("R1" & ":R" & nxtRow)
Set d = .Find(Range("K6"))
If d Is Nothing Then
If MsgBox("Is the Competition Date Correct?", vbYesNo Or vbInformation, "Date") = vbYes Then
' Date is Copied and pasted into this range of merged cells
Range("K6").Copy _
Destination:=Range("D5:E5")
' date is pasted into the next blank cell in column R
Sheets("SCARD").Range("K6").Copy _
Destination:=Sheets("SCARD").Range("R" & nxtRow)
Else
MsgBox "Please re-enter the Correct Date", vbCritical Or vbOKOnly, "Date"
End If
Else
MsgBox "Date Already Exists. Please Try Again", vbCritical Or vbOKOnly, "Date"
End If
End With
End Sub
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 91.64%

everytime i open my computer i have to go to BIOS and enter the valid date and time even if i  have saved the chages.can anyone help??thanks!

Answer:computer always ask date to be entered

Yes you need a new CMOS battery...part # CR2032 about the size of a dime on the MBoard.As always when working inside the case make sure all power is removed and take anti-static precautions...

1 more replies
Relevance 91.64%
Question: Excel Date Entered

I have a spreadsheet in excel that contains columns such as Name, DOB, form no etc, and I want to add a column that will auto enter the date that the information was entered. I tried adding a column which uses the TODAY() function when something is added to the column to the left but everyday it updates the TODAY() to current day so that won't work. Can anybody think of a way to stop it updating or another way to put the "entered date" on?

Answer:Excel Date Entered

try the now() command, this will not update automatically.

This is the help text from excel

Returns the serial number of the current date and time. If the cell format was General before the function was entered, the result is formatted as a date.
Syntax
NOW( )



Remarks
Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,448 days after January 1, 1900. Microsoft Excel for the Macintosh uses a different date system as its default.
Numbers to the right of the decimal point in the serial number represent the time; numbers to the left represent the date. For example, the serial number .5 represents the time 12:00 noon.The NOW function changes only when the worksheet is calculated or when a macro that contains the function is run. It is not updated continuously.

7 more replies
Relevance 89.61%

HI,

I created a query with a paramater that prompts the user to enter a start date and an end date to query a table based on the entered dates. I have this data displayed on a report so when the report is opened, it automatically asks for the start date and the end date. My question...

Is it possible to have the selected date range the user typed in, displayed somewhere on my report?

The report works great except there is nothing on the report that specifies...'Date range is 1/1/02 to 4/25/02'.

Any help would be greatly appreciated.

Thanks!
Amy
 

Answer:Display user entered date range

7 more replies
Relevance 89.61%

up.On my lad's PC.Every time he boots up it tells him that he needs to enter the date and time even though I;ve updated it for him for GMT and current time/date.Any ideas please?

Answer:XP asks for date/time to be entered at each start

Sounds like the battery on the motherboard is flat, without its power the bios cannot retain the time etc.

3 more replies
Relevance 89.61%

On registering my product the date format |I entered did not accept eventhough \i followed the format mm/dd/yyyy

Answer:|The date format I entered did not accept eventhou...

Hi,Right click Date & Time in taskbar, select Adjust Date and Time, change Date and time formats, change the date format to mm/day/yyyy. Then try registering and switch back to your preference.

3 more replies
Relevance 88.74%

Hi,

Trying to write some code that checks the DateDiff between 2 fields once the 2nd date is entered. This is the code as it stands...

Dim Days As Integer
Dim msg As String
Days = DateDiff("d", [Agent Notified], [Collected])
msg = "Date Difference is " & Days
MsgBox (msg)

I tried placing the code behind the "On Change" event but it tries to run the code after each digit of the date is entered so I placed it behind the "Before Update" event. This seems to work better apart from if a date is entered in error which is then deleted. I then get a "Invalid Use Of Null" message.

Question 1: Is the "Before Update" event the place to have this code?

Question 2: What is the "Ignore if null" code?

TIA
SBF
 

Answer:Solved: Access 2003 - DateDiff after date is entered.

6 more replies
Relevance 86.71%

Hey you got a few seconds can you help me with an excel formula? What I am trying to do seems like it should be an easy thing but for whatever I can?t zone in on why it?s not working. What I?m trying to do is have a cell with a date and have that cell change colors from green meaning recently done, yellow would be like 6 months from whatever date is put in the cell, and then red when that date is over a year old.E.g.;3/29/2013 9/29/2013 3/29/2014But all these colors would be in one cell. I have tried a formula that I found in the help thing within excel it?s something like this =IF(TODAY()=EDATE(E4),TRUE,FALSE) format in green color. I?ve done this in the conditional formatting option along with these formulas as well; =IF(TODAY()>EDATE(E4,6),TRUE,FALSE) format yellow, and =IF(TODAY()>=EDATE(E4,12),TRUE,FALSE) format in red. For some reason I can?t get it to reflect the change when the date is changed. I know I probably sound stupid because it?s probably something super simple but I can?t stare at it anymore.

Answer:Color change formula to reflect time past entered date

First, this formula will never work because it is missing the months argument.=IF(TODAY()=EDATE(E4),TRUE,FALSE)I'm not sure what you mean by "recently done" (it's not very specific) but that formula won't work for any situation. One way to test formulas that you want to use for Conditional Formatting is to put them in a cell to see if they return TRUE or FALSE when you want them to. In this case, you would see that Excel would return an error because you are missing an argument.Second, what you are asking for and what your formulas are checking seem to be the exact opposite of each other.Based on the Date examples you've given, your formulas are checking to see if TODAY() is greater than a date in the future. That's never going to be TRUE.Perhaps you meant use something like this, where the months argument is a negative number, specifying a date that has past.=IF(TODAY()>EDATE(E4,-6),TRUE,FALSE)Finally, this is just a tip to keep in mind when writing rules for Conditional Formatting. You don't have to use a complete IF statement with TRUE and FALSE as your return values. All you need is a formula that will return TRUE or FALSE, such as:=TODAY()>EDATE(E4,-6)Whether used in a cell or as CF Rule, Excel knows to return TRUE or FALSE when it evaluates that type of formula.=A1=B1=A1<>B1=VLOOKUP(A2,$B$1:$D$6,3,0)="Done"Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

9 more replies
Relevance 85.84%

Hello,
Firstly, let me apologise, I'm a complete Access noob & am trying to teach myself as I've got no one to help me in person.

Ok,
I'm trying to build a Time Sheet database that should record daily duties via an entry form:
"frm_Work_Hours"

This form updates an underlying table:
"Work_Hours"

The date field of the "Work_Hours" table is:
"Date_Worked"

However, workers get paid fortnightly and all their entitlements, allowances & overtime are calculated on these fortnightly periods. To be more specific, the workers are paid for a certain amount of overtime for each fortnight upfront & when they exceed that, then they are entitled to all excess time back in TIME OFF. So it's pretty important that each day's duties are assigned to the correct fortnight period so that their overtime & so-forth are calculated correctly.

Each fortnightly period is numbered according to year. For example, each year there are 26 fortnightly periods, so as an example today (3rd October 2013) falls in period 2013-19 (23rd September 2013 to 6th October 2013).

I've created a table called:
"tbl_Pay_Period"

Which has the following Fields:
"ID" (Auto-number)
"Period_Start" (date - the first day of each new fortnight period)
"Period_Number" (number - eg: 2013-19)

Back in the "Work_Hours" table, I inserted a new (Number) FIELD called:
"Pay_Period"

and set ... Read more

Answer:Solved: MS Access - How to get a field auto-update based on date entered in a form

9 more replies
Relevance 99.22%

I am working with an Excel Spreadsheet (2007) that stores assessment grades for the students in my school. At the moment, teachers go on and access the spreadsheet from a shared drive, add their changes and then save. The problem is that some teachers are entering 'A*' which Excel recognises as 'A' plus any other characters due to * being the wild card character. I have Data Validation on the cells in question to only allow them to enter grades such as A+ and A but even with this on the A* can still get through. I have quite a few calculations and comparison formulas on this sheet that require A* to be entered as A+ in order to be calculated. Is there any way to stop them entering these grades in the first place? Otherwise I could settle with a way to replace them easily, as the Replace function also recognises A* as the wild card character and replaces the letter A anywhere it appears on the sheet?
 

Answer:Solved: Stop A* being entered

9 more replies
Relevance 95.12%

...hope I named the thread right.

Good day everyone. This one thing in Excel has been driving me crazy for a couple of hours now. I've looked all over the internet trying to find the solution and still couldn't. Hoping to find the solution here. otherwise I might stay up all night tonight, trying to make this work

so I'm putting together this custom spreadsheet for my own little needs. let's say I have A1, B1 and C1 cells. in the C1 cell I want to display "1" if the numbers in A1 and B1 are equal and they are not equal then display nothing. so the formula I'm using is

=IF(A1=B1,1,"")

and is there are any numbers in A1 and B1 excel interprets everything just fine. but if if there are no numbers yet, it takes two empty cells as having the similar data and still gives me "1" in C1 cell. so how do I make so that Excel does not execute the IF formula before I enter the numbers in A1 and B1. or is there another of of not getting the "result" before actually putting in the numbers?

hope that someone can help me with this thing.
 

Answer:Solved: Excel 2007, stop IF formula if no data entered.

12 more replies
Relevance 82.82%

I booted my PC up earlier today and I noticed that I was missing a few icons and PC settings so I restarted my PC and it happened again however I was missing basically everything on my pc as if it booted from a year ago. I'v tried to do a system restore but I keep getting an error where I cannot even activate system restore. I have no idea what to do or know what is going on? Do I have a virus or is my PC just screwed, any help would be greatly appreciated thanks!

More replies
Relevance 82%

how do i restore to older date on acer .Computer is running very slow and is saying all files infected even when i try to click internet icon

Answer:system restore older date

http://windows.microsoft.com/en-in/...ARM Devices the future. Windows have accepted the fact!

3 more replies
Relevance 82%

in cell H2 I'm entering this to get a yes or no answer, if the date in cell D2 is past 90 days. =IF(D2-TODAY()>90, "No", IF(TODAY()-D2>90, "Yes", ""))It's not working

Answer:Is date in cell D2 older than 90 days?

If you want a Yes if the date is older than 90 days, then use this:=IF(TODAY()-D2>90, "Yes", "No")The syntax of the IF function is:=IF (logical_test, [value_if_true], [value_if_false])For a simple IF, you only need one logical_test and "answers" for when the result is True and False. In other words, you don't have to check the Date twice like you were doing.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

4 more replies
Relevance 82%

Does anyone know of an application that will identify and extract files older than any given date across a set of folders and write those files in the same folder structure to a backup device?

Answer:Archive files older than a date

I am surprised that nobody responded to this one yet. I didn't respond yesterday as I do not use a backup program, I use an Archive program zip files for my backups, and it doesn't have this feature. In the old days I used to use PC Tools Backup to archive files to floppy disks. I am sure there was an option to select files older than a certain date.

1 more replies
Relevance 81.18%

I've just upgraded from Windows xp to 10.
I use an older version of the Quattro Pro spreadsheet (2003) and have columns formatted for dates. In XP, the slash between 2 numbers is interpreted as month and day, but in W10, it treats it as a calculation and the date appears as 30-Dec-99.
Is there a fix for this or am I missing something? I've noticed that Excel recognizes it as a date.

Answer:Date entry on older version of Quatro Pro

Blimey - talk about nostalgia. I haven't used QP for over 20 years!

I doubt there is a simple fix. There are many free alternatives if you want a free solution but I would recommend you consider leasing MS Office as it is only ?80 total a year for up to five users with 1TB each of onedrive storage space.

1 more replies
Relevance 81.18%

I've just upgraded from Windows xp to 10.
I use an older version of the Quattro Pro spreadsheet (2003) and have columns formatted for dates. In XP, the slash between 2 numbers is interpreted as month and day, but in W10, it treats it as a calculation and the date appears as 30-Dec-99.
Is there a fix for this or am I missing something? I've noticed that Excel recognizes it as a date.

More replies
Relevance 81.18%

Windows repeatedly asks me to update with the little yellow exclamation mark in the tray but it always fails and then keeps asking over and over again. It's trying to update something I don't even use I think PowerPoint or something; I had the option off at one point for those programs so it wouldn't keep asking but then a message pops up saying are you sure you want to leave these off you might need them.

Any ideas on how to get past this?
 

Answer:Windows Update...date...date...date....

Have a look at this link and see if it helps.

http://support.microsoft.com/kb/910339/en-us
 

1 more replies
Relevance 79.13%

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.
 

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

10 more replies
Relevance 78.31%
Answer:windows 10 mobile anniversary update release date in older lumia

These are the phones that can update to Windows 10. If you don't have one you won't get the update.
Lumia Icon, 1520, 930, 640, 640XL, 730, 735, 830, 532, 535, 540, 635 1GB, 636 1GB, 638 1GB, 430, 435, BLU Win HD w510u, BLU Win HD LTE x150q, MCJ Madosma Q501
Also the anniversary update hasn't been released for mobile and won't be for a few weeks.

more replies
Relevance 77.9%

Help! I am using a Seagate Central 4TB NAS drive attached to my router via Ethernet. It has been working fine so far for all kinds of file activities. But whenever I modify a file in one of its folders, the creation date for the file also updates and is
changed to the same time as the new modified date.
Maybe relevant details:
I can move/copy folders to the drive and they maintain their created dates.
It happens for both a private user share on the NAS and for the Public share on it.
It happens for at least image files and text files.
I am able to edit files across two computers on the network just fine, the create date stays the same.
This happens from a new Windows 10 machine and Vista machine both.
I notice sometimes the date created seems to stay same until I access the file the next time.
I can't update the NAS firmware because of error.

If it could be a permissions problem, I have been unable to change it from:
Everyone: Special Permissions only
nobody (Unix Group\nobody): Special Permissions only
nogroup (Unix Group\nogroup): Special Permissions only
(Those were there automatically, they are not something I manually put there. I get "Access is denied" whenever try to add permissions or change ownership.)

I have Googled many phrases of this problem far and wide and come up with nothing. I really need to save the original create date because that's how I sort them in programs like Windows Photo Gallery or Picasa. Does anyone know what's goin... Read more

More replies
Relevance 77.9%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

More replies
Relevance 77.9%

I got a Refurbished Dell Latitude D600 Laptop from ebay yesterday on Tuesday, September 26th 2017, It had Intel Pentium M (Non-Centrino) and Windows XP Pro SP3, but when i boot it up, it resets to The Default BIOS Date, can someone help me?

Answer:Dell Latitude D600 Current Date Resets to The Default BIOS Date

The coin cell battery on the motherboard that keeps time while the system is powered off is probably dead.  Not too surprising given that the D600 is about 15 years old at this point.  If you open the system up, it should be easy to find, so just note the type of battery, e.g. CR2032, and then buy that type of battery at any grocery/convenience store.  Should only be about $2-3.

2 more replies
Relevance 77.9%

First the background: We are gradually deploying Office 2007, but not everyone in the agency has it. I have both 2003 and 2007 installed on my system, but I do my work in 2003, and none of our databases have actually been converted to 2007 format (at least, none that I work with). There are occasionally people who use 2007 when viewing databases, but I don't know if any of the people who are working in this particular database are using 2007. The problem is reproducible in 2003 and so I've been trying to fix it here. The query behind the problem report used to work. It has been a problem for several months (it is run monthly, and every month for the past five they've had problems with it) and I've finally gotten to the root of the actual issue.

The purpose of the report is to generate invoice for outstanding loans. The DateNextPayment is a calculated field based on the payment plan for the loan. It is calculated using a function in the query named qryGetSitesDDInvoices1. This is the function that is called (I did not write this function, I'm supporting this db long after the original writer has left):
Code:
Function DateNextPayment(PaymentSchedule As String, DateFirstPayment As Date, Balance As Currency)

On Error GoTo Handle_err

Dim Date1 As Date
Dim Date2 As Date
Dim Date3 As Date
Dim NextQtrDate As Date

'The code adds one month to datenextpayment at start of each month. Or yearly or weekly

... Read more

Answer:Solved: Date Parameter Failing in Query from calculated date field using DateValue Ac

16 more replies
Relevance 77.9%

Greetings, and thanks in advance for your help..

Awhile back I formatted my Windows 10 PCs to show ddd dd-mmm-yyyy on my taskbar clock. This worked happily on my desktop and laptop for months, maybe even a year +

Now (probably starting in the past couple days, if not today), on one of those two PC's, this format will no longer display. It is Okay on the other PC.
What has changed that the taskbar clock space used to expand to fit the "short date" format, but now it will no longer expand - and instead just refuses to display the date at all. (NOTE: I've verified the issue by testing shorter formats -- short formats, like "ddd" show up correctly. Only if you request a longer format will the date not display - evidently because it is too long for the clock area. )

Additional Notes that may help:

* "Working" pc is running build 10586 PC with too small a clock space that won't expand -- Build 14393

*Other differences: Notification/Action center Icon is left of clock on the working PC - Right of clock on the non-working
Right- Clicking on task bar gives "properties" option on working PC -- But "Settings" option on the non-working

( I don't want to prejudice responses - but clearly the implication to me is that some recent OS update is most likely the culprit.)

Thank You

Answer:Taskbar Time / Date area quit expanding to fit desired date format

I had a similar problem which has been greatly ameliorated thanks to a kind respondant - see https://www.tenforums.com/installatio...-new-post.html

1 more replies
Relevance 77.9%

The title is self-explanatory. So far, I found a software that is able to change this called 'Attribute Changer' but it only changes the date modified in the folder and, when you go into the actual word application > file > info, the date created and modified are not changed. Any help would be greatly appreciated! Thank you!
 

Answer:Changing 'date created' and 'date modified' in Microsoft Word 2013

7 more replies
Relevance 77.9%

Searching for files modified in a specified date range (of the past 3 days) gets a search result list titled "date modified", and with the column heading "Date Modified" but the date listed against a file modified today is wrong. The date displayed matches the file creation date & is within the specified range ... but how do I know what the Search is doing?

Can't trust it... !

Answer:File search (by date range) displays incorrect Mod Date in results

That is very strange. Bump for a possible solution, since I can't think of one off the top of my head.

1 more replies
Relevance 77.9%

Hey guys,
I have a question about coding and setting an excel file to send emails. I am using an excel file to track maintenance work orders and I would like to get an email each day for each work order that is requested to be finished on that days date. I have attached the excel file I am using, and the column that is important is C, "Date Needed" - If that date is today's date, the cell turns red and I would also like to get email notification about it. A separate email for each cell that matches today's date.

Also, if possible, I would like for it to look at all the sheets, not just the current month's sheet. For example, if a work order was filed in July but wasn't needed until September, I would still like to get the email reminding me that it needs to be finished on xx date in September.

I have attached the excel file I want to use.

I have searched all over this forum and others and have found many posts similar to this, but I am not a great manipulator of code, so I cannot get any of the other solutions to work.

Any help would be greatly appreciated, thanks!
 

Answer:Solved: Using Excel 07 to Send Emails When Date in Column = Today's Date

16 more replies
Relevance 77.9%

It looks like the 31 March deadline for the latest Edge promotions is the date of invoice rather than the date of order. Given Lenovo's reported long build time and slow delivery (= late invoice), I suspect that ording now from the Lenovo web site will see an invoice date outside the qualifying period. Even a dealer who says he can 'get one in' may not deliver and invoice until April or beyond. I think the only option is to find a dealer who unequivocally has current stock.Can anyone shed any light on the likely position. I do, though, wonder about trying to take advantage of Lenovo Cashback at all, given the horror stories reported here.

Answer:Edge 31 March promotion deadline - order date or invoice date?

My experience with cashback is a deathly silence from Lenovo to emails asking for progress on the cash or even recognition that there has been a registration for cashback...Currently considering giving Lenovo some publicity on the matter.Unless you have a lot of time to possibly get no where I would steer clear of the alleged cashback scheme...

1 more replies
Relevance 77.9%

hello to everybody

I need batch code to check if date is modified in three files and that date should be compared with current date (%date%).If so,do some job,otherwise quit (exit /b)

I found a bunch of solutions but what troubles me is date format.
On my machine it is dd.mm.yyyy

Thanks in advance.
 

Answer:Solved: batch to compare file modified date with current date

10 more replies
Relevance 77.9%

Hello.
I'd like to see Long Date and Long Time in my System Tray instead of Short Date and Short Time. 
But due to some restrictions connected with my work I can not modify Short Date & Short Time to look how I want them to look in System Tray.
So basically I need Windows to show what is set as Long Date & Long Time in System Tray instead of showing Short ones.

Is it possible? Maybe some registry tweaks?

Answer:How to display Long Date in System Tray (without modifying Short Date)?

Hi,
There is no workaround to display the Long Date in taskbar without modifying the Short Date parameter.Ivan-Liu
TechNet Community Support

8 more replies
Relevance 77.9%

After running a large update of windows on May 18 I found that ALL my files in ALL my folders are showing a Date Modified of May 18 2013. Can't find a similar report of this problem. Any ideas?
Using Windows 7 Professional 64-bit

Answer:File Date Modified reset to today's date after windows Udate

Would this help? enter link description here

1 more replies
Relevance 77.9%

Hi! Does anyone know what is the format of the date in the field "(battery) Manufacture Date" informed by Lenovo Vantage (Hardware Configuration > Energy)? It seems not to follow Windows setting. In my case, it is set to Brazilian Portuguese DD/MM/YYYY, but there is not a leading "0" in the returned value (see attached image). Does it really disregard the Windows setting and presents it in a fixed format (maybe American English)? When was my battery manufactured (Oct. 07 or July 10)?Thanks in advance.  

More replies
Relevance 77.9%

I have tried using Hijack to delete it but it always comes back on reboot?

this is my log and any assistance will be greatly appreciated.....thnx

Logfile of HijackThis v1.99.1
Scan saved at 1:53:03 PM, on 6/19/2005
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)

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\Common Files\Symantec Shared\ccSetMgr.exe
C:\Program Files\Common Files\Symantec Shared\SNDSrvc.exe
C:\Program Files\Common Files\Symantec Shared\SPBBC\SPBBCSvc.exe
C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\system32\nvraidservice.exe
C:\WINDOWS\essspk.exe
C:\WINDOWS\SOUNDMAN.EXE
C:\Program Files\Common Files\Symantec Shared\ccApp.exe
C:\Program Files\CyberLink\PowerDVD\PDVDServ.exe
C:\Program Files\Dlmtbf\Daszjhk.exe
C:\Program Files\ScanSoft\OmniPageSE2.0\OpwareSE2.exe
C:\Program Files\Winamp\winampa.exe
C:\WINDOWS\system32\RUNDLL32.EXE
C:\WINDOWS\system32\r?ndll.exe
C:\Program Files\tuat\aoar.exe
C:\Program Files\WinZip\WZQKPICK.EXE
C:\Program Files\Norton AntiVirus\navapsvc.exe
C:\Program Files\Norton AntiVirus\IWP\NPFMntor.exe
C:\WINDOWS\system32\nvsvc32.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Common Files\Symantec Shared\CCPD-LC\symlcsvc.exe
C:\WIND... Read more

Answer:Spysherrif has entered my PC

9 more replies
Relevance 77.9%

And if so, how can I VIEW them?

Thanks,

4Deucer
 

Answer:Does my PC keep all filenames I've entered?

12 more replies
Relevance 77.9%

I am a resident of an assisted living facility. I have some computer knowledge and was asked by the director if I would take care of their new computer.
The first thing I did was create an admin account for myself and password protect it. I didn't have time to setup all of the rules to prevent any resident from getting into areas they know nothing about.
This morning I went to work on the computer and even before i got there I was stopped by two people asking me for the PW to use IE. I went in and found that a PW was required to open IE. It was OK two days ago. Then I tried to open my admin account and my password would not work. I have been using it for a week now so I know what it is.
Is there any way for me to change the admin account password or/and remove the IE PW?

Answer:I think somebody may have entered passwords

Never heard of needing a password for internet explorer. It sounds like you can get into the machine OK, if that`s the case, then just create another admin account.

You should be able to change the password on your old account using the new account.

If the old password still doesn`t work, then just delete the old account.

6 more replies
Relevance 77.9%

When i entered the cell value should get "Hello" in other cell. supose my cell doesnt have value then nothing need to get but if i enterd any value then get Hello massage. then when i removed the value then hello also removed.But this Hello i want in my cell D9. But here i have pai chart so it should dispaly over it.Thanks for advance

Answer:When i entered the cell value should get

you might be able to use this?put this into cell D9
=IF(A7>0;"hello";"")
change the value of A7 to your origin cell:: mike

7 more replies
Relevance 77.9%
Relevance 77.9%

Okay. I've tried quite a few things, and I still have this problem, so please, if you can help, it'd be greatly appreciated.

Some malign stuff has entered my PC (running on WinXP), it seems that always when I open IE (altough I use Opera most of the time) it changes my starting page to "about:blank", and offers some sort of a search engine whith a randomly changing searchword which has to do with porn. I have Black Ice Defender running too, and it's application protection detects two unknown prosesses when IE is started. The prosesses names vary each time IE is started. In IE's favorites also appear some links to porn sites. And I haven't even surfed for porn in a while!

In the control panel's add/remove programs "Home Search Assistant" and "Shopping Wizard", which when I try to remove, just opensa a browser window which tells me to download 'an uninstall software' and run it. I did download the file (aroun 600KB), but needless to say I didn't do so.

I've run everything I've got, Norton antivirus, Ad-aware 6.0, Spybot S&D 1.3, checked manually most of the running processes shown in the task manager, but still the problem remains. So I started googling for help, and found this forum, and reading other peoples' problems I downloaded HijackThis and run it, here's the log:

Logfile of HijackThis v1.99.1
Scan saved at 14:48:14, on 29.4.2005
Platform: Windows XP (WinNT 5.01.2... Read more

Answer:Help, something bad entered my comp

Ofcourse, during the hour or so that I spent searching for an answer here I found nothing, but right after posting I found a very similar case which already had an answer. I'll try that and whine here once again if I still can't get the problem fixed.
 

1 more replies
Relevance 77.9%

Hello,

I have read how to change the default app that opens "things." For a DVD (and this is one attached by a USB because it's an ultrabook), I chose VLC. I put in a DVD and nothing.

Any ideas what I am doing wrong? Thank you~!

Answer:Set Default App to VLC; nothing happens when DVD entered

My choice doesn't seem to stick either.

With the DVD movie in the drive, open file explorer, right click on the Drive letter for the DVD drive, mine is D:. Select Open AutoPlay....
The box comes up that says "What to do with DVD movies" I click on Play DVD Movies VideoLAN VLC media player , and VLC opens the DVD but it won't stick, I have to do the same thing every time I put the DVD in the drive.

3 more replies
Relevance 77.9%

my id has locked, how to i can open the id again?

Answer:i cant entered in yahoomasenger

The lockout is applied automatically if you get the id password wrong three times, or if someone else tried to access your account with three incorrect passwords.The lockout should last for no more than 24 hours from the time that the lock was applied. After 24 hours you should be able to sign in.

3 more replies
Relevance 77.9%

i need the recovery media..but when i enter the serial number of my laptop it said No RCD available for the entered Serial Number...what actually mean by this? and i need the recovery media as soon as possible because i need to done my assignment.

Answer:whats mean by No RCD available for the entered Ser...

post notebook model and installed OS, please.

9 more replies
Relevance 77.9%

Had this happen once before some years ago, and I can not remember if it was a virus or a hardware issue.

The computer tries to continuously enter 0 (zeros) in any text entry area. Tried unhooking my keyboard and mouse to no avail, and I also tried rebooting into safe mode and it did the same thing there. I am running another virus scan to check but it hasn't found anything yet. ANY suggestions are appreciated while I am beating my head into the wall.

Matt
 

Answer:Constant 0s being entered

Is it occurring when you start up the system without a keyboard plugged in (mouse is fine)?

And are you getting an BIOS errors about a key held down during boot if the keyboard is plugged in?
 

3 more replies
Relevance 77.9%

I forgot my new mobile password.Also i remove battery then time setting is now incorrect.I try 5-6 type to set password

Answer:I forgoet my scree lock password?Also i remove battery ow date setting is not current date?

hard reset your phone using following steps :-
1. Turn off your Windows Phone. Use power button to power off the phone.
2. Press and hold Volume down key and connect the charger to phone. You will see a big exclamation mark on the screen.
3. Press these keys one after another in the same sequence. Volume Up, Volume Down, Power, Volume Down.
4. You will see the phone reset and boot normally. You will see wheel gears working on the screen. It will take few minutes.
Your phone will be reset to factory settings and you need to set up the phone again.
Or try to reset phone's setting if it is connected to Wi-Fi or data is enable through your account.

more replies
Relevance 77.49%

Somehow the date on one of my old Excel files has turned from 1999-10-04 (i.e. October 4, 1999) to 4617-04-11. How can I change all the rest of the incorrect dates back to what they should be? This is the only date that I can confirm. And I have no idea what the rest of all the dates should be on this spreadsheet. TIA.

Answer:Excel date problem - to convert incorrect date to original

I have no idea what the rest of all the dates should be on this spreadsheetThen how do you purpose to change them, when you don't know what year they are supposed to be?Somehow the date on one of my old Excel filesAny Macros running that may have in some way impacted the dates?How is the data stored? As Text or as a Date?MIKEhttp://www.skeptic.com/

5 more replies
Relevance 77.49%

I need to return a number associated with a date based on today's date. For example: A1:A24 are numbers 1 to 24 and B1:B24 contain the 15th and 30th for each month of the year; 15-Jan, 30-Jan, 15-Feb, 28-Feb, ... 30-Dec.Cell C1 needs to return the number from A1:A24 based upon today's date compared to the date in B1:B24.For example today is 08/21/15, what number should be returned in Cell C1. It should be 15 as 08/21 is less than 30-Aug.message edited by jmichels

Answer:Return a number based on today's date compared another date.

Try this formula, see how it work for you:=INDEX(A1:B24,MATCH(TODAY(),B1:B24,1),1)This will work for most dates, but errors out if the Date is 01/14/15 or less.MIKEhttp://www.skeptic.com/message edited by mmcconaghy

4 more replies
Relevance 77.49%

I have a field that reads 2009-12-30-15.42.22.81298 as text. i want to make in be a date of 12/30/2009 15:42:23 and ignore the milliseconds. Is this possible?

Thanks
Ted
 

Answer:Converting complex date text fields into date or numbers

Ted, what software are you talking about?
Are there always 8 values in the date part?
 

3 more replies
Relevance 77.49%

Hi all,I need dos command to compare the file creation date and the modified date.My scenario is,If user inputs the folder path to the batch file, i have to provide the file list (which are under sub folders of the given folder) ,which do ot have creation date and modified date as same.can anyone help in thisThanksVanisree

Answer:Dos command to compare file creation date and modified date

You need a CMD.EXE Command Prompt solution, XP does not have MS-DOShttp://ss64.com/nt/ARM Devices are the future, great British Design !

2 more replies
Relevance 77.49%

Hi all,

I'm new to Windows 7 (Home Premium 32-bit) and I just can't figure out what's going on here! Basically I want my short date format to be dd/mm/yyyy (UK format) e.g. 05/11/2010, but when I key a date into Excel 2002 it is appearing as 05 11 2010. In Control Panel I have the short date format set to ddd dd/MM/yyyy and the example is shown as Fri 05/11/2010, but in Excel all the date formats are shown with space separators, e.g. 14 03 2001! I don't think it's an Excel problem though as in Windows Task Scheduler the dates are shown with spaces there e.g. '19:25 on Mon 01 11 2010'. The date by the clock though is shown correctly with slash separators!

I know in Windows XP you can select the date separator from a drop-down list, but this option seems to be absent in Windows 7. Under HKEY_CURRENT_USER\Control Panel\International in the registry, sDate was set to a space, but changing that to a slash (and rebooting) didn't fix the problem.

Does anyone have any ideas please what's wrong and how to fix it?

Thanks
Steven

Answer:Date format using space as date separator rather than forward slash!

Hi,

The option you're after is controlled from within Excel. If you right-click the cell(s) in question you can select 'format cells' and under 'Date' you can select the desired format.


OS

9 more replies
Relevance 77.49%

Hi all,I wish to create a macro that when i click a button i can input what month i wish to print out data for. I have 7 columns (A-G).Date Day Activity Income 02/01/2012 Monday Work (8) 48.00 02/01/2012 HMOT 5.00 02/01/2012 Peter Taylor 134024855 HMOT 5.00 02/01/2012 Susan Taylor 134023422 HMOT 5.00 02/01/2012 Steve Davy 13402737404/01/2012 Wednesday Work (8) 48.00 04/01/2012 HMOT 5.00 04/01/2012 Tom Thompson 134027410 HMOT 5.00 04/01/2012 John Ackroyd 134025131 HMOT 5.00 04/01/2012 Aftab Ilahi 134022546Above is an example of the sheet.In column A we have the date, B we have the day, C we have the activity, D we have the income, E is a cell with the previous month date in to track data for the month, F is a name and G is a number.I wish to be able to print all of january for example, rows A-G by clicking a button and entering something like 'january' or '01/12'. This will then select all of the rows with data in based on the date range in column A and print the selection.Please feel free if that doesn't make sense to ask questions.Thanks in advance.

Answer:acro to input date and print based on date range

Below is the code I have for a macro which I can't seem to get to work right.Thanks.
Public Sub PrintMonth()
On Error GoTo Proc_Error

Dim wksCurr As Worksheet
Dim rngTarget As Range

Dim strInput As String
Dim datInput As Date
Dim datStart As Date
Dim datEnd As Date

strInput = InputBox("input start date for month", "Enter date")
If strInput > "" Then
datInput = CDate(strInput)
If datInput > 0 Then
Set wksCurr = ActiveSheet
Set rngTarget = wksCurr.Columns(4)
datStart = WorksheetFunction.EoMonth(datInput, -1) + 1
datEnd = WorksheetFunction.EoMonth(datInput, 0) + 1
With wksCurr
If .AutoFilterMode Then
.AutoFilterMode = False
End If
.UsedRange.AutoFilter Field:=rngTarget.Column, Criteria1:=">=" & datStart, _
Operator:=xlAnd, Criteria2:="<" & datEnd
.PrintOut
.AutoFilterMode = False
End With

Set rngTarget = Nothing
Set rngDate = Nothing
Set wksCurr = Nothing
End If
End If

Proc_Exit:

Exit Sub

Proc_Error:

Select Case Err
Case Else
MsgBox "Error " & CStr(Err) & ": " & Err.Description
Resume Proc_Exit
End Select

Exit Sub

End Sub

3 more replies
Relevance 77.49%

I'm working on a spreadsheet that lists monthly recurring expenses. I have one cell on the sheet listing the current date (using the "=Now()" formula), but I'd like to have the other cells change at certain times throughout the month.

For example, if one cell currently says "April-15", when the actual date reads "April-16", the respective cell would change to "June-15". This way, whenever the spreadsheet is viewed the next recurring payment date will be seen.

I know this is the wrong tool for something like this - I'm using SharePoint at the office with a calendar list with workflows that shoot off emails in a much better put together format - but this is just for home use and I'd like to keep it all in one document if possible.

Any ideas or suggestions would be greatly appreciated. Thanks in advance.
 

Answer:Excel 2010: Cell Date Change with Current Date

The way I read it was that you have fixed recurring payment dates, so you just want to know the next date based on the day today. Hope the attached might assist.
You need to list the payment dates somewhere and then the formula looks up the next date. You might want to look up today plus 1 (or something) to reflect the fact that if the next payment date is today, there's a good chance you'll not get any unplanned payments on that run.
 

1 more replies
Relevance 76.67%

I keep getting this error when trying to install and exe I have tried safe mode and system restore but can get no joy I get this error message when I try system restore.



Help

Answer:could not find the environment that was entered

Can you please give us a little more detail about the problem? I know you have a problem with system restore, but in what aspect? Can't you bring up the System restore window at all? Or can't you restore your system?
Instead of a System restore, you might be able to do a Repair install. Or just talk us through the problem that makes you need to do a system restore.

9 more replies
Relevance 76.67%

How to "hide" the password entered via MS-DOS using the SET/P and changing the color of the text and background?

Answer:How to hide the password entered via MS-DOS

i dont know if i understand the question, but if you need to change the color for whatever reason just type in "color ?" into cmd to look at your color options

5 more replies
Relevance 76.67%

I changed the pasword on my laptop with a 20 digit random sequence of letters and numbers. Seemed like a good idea at the time Anyway I obviously wasn't paying attention because I didn't enter what I wrote down, now I can't remember what the password is. Is there anyway I can change it/delete it?

I know I can do a complete reinstall but that is a last resort. Please help. Quickly!

Btw I am currently still logged on...

Answer:Entered wrong password...

The administrator account can change your user account password. Here is how you enable the administrator account (while logged on). After the admin account has been created, simply logon to it, and change your user account password.

9 more replies
Relevance 76.67%

I use the stamp function in Foxit 7.0.6 to add stamps I've created. There a lots of pre existing stamps that mean I need to scroll down to see my stamps. Does anyone know how to remove these?
 

More replies
Relevance 76.67%

Hello Sir or Ma'am,
 
My hard drive has failed and I am trying to re install Windows XP Home Edition with SP3.  I am unable to do so because "No RCD available for the entered Serial Number" on your web site.  Please Help.
 
Windows XP Home Edition with SP3
AMD Athlon 2650e processor
NVIDIA GeForce 6150SE Integrated
DVD Super Multi drive with LabelFlash
160GB HDD
1 GB DDR2 memory
Multi-in-one Digital Media Manager
EL1300G-02w
SNID [edited to comply with guidelines]
 
[edited for privacy]
 

Answer:"No RCD available for the entered Serial Number" H...

XP is no more supported, so no recovery disks are available to buy. you have to find somewhere else an original windows XP CD. Delete your Serial number, mail and phone number from your post, please.

3 more replies
Relevance 76.67%

Hi

Interesting problem.

We have a site license for Office XP. One of my coworkers upgraded Office 2000 to XP but used one of the keys that was not the site license. We're not sure just where she got it...but anyway. It allowed her to install but then it went out to the Microsoft site and checked it. It informed her that the key had already been activated and this install she did would only run for so many days.

Is there anyway we can get the correct key entered? We don't really want to uninstall Office because the user has a lot of settings in Outlook that would be lost. She said it would take hours to get it all back.

We tried a re-install but it doesn't ask for the key again.

Thanks
 

Answer:Office XP - Wrong Key Entered

6 more replies
Relevance 76.67%

I'm not sure how this worked out but my hijack this has started working again. Subsequent to my loading one or more of the Spyware/Adaware packages, Hijack quit-refused to run. Now since the old version of spyware blaster has been uninstalled and the new version of Spyware blaster has been loaded along with fixes for .net and some other stuff, hijack is running again and I can obtain a list of those files it examines. The good news is that everything appears o.k. no apparently weird .exe lines
So, for anyone out there having hijack this issues, I'd say check for subtle conflicts between it and your resident spyware..
Copernicus sends
 

More replies
Relevance 76.67%

Hi there,

I am a complete nono when it comes to software and my computer has been infected. I managed to create a log with hijackthis:

Edit by bjgarrick: Unrequested, Inline HJT log removed!

Can you please advice me which lines to remove!

Thanks very much!!!!!!!!
 

Answer:HELP, PSguard has entered my computer

Please follow standard cleanup procedures as given below:

- Run ALL the steps in this Sticky thread READ ME FIRST BEFORE ASKING FOR SUPPORT: Basic Spyware, Trojan And Virus Removal

Make sure you check version numbers and get all updates.

- Very Important: Make sure you tell us the results from running the tutorial...was anything found? Were you unable to complete any of the scans?...Were you unable to download any of the tools?...Did you do the on-line scans as suggested? etc.


After doing ALL of the above and you still have a problem, make sure you have booted to normal mode and run the steps below:



Download HijackThis 1.99.1

Unzip the hijackthis.exe file to a folder you create named C:\Program Files\HJT

Do NOT run Hijack This from the Desktop, a temp folder, or a sub-folder of C:\Documents and Settings, or choose to run it directly from the ZIP file as your backups will not be safely stored.

Before running HijackThis: You must close each of the following:your web browser, e-mail client, instant messenger, and programs like notepad, wordpad, MS Word etc. And any other unnecessary running programs.

Run HijackThis and save your log file.

Post your log as an ATTACHMENT to your next post. (Do NOT copy/paste the log into your post as it will be removed).

Need help with HJT? See this thread: NO HIJACK THIS LOG FILES BEFORE READING THIS: HJT Tutorial & LOG File Posting
 

13 more replies
Relevance 76.67%

My Windows Mail program suddenly stopped sending and receiving messages. The following error message popped up: "Account: 'Windows Mail', Server: 'pop3, Server Response: ERR An authentication mechanism MUST be entered,' Port: 110, Secure (SSL): No, Server Error: 0x800ccc90, Error Number: 0x800ccc18"

I have tried to trouble shoot settings. Everything appears to be correct per my internet provider. My operating system is Vista; I have been using Windows Mail for several years with no problem. Nothing has changed with my computer re: recent updates or new programs.

What is an "authentication mechanism" and how do I set/respond to the error issue? Any available help would be greatly appreciated! (FYI I'm not a computer techie-type so simple-minded (referring to me of course!!!) direction would be especially appreciated! Thank you!!!

Answer:Authentication Mechanism MUST be Entered

The problem could be with your mail provider. Wait until tomorrow, if it still does not work properly report back and we will go from there.

3 more replies
Relevance 76.67%

Hello Sir or Ma'am,
 
My hard drive has failed and I am trying to re install Windows XP Home Edition with SP3.  I am unable to do so because "No RCD available for the entered Serial Number" on your web site.  Please Help.
 
Windows XP Home Edition with SP3
AMD Athlon 2650e processor
NVIDIA GeForce 6150SE Integrated
DVD Super Multi drive with LabelFlash
160GB HDD
1 GB DDR2 memory
Multi-in-one Digital Media Manager
EL1300G-02w
SNID [edited to comply with guidelines]
 
[edited for privacy]
 

Answer:"No RCD available for the entered Serial Number" H...

XP is no more supported, so no recovery disks are available to buy. you have to find somewhere else an original windows XP CD. Delete your Serial number, mail and phone number from your post, please.

3 more replies
Relevance 76.67%

multiple programs suddenly crash when the keyboard is used in any way. NOT ALL PROGRAMS! Just some...

Does this sound like a virus???

Have fan spybot and macaffee ... it's clean now.

what's the possible problem then?

Do you know??

Thanks for reading!!

Have a good one!
 

Answer:Need help!!! Crashes when text is entered

EnchantedDreams said:





Does this sound like a virus???Click to expand...

Not really.





EnchantedDreams said:





Have fan spybot and macaffee ... it's clean now.Click to expand...

Running those with no detections, does not mean you are clean. They both miss most malware problems that we see everyday. Run our cleaning procedures if really want to know if you are clean.
 

1 more replies
Relevance 76.67%

My pc is freezing with alarming regularity when I am entering data into a web site or search engine. This only happens when the internet is enabled. I have a Mesh Matrix XP 2200 running windows XP. I have carried out all the self diagnostic tests and everything appears ok. I have also reformatted the hard disk and loaded XP again to no avail. Any idea's?

Answer:pc freezing when data is entered on the web

trevor47,boot into bios and check the core voltage. If it is set to default 7.5, turn it up one notch, and try again.This is a known problem with xp cpu's, and the core voltage with certain psu,s.

2 more replies
Relevance 76.67%

So what's this about.

I have transferred my Windows 10 Pro digital licence from my old laptop to a new laptop. This was upgraded (MS 2016 free upgrade) from a purchased RETAIL copy of Win 7 Pro (I used the Windows 7 Pro key during installation).

Prior to passing the old laptop onto someone else I have formatted and reinstalled Windows 10 HOME fully expecting that it would remain inactivated until such time as the new owner bought a licence.

I chose to skip entering a licence key during installation.

Will this automatic digital licencing on the old laptop in any way compromise my transferred digital licence on the new laptop?

Thanks in advance.

Answer:Windows Activated without a key being entered

Nope.

24 more replies
Relevance 76.67%

Hi,

I am using a series of Autoshapes as input boxes on a spreadsheet. I need to obtain the value entered into these Autoshapes to do validation on the entries.

I can see how I can place a value in the Autoshape, but is there anyway I can transfer the value of the Autoshape into a cell - something like...

A3=(value Autoshape 3).

Thanks,
 

Answer:Excel - getting value entered in Autoshape

I don't know of a way, and I tried quite a few.
You can do the opposite and have the value in the shape be based on the value in a cell, although only in the most basic way, such as =F5 (no summing or anything else allowed).
 

1 more replies
Relevance 76.67%

Hi TechGuys,

My IE8, operating with XP Home 2002 (SP3 is done of course, with updates etc.) on my Dell desktop, has been operating fine but this weekend it started shutting down immediately (all windows including those minimized) when I start to enter anything in the Search box at the top right corner of the screen.

I haven't installed anything new to cause a change (to my knowledge).

I have run Malwarebytes and Super Anti-Spyware as well as AVG Free and Microsoft Onecare Scan. Nothing found.

The HiJack This log is attached here for reference.

I have no idea what to do. Can you help?

Thanks and best regards,
David
 

Answer:IE8 (XP) shuts down when anything is entered in search box

16 more replies
Relevance 76.67%

A bit water entered in phone due to rain. I given it to repair. Phone starts but the network symbols are blinking with no network symbol and when we turn on flight mode it stops. kindly help..

More replies
Relevance 76.67%

Please someone tell me how I can keep the data entered on form in web can be kept to avoid re-entering them,e.g. some competition forms where the name & address details have to be entered.

Answer:How to keep data entered on Forms

download the browser Opera , it can store details such as name address etc so you can enter them at the clickk of a mouse , it doesnt store passwords etc so yuor safe.There are plenty of other tools available for IE just google it

10 more replies
Relevance 76.67%

Hello everyone from Tech Support Forum, I need help with my computer, it became strange after I was stupid enough to un-activate my game booster after gaming, so my anti-virus was off. I was browsing and downloading through the internet, then suddenly a random black window popped up with a bunch of white text, then on my desktop were some shortcuts of XXX sites, and since then when I tried to open firefox, it said "This file has been infected, please turn on your anti-virus", so i clicked start> AVG anti virus, which was infected too. I then tried Start>Accessories>System Tools>Restore computer, which was infected too. I tried to open internet explorer, then it wouldn't connect to the internet, and on my favourites were some more XXX sites. . . So then I restarted my PC, and when i started it up, a window popped up asking for my password of windows, which I didn't have, so i just pressed OK, then my desktop came up, nothing else, not even the taskbar and icons. And then: "Windows Explorer was stopped to protect your computer' (or something similar to that), then the "not responding"/"send error report" screen came up, then it stood at that desktop all the time.

Please help me!!

By the way: im using the other computer at the moment :D

Already alot of thanks !

Answer:Please help! - Virus Entered My Computer!

Hello H2owned,

Do you still require assistance?

3 more replies
Relevance 76.67%

how?
it just zapped right into my well secured [I thought] ap....

Answer:How did 8 hack into my network?! No PW entered....

WIFI connection?

7 more replies
Relevance 76.67%

When I enter www.facebook.com in any of my browsers (Firefox and Internet Explorer), I get the 'done' result at bottom of browser, but the Facebook page is not displayed. I can get to any other site I enter, but for some reason this is happening for only Facebook. I have McAfee for security software. Please help to figure this out. Thanks.
 

Answer:URL entered on browser, 'done' immediately

6 more replies
Relevance 76.67%

A few days ago, I noticed random sound clips coming from my TV speakers.  This is followed eventually by a Plug & Play has unexpectedly stopped so Windows must be shutdown & restarted or Dsomething server process has unexpectedly stopped etc.
Gateway computer running Windows 7 is connected, via wire, to a large SHARP flatscreen.
The sound clips repeat on a loop and consist of bits of music, commercials, interviews etc, which repeats on a loop until shutdown.
The sound clips come thru the speakers when the computer is on and isn't dependent on opening up Firefox or IE.
 
I did some spelunking on the web, so think it's some kindof virus or malware perhaps?  I have very specific places that I visit internet-wise so I believe it may have entered my computer via email and not a site.
 
I'm not a computergeek (I have lots of random bits of knowledge but am a serious plant & dog nerd) but I can follow directions.
 
Have run AVG & Malwarebytes but they've not found anything.
 
Someone on the Delphi Cookstalk forum recommended Combofix.
 
Any assistance is appreciated.  If you need more info let me know what I can do to supply the needed info.
I don't want to send out any emails until this is fixed.  Not sure if this "thing" perpetuates via email.

Answer:Something evil has entered my computer

Hello Plantlust Yes  it is a newer malware. To get it out we should get a deeper look. Please follow this Preparation Guide, do steps 6,7 and 8 and post in a new topic.Let me know if all went well.

3 more replies
Relevance 76.67%

Hi All,
I am using LUMIA 1320 that has Lumia Cyan.
Sometimes the time and date is getting reset to a specific date, i.e. 22nd May 2014
Due to this all reminder, alarms and new messages are not coming in sync.
Is this a virus? Does it have come from an app. If that is the case then it questions Microsoft App policies...
Anyone who has encountered this issue and has done something to eradicate it let me know.

Answer:Why is my phones time and date getting reset to a specific date?

First, windows phone can never get a virus. Its the safest platform after iOS . And no, a particular app can't affect the system's time and date. I think your should try to manually set the time and date in the settings. And see if it works.

3 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

Wait for the more knowledgeable to report but a new CMOS Battery would seem to be in order.
Easy to replace and only £1, or so, to buy, in almost any Supermarket.
About the size of a 10p piece on the motherboard, with a number like CM032. Don't take it out until you are ready to replace it.
Get the replacement > Take the old one out > Instal the new one and, with luck, that should be it.

6 more replies
Relevance 76.67%

Hello, I have spreadsheet with a number of dates and times ie (11/19/07 8:57 AM) in column A and data going along with each of these dates and times from columns B-CK. I am trying to limit the list to show the information that is for all times after 2:45PM. The problem is I cannot sort by time and the dates attached to all the times span from 2004-2007. Please help!
 

Answer:Stripping the date portion of date/time in excel

7 more replies
Relevance 76.67%

I want to calculate how long a member of staff has worked for the company and therefore need to subtract their starting date from the current date.

Answer:How to subtract a date from a date ie years/months elapsed

If you use google to search:Time elapsed calculatorThere are a few online results to help. I hope they help. For the fun of it I calculated how long I have been in existence : 2,177.43 total weeks or: 15,242.00 total days or: 365,808.00 total hours or: 21,948,480.00 total minutes or: 1,316,908,800.00 total secondsThat was from the first result google gave me. Thank god no one will be able to figure out when I was born. message edited by btk1w1

9 more replies
Relevance 76.67%

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?
 

Answer:Solved: Access - Convert Date Time to Date

10 more replies
Relevance 76.67%

I've just moved "My Documents" contents from one laptop to another
I now find that some of the Word Documents are showing the current date in letters to customers that were created & dated months ago
As these letters are records documents sent out is there a way of preventing them opening with the current date

I've already checked, Wotd - Insert - Date & Time & the Automatic Updates box is unchecked

Thanks for any help

Answer:In Word the Original Date in a letter changes to current date

Is this the file modified date or the file created date? Moving the file will give it a new "modified" date.

1 more replies
Relevance 76.67%

Dell Dimensions XP PC bought 9 years ago.On opening date 7 time reverts to date of purchase.Can change and all ok.Can anyone Help Please? Thank you

Answer:Date & Time reverts to Date of PC purchase 9 Years Ago

http://www.pcadvisor.co.uk/forums/1/tech-helproom/4204823/date-amp-time-reverts-to-date-of-pc-purchase-9-years-ago/
see duplicate thread

1 more replies
Relevance 76.67%

Hello, I am having trouble finding the previous 2 days totals in a query. I have a totals query with the following fields:
JobID - Criteria: Between 500 And 599
WorkType
JulianDate
Batch
TotalProcessed - calculated field, grouped on Sum. sums field entry
ProdDate - Short Date - Grouped on Where - Criteria Date()-1 Or Date()-2

Today's Julian Date is 199 so query should give me Julian Dates 197 & 198, but instead returns Julian Dates 188 - 196.

Thank you for your help!
 

Answer:Solved: AC2007 Find Date()-1 And Date()-2 in Query

The criteria that you should use for a date period is
Between Date()-1 and Date()-2
 

2 more replies
Relevance 76.67%

The column heading in Win 10 File Explorer is 'Date'. But which one?

I've always been used in XP to the default being 'Date modified', but it seems that here it's Date created? Several re-saves have left 'Date' unchanged.

--
Terry, East Grinstead, UK

Answer:File Explorer Date column - whiich date is it?

Hi:
What is the column in Windows 7 explorer? It matches no date column from Windows XP explorer - Super User

2 more replies
Relevance 76.67%

Hi there

I know how to do add a criteria to a Query. For example in the QBE pane in design view in the criteria row I enter this statement: Between [Start Date] And [End Date]. When I open up the form that is bound to the query, a message box pops up and I enter the required dates and I get the required data that is between the dates that I specify. However, I'm now finding out that this method is now becoming a nuisance.

Is there a way that I can have 2 unbound controls - one for the start date and the other for the end date in a criteria form. This way I input the dates I want for a particular customer and the form with the required data shows up. For example, I have already developed a criteria form for customers. I have an unbound combo box control that has customer names and when I click on a particular customer name, all the data for that customer is displayed in a form. In the row source of the unbound combo box control there is a SELECT .... FROM ... statement. I also have a button next to the unbound combo box control that opens up the form for that particular customer. Now I want to add two more Unbound controls in the criteria form, one for Start Date and another for End Date.

This way I can select a customer from the customer combo Box, select the start start date from the start date combo box and the end date from the second combo box control and get the desired data for that particular customer between the specified dates. I have attempted to do this bu... Read more

Answer:Access - Start Date and End Date in a Criteria form

Mario: What you want is called a query by form (QBF). I don't know how to do them myself, offhand, but here's the MS Technet article:
http://support.microsoft.com/?kbid=235359
 

2 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:

Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

(Sorry, the text keeps left aligning so person 2 should actually have 25% under Mar, Apr, and May.)

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End date question

16 more replies
Relevance 76.67%

I accidentally formatted the date cell & it only accept numbers

Answer:how to correct a date field when you enter a date a number a

I don't know what you mean by "it only accepts numbers".Why can't you just format it as a date again?Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 76.67%

Hello,

I have a large report of application forms which have been submitted including the date when they were submitted however the dates are formatted incorrectly.

1. Although the cell formatting is dd/mm/yyyy the data is being shown in mm/dd/yyyy which means the dates are incorrect (e.g. 2nd January would read as 1st February.)
2. As a result of this dates which are passed the 12th of a month are not accepted as dates (it reads the day figure as months and there is no 13th month etc)

I have tried to use the text to columns function but that makes no difference and I have tried to extract just the dates but I've had no luck.

Can anyone help, I've attached a small sample of the data.

Thanks

Daniel
 

Answer:Exported date field not recognized as date in Excel

Where does the data come from?
What do you get if you have no cell format?
 

3 more replies
Relevance 76.67%

I received a .csv file from a company with a date field that looks like this: Tue Jan 03 12:12:20 PST 2012I have tried using the Data Type options to change this to a mm/dd/yyyy format but it will not apply. I tried converting it to a serial number using*mm/dd/yyyy and it will not work ~ nothing happens. I tried using a DATEVALUE formula but keep getting a #VALUE error .. I obviously don't know how to lay it out. Can anyone give me the DATEVALUE formula for this example? I am not sure what "right", "left" or "mid" represent or how to count the value placements. THANKS!!!

Answer:How do I convert a complex date to a simple date in Excel?!?

Try this:With your date in cell A1,First, format cell B1 as a DATE fieldRight click your mouse, select Format Cell, Select Number Tab,select Date, choose the date format you want.Next, in cell B1 enter the formula:=DATEVALUE(MID(A1,5,3)&" "&MID(A1,9,2)&", "&RIGHT(A1,4))That should give you what your looking for.MIKEhttp://www.skeptic.com/

3 more replies
Relevance 76.67%

I am looking to set up a macro or formula that basically inserts the current time when a cell is filled SO:

when a2:a100 is populated with any thing then the corresponding C cell will be populated with the time.

AND

when e2:e1000 is populated wiith anything then the corresponding D Cell will be populated.

Currently I am using this macro.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("A6:A100")) Is Nothing Then
With Target(1, 4)
.Value = Time
.EntireColumn.AutoFit
End With
End If
End Sub

which works great for the A and C cells

but it does not work for the other one.. how do i add and modify this so all my needs are met.
I need another 2 sets of 2 macros accross the sheet for time entry.
 

Answer:Excel date auto populate date/time

11 more replies
Relevance 76.67%

I have a file that lists a Julian date of, for instance, 37573. How do I convert that into something like 11/06/02?

Thanks in advance!
 

Answer:Julian Date--How to convert to calendar date in Excel

That's not a Julian date, Beth.

That is actually a date value that Excel provides.

That's how many days it's been since 1/1/1900.

To change it to a real date, you should be able to select that cell or entire column, hit Format-Cell, Number tab, and choose Date, and then any one of the date formats.

Julian dates are what numbered day of the year. For instance, January 3, 2002 would be 3.

Learn lots about dates and times in Excel:

http://www.cpearson.com/excel/datetime.htm

Be prepared to be there for a while.

Happy Thanksgiving!
 

2 more replies
Relevance 76.67%

So I have this excel spreadsheet and an example of it basically looks like this:
Project Phase Person Capacity Start Date End Date
A Design 1 25% 1/15 3/16
A Model 1 25% 3/17 5/11
A Design 2 25% 1/15 3/16
A Model 2 25% 3/17 5/11

I'm looking to track a monthly outlook of capacity % over time for each person (in a pivot table), but I'm unable to get it exactly the way it should be. Essentially I would like it to look like this below:

Dates
Person Jan Feb Mar Apr May
1 25% 25% 25% 25% 25%
2 25% 25% 25%

Is this even possible, either in a pivot table, or even using formulas?
 

Answer:Excel 2007 - Start Date and End Date question

You should have posted that in "Business Applications" here: http://forums.techguy.org/16-business-applications/
 

3 more replies