Computer Support Forum

Determine Number of Night Consultations from time entered

Question: Determine Number of Night Consultations from time entered

What formular can i use to determine the number of night consultations from time column of number of visits in one month.Night consults is anytime between 18:00hrs to 06:00hrs, 06:00hrs to 18:00hrs are regular day consults

Relevance 100%
Preferred Solution: Determine Number of Night Consultations from time entered

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: Determine Number of Night Consultations from time entered

There may be a shorter method, but this seems to work:=SUMPRODUCT((HOUR(A1:A25)>=16)*(HOUR(A1:A25)<=23))+SUMPRODUCT((HOUR(A1:A25)>=0)*(HOUR(A1:A25)<=6))The first SUMPRODUCT determines the number of Times whose Hour is >=16 and <=23.The second SUMPRODUCT determines the number of Times whose Hour is >=0 and <=6.Summing those 2 values should give you the result you are looking for.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Relevance 65.19%

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 65.19%

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 64.78%

Hello All,I am writing an Excel program for my employer and we are in the fabrication industry and use AutoCAD and Excel in tandem. What I am wanting to do is to write a formula that will determine if a number is either on the + side of a multiple of 1/16" (.0625) or on the - side of it. For instance, if a calculated value comes back as 1.0945" I want it to read 1.125"- if the calculated number is 1.555" I want it to read as 1.125"+. The deciding factor would be which side of the 1/32" between two 1/16ths the calculated number fell between. I hope this makes sense and that someone out there can be of some help. Thank you in advance.

Answer:how to determine if a number is on the +/- side of a number

I'm confused...The rounding of 1.0945 to 1.125- makes sense, but the rounding of 1.555 to 1.125+ doesn't.1.555 is much more than 1/16th higher than 1.125. Are you sure you don't want 1.5625- for 1.555?If so, try this:=IF(A1<ROUND(A1*16,0)/16,ROUND(A1*16,0)/16&"""-",ROUND(A1*16,0)/16&"""+")Sorry, I forgot to deal with situations where the calculated value lands right on a 1/16th increment. Try this:=IF(A1=ROUND(A1*16,0)/16,ROUND(A1*16,0)/16&"""",IF(A1<ROUND(A1*16,0)/16,ROUND(A1*16,0)/16&"""-",ROUND(A1*16,0)/16&"""+"))Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.message edited by DerbyDad03

3 more replies
Relevance 64.37%

Hi , I did a restore recently of my Tiny PC and I am having a problem with the keyboard number pad. When I use it the numbers it does not put in the keys that I have entered. When I hit the keys the following happens 1 =2122 = 213 = 34 = 455 = 546 = 67 = 878 = 879 = 90 = 000The keys on the main keyboard are fine can anyone advise on this please? Ta Dave

Answer:Incorrect Numbers entered number pad used

I should also say that I my PC runs on Windows 98 Regards Dave

2 more replies
Relevance 62.32%

Will this cause problems & how do you get in to enter the number?
 

Answer:looking thru cmos setup utility and there is no system serial number entered

Are you trying to flash a motherboard?

7 more replies
Relevance 59.86%

Hi! I recently sent my lenovo Y450 laptop to a service center for repair of malfunctioning SHIFT key. After 3 weeks it was repaired. BUT i noticed that the HDD was replaced and reformatted without prior notice from the service center. Is there a way to track the original parts? I have recently browsed my product info in lenovo site but did'nt gave me any serial number of my HDD.. Thanks in advanced Jessie Boy

More replies
Relevance 59.86%

Dell Studio 1537 Laptop (c. 2009)
I'm trying to determine which replacement lid, hinges, and bezel I should order to fix up my old Studio before I sell it.  I know that I should be able to take it apart and read the stickers to find out which revision it is, but Dells repair staff swapped so many parts around during the process when I'd sent it in to them, I'm not sure which parts are original, or where I could look to determine which revision number I would need with the current configuration.  Any advise would be appreciated.  Please read on for further details...
The Problem
The Bezel fits the lid properly, but not around the screen.  It covers up the bottom edge and one side of the screen by about 1/8", while there's an exposed black area on the top edge and the opposite side.  Basically, it looks like the lcd panel is not aligned properly inside the lid, but I took the bezel off to fix it myself to find that the screen is mounded and aligned properly.  after doing some research i remember reading something about various revisions of the Studio 15 series using different parts, which aren't all compatible with each other, but I dont know if the lid is the cause of the problem, or having the wrong bezel for that lid... or if those parts match but the lcd panel is wrong for both.  so for the past however-many-years, I've lived with the off-center screen.
To add more complications to the probl... Read more

More replies
Relevance 59.86%

Hello,
 
Question 1: How do I determine the version number of McAfee Framework on Windows 5, 6, 7, 8, etc.
 
When I run services.msc on Windows (via the Search box and the Start task bar), I see FrameworkService.exe. The description shown is "Shared component framework for McAfee products."
 
This service, I believe, is McAfee Framework. I'm looking how to determine the version number of this.
 
For work, I have to determine the version number of McAfee Framework on several computers because they may be updated to a newer version of McAfee Framework.
 
Question 2: How do I install the most recent version of McAfee Framework?
 
Thank you,
Michael

Answer:How Do I Determine The Version Number Of "McAfee Framework"

Hi Michael The article below might be of use to you:https://kc.mcafee.com/corporate/index?page=content&id=KB58876Personally, I would right-click on the FrameworkService.exe file and select Properties. From there, I would go in the Details tab and check the version number of the file. If it doesn't have the version number, we could make you list your installed programs with MiniToolBox and look for "McAfee Framework". Usually, the version number is listed with the program name.

12 more replies
Relevance 59.45%

My Lenovo T61 Thinkpad won't power up and I've been told that the motherboard is dead. I'd like to get a new mobo before dis-assembling the unit. Am I able to determine the actual mobo number via the computer number? It's a Lenovo T61 7658-CTO serial number L3-F00780H12. Any help will be appreciated. Thanks.
 

Answer:Can I determine the motherboard number before dis-assembling the dead computer?

You could download the free Everest diagnostic.
 

2 more replies
Relevance 58.22%

Had an AMD HP G62-227CL laptop that overheated and required motherboard replacement with similar Intel motherboard. Old board clocked at 2.2 MHZ .. new one is 2.0 MHZ.
Board I got from Ebay works but now computer believes that it is a Compaq CQ42 Laptop. Do not know the model number, which I would need on HPs site to download BIOs upgrades.

Is there a way to tell which bios I need or what model I now have?

Thank you,

Steve
 

Answer:Replaced Failed Motherboard.. now how do I determine model number and which BIOS to download?

Finding a bios update rather then the one hp would give for this board. Would be next to none.
You could check a few of the support pages for this model. Which their are a lot Of
Maybe find out the motherboard you have bought.

HP Support, Drivers, Contact and Help Forums | HP ģ Support
 

2 more replies
Relevance 57.81%

Hi there, I hae windows 7 x64 and it's currently haing a problem that baffles me.
Wheneer I enter my password the first time it says that it is incorrect, but the next time I enter it, it works correctly.
Help would be appreciated! Sorry about the missing letters my V key doesn't work (no its not in my password)

Answer:Password doesn't work first time entered

Replace the keyboard.

5 more replies
Relevance 57.81%

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 57.4%

24 hour format, only zeros appear when data entered. I want to enter an arrival time in a spreadsheet. The cell is formatted to Time, 24-hour (HH:mm:ss). No matter what is entered the only thing that shows up is 00:00:00

Answer:24 hour time format, only zeros appear when data entered

re: "No matter what is entered the only thing that shows up is 00:00:00"Even text?Please be more specific.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

6 more replies
Relevance 56.17%

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 54.94%

Hi,
I am trying to find a reliable method how to determine the boot time of our Windows clients (still mostly Windows 7). As far as I can see, it is mostly recommended to use WMI ($x = gwmi -comp $Computer -cl Win32_OperatingSystem) but in several cases
(about 7 % in our domain) the time ($x.LastBootupTime) does not correspond to the latest Event 6009 in the system log and is obviously wrong.
What is the reason for the discrepancies? Querying the event log is much slower...
Thanks, Georg.

More replies
Relevance 54.53%

Hi,

At 2:24 am each night, my computer freezes. I have tried to look in my Event Viewer but cannot see anything that sticks out. I was hoping that you folks might be able to help.

I have been using HJT, AdAware, Microsoft AntiSpyware, NAV and Spybot but to no avail. Here is my HJT log:

Logfile of HijackThis v1.99.1
Scan saved at 12:14:08 PM, on 11/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\ccEvtMgr.exe
C:\WINDOWS\system32\LEXBCES.EXE
C:\WINDOWS\system32\LEXPPS.EXE
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Java\jre1.5.0_04\bin\jusched.exe
C:\Program Files\Analog Devices\SoundMAX\SMax4PNP.exe
C:\Program Files\Analog Devices\SoundMAX\smax4.exe
C:\PROGRA~1\Logitech\MOUSEW~1\SYSTEM\EM_EXEC.EXE
C:\Program Files\Common Files\Symantec Shared\ccApp.exe
C:\Program Files\Microsoft AntiSpyware\gcasServ.exe
C:\Program Files\Logitech\iTouch\iTouch.exe
C:\Program Files\Common Files\Real\Update_OB\realsched.exe
C:\Program Files\Microsoft AntiSpyware\gcasDtServ.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\program files\TheWeatherNetwork\WeatherEye\Weathe... Read more

Answer:XP Freezes Each Night at Same Time!

Hello TheFloydSW and welcome to TSF,

How long ago did this problem start?

I'm not seeing anything in the log, plese do the following:

Download CleanUp! (Alternate Link if main link doesn't work) and install it.

Open Cleanup! by double-clicking the icon on your desktop (or from the Start > All Programs menu). Set the program up as follows:
*Click "Options..."
*Move the arrow down to "Standard CleanUp!"
*Uncheck the following:
-Delete Newsgroup cache
-Delete Newsgroup Subscriptions
-Scan local drives for temporary files
Click OK
Press the CleanUp! button to start the program. Reboot/logoff when prompted.
Note: CleanUp! deletes EVERYTHING out of your temp/temporary folders, it does not make backups. If you have any documents or programs that are saved in any Temporary Folders, please make a backup of these before running CleanUp! If you have a 64 bit Operating System do NOT run Cleanup and let me know as we will use another utility

Please run an online scan at http://www.pandasoftware.com/products/activescan.htm *Requires Internet Explorer.
Make sure you click the "Free Online Virus Scan" in the upper right hand corner of the page under the Free use Activescan header. We do NOT want the default spyXposer scan. Click on the Scan your PC button & a 'pop up' window shall appear. * ensure that your pop up blocker doesn't block it
Click On 'Scan Now'
Enter your e-mail address & click 'Scan Now'... Read more

6 more replies
Relevance 54.53%

Every night at 11:00pm, my computer freezes. Not even the screen saver moves. No mouse, etc. Have to reboot to resolve. Nothing unusual in Event Viewer. Just nothing happens after approx 11:00pm.

Answer:Freeze at same time each night

just a long shot .... check in control panels>scheduled tasks do you have any scheduled tasks that start at 11PM?

3 more replies
Relevance 54.53%
Question: Night time clock

Can anyone recommend a good night clock (free) as my new 930 doesn't have glance. Didn't realise I would miss it so much from my late (but great) 920

Answer:Night time clock

If you do not get better suggestions try car dash. It's actual for cars but you can use it as nigh stand. The lock screen can be disabled.http://www.windowsphone.com/s?appid=...5-bbb7d4a8c652

more replies
Relevance 54.12%

As long as i've been using computers I cant remember how you can determine how long windows has been up since your last restart. I tried searching yahoo but couldnt find anything. Argh.
 

Answer:Stupid question, how do you determine windows up time?

Start > Programs > Accessories > System Tools > System Information. I just checked my system and it doesn't show there anymore (it used to!!!). If you are really concerned with it, I can email you a 1KB batch file that shows you just that. LMK. Try the system information thing first and let me know if yours shows. Thanks!
 

14 more replies
Relevance 54.12%

OK, I'm writing a game for my AP Computers final project. I want to load some images into the game. I don't have a problem with actually loading the images, I just need a way to figure out where the images are on the disk. I know where the images are relative to the class file, I just need to figure out where the class file is. Something similar to getCodeBase in applets.
 

More replies
Relevance 54.12%

Every night usually between 8-10pm my DSL goes down. This has been going on for several months now (never happens during the day). I have replaced the DSL modem and my NIC card. Sometimes I can power cycle the modem and it will bring it back up, somethings that doesn't work. My modem is connected to a Linksys Wireless-G Broadband Router which is very secure. I have called Earthlink about this issue numerous times ... and I have spoken with Linksys ... but the problem goes on!!!

Can the Norton Log ... or any other log on my system help me figure out what is going on? Does this seem like a problem with the local telephone company that Earthlink rents space from?

Your thoughts/ideas would be most welcomed!!! I would like to end my frustration on this issue!
 

Answer:DSL connection lost same time every night

11 more replies
Relevance 54.12%

I'm running Windows 7 64 bit with a Linksys WAG 320N modem.

The last few days my internet disconnects every night at roughly 12:30. I have checked my wireless drivers in devices and the part to automatically disconnect is unticked.

I can't find anything in the modem to automatically shutdown

Anyhelp would be greatfully appreciated
 

Answer:Internet disconnects every night, same time

8 more replies
Relevance 54.12%

I am in canada now, im from the usa. When i first got here, the internet wifi was very bad at that place. I then went to another apartment and was told internet wifi here was very fast and reliable. The wifi is fast and reliable here... however, sometimes it does disconnect a bit and a bit slow but thats not a big problem usually.
Well i had noticed something very strange. The last week or so i went to bed pretty late and am online. I noticed that at exactly 3:40am... the wifi immediately disconnects and when i click on the internet icon in the bottom right to look for the internet connection... its no longer there. There are 2 wifi internet names/routers in this building that i live in and i was told they have 2 of them in case one of them have a problem, i connect to the other. Lets call them wireless connection a and b. Wireless A is very fast and reliable. B isn't that reliable and many times you can't connect to it though but its still okay. During the day seems to be good but Wireless A is faster than B so i stick with that one.
Anyways, at around 3:40am... wifi goes off. Check the wireless connections... both of them are gone. So i cannot connect to any wireless internet connection at all. I see some other wifi networks but of course thats someone elses and i cannot connect to it b/c u need a passcode for it.
The next day or so, i went to bed pretty late so just going online. Same thing... 3:40am... wifi goes off and when you search for the wifi connect... Read more

Answer:Why does my wifi in my building go out every night at exactly the same time?

16 more replies
Relevance 54.12%

Sorry if this is the wrong forum. Every night at 11:30 my cable internet connection is lost. It comes back on after about a minute and everything is fine. This is the only time of the day that I have noticed this problem.

I am running XP Pro with SP1. I run AdAware and Spybot a couple times a week, and I use Norton AV as well as AVG Free. I also recently set up Zone Alarm Firewall. This problem was there before ZA though. I also do not have any scheduled tasks set at this time.

Does anyone have any ideas about this? Thanks for any help.
 

Answer:Internet connection goes away every night, same time

Your cable modem or network hub (if you have one) could be set to allow connections 23 hours and 59 minutes. this would disconnect you and then after the minute is up it would reconnect you. My wireless router does this at 11:59pm every night. I don't beleive there is anyway around it.
 

2 more replies
Relevance 54.12%

Every night between 8pm and 10pm the game I play, Perfect world international and Arc the launcher stops working. I cant load website or get onto game , once it gets to 10.05pm it works fine again. Everything else on the net works fine. I contacted their tech department and the reply is...That's odd. It doesn't appear to be a latency thing, as pings are decent along the way, but the connection appears to be dying just outside our network. The next time the connection goes out like this can you try pinging the server directly, then launching the game and see what is happening? I'm at a loss as to what's going on with your connection. The fact that it happens at the same time every day clearly makes it a connection issue, but the times don't match up with anything on our end .. so I ran the ping test when I couldn't get on and it was
Pinging patchserver.crypticstudios.com [208.95.185.41] with 32 bytes of data:
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Request timed out.
Request timed out.

Ping statistics for 208.95.185.41:
Packets: Sent = 47, Received = 0, Lost = 47 (100% loss),
Control-C
^C
C:\Users\User>
I deleted a lot of those request timed out so it fits on this page ...I contacted my isp they said the lines were fine. Im at a loss what to do as both sides say its not their problem....
 

More replies
Relevance 54.12%

Every night, at exactly 2:00am my computer starts slowing down, taking forever to open programs, any video playing will begin to skip and get choppy, even switching to AIM from the task bar takes forever. When it happens I look at the taskbar and there appears to be no major programs running, usually just AIM and McAfee. And when I go to current system processes neither are using CPU power, the only thing that has high CPU usage is "System Idle Process" which I don't know what that means. I thought it might be Windows Update but I've disabled it. It is annoying because i usually stay up late and it gets so slow at this exact same time. Resetting the computer seems to work and make it normal but is there a way I can find out why it gets so slow every time at 2:00am?
 

Answer:Computer slows down at same time every night

Something is kicking in, maybe it's a virus scan sheduled for that time, or virus updates. Those are my two guesses. Windows Defender is set to do auto scans at 2:00am, as is another virus/malware protection program, but I can't remember which one! If you have Defender installed check it's scheduler. It doesn't have an icon in the system tray by default, you have to go in and change the settings to show the icon, so you may not know that it's running. It's listed in processes as MSAScui.exe.
 

2 more replies
Relevance 54.12%

If I tel my computer to go to sleep when I am finished with it for the day, sometimes about 01:00 in the morning. When I get up, or even wake through the nightI can see that it hase come back on even while in another room as the screen will be lighting up the room. The screen / monitor would just be left to go on stand-by which I prefer rather than actually switching it OffWhat has caused this and how can I stop it?My laptop which uses Win7 also, is OK an will not do this.HP Computer, Intel i5, using Win7.Thanks

Answer:computer wakes up at any time through the night

Probably a program updating itself , or Windows checking for updates , something like that would be enough to wake a sleeping PC . Ashley

8 more replies
Relevance 53.71%

Hello,

I have been using Dreamweaver for several years now and this is the first time I have received this error.

When I try to connect to the host I get a message that says the host is found. Then I get another saying it is verifying connection. This verification goes on for a while then I get "connect to host lost.' When I click on okay I get the "Dreamweaver cannot determine the remote server time."
When I click okay I get another error "An ftp error occured - cannot get remote folder information."

I have a cable modem with 2 computers set up through the modem. I uploaded Dreamweaver on the second computer and tried to connect. I get the same errors.

I have a co-worker in a different location who is able to connect to the host with no problem.

I am using Windows XP

Thank you for any help you can give.

Regeth
 

Answer:Error: Dreamweaver cannot determine the remote server time

8 more replies
Relevance 53.71%

Every morning for the past week and a half, I've gone into my office to discover that my monitor screen has gone black at some point during the night. This morning was different. It was stuck on the reboot stating "windows is shutting down". Each time I have to do a hard reboot. The computer runs fine throughout the rest of the day. I first made sure my drivers were updated and ran a couple of malware scans, which indicated my system was clean. I checked my system log in event viewer and found that every morning at 3:30AM my system tries to reboot after Microsoft tries to install KB970430.

Here are the events:

------
3:00:35 AM Windows XP Hotfix KB970430 was installed.

3:00:41 Restart Required: To complete the installation of the following updates, the computer will be restarted within 15 minutes:
- Update for Windows XP (KB970430)

3:00:41 Installation Successful: Windows successfully installed the following update: Update for Windows XP (KB970430)

3:15:36 The process winlogon.exe has initiated the restart of CHUCK for the following reason: No title for this reason could be found
Minor Reason: 0x2
Shutdown Type: reboot
-----

This is when my system gets hung up.

I disabled automatic updates for now, but would prefer that they work when I have them enabled.

Why is my system having trouble installing this update and why is it having such a difficult time restarting?

Thanks in advance!

Chuck

More replies
Relevance 53.71%

Hi to all

I bought new laptop satelliate P300-133 two weeks ago, since 3 days ago the laptop always restart in the minight about 3 AM,
does anyone have same problem like this?
I do not think the problem from the machine,becasue the problem just came 3 days ago,maybe there has some thing worng about system set or someting
pls give me some point if you can help me ,thanks

Answer:Satellite P300-133 restart in the same time every night

Hi

I doubt there is something wrong with your notebook.
Is the notebook connected to LAN?
If yes then the enabled Wake up on LAN option could be the reason why the notebook powers on itself?

So access the BIOS and disable this option;
Furthermore I recommend disabling this in device manger -> LAN properties -> Advanced tab.

Last but not least you should check if some ?Scheduled Tasks? are not set which could power up the notebook as well?


Greetings

3 more replies
Relevance 53.71%

Each morning when I wake up, my computer is on, rather than in sleep mode, as I left it. I have disabled the power of the mouse to wake it. What else can I try to fix this problem?

Answer:computer wakes from sleep at night time

Check all likely devices in Device Manager to see what their power management settings are. Also it could be MS updates taking place, or in my case a cat walking across my keyboard at night when keyboard wake up was enabled.

10 more replies
Relevance 53.71%

Hi all newbie on the lan gaming
Have: belkin five port gigabit switch
: five pc's 4 intel and 1 amd all nvidia cards 5900 5950 6600gt 8800gt 7600gt
Games:Unreal 2004 works great and swat four no prob
V8 Supercars Times out on the AMD - Any Ideas Please ?
Battlefield 2 Hangs on one intel machine so make that machine the server then the Amd gets kicked or just shut down whole game on that machine ?
Flatout 2 would not allow the amd machine to log on and when it could it would kick and or freeze and have to do a ctrl alt del ?
Swapped Lines around in switch with same results any ideas or is it just patches for all these games
Thanks for any help
ps sorry if i havent give all the info i need but first time with this
pss also on the switch notice there is a four block of slots then one by itself ?
 

Answer:Lock ups and time outs on a network night

What is the model number of the Belkin "switch"?
 

3 more replies
Relevance 53.71%

There is a program on my PC that runs every night at exactly 11:02 PM, but it does not show up in Task Scheduler. The reason I know it runs is because there is a tiny window that pops up in the top left corner of the monitor and then disappears very quickly. I have tried to see what it is, but it is impossible. It happens too fast for me to catch what the window says. Is there a catalog in Windows that I can use to see what opens at a particular time? I guess it is showing up in Task Manager, and I have tried to identify the process, but there are too many. I have researched them, but that hasn't helped, because I am not getting enough information about some of them.

Thanks in advance for any and all help
 

Answer:Unknown Program Initiates at the Same Time Every Night

6 more replies
Relevance 53.71%

Ok basically I'm having trouble with my son staying up too late during the night surfing the net. We've agreed his bedtime should be midnight, however he sleeps in the basement and that is where our computer also is stationed.

I can't stay up until midnight to be able to see to it he goes to bed on time as I have work early in the mornings.

I heard from a friend at work that you can program your network connection to go offline at a specific time every day using an administrative account on our computer.

Could anybody please give me a run through of how I could possibly set this up? We run Windows XP and our service provider is Shaw(Canadian Internet Service Provider)
 

Answer:Need Help programming network to shut off at the same time each night

8 more replies
Relevance 53.71%

Each morning when I wake up, my computer is on, rather than in sleep mode, as I left it. I have disabled the power of the mouse to wake it. What else can I try to fix this problem?

Answer:computer wakes from sleep at night time

Check all likely devices in Device Manager to see what their power management settings are. Also it could be MS updates taking place, or in my case a cat walking across my keyboard at night when keyboard wake up was enabled.

10 more replies
Relevance 53.3%

I have an Excel cell (general format) with the number 7.40 in it. It's supposed to mean 7 hours, 40 minutes. I need to multiply what 7.40 really means (7.67 hours) by a rate for another cell total. How do I convert the 7.40 to 7.67? (I realize I could just change the 7.40 to 7.67, but I'm being simplistic - there are thousands of cells with the data entered this awful hh.mm way.)

Answer:Convert number to time to decimal time in Excel

The trailing zeros are the main problem, as Excel will drop them, so 7.40 becomes 7.4Here is a work around.With your numbers in column Ain column B enter the formula: =TEXT(A1,"00.00")which will convert your number to text and retain any trailing zerosYour column B should look like: 07.40Next, in column C enter the formula: =TIME(LEFT(B1,2),RIGHT(B1,LEN(B1)-FIND(".",B1)),)*24Which will now convert your text string back into a time and by multiplying by 24 get your decimal number.See how that works.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 53.3%

i have Time computer which i bought in 2004 and then later it went bust and now i have virus on the computer and try using the reload or recovery cd but i get the error message unable to determine bios lock please contact manufacturer which have gone bust and need to my computer back as quick as possible running please help much appreciate with owners of time computer or ho have experienced this problem please help! what shall i do and how to bypass it and reinstall windows xp because it's not happening with bootup disks

Answer:Time computer showing unable to determine bios lock?

HI, i have the same issue with tiny PC, any help appreciated. In fact what i would prefer is not tohave to do the reload, but it all keeps crashing on me, cant boot up even in safe mode. Got as far as defrag in safe mode then crashed and cant get anywhere near it now

1 more replies
Relevance 52.89%

About a month ago I made the mistake of allowing windows 7 to update, which I do maybe once a year, which had the same consequences it always does, it ****s my graphics drivers. Normally I just pop my VGI cable into my integrated graphics card, uninstall my graphics drivers and reinstall them straight from AMD's website. This time that has not worked and now around 4 am every day my computer crashes. I actually slept through an exam because my computer also functions as my alarm clock.
my specs are on my profile and my log is right here

Answer:BSOD same time every night since Windows Update, GPU related

Hey chalkbrood, Welcome to Sevenforums.

Lets start by updating your BIOS. There have been several updates since the version you have.

New version = 3603 Yours is 3201

Motherboards - P8Z68-V/GEN3 - ASUS

After this, its going to take a while for me to go over all of your programs that you have on your PC... Its A LOT. My biggest recommendation would be to start over and perform a clean install. If thats not an option...

You have Daemon Tools/Alcohol 52% which can cause BSODs and sometimes carry malware/spyware. Second, I haven't looked at all your programs like I said but just by skimming through a bunch of red flags go up. In startup you have some odd Google Chrome startups and upd.exe which is sometimes associated with a Trojan. It doesn't help that you're running McAfee security because it's garbage.

At a minimum for now..

Download Revouninstaller (Always use Advanced Option > Select All entries found on each screen and delete them)
Download Revo Uninstaller Freeware - Free and Full Download - Uninstall software, remove programs, solve uninstall problems

Please remove McAfee, Alcohol 52%/Daemon Tools, and any other programs you've installed that you don't need. There is something showing up in your programs with a bunch of weird characters. If it is present when you scan with Revo, remove it.

Download and install, then scan with Microsoft Security Essentials.
Microsoft Security Essentials - Microsoft Windows

Download and run Malwarebytes (Click Custom Scan, C... Read more

1 more replies
Relevance 52.48%

Whenever I take pics in the night time with flash, so many bubbles are in the photos taken from my Lumia 1020. So anyone tell me what's the problem? I'm on latest developer preview. :(

Answer:Why the bubbles came in the pics in night time with flash when I take from my Lumia 1020??

Do you mean bright circles? It might be dust or to much moisture in the air. It happens to me when it gets abit foggy.

6 more replies
Relevance 50.02%

Does any one know a tool which is able to measure bandwidth, connection loss time, number of packet loss, switching time of a wireless network

thanks
 

More replies
Relevance 49.2%

Not EXACTLY every other night, but it seems that way.

This is my office machine, Dell Studio XPS 8100, purchased October 2010:

- Win7 x64 Pro
- Core i7 Quad 870 2.93 GHz
- 12 GB DDR3 SDRAM
- ATI Radeon HD 5770 1GB

This is in an office with a Server 2003 machine as the domain controller, and all machines in the office log onto the domain.

Typically in the evening I log off my machine, but leave the machine running (for updates, etc). Quite a few times over the past few weeks, I come in the next day, log on, and see the message "Windows has recovered from an unexpected shutdown".

In the Event Viewer, it looks like it's happening as a result of something called "bugcheck" running. It happened Friday night, based on the following messages:

Event 6008 8:58:37 PM "The previous system shutdown at 8:49:11 PM on ‎12/‎17/‎2010 was unexpected."

Event 1001 8:58:39 PM "The computer has rebooted from a bugcheck. The bugcheck was: 0x000000fe (0x0000000000000005, 0xfffffa800d6501a0, 0x0000000080863b3c, 0xfffffa800de6f8a0). A dump was saved in: C:\Windows\MEMORY.DMP. Report Id: 121710-21028-01."

I logged off on Friday about 5:04 PM, and I know there was a Windows Update installed just after 7 PM.

Graphics driver is up to date. Not sure about the BIOS. What could be causing this bugcheck crash?

Answer:System crash at night every other night past 2 weeks

Follow these instructions
http://www.sevenforums.com/crashes-d...tructions.html

9 more replies
Relevance 47.97%

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, ?????

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").... Read more

13 more replies
Relevance 47.56%

We have a Windows server 2008 network in our office. Someone stole one of the switches but I can't be sure of the exact time. Where the switch is there's no CCTV camera, but there is a camera that shows the entry into the room where the switch is. Is there any way of looking at a log in any of the 2 computers that became disconnected from the network as a result of the theft to determine what time the disconnection took place? If I know this time I can correlate this information with CCTV data to see who did it. The disconnected computers were running Windows 7 and one was a Windows XP machine.

Answer:Who stole the network switch? How to determine what time the network went down from a log?

Maybe possible by looking in Event Viewer ClickHere Might be logged in Event Viewer. I think the path is: Event Viewer, Applications and Services Logs, Microsoft, Windows, Diagnostics-Networking. The Event ID is 6100 I think for disconnections.

1 more replies
Relevance 47.56%

I need to have users fill out a form in word or excel. I would like for each form to have a unique number when they fill out another one. Is there a way to do this automatically ?
 

Answer:Forms with new number every time

Here's a file that does it in Excel. You can steal the code or just change the file as needed.

Download MyInvoicing at:

http://www.theofficeexperts.com/downloads.htm#ExcelDownloads
 

1 more replies
Relevance 47.56%

I need to roundup a block of time to the near 10 min increments. ex. cell F4 has 8:43 AM cell G4 has 9:16 AM using formula =TEXT(G4-F4,"h:mm") I get 0:33 in cell H4 now i need to roundup this :33 min to the nearest 10 in cell I4 but not sure how to write the formula.Please help :)

Answer:Rounding up time instead of number

Try this:=MROUND(H5,"0:10")If you get an error message, then install the Analysis Tool Pack add-in. Sorry, =MROUND() only rounds Down.MIKEhttp://www.skeptic.com/

5 more replies
Relevance 47.15%

ExcelI put in 10:25 begin time10:30 end timethe calculation I set up shows a diff of 00:05 minutes it is rightIf I put in 10:59 begin time11:00 end timethe calculation shows a diff of 00:41 minutes.When the begin time is in one hour and the end time is in another doesn't calculate correctly

Answer:excel time calculates as number

How are you doing your calculations?What is the formula your using?
A B C
1) 10:25 10:30 0:05
2) 10:25 11:00 0:35
The correct formula should be =B1-A1The cells in column C should be formatted as TIMEIf you do =A2-B2 you get -0:46MIKEhttp://www.skeptic.com/

4 more replies
Relevance 47.15%

Convert mm:ss to number format to be able to calculate average time ex.A1=00:57A2=01:06A3=03:10A4= AVERAGE A1:A3

Answer:need to convert time format mm:ss to a number

Try this:Custom Format you time cells as: [H]:MM:SS then do your average:

A
1) 0:57:00
2) 1:06:00
3) 3:10:00
4)
5) 1:44:20 <--=AVERAGE(A1:A3)

MIKEhttp://www.skeptic.com/

2 more replies
Relevance 47.15%

get a high pitched whine on start up and number four appears in all fields

Answer:ithe number four appearing all the time

sounds like another issue, try starting up with a different keyboardmike

2 more replies
Relevance 47.15%

Hello TSG!
I am looking for a solution (maybe a registry setting) to not allow XP to print, say, more than 30 pages in any one print job. Any ideas?

Thanks!
Curtis
 

Answer:Set Max Number of Pages to Printed at a Time

Any ideas? Found some software online that is far beyond what I need.
 

1 more replies
Relevance 47.15%

EXAMPLE:8:00 B2 9:30 C2 D2 needs to be total hours in number format (eg. 1.5)

Answer:how do i convert time to a number in excel

Format cell D2 as NumberInsert the formula:=(C2-B2)*24See how that works.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 47.15%

i am looking to change time to decimal via excel.For ExampleA1 (Start Time) 18:10B1 (Finish Time) 20.30A2 (to equal total working time) the changed into Decimal could you please guide me through this as everything i have tried is coming up with an error.Ian

Answer:change time to decimal number

Try this link.

2 more replies
Relevance 46.74%

Can anyone help me with a safety project? I'm looking for a cross-section of a domestic bath, which will be used to represent a reservoir. I'm using the ArtRage program, which unfortunately requires free-hand drawing, which I'm hopeless at.But I'm very good at tracing! Any offers can be uploaded to click here and the link posted in the forum.

Answer:Friday night is bath night?

Is this click here any help?

3 more replies
Relevance 46.74%

For the last 2 weeks or so my computer reboots during the night. I don't see the BSOD it just reboots to my normal start screen.  When I check CCleaner I find these files:C:\WINDOWS\MEMORY.DMP 2,046.0MBC:\WINDOWS\MiniDump\Mini070609-01.dmp 64.00KBC:\WINDOWS\MiniDump\Mini070709-01.dmp 64.00KBC:\WINDOWS\system32\wbem\Logs\wbemcore.log 2.34KBC:\WINDOWS\system32\wbem\Logs\wbemess.log 3.42KBC:\WINDOWS\system32\wbem\Logs\wmiprov.log 1.59KBC:\WINDOWS\system32\wbem\Logs\wbemcore.lo_ 64.07KBI delete them and they are there the next day.I've done a memory test and the memory passed with no faults.  I have AV and antispy software and run regular checks.  I haven't installed any new software/hardware recently.  I'm running Windows XP with SP3.   Apart from the reboot and the files in CCleaner the computer seems to be running fine.Any ideas?

Answer:Computer reboots during the night every night

QuoteI delete them and they are there the next day.Don't. Those files are needed for troubleshooting.Open Windows Explorer.Navigate to: C:\Windows\Minidump folder.If you see any .dmp files, zip all of them, and attach zipped file to your next reply.Vista users. You may need to copy .dmp files, paste them into some other folder, or desktop, and zip them there.

14 more replies
Relevance 46.33%

Hi:

I need this urgently!

Trying to find the average sale per hour using number and time.

E.g:

Sales = 2

Hours worked is calculated as a difference between opening and closing time.
 

Answer:[SOLVED] calculating average using time and number

9 more replies
Relevance 46.33%

Hi, i have this text file which i want to format with excel by changing numbers series in first column to time format( 933242124,933242148 so on ..)I want time in hh:mm:ss format.
Problem is i can convert the number by dividing 84600 ( number of seconds per day ) and then format cells with time format ( see the excel in second attachment), but i want time series in Indian stock market session ( 09:55:00 to 03:30:00)and i want time started from 9:55:00 AM and time series should look like after converting first column 09:55:24,09:55:48 etc ( few minutes here and there would be ok ) is there any way to convert time in to user define time series?
Also like to add that i tried to devide above number series by 20100 ( total no. of seconds from 9.55 to 3.30 pm ) but i didnt get success.
 

More replies
Relevance 46.33%

It seems that my keyboard has this issue where it only allows 3 keys to be in use at a time. I have troubles with some of my PC games that require the use of 4 or 5, sometimes even 6 keys to be pressed at a time. It's a Cordless Gateway iTouch Keyboard. If anyone has any suggestions, I'd be very appreciative.
 

Answer:Is there a way to disable my keyboards max number of keys at a time?

It's normally a function of the keyboard encoder chip, usually in the keyboard for desktop machines, and on the MB for laptops. Have you tried a new keyboard?
 

2 more replies
Relevance 46.33%

Hi all,

As per title, how can do will the below data set?
F G
13:03 14:31
13:04 14:25
13:05 19:00
13:37 15:45
13:31 14:24
14:02 15:00
14:03 15:32
14:05 14:45
14:35 15:35
How can i know the max times overlapped for the above 10 sets of data? thanks!

Edit
 

More replies
Relevance 46.33%

Hello I was using the night mode option available on Lenovo Settings, which then had a option to turn it on or off. After Windows 10 updated, Windows now has a night mode option, but the Lenovo Settings one is still working and I can't deactivate it because there is no longer a option. At night, the screen become so red all the black parts on the screen look like blood.  Removing Lenovo Settings solve this, but I need the configurations available on Lenovo Settings, so I can't uninstall it.  Is there a way to deactivate the Lenovo Settings night mode after this update, knowing there is no longer the toggle option in the interface? A configuration file or registry I should remove or a command I should use? Thank you. 

More replies
Relevance 45.92%

I was performing updates on the computer when the battery power died and when provided the power cord I had a black screen and the caps and number button appears to blink once at the same time. I upgraded the operating system about 1 month ago to Windows 7 and it has been working fine until the updates began to update.

More replies
Relevance 45.92%

From an archiving operation I have to handle a directory that contains about 80.000 sub-directories (and increasing).The number cannot be reduced or distributed over a larger number of sub-directories.Consequently, working in the directory is VERY slow, as it re-reads the directory structure after every action.Is there any way to speed up access to such a directory (e.g. when accessing with "Explorer" or programs such as "Total Commander") or at least optimize performance ?

Answer:Large number of directories - access time (NTFS)

Not sure I can give you a good answer, but might be worth asking whether your hard drive has recently been defragmented.  Has it?Your OS?  How much free space (MBytes and percentage) on your hard drive? 

6 more replies
Relevance 45.92%

How many Real-time 3rd Party Security products do you use?
...and if you had to grade them,which would you be least willing to part with?

Most of us at MT use one or more Real-time 3rd Party Security Software products,such as...
Security Suite, Firewall, Antivirus, Anti-Malware, Anti-Exploit, Anti-EXE, Sandbox, HIPS, HIDS....

How many do you use?.and to Grade them,If you have 5 Real-time 3rd Party Security products then..
Number 5 would be the one that you would remove first should you have to,and...
Number 1 would be the one that you would be least willing to part with.

Please Note:
Software that is only "On Demand" such as "Malwarebytes Anti-Malware free" does not count.
Browser Extensions do not count.
Software that detects threats,but does not block them can be included.
 

Answer:Number of Real-time 3rd Party Security products

2 IObit Malware Fighter Pro
1 VoodooShield Free
 

3 more replies
Relevance 45.92%

Installed 64-bit Lightroom 2.5 on new Win-7 box. Entered serial numbers and LR started OK, but when I close LR and restart, it asks for serial numbers again

Lightroom Forum provided the link You must enter your serial number each time you open Photoshop Lightroom 1.x, which gives registry-fix paths for Vista and XP to change permissions to save serial numbers, but these paths don't exist in Win 7. I searched the registry for "serial_number," "registration," and other possibilities, but no luck.

Adobe responded, in part, as follows:

"We believe your issue is resolved and have therefore closed your case #202645724."

"About your concern, try to check the system requirement of the product if it will run on a 64 bit. We are still conducting test since Windows 7 is a new Operating System."

I'd be very grateful for any assistance.

Steve

Answer:Must enter serial number each time you open Lightroom

Problem solved! Went to C:\Users\[Username]\AppData\Roaming\Adobe\Lightroom\Lightroom 2.0 Registration.lrreg, deleted "Lightroom 2.0 Registration.lrreg," which was apparently corrupt, and 64-bit Lightroom 2.5 started normally. Thanks to quetzalita at Lightroom Forums: LR 2.5 serial numbers not retained.

2 more replies
Relevance 45.51%

Yesterday I spread some waters on my thinkpad keyboard and when I rebooted the mouse started to move randomly on the screen. I installed the UltraNav drivers and I decided to remove the keyboard (but it wasn't unplugged) and I waited the entire night to make sure it was dry.When I booted the computer today I got the stuck 38 keys error. After my second attempt the error disappeared. When arrived to the login screen  the mouse was working fine(the touchpad and the trackpoint), however the letters and numbers keys wasn't workings at all(Keys like the arrows , enter and num lock were working). I waited something like 20 minutes and when I tried the keyboard, the keys were working. I dicovered that the keys are working only after some random amount of time after the windows vista login screen appear. It does the same when my thinkpad is turned on sleep mode, the keys are are working only after a random amount of time after the computer is awaken.When I boot with an ArchLinux live cd, every keys are working. I'm wondering if replacing the keyboard could solve the problem :/ I was installing the UltraNav drivers ahen the accident arrived, I wondering if it could be a software issues too ? However I get the stuck 38 keys error when I boot some times.

Answer:T61p : letter and number keys start working only after some time

For how long did you leave it to dry after water was spilled on it?

3 more replies
Relevance 45.1%

I donít know VBA but have been using Access for awhile using tables, queries, forms and macros. I am trying to automate importing a number of Excel 2007 spreadsheets into an Access 2007 table. The import will be done each month, but the number of spreadhseets could be different. The spreadsheets will all be saved to the same folder. I need to import all the spreadsheets in the folder into the same table. I found VBA code that was written for Excel 2003 and Access 2003. I changed the path, the table name and the spreadsheet type. When I run the code I get Run-time error 52, Bad file name or number.

When I debug the code, it highlights the line this line --strFile = Dir(path & "*.xlsx").

Any help will be greatly appreciated!
Code:

[COLOR=black][FONT=Arial][COLOR=black][FONT=Arial][FONT=Calibri][SIZE=3]Function getData()[/SIZE][/FONT][/FONT][/COLOR][FONT=Arial]
[COLOR=black][FONT=Calibri][SIZE=3]Dim strFile As String 'Filename[/SIZE][/FONT][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]Dim strFileList() As String 'File Array[/SIZE][/FONT][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]Dim intFile As Integer 'File Number[/SIZE][/FONT][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]Dim filename As String[/SIZE][/FONT][/COLOR]
[COLOR=black][FONT=Calibri][SIZE=3]Dim path As String[/SIZE][/FONT][/COLOR]

[COLOR=black][SIZE=3][FONT=Calibri] DoCmd.SetWarnings False[/FONT][/SIZE][/COLOR]

[COLOR=black][SIZE=3][FONT=Calibri] path = "\\c:\Monthly Data\"[/FONT][/SI... Read more

Answer:Solved: Debugging for Access 2007 VBA Run-time Error 52 - Bad file name or number.

7 more replies
Relevance 45.1%

Seriously I think the no. Is huge.... But still people in India hv to preorder to buy a phone...!!

Answer:Lumia 535 half a million in number in India is huge or not....in just a time of three month???

At such a reduced price (compared to other smartphones) demand has overpowered supply.
It is that simple.

2 more replies
Relevance 44.69%

I have the following formula in a cell:

=IF((Sheet2!$F$8=Sheet2!$AK$3),(Sheet2!$C$2),(""))

I need to copy this fomula down through 174 rows with the 'sheet number' increasing by 1 in each row.

So the next row should read:

=IF((Sheet3!$F$8=Sheet3!$AK$3),(Sheet3!$C$2),("")) and so on for 174 rows. Is there a way to do this without editing every row?
 

Answer:Solved: Copying a formula in excel 2011 to increase sheet number by 1 each time

7 more replies
Relevance 44.69%

Dear community,  I recently updated my BIOS using the thinkvantage flash BIOS utility for no reason other than it appeared on the update utility. I also updated the model number, once again for no real reason other than update pleasure. Now, everything works perfectly fine on the system, and I have no problems EXCEPT: I use New York Times Adobe Air product called "Times Reader". Since the update, when I try to log into the Times Reader I get an error that states "Authentication Error. Check that your system time is set correctly." In the pre-boot set up screen the time seems to be set right, and in the windows utility the time is set correctly. So my questions is, after a BIOS flash / Model # update, does the system time function need some re-boot / update?  Thanks! 

More replies
Relevance 41.41%

Hi, On my new T61 something is happening. I create my user local profile and then create a user on domain.I already copy my data into my folder Document.But everytime that I log on my user account, appears a new folderon the Folder Users with my "account.domain.001", "account.domain.002", "account.domain.003"What is happening? I need to reinstall my T61 from my Start Recovery Disc?  Thanks in advance, Ruben Elizondo

More replies
Relevance 39.36%

Basically each morning I import data from an internet database to excel.
I need to divide the number of rows, that i receive daily in this excel document, to 4 worksheets designated to 4 staff members.
Each staff member needs to receive an equal amount of rows.

For e.g. if today i received 124 rows of data then each staff member should get 31 rows each.
Except the number of rows will vary on each day. I could get 200 plus rows of data.

Can someone please assist with writing a macro to divide up the rows in to the 4 worksheets? I would be very appreciative. Thanks in advance

I have attached the sample file for viewing....the data starts from row 3...thanks
 

Answer:Solved: Excel Macro to divide any number of rows equally onto certain number of works

11 more replies
Relevance 39.36%

How can I change this number?I simply have not been able to find a place to change the number. The pop-up says "Call us over-protective" But all that seems to be protected is how to contact Microsoft!

Answer:Microsoft wants to send me a security code. And the telephone number is incorrect. How can I change this number?

For me, I login to https://account.live.com and under Security & Privacy, select Managed Advanced Security. In there I can set the phone number(s) that can be used to receive codes.
?

2 more replies
Relevance 39.36%

I deleted mobile number from live Microsoft people account. it is very important to me
how can i get back that number :(

More replies
Relevance 39.36%

*system info*: BIOS Version/Date TOSHIBA V1.60, 26/05/2009 :: Vista SP1 :: windows explorer 8 :: 64 bit os :: Toshiba Satellite laptop P500 :: Computer is less than 1 mth old

*Problem*:
1. Number pad keys are not 'using' numbers .... when any number on the number pad is keyed it activates either the "find" or "search" field of the program I am using.
2. Number pad won't 'unlock' - light is always on.

Example: if using IE8 the 'find' field activates as if you pressed Ctrl+F or in other instances (using software programs) the window opens as if you clicked the windows icon key + F.

I assume I have activated a keyboard shortcut of somekind ... or .......?????
I can not associate this problem with any update or program installation - hadn't done any when I first realized my number pad issue.

Vista SP1 - windows explorer 8 - 64 bit os - toshiba satellite laptop P500. Computer is less than 1 mth old

+Thank you for your help+.....I really miss the use of my number pad and having to close the activated 'find/search' window/tool is frustrating

I'll likely need the KISS method - I'm not real computer savvy.

Answer:Satellite P500 - number pad keys open 'find'/'search' - NOT number usage

>1. Number pad keys are not 'using' numbers .... when any number on the number pad is keyed it activates >either the "find" or "search" field of the program I am using.
>2. Number pad won't 'unlock' - light is always on.

Maybe your first issue has something to do with the second point and the fact that you cannot ?unlock? or disable the number pad.

Did you try to enable and disable the numpad using or pressing the NUMLOCK?
Check this!

5 more replies
Relevance 39.36%

I need a viber for my old phone number to keeo in touch with friends who do not know my new phone number.

Answer:I want to get back my Viber on my device but I can not use the phone number which I had the code on, how do I get my friends, who don't have my new number, on it?

Cannot be done.
Give your friends your new number and reregister Viber on your new number.

2 more replies
Relevance 39.36%

Is 0800-086-8676 UK Yahoo Phone Number Technical Support Number?
I need help with my Yahoo email, my Yahoo is being compromised. Someone is sending out the emails from my Yahoo, I cant even reset the password online.
Password can't be reset online is the message that i am getting on my screen.
I Googled Yahoo phone Number.
So, i want to confirm is 0800 086 8676 Yahoo Phone Number UK Technical Support Number?

Answer:Is 0800-086-8676 UK Yahoo Phone Number Technical Support Number?

No it isn't. It's just a number that's being spammed all over the internet, probably in an effort to scam money out of people looking for technical support.
Go to https://uk.help.yahoo.com/kb/helpcentral and follow the links there.
When looking for technical support, always go to the home page of the relevant product/service and follow the links there - your security/money is too valuable to trust strangers.

3 more replies
Relevance 39.36%

Just like the title, when I checked it on Lenovo Setting app, I saw that. What should I do? can I work around myself? or should go to service center instead?

More replies
Relevance 39.36%

Windows Tech Support Phone Number 1-800-723-4210 USA and Canada
microsoft tech support phone number 1-800-723-4210 microsoft office tech support phone number windows tech support phone number1-800-723-4210 microsoft tech support phone number usa microsoft windows tech support phone number 1-800-723-4210 support phone number microsoft office 365 tech support phone number1-800-723-4210 microsoft tech support phone number for windows 8 microsoft windows 7 tech support phone number1-800-723-4210 microsoft 365 tech support phone number 1-800-723-4210 microsoft word tech support phone number microsoft office tech support phone numbers 1-800-723-4210 contact microsoft tech support phone number microsoft tech support phone numbers microsoft tech support number microsoft windows 8 tech support phone number microsoft phone number 1-800-723-4210 tech support phone number for microsoft tech support windows tech support number windows 8 tech support phone number acer tech support phone number skype tech support phone number 1-800-723-4210 office 365 tech support phone number tech support number tech support microsoft phone number office 365 tech support phone number 1-800-723-4210 us microsoft office tech support number hotmail tech support number microsoft tech phone number surface tech support phone number free tech support phone number microsoft tech help phone number 1-800-723-4210 phone number for windows tech support phone number microsoft tech support microsoft windows tech sup... Read more

More replies
Relevance 39.36%

i am looking to upgrade various parts of my computer and a diagram of the motherboard please

Answer:compaq SR5000 serial number CNX744147J S system number ...

Hi: Here is the link to the support page for that model series.  The product number doesn't give any info. http://support.hp.com/us-en/product/compaq-presario-sr5000-desktop-pc-series/3328519/product-info Use this guide for how to find the product number of your PC. http://support.hp.com/us-en/document/bph07555

1 more replies
Relevance 39.36%

Here in my country:
we have 8 digits numbers:
If we save a contact using the number: 5926****
For calls everything is perfect! But when
we receive a text message from them: we get a reply from the number +230926****, which is detected as another number!!! [where +230 is the country code which is automatically added to the contact's number]
Previous Nokia models had no issue with this, but all lumia models are facing this two different number problem. Any solution for this??

Answer:How to make a phone number, with country code be detected as one number?

Check if your country is set correctly on your phone. Also from phone settings enable International assist.

2 more replies
Relevance 39.36%

AVG Security solution, one of the best antivirus software solutions with advanced features.  The security solution is known for its capability of removing viruses at greater extent.  We at avgsupporthelp247 provide support for this advanced and well known security solution. Our toll free number 1-800-723-4210 is toll free and you can get the technical support for 24x7 hours. If your device including laptops, PCs, mobile phone or tablets are infected by the viruses we at avgsupporthelp247 is just a call away.  AVG Antivirus+(1-800-723-4210)+ Help Desk Customer service number 1-800-723-4210for online tech support Help Desk And Care on Toll free phone number Contributors: Poojajaanu Date created: 2016-09-06 05:39 PM | Last Updated: 2016-09-06 05:39 PM Category: Project Description: AVG security USA#[email protected] customer service phone number, AVG antivirus customer service phone number AVG +∑™+1-800-723-4210AVG Tech Support Phone number, AVG customer support phone number AVG customer care phone number AVG USA((((=1-800-723-4210))))) AVG Antivirus tech Support Phone Number, AVG Antivirus Technical Support Phone Number, AVG Antivirus Customer Support phone Number AVG Antivirus help desk number, AVG telephone number AVG Support Phone Number 1-800-723-4210USA, AVG Antivirus Support Phone Number, AVG Technical Support Phone Number, AVG Customer Support Number?? AVG Support Phone Number 1-800-723-4210USA, AVG Antivirus Support Phone Number, AVG Techni... Read more

More replies
Relevance 39.36%

     I have been trying to buy a replacement wireless WAN antenna (AUX) #P93P4387 (listed in HMM on page #127 and illustrated on page #112).  Trouble is there is also PN 93P4387 on listed on page 131 and illustrated on page 128.  The latter has been shipped.  I need the former.    I talked to IBM parts today and they said that I have to have tech support clarify the proper item and gave me a number.  I called it and got a garbled message - obviously I was given an incorrect phone number.  Then went to the web site and could not find a phone number.     I need the item pictures as "23" on page 112 of the HMM for the T60 and dated October 2007.  Can somebody identify the proper part number or refer me to someone I can talk to so that I can call IBM Parts back and get this thing???     Thank you.

Answer:Part Number Mixup - tech support phone number

Originally posted 03/10 looking for help getting a replacement part that is listed incorrectly in HMM.  No help from Lenovo Customer Service or Tech Support and no answer here to date.  Where can I turn to get help???  Would really appreaciate any help anyone can give me.

3 more replies
Relevance 39.36%

i am looking to upgrade various parts of my computer and a diagram of the motherboard please

Answer:compaq SR5000 serial number [edited] system number GZ7 ...

Hi:
 
Here is the link to the support page for that model series.  The product number doesn't give any info.
 
http://support.hp.com/us-en/product/compaq-presario-sr5000-desktop-pc-series/3328519/product-info
 
Use this guide for how to find the product number of your PC.
 
http://support.hp.com/us-en/document/bph07555

1 more replies
Relevance 39.36%

I need help turning my number pad on and keeping it on at start up. It's a brand new laptop and I can't get it turned on.

More replies
Relevance 38.95%

My computer, which is running Windows XP, got infected with the Google redirect virus. In the Task Manager, there is an unknown process 2212512753:247209852.exe, which I cannot stop.

I am using the McAfee anti-virus program. When I turn on real-time scanning, it immediately turns off again. When I try a quick scan, I get a message saying "An Error Has Occurred".

When I try running a quick scan in Malwarebytes' Anti-Malware, it runs for a few seconds, then quits. I tried other options, including running it under a different name.

Recently, I have been unable to access the Internet, although my wireless connection still seems to be working. I have been using another computer and a flash drive to transfer files.

The GMER program ran for a couple of minutes, then quit.

The dds.txt file contains the following:
.
DDS (Ver_2011-08-26.01) - NTFSx86
Internet Explorer: 8.0.6001.18702 BrowserJavaVersion: 1.6.0_21
Run by David Kingsley at 20:02:03 on 2011-10-05
Microsoft Windows XP Professional 5.1.2600.3.1252.1.1033.18.3068.2384 [GMT -5:00]
.
AV: McAfee Anti-Virus and Anti-Spyware *Disabled/Updated* By default we load generic code, php, css, sql and xml/html; load others here if desired 3
FW: McAfee Firewall *Enabled*
.
============== Running Processes ===============
.
C:\WINDOWS\system32\Ati2evxx.exe
C:\WINDOWS\system32\svchost -k DcomLaunch
svchost.exe
C:\WINDOWS\System32\svchost.exe -k netsvcs
svchost.exe
sv... Read more

Answer:Google redirect virus, unknown process with name format of "number colon number dot exe", Malwarebytes scan quits

Hello and Welcome to the forums! My name is Gringo and I'll be glad to help you with your computer problems. Somethings to remember while we are working together.Do not run any other tool untill instructed to do so!please Do not Attach logs or put in code boxes.Tell me about any problems that have occurred during the fix.Tell me of any other symptoms you may be having as these can help also.Do not run anything while running a fix.Do not run any other tool untill instructed to do so!Click on the Watch Topic Button and select Immediate Notification and click on proceed, this will help you to get notified faster when I have replied and make the cleaning process faster.Please print out or make a copy in notpad of any instructions given, as sometimes it is necessary to go offline and you will lose access to them.Please download DummyCreator.zip and unzip it.Run the tool.Copy and paste the following into the edit box:

path to the numbered file
Press Create button and post the content of the Result.txt.

Important: Restart the computer.Run Combofix:You may be asked to install or update the Recovery Console (Win XP Only) if this happens please allow it to do so (you will need to be connected to the internet for this)Before you run Combofix I will need you to turn off any security software you have running, If you do not know how to do this you can find out >here< or >here<Combofix may need to reboot your computer more than once to do its job this is norma... Read more

14 more replies
Relevance 38.95%

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 38.95%
Relevance 38.95%

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 38.95%

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 38.95%

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 38.95%

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 38.95%

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