Over 1 million tech questions and answers.

Solved: Access 2007 Query: Return count of "Yes" and "No" values for Analyst/Report M

Q: Solved: Access 2007 Query: Return count of "Yes" and "No" values for Analyst/Report M

I recently built a call log database in Access 2007 for my team to use when calling agents on our top errors we see from a vendor's error report. My boss is requesting a report to see how many items have been resolved

I have a query started and I am trying to complete this task in a single query (if possible) instead of several queries (as I've done for a couple other things).

I have 3 tables I'm using: Assignment, AgtInfo and CallLog
Joins as follows: Assignment.st=AgtInfo.agcy_st
AgtInfo.agt_id=CallLog.agt_id

Fields in the results: Assignment.assigned_analyst, CallLog.rpt_mnth, CallLog.resolved

Resolved is a yes/no field. I've done a query that converts the -1 to a 1, so that the sum is a positive number for the "Yes" values. I'm not sure how to enter the expression to subract the "Yes" values from the total number of values (yes/no) to get to my "No" count.

Essentially, I'd like the results to display as:

assigned_analyst, rpt_mnth, CountYes_resolved, CountNo_resolved

Somehow the connection is just not clicking in my brain with everything I've read though searches. Any help is appreciated! Thanks!

RELEVANCY SCORE 200
Preferred Solution: Solved: Access 2007 Query: Return count of "Yes" and "No" values for Analyst/Report M

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.)

A: Solved: Access 2007 Query: Return count of "Yes" and "No" values for Analyst/Report M

It is easier to add another column to counf the Nos, use
0 or is null
as the IIf statement and use a 1 to count them

Read other 3 answers
RELEVANCY SCORE 180.8

I am hoping that someone can help me with what may be a complex question.

I have a spreadsheet, similar to the demonstration file I have attached. In it, there are a range of columns. One set of columns (A - D), shows a list of numbers that are references to items in a store, and it also shows their location in the store, so it acts as a floor-plan. The next column (E) lists those items again to show the dollar amount that those items have produced in total sales (F).

So, what I'd like to do is to add a conditional formatting to show me the "cold" and "hot" spots on the floor-plan so I can see where sales are most concentrated. I would assume that this would be done with a colour scale (using the range of values in column F to work itself out)?

Either way, the figures in column F would change weekly, so the relevant cells in columns A - D would need to automatically change when they're matching cells in column E - F change.

I hope this makes sense, as it's difficult to explain, but any help that someone could provide would be greatly appreciated.
 

A:Solved: Creating Cell "Cold" And "Hot" Spots Based On Values In Microsoft Excel 2007

Read other 16 answers
RELEVANCY SCORE 172

Ok, so im new here so hey everybody..

to the point: my laptop is "stuttering"/lagging/skipping.
whatever you wanna call it its doing it.
my video/music/and cursor skip every second for a splt second it starts on start-up and dont stop til i turn my laptop off. it happens in a pattern its not random, ive done checked my drivers, spyware, and m RAM is good.. so can someone please help me? ***could it be because my battery wont hold a charger? so it has to be hooked up to the charger at ALL times or it dies Example: is the charger not got the "juice" to run the laptop by itself so it studders/skips..*** i dont know if this has anything to do with my problem but i ran "event viewer" and found this : The following boot-start or system-start driver(s) failed to load:
Cdrom
Imapi
redbook

PLEASE HELP




OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Genuine Intel(R) CPU T2250 @ 1.73GHz, x86 Family 6 Model 14 Stepping 8
Processor Count: 2
RAM: 502 Mb
Graphics Card: Mobile Intel(R) 945GM Express Chipset Family, 224 Mb
Hard Drives: C: Total - 39723 MB, Free - 23484 MB; D: Total - 12684 MB, Free - 3633 MB;
Motherboard: Dell Inc., 0FF049, , .HWPLLB1.CN1296167S5169.
Antivirus: McAfee VirusScan, Updated: Yes, On-Demand Scanner: Disable
 

A:Solved: Whole computer "studders"/"skips"/"lags" .. have event viewer report (PLEASE

Read other 6 answers
RELEVANCY SCORE 165.2

Hey everyone,
        I am trying to get the REST queries to work with the sharepoint end points instead of graph end points. I first created an app with relevant permissions and have given it the admin consent. Then I am hitting the https://login.microsoftonline.com/<tenant>.onmicrosoft.com/oauth2/token?Content-Type=application/x-www-form-urlencoded end
point with https://<tenant>.sharepoint.com as resource. I am then using the access token retrieved to give the rest call to https://<tenant>.sharepoint.com/_api/v2.0/drives/b!3indYSbqZ0-hVSPnCgIZy-2xDMh7jH9AuQnEzJMc6TEfQoSJvJT-R6tT0lFBQiPr/root/delta
but it is failing with "error":{"code":"generalException","message":"General exception while processing"}}. The REST response code is 401 Unauthorized. I have filed a Microsoft support ticket but they
have asked me to post on these forms. Can someone please help me with this? I am not able to move forward because the error is pretty generic and doesn't give any additional details.
Thanks,
Sai Kiran Katuri.

Read other answers
RELEVANCY SCORE 162

Ok, so im new here so hey everybody..

to the point: my laptop is "stuttering"/lagging/skipping.
whatever you wanna call it its doing it.
my video/music/and cursor skip every second for a splt second it starts on start-up and dont stop til i turn my laptop off. it happens in a pattern its not random, ive done checked my drivers, spyware, and m RAM is good.. so can someone please help me? ***could it be because my battery wont hold a charger? so it has to be hooked up to the charger at ALL times or it dies Example: is the charger not got the "juice" to run the laptop by itself so it studders/skips..*** i dont know if this has anything to do with my problem but i ran "event viewer" and found this : The following boot-start or system-start driver(s) failed to load:
Cdrom
Imapi
redbook

PLEASE HELP
 

A:Whole computer "studders"/"skips"/"lags" .. have event viewer report (PLEASE HELP)

**(DONT KNOW IF THIS WILL HELP..)***

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows XP Home Edition, Service Pack 3, 32 bit
Processor: Genuine Intel(R) CPU T2250 @ 1.73GHz, x86 Family 6 Model 14 Stepping 8
Processor Count: 2
RAM: 502 Mb
Graphics Card: Mobile Intel(R) 945GM Express Chipset Family, 224 Mb
Hard Drives: C: Total - 39723 MB, Free - 23484 MB; D: Total - 12684 MB, Free - 3633 MB;
 

Read other 2 answers
RELEVANCY SCORE 161.6

In Windows XP, fully updated, I have several folders full of mp3's and want to see the bit rate and duration. I right click on a column heading and select "Bit rate". I then click on "More..." so I can get to "Duration", and I select that one too.

But all the figures in the "Duration" column appear to be in "hours" and "minutes", so I see "00:04" or "00:03", but what I want is "minutes" and "seconds".

Any thoughts as to how to change this?
 

A:Solved: Windows Explorer "Duration" Column - no "Seconds", just "Hours" and "Minutes"

Read other 16 answers
RELEVANCY SCORE 158

Please can somebody help with this minor but annoying matter. When turning on my business computer one morning, the space bar and return/enter buttons are visable when i type emails, but when i send them, they are not. I know its a setting, but can anyone tell me what setting and how to turn it off?

Thanks!

A:[SOLVED] &quot;Space bar&quot; and &quot;return/enter&quot; are visual on emails! Help

You need to tell us what email client you use as these days not everyone uses the built-in one.

Read other 4 answers
RELEVANCY SCORE 157.6

When I am building a query in Access 2007, the "Sort:" and "Criteria:" selctions don't work when I switch from 'Design View' to 'Datasheet View'.
If I change the query type from 'Select' to 'Make Table' and run the query, the data in the new table mathces the "Sort:" and "Criteria:" selctions correctly.
What is wrong with my Select Query - Datasheet View? This is very annoying.
 

A:Access 2007 "Sort:" and "Criteria:" not working in Datasheet View

Read other 10 answers
RELEVANCY SCORE 157.2

I am trying to use the fsutil file setshortname to set "Program Files" to PROGRA~1,

but the system is giving me an "Error: Access is denied" response.
what I have typed:
Microsoft Windows [Version 6.3.9600]
(c) 2013 Microsoft Corporation. All rights reserved.
C:\Windows\system32>cd /d D:\
D:\>fsutil.exe 8dot3name set 0
The registry state is now: 0 (Enable 8dot3 name creation on all volumes).
D:\>fsutil file setshortname "Program Files" PROGRA~1
Error:  Access is denied.
And I try it in Safe Mode.It is also "Access is denied.".
Can someone
help me?

A:"fsutil file setshortname "Program Files" PROGRA~1"=>"Error:Access is denied."

Hi TimFF,
This might be related with the UAC settings, check this thread:
give full permission for the users in program
files folder
The steps in the above thread is not recommended.
For the short name usage, we may consider to create a directory-junction from
PROGRA~1 to C:\Program Files:
With the following commands:
mklink /J "C:\PROGRA~1" "C:\Program Files"
Reference:
Mklink
Best regards


Michael Shao
TechNet Community Support

Read other 3 answers
RELEVANCY SCORE 157.2

This error is randomly popping up in several of my database programs. I will arbitrarily find that a button on a form to print, add new record, or even search, will just suddenly give this error when it had been working find. Sometimes closing and reopening the program corrects it, and sometimes there is nothing to do but delete the button and recreate it. No problem for me, but I have customers who can't do that and they call me several times a week to fix it. Is there something I am doing wrong when I create these forms?
 

A:Access 2007 Error "Return without Gosub"

See if this fits.
http://forums.techguy.org/business-applications/795546-solved-return-without-gosub.html
 

Read other 2 answers
RELEVANCY SCORE 152

Hi,

I'm setting up a spreadsheet for work to help track some work. I have a drop down menu with "Yes" and "No" options set up in cell E2 and I am trying to return todays date in cell F2 if E2 equals "Yes". I have tried a few different things but I can't seem to get it to return the date. This would allow me to confirm when a job has been completed (E2= "Yes") and then return the days date automatically in the cell next to it (F2). Any help with this would be greatly sppreciated
 

A:Solved: Excel 2007 - If "Yes" return todays date

Read other 8 answers
RELEVANCY SCORE 151.6

I am running Windows XP SP3, fully updated, on an Acer lap top PC.

I have several folders full of .mp3's and want to see the bit rate and duration. To do this I right click on a column heading and select "Bit rate". I then click on "More..." so I can get to "Duration", and I select that one too.

The two new columns appear, but the format of the "Duration" column appears to be "hours:minutes", so I see "00:04" or "00:03" for most .mp3's, when what I want to see is 'hours:minutes:seconds", e.g. "00:03:45".

This also happens for video files (.avi files), e.g. all my episodes of "Heroes" (sad, I know) have a duration of "00:42" instead of "00:42:xx".


Here are two pictures showing the problem with the .mp3's. The first is of Explorer showing the Duration as "Hours:Minutes":




The second picture is of the properties window of the first .mp3 in the list above:




I copied some .mp3 files to another (old) PC on my home network, and it displayed the duration field correctly:




Also, the properties window correctly shows the duration also:





I'm not the only person to have this problem. I received a private message from a member of another forum where I posted about this problem several weeks ago. That person also has the same problem with the duration field.

The tech guys on that forum were unable to find the source... Read more

A:Windows Explorer "Duration" Column - no "Seconds", just "Hours" and "Minutes"

* bump *

Tricky, this one!

Read other 8 answers
RELEVANCY SCORE 151.2

Which one should I do? I originally wanted to just do "Return computer to factory condition" but Theog just suggested "Use A System Image Created Earlier." I have no idea what to do. So confusing!

A:"Return computer to factory condition" or "Use A System Image Crea..."

Hello M4TE and welcome to Seven Forums. Sorry for the delay in responding but I just came across your question.

Most newer manufactured computers have a hidden recovery partition on the hard drive. The manufacturer provides specific instructions on how to access that partition in case you want to restore your machine to the exact condition it was in when it left the factory. That means you'd have to go through the time consuming process of cleaning out factory bloatware (like free trials of programs you'll never need), installing programs you do need, updating everything, creating your personal settings, etc. Here is a general idea of how to access the hidden recovery partition.

HP Recovery From Partition

Let's say it took you a day or two to set up your machine to your liking using the hidden recovery partition. A System Image is like a snapshot of your entire hard drive. It will include everything from the operating system to all your programs, files, photos, music, all updates ... everything. Most folks keep it on a separate external hard drive. Let's say a week later you get a virus or your machine crashes for some reason. You can use that System Image to return your machine to the exact condition it was in when you made the image. Usually takes about 30 minutes or so and you're back in business. It's a lot faster and more convenient to only worry about a week of updates compared to probably months with the hidden recovery partition. The newer a System Image is the... Read more

Read other 1 answers
RELEVANCY SCORE 151.2

I double-click and get "search" instead of "open"--only when I click a disk, like Hard Drive C: or Floppy A: or CD F: and so on.

It didn't used to do this, so I must've inadvertently changed some setting somewhere, but darned if I can find it now.

Any ideas?
 

A:Solved: On the "my computer" list, I double-click on disks and get "search" instead of "open"

Read other 12 answers
RELEVANCY SCORE 150.8

I have a nested "IF" statement that inlcudes the "OR" function because I have more than 7 logical tests. One of the logical tests looks for two fields to be true in order to return the "value if true". If either or both fields are false, then the "value if false" is returned, in this case zero. When the value of the first field is correct, but the value of the second field is not correct, zero is returned, which is the "value if false" and a correct return.

However, when both fields are false, the formula is returning the word "FALSE" instead of zero.

The attached file shows these returns and the formulas. Cells F2-7 are corrrect returns (highlighted in green), while cells F8-11 are not correct returns (highlighted in red).

Any ideas on how to return the "value if false" (zero) in cells F8-11 would be appreciated.
 

A:Solved: Excel 2007 - Nested "IF" formula using "OR" Function

Read other 8 answers
RELEVANCY SCORE 149.2

I added a slave drive to my Windows XP Pro computer, and it appears to work properly.

However, when I open the "Documents and Settings" folder (on the slave drive E:\, which is Windows XP Home Edition -- not XP Pro), I do not see any of my documents, sub-folders, etc. There should be MANY sub-folders (inside the "My Documents" folder which isn't even visible), with hundreds of documents, jpgs, etc. within it.

When that drive is installed as the Primary drive in my other computer, the User "Larry" (which is me) has all Administrative privileges. On the computer that I'm running now (with the slave drive in it), I also have Administrator privileges. I own both computers.

My User Name "Larry" is password-protected when I login to Windows (when the drive is Primary and installed into my main computer (not this computer with XP Pro).

I've tried clicking on all the users; Administrator, Default User, Larry, Guest, etc. (Note: I get an "Access Denied" error when clicking on the Guest "Documents and Settings" folder).

So, the questions are:

1. Why can't I see any files or subdirectories in the "Documents and Settings" folder on the slave drive?

2. There's supposed to be a folder named "My Documents," but I can't find it. Normally, that path is "C:\Documents and Settings\My Documents".
--- Where is that folder? It contains all the files I'm looking for.
... Read more

A:Solved: Slave drive "Access Denied" on "Documents and Settings" Folder

Follow the directions here to take ownership of a file or folder.

http://support.microsoft.com/kb/308421
 

Read other 2 answers
RELEVANCY SCORE 148.8

I tried to associate the file extension .txt to a new editor program
with the well known cmdline programs ASSOC and FTYPE.

No, assigning them through WinExplorer menu does not work.
But this is another problem which should not discussed here.

When I type now one of the following alternative commands at the CommandPrompt then Win7 returns me something like:

assoc .txt=txtfile

"Access denied"
The following error occurs: .txt"

or

ftype txtfile=D:\notepad++\notepad++.exe "%%1"

"Access denied"
The following error occurs: txtfile"

Why?

The command above work fine under WinXP

Peter

A:"access denied" when using "assoc" and "ftype" from cmdline?

Question:

Did you run cmd.exe with administrative previlliges?
Elevated Command Prompt

Read other 3 answers
RELEVANCY SCORE 148.4

ok!!!!!!!!!! what is it and how do i fix it,,,, eyes crossed knees woobly help?????????????????????
 

A:[Solved] mplay32.exe,1"/play/close"%L"." and sndrec32.exe"%L"."

Read other 9 answers
RELEVANCY SCORE 146.8

Hi

Is it possible to start the app without "Security Worning" window ("Cancel. Open, More Info" buttons)? If yes, how you can make changes then?

Is it possible to start the app without "Microsoft Access" window on the background?

Thanks,
Barbos
 

A:Solved: Access 2003 - To start the app w/o "Security Warning" and "Microsoft Access"

Read other 6 answers
RELEVANCY SCORE 145.2

hello,

This site helped me cure my Laptop in the past and now I am in the process of aiding a friend whose IE is being hijacked to a suspected Anti-malware site for a product known as "Ultimate Cleaner 2007". He also keeps getting repetative pop-ups for an alleged virus known as "Worm.Win32.NetSky" which redirects you again to an unknown site.

here is his HJT log:

Logfile of Trend Micro HijackThis v2.0.0 (BETA)
Scan saved at 8:27:09 PM, on 11/11/2007
Platform: Windows XP SP2 (WinNT 5.01.2600)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\system32\wscntfy.exe
C:\WINDOWS\Explorer.EXE
C:\Program Files\Synaptics\SynTP\SynTPLpr.exe
C:\Program Files\Synaptics\SynTP\SynTPEnh.exe
C:\Program Files\HPQ\Quick Launch Buttons\EabServr.exe
C:\Program Files\Java\jre1.6.0_01\bin\jusched.exe
C:\Program Files\HPQ\HP Wireless Assistant\HP Wireless Assistant.exe
C:\WINDOWS\system32\igfxtray.exe
C:\WINDOWS\system32\hkcmd.exe
C:\WINDOWS\system32\igfxpers.exe
C:\Program Files\Hp\HP Software Update\HPWuSchd2.exe
C:\Program Files\iTunes\iTunesHelper.exe
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\SUPERAntiSpyware\SUPERAntiSpyware.exe
C:\Program Files\iPod\bin\iPodService.exe
C:\Program Files\HPQ\shared\hpqwmi.exe
C:\WINDOWS\system32\wuauclt.exe
C:\Docume... Read more

A:HJT log for "Ultimate Cleaner 2007" browser hijacking and "Worm.Win32.NetSky" warning

Welcome to TSG

Please download SmitfraudFix

Double-click SmitfraudFix.exe
Select option #1 - Search by typing 1 and press "Enter"; a text file will appear, which lists infected files (if present).
Please copy/paste the content of that report into your next reply.

Note : process.exe is detected by some antivirus programs (AntiVir, Dr.Web, Kaspersky) as a "RiskTool"; it is not a virus, but a program used to stop system processes. Antivirus programs cannot distinguish between "good" and "malicious" use of such programs, therefore they may alert the user.
http://www.beyondlogic.org/consulting/proc...processutil.htm
 

Read other 3 answers
RELEVANCY SCORE 144.8

My office just upgraded, and I can no longer use Windows XP. On this system, I was able to add a separate taskbar to facilitate quick access to commonly-browsed folder locations on our vast network, and another one expedited the launching of useful programs and lists. Each task on each taskbar was represented with a big custom icon to save eye strain. I had them installed in opposite vertical margins, and they were set on auto-hide to keep them out of the way when not being used. Just move your mouse pointer to the left or right margin, and BAM! Sorry for the cliche, but I really got used to the convenience of what I had set up, and I just don't think I can be as efficient without anything comparable.

Now there appears to be nothing comparable in the Windows 7 GUI, and it's making me sick with rage! I see only the option to put a "toolbar" on an existing "taskbar", and no option to create any additional taskbars! This cramps up your one-and-only taskbar, plus the tiny toolbar access buttons require way too much precision for anything that's supposed to be quick. When you've figured out how to bring up that ridiculous button, the list that it yields is small enough to cause painful eyestrain - nothing efficient, much less cool about this at all! I have seen customization options in other OS GUIs that may have resolved some of these issues, but I see none such in W7.

I have tried every google search string that I can think of, and found... Read more

A:Need to add "TASKBARS" (MSese for "Launchpads", "Docks" NOT "Toolbars"

Several possibilities here: Second taskbar in windows7? [Solved] - Windows 7 - Windows 7

Read other 1 answers
RELEVANCY SCORE 144.4

Hi,

When our website users click on an html attachment embedded on a web-page in IE9, the download manager will not display the "Open" option. It will only display "Save" and "Cancel" which our users don't like, having to save the
html document in a folder to open it. Whereas, when downloading attachments like pdf, word etc. all three options are displayed. 

Is there any setting to tweak , which will display all the 3 options for HTML attachments as well?

A:IE9 download manager will not display "Open" option (only "Save" and "Cancel" is displayed) for downloading HTML documents.

Hi,
As you know, the Open-Save-Cancel dialog box helps you prevent your computer from affecting by virus while downloading. 
So I suggest you test to reset all zones to a lower level temporarily and then please attempt to download this html attachment again.

However, since you can normally download the other documents, I suspect there is some restriction in the website which you are trying to view. I recommend you to contact the administrator of that website if possible.
could you please send me the link of the website from where you are trying to download the html attachment?
Thanks!


We
are trying to better understand customer views on social support experience, so your participation in this
interview project would be greatly appreciated if you have time.
Thanks for helping make community forums a great place.

Read other 6 answers
RELEVANCY SCORE 144.4

Hi all,

I just created an Access database and I'm having trouble running the query. I keep receiving the error message "Type Mismatch in Expression". I have triple checked all of my underlying fields and they all match so what am I doing wrong? I can't upload the file as I'm at work and don't have access to my FTP so if you are able to assist me with hosting this file, it'd be greatly appreciated. (Note: all names & addresses included in the database are fictitious).

T.I.A!
 

A:Solved: "Type Mismatch in Expression" - Access Query Problem

Read other 9 answers
RELEVANCY SCORE 144.4

I am getting an "Access is Denied" error message on a hard drive that I am trying to recover files from that is from my HP Pavilion with Windows XP that fried. My hard drive is still good, and I am trying to rescue the files in the "Documents and Settings/Owner" folder. I have connected the hard drive to my laptop, which also has XP; but when I try to open the "Owner" folder in "My Documents", it tells me that "Access is Denied." And when I hover over the folder, it says "Folder is Empty." But it is not empty. I can also access everything else on the drive fine -- just not this folder. I suspect that this is a networking type of issue, but I am not sure how to resolve it. Can someone please help me?

Thank you,
 

A:Solved: "Access Denied", "Folder Empty"

Read other 9 answers
RELEVANCY SCORE 144.4

I got my dell few days ago. Installed it with Samsung EVO 850 SSD 500 Gb and Kingston 8GB PC3L - 12800 SODIMM.The Windows 10 Home OEM home is installed on HDD 1TB so I decided to use Samsung Data Migration software to clone the data to SSD. However, the OS crashed and decided to install a fresh Windows 10 Enterprise to SSD and deleted the previous OS on HDD using diskpart.Now after Installing Windows 10 Ent OS files. Every after BIOS run, I got BSOD errors "MEMORY MANAGEMENT" + "Page Fault it non paged area" + "IRQL NOT LESS OR EQUAL" 

Read other answers
RELEVANCY SCORE 143.6

I am infected with this crap and have used the following tools to try to get rid of it:
Windows Defender, Unible PowerSuite (SpeedUpMyPC, Registry Booster & Spyware Protector) and Norton's One Button Checkup and WinDoctor.

Not sure if it's related, but my DISPLAY is locked at 640 X 480.

Atempted the 5 Step Process before posting and Panda ActiveScan froze and crashed after scanning 59253 files, but not before identifying 28 spyware files.

Here's my extra.txt log from Deckard's:

Deckard's System Scanner v20071014.68
Extra logfile - please post this as an attachment with your post.
--------------------------------------------------------------------------------

-- System Information ----------------------------------------------------------

Microsoft Windows XP Home Edition (build 2600) SP 2.0
Architecture: X86; Language: English

CPU 0: Intel(R) Pentium(R) 4 CPU 2.80GHz
Percentage of Memory in Use: 36%
Physical Memory (total/avail): 1277.95 MiB / 810.39 MiB
Pagefile Memory (total/avail): 1516.89 MiB / 1165.44 MiB
Virtual Memory (total/avail): 2047.88 MiB / 1930.88 MiB

A: is Removable (No Media)
C: is Fixed (NTFS) - 37.21 GiB total, 18.7 GiB free.
D: is CDROM (CDFS)

\\.\PHYSICALDRIVE0 - ST340014A - 37.25 GiB - 1 partition
\PARTITION0 - Unknown - 39.19 MiB
\PARTITION1 (bootable) - Installable File System - 37.21 GiB - C:



-- Security Center -------------------------------------------------------------

AUOptions is scheduled... Read more

A:Netsky Worm-Popups-The Three Icons - "Error Cleaner" "Privacy Protector" "Spyware..."

Bump.

Read other 14 answers
RELEVANCY SCORE 142.8

It seems that no matter how I set this, after the next start-up it reverts to "15 minutes".  What registry key controls this?

Read other answers
RELEVANCY SCORE 142.4

I'm working in excel 2007 and trying to separate many lines of address info into separate columns; i.e., street address, city, state, zip.

The data is not consistent enough to use txt to columns but I can see there is a "return" or "entered" key in the data.

I do not find any special characters in the excel find function so I can choose "find return" and replace with a comma.

If I can replace return with a comma I think I can then use the delimited txt to column. HELP!!!
 

A:Excel 2007 Find and replace "Return"

Hi, welcome to the forum,

With vba (a macro) you could use the following:
Chr(10) is the return, Enter code
Chr(13) is the carriage return

However, there is trick:

If you press Ctrl+F (which opens the Search and Replace) you could then go and sletect that portion of txt that has the line feed end or return in it Copy this portion of seemingly blank text, paste if in the Search field and put a 'in the replace.

I've tried this and it works.

You can use it for the eintire worksheet and all will be replaced.
 

Read other 1 answers
RELEVANCY SCORE 141.2

OK fellow "computer-holics", here's a difficult one for ya. I have a user who e-mailed me the following:

"Ever since I downloaded Crystal Graphics' "PowerPlugs v 1.2" (powerpoint plugin software I purchased which allows for 3D motion graphics on slides), Microsoft Powerpoint won't allow me to access "Slide Color Scheme" or "Apply Design Template" from the format menu...."

I've tried completely removing Office, and re-installing it, but to no avail. I have yet to find an uninstaller for the "PowerPlugs" software, so I haven't tried that yet. (I wan't to save that as a "last-resort" anyway....even when I DO find an uninstaller). Does anyone know anything about the PowerPlugs software that could help out in this situation? Thanks in advance for any help.
 

A:Unable to access "Slide Color Scheme" or "Apply Design Template" in Powerpoint

I can only suggest that you use this form to contact the vendor of PowerPlugs:

http://www.crystalgraphics.com/main.support.asp

Whether you purchased it or not, it should certainly allow PowerPoint to continue to work.
 

Read other 2 answers
RELEVANCY SCORE 140.4

hey

ok so about 2 weeks ago ive been noticing that any cd i burn, half of the cd would be un readable . so for example: if i were to try burning a 21 sond cd i would only be able to listen to songs up to song 7 or so and the rest of the songs were showing up on my cd player screen but no sounds would follow...

so ive tried the usuall stuff here...first did a scan with adaware se and spybot and then i un installed then re installed my cd burners drivers and tested the burnign out on nero once more...no success at all......

so heres my nero log maybe u guys can find something. thanks.

Drive Information
-----------------
Drive : LITE-ON LTR-52327S
Type : CD-RW Recorder
Firmware Version : QS0C
Buffer Size : 2 MB
Date : ?
Serial Number : ?
Drive Letter : F:\
Location : 1:0
Mechanism : Tray
Read Speed : 12, 8, 4 X
Write Speed : 52, 48, 40, 32, 24, 16, 12, 8, 4 X

Read CD Text : Yes
Return C2 Pointers : Yes
Read CD-R : Yes
Read CD-RW : Yes
Read DVD-ROM : No
Read DVD-RAM : No
Read DVD-R : No
Read DVD-RW : No
Read DVD+R : No
Read DVD+RW : No
Read Digital Audio : Yes
Read CD+G : Yes
Read VideoCD : Yes

Write CD-R : Yes
Write CD-RW : Yes
Write DVD-R : No
Write DVD-RW : No
Write DVD+R : No
Write DVD+RW : No
Write DVD-RAM : No
Buffer Underrun Protection : No
Mount Rainier : Yes
Modes : Packet, TAO, DAO, SAO, RAW SAO, RAW SAO 16, RAW SAO 96, RAW DAO 16, RAW DAO 96
Disc Information (F:\)
-------------------
Type : - no disc inserted -
Capacity : 00:00.01 (0 MB)
Tracks : 0
Sessions : ... Read more

A:"D:\ access denied" and "no additional sense information (000000)" Burner Probs

Read other 11 answers
RELEVANCY SCORE 140.4

Hello,

I have an Asus Netbook 1005P, running Windows 7, SP1, with Internet Explorer 11.

I am often but not always, experiencing the following issue:

When I attempt to connect to Wifi at a caf, the "Wireless Network Connection" for the Network shows "Connected", yet there is no Internet access. Placing the pointer over the Connection icon in the Notification Area displays:

"Unidentified Network No Internet Access".
(The network in question always has an SSID shown in the Wireless Network Connection list.)

This issue occurs whether I am running only the Windows firewall, or am only running the firewall that I prefer which is Comodo.

For antivirus I have Avast Pro (with its "web shield" currently disabled) and so far as this issue is concerned it makes no difference whether this Avast component is enabled or disabled, or whether I disable all Avast Shields.

When this issue occurs, there are often other customers in the caf connected to the caf wifi and also using the Internet.

I have to ask the caf to reset, or turn off and then turn back on, their router, yet other customers do not have to do this to get Internet connection!

This is the issue at whatever caf, to whose Wifi I attempt to connect.

Please help with a solution to this issue.

Regards,

Robert339

Read other answers
RELEVANCY SCORE 140.4

Hello,
I have an Asus Netbook 1005P, running Windows 7, SP1, with Internet Explorer
11.
I am usually though not always, experiencing the following issue:
When I attempt to connect to Wifi at a caf, the "Wireless Network
Connection" for the caf's network shows "Connected", yet there is no
Internet access. Placing the pointer over the Connection icon in the
Notification Area displays:
"Unidentified Network No Internet Access".
(The network in question always has its SSID shown in the Wireless Network
Connection list.)
This issue occurs whether I am running only the Windows firewall, or alternatively
try only running the firewall that I prefer which is Comodo.
For antivirus I have Avast Free (with its "web shield"
not installed) and so far as this issue is concerned it makes no difference if I
disable Avast.
When this issue occurs, there are often other customers in the
caf connected to the caf wifi and also using the Internet.
I have to ask the caf to:
reset,
or turn off and then turn back on,
or remove the power plug,
for their router, 
yet other customers do not have to do this to get Internet connection!
This is the issue at whatever caf, to whose Wifi I attempt to connect.
My computer has an up-to-date network adapter update!

Please help with a solution to this issue.
Regards,
Robert339

Read other answers
RELEVANCY SCORE 140.4

Hi
I'm currently trying to finalise group policy settings for my Windows 8 students. All seems to be going well except, I cant for the life of me find out hide to hide 2 remaining items under "This PC", these being the "Access
Media" & "Add a Network Location" icons on the File ribbon (image below), can anyone help please.

A:Hide "Access Media" & "Add a Network Location" icons using Group Policy

Hi,
I think we can deploy script with set-acl powershell command to take ownership with Administrator of following keys, and set Deny permission on Users:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\CommandStore\shell\Windows.AddMediaServer
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Explorer\CommandStore\shell\Windows.AddNetworkLocation
SET-ACL on registry key
http://blogs.technet.com/b/brad_rutkowski/archive/2008/09/29/set-acl-on-registry-key.aspx
Image like this:

After doing this, my explorer appears like this: No these 2 options



Kate Li
TechNet Community Support

Read other 3 answers
RELEVANCY SCORE 140.4

Hello,

I have an Asus Netbook 1005P, running Windows 7, SP1, with Internet Explorer 11.

I am often but not always, experiencing the following issue:

When I attempt to connect to Wifi at a caf, the "Wireless Network Connection" for the Network shows "Connected", yet there is no Internet access. Placing the pointer over the Connection icon in the Notification Area displays:

"Unidentified Network No Internet Access".
(The network in question always has an SSID shown in the Wireless Network Connection list.)

This issue occurs whether I am running only the Windows firewall, or am only running the firewall that I prefer which is Comodo.

For antivirus I have Avast Pro (with its "web shield" currently disabled) and so far as this issue is concerned it makes no difference whether this Avast component is enabled or disabled, or whether I disable all Avast Shields.

When this issue occurs, there are often other customers in the caf connected to the caf wifi and also using the Internet.

I have to ask the caf to reset, or turn off and then turn back on, their router, yet other customers do not have to do this to get Internet connection!

This is the issue at whatever caf, to whose Wifi I attempt to connect.

Please help with a solution to this issue.

Regards,

Robert339

Read other answers
RELEVANCY SCORE 140.4

Does anyone know if its possible to autofill the "from field" as a rule, when your in "another users /delegates" mailbox, so you dont have to add their address in the "from field"? (so it will autopopulate with their email address (and show "on behalf of")?
I hope this was clear.

thanks.
 

A:Solved: outlook 2007 "from field" 'on behalf of" issue

No ... its not possible if the user has more than one delegate (that has added them with the applicable rule). from that point on, they will have to choose which person they want to add to "sent" on behalf of field.

However, If they have just one (one only) user who has added them with that permission (to send on behalf of), it will auto-populate with that user.

So, It does not matter even if they are "in" a specific users mailbox (and expect the "on behalf of" to auto fill with that users name). If they have more than one delegate that has added them with that permission, they will still have to choose which user the message will sent "on behalf of"

i figured this out by trail and error etc
 

Read other 1 answers
RELEVANCY SCORE 139.6

Anyone tried deleting a registry key in Windows 7?  Got "access denied" or "Error while deleting key"?
The usual response is, "You need to run regedit as an administrator".  but I *AM* logged in as Administrator, and running regedit as administrator, trying to assign administrator full permissions on that registry key in order to delete it!!  
Am I mistaken, or isn't Administrator supposed to be able to administer and control all the settings on the computer, in order to set it up for the "Average Joe" user?
So, under the permissions menu of that key, go to advanced, change the owner from System to Administrator, and try again.  It's no longer saying "access denied", but "Cannot delete xxxxxx. Error while deleting key".

The scenario: Basically, the wireless has stopped working on a laptop. The device does not show up in Device Manager, but is in the registry, so the normal procedure is to delete the registry entry for the device in HKLM/System/CurrentControlSet (and /ControlSet001) /Enum/PCI    ,then attach the device or restart the computer, it finds the "new" hardware and reinstalls it. Easy!...

Not with permission restrictions on the administrator account it's not!  So I need to give myself permission, to give myself permission, to do a simple task like delete a single registry key!  Why, Microsoft, why???!!!  Please just make the Administrator accoun... Read more

Read other answers
RELEVANCY SCORE 139.6

I have a text box that acts as a search field. There's a "Go" button right next to the search field. The "Go" button has an onclick event that executes a macro. How can I make it so that after someone types something into the search field, they can just hit "Enter" instead of having to click "Go"?
 

A:Solved: Access 2007 - Hit "enter" to execute a macro

Read other 6 answers
RELEVANCY SCORE 139.6

Hello All! I have created a database that uses a login form that directs people to specific forms based on priviledges. However, I would like to provide a form that allows users to change their passwords (preferably with a confirm password box). Also, I have one user defined as Administrator, with a special form. I would like to create a special form for the Administrator to be able to add/delete/edit users and their security levels.

I found similar threads, but none that answered my specific questions- relative to my current setup.

Thoughts?
 

A:Solved: Create a "Change Password" form for Login in Access 2007

Read other 16 answers
RELEVANCY SCORE 139.2

Hi all,

So I'm kind of stuck.. I currently have the problem where I am in an endless cycle of "loading files" -> "Windows Boot Manager" (see: How To Boot Into Safe Mode On Windows 8 (The Easy Way)).
I have tried to load all of the options -- and none successfully load.
I also end up at a OneKey Recovery as well.. unfortunately, the laptop does not have initial backup or user backup images.
I have a Windows 8 CD for repairing purposes.. however, I cannot load the BIOS/UEFI to change the boot order to load the optical drives first. I have also tried to remove the CMOS battery to fix it.. did not work. .
Also - Windows Boot Manager:
Windows Setup [EMS Enabled] -- does not load properly (leads to OneKey Recovery) Safe Mode (does not load properly) Safe Mode with Networking (does not load properly) Safe Mode with Command Prompt (doesn't load - tries to boot and load all files onto partition that is too small.. can't change partition?)
Enable Boot Logging Enable Low-Resolution Video Debugging MOde Disable automatic restart on system failure Disable Driver Signature Enforcement Display Early Launch Anti-Malware Driver
Start Windows Normally
Any ideas would be greatly appreciated! Thanks!

Read other answers
RELEVANCY SCORE 139.2

Hi everyone!

Yesterday my HP laptop (Windows 7) started getting BSOD with various types of errors (mostly "STOP: 0x00000F4", "STOP: 0x0000007A", "c00021a" and one "missing %hs, c0000135"). Most of the time it restarts without any issues and works fine right after the BSOD and then an hour or two later I get a BSOD again.

I have tried restoring to Last Known Good Configuration, startup repair, hard disk check, virus scans and I also uninstalled any recently added programs I could think of and cleared up more than 50% of my hard disk space. None of these seem to have helped and I still get BSOD regularly.

I have attached the folder from the SF Diagnostic Tool and would appreciate any advice!
Thank you!

A:BSOD every few hours: mostly "STOP: 0x00000F4", "c00021a" & "c0000135"

Welcome to the forum.

MSINFO32:
Please go to Start and type in "msinfo32.exe" (without the quotes) and press Enter
Save the report as an .nfo file, then zip up the .nfo file and upload/attach the .zip file with your next post.
Also, save a copy as a .txt file and include it also (it's much more difficult to read, but we have greater success in getting the info from it).
------------------------
Upload a screenshot using: CrystalDiskInfo For how to upload a screenshot or file, read here
Test your Hard Drive(s) by running: Hard Drive Diagnostic Procedure
------------------------
Test and Diagnose RAM Issues with Memtest86+: RAM - Test with Memtest86+


   Tip
Pay close attention to Part 3 of the tutorial "If you have errors"
Test the RAM with Memtest86+ for at least 7-10 passes. It may take up to 22 passes to find problems. Make sure to run it once after the system has been on for a few hours and is warm, and then also run it again when the system has been off for a few hours and is cold.


------------------------
Monitor hardware temperature with system monitoring software like Speccy or HWMonitor. Upload a screen shot of the Summary tab as well:Piriform - Speccy
CPUID - HWMonitor
For how to upload a screenshot or file, read here

Code:
*******************************************************************************
* *
* Bugche... Read more

Read other 5 answers
RELEVANCY SCORE 139.2

Hello guys, the last week I've been strugling with these nasty BSODs. At first I thought it was my HDDs as ntoskrn.exe somewhat hinted towards that from googling it. My HDDs have been causing a lot of trouble earlier as well due to their somewhat long years of service. However, I've recently reformated my computer and installed W7 on a brand new Corsair Force GT 120GB SSD hoping the BSODs would go away, they didn't.

I googled BSOD and I stumbled upon this forum and I thought I'd give it a try. I'm somewhat desperate, as I need my computer working for both work, school and amusement.

I've been trying to run Memtest in order to test my memory but without any results. I'm also currently running on only on 4GB chip instead of two, to see if the problem still exists. Also, without any results.

This is the second time I'm writing this thread btw, I was just about to post it and my PC crashed.

Here is my two logs + dxdiag (last crash didn't generate a log oddly enough).

Here is additional hardware/gear that I use:

Razer Megalodon 7.1 Headset
Razer Naga
Logitech G19
Logitech C920 (Webcam)
Corsair 750W PSU

My temperatures are also good. Both CPU and MB idles at around ~25. GPU's all good too. I'm also using a Corsair 650D chassi with dustfilters at both air-income so dust is minimal. On top off this, I use airpressure to clean away dust somewhat regularly and I also did exactly this 2 days ago when I reinstalled the pc.
... Read more

A:BSOD - "Memory management", "Bad pool header", "ntoskrnl.exe"

Are you over-clocking? Is the bios set to its defaults? Is the SSD set on a SATA 3 port in AHCI mode?
 

Read other 5 answers
RELEVANCY SCORE 139.2

I am using Windows 7 on my laptop and I have question about when to use "Home", "Work" and "Public" profile.

If I am logging in without setting password, and I am logging in network with "Public" profile, then will any other user, who can see my computer, be able to enter my computer and check the contents on my computer ?

I am connecting to a network and there are 6 other users connected to this network. In the set network location window, if I select the netwoek as "Home", does it mean that other 6 users will not be able to see my computer on network and if I use "Public", then all other six users will be able to see my computer on network ?

Thanks

Read other answers
RELEVANCY SCORE 139.2

Ok so I'm using a custom visual style made by another user however I don't really like the buttons used that I mentioned above. The creator states it is acceptable to change the theme to however you like as long as you don't redistribute it anywhere.

Ok so I opened up the .msstyles file (using Restorator) located in the theme folder of this VS. I went into the images directory and located what seems to be the images used for the buttons. Intuitively, it seems like it would make sense to replace those images with different ones (perhaps from another visual style) and it should change them. However, would this actually work? Could the theme get messed up in some other way (like proportions or something if the new button images are smaller)? I don't know of any other way to change them that would be easy.

But I did run into another problem. For some visual styles I can't even locate those buttons in the images directory. Where else would they be?

A:Changing the "minimize" "maximize" and "close" buttons of a theme

Use Windows Style Builder to do that...

Read other 9 answers
RELEVANCY SCORE 139.2

Example sentence: vrytim I prss ths kys, nothing happns. Now I'm writing with my on-sreen keyboard. I'm clueless when it comes to computer stuff. How do I fix this? Is this a software problem, or a hardware problem?Help is much appreciated!

A:Kyboard deos not respond to the keys: "e", "d", "c" and "3"

My keyboard hath the thame problem with the thupid eth key. The blathted thing ith driving me nutth.

All theriousneth...er...seriousness aside, usually, that is a hardware problem. Can you find or borrow another keyboard and see if it will work correctly on your machine?

Read other 6 answers
RELEVANCY SCORE 138.4

Hi, I've looked all over the internet in attempt to find a solution to a problem that's just affected my computer, and I haven't been able to find anything that relates specifically to the problem I'm encountering.

This hit my computer without warning, I switched it on this morning and it worked as normal, all of a sudden things started to freeze up. I restarted the computer, and now a lot of programs are refusing to open - Microsoft Office, among others, states "Error: There Are No More Files", whilst other programs such as Google Chrome and Internet Explorer state "Attempt to Access From Invalid Address", even when I am running them from their root folders.

I am running a Dell Latitude 830 with Intel Core 2 Duo T7250 (2.00GHz, 2M L2 Cache, 800MHz) Dual Core, 1.0GB, DDR2-667 SDRAM, 2 DIMMS, Intel Integrated Graphics Media Accelerator X3100 and am obviously using Windows XP. I have scanned my system with Avast Antivirus, which didn't state that there were any viruses, so I am stuck as to what exactly the problem is.

I'd really appreciate some help in figuring out what has happened, thankyou so much for your time in reading this!

A:"There Are No More Files"/"Attempt To Access From Invalid Address" Issue

I am having the same problem on the same exact hardware. i don't think it could be a hardware issue, but i could be wrong. i have tried repairing windows with no success. i'm thinking the only option is to reinstall windows completely.

Read other 13 answers
RELEVANCY SCORE 138.4

The control panel opens fine. I can access all items in the control panel
except "Network and sharing center" and the "User accounts" (I can't access this sections via the taskbar either).

What happens when I open one of the two items is I get a popup saying the
following; WINDOWS EXPLORER HAS STOPPED WORKING.

I used to be able to access these items. And one day, I just coulodn't anymore...

Anyone knows how to solve this? Thanks.

I'm using Vista Ultimate x64

A:Can't access "Network and Sharing Center" nor "User Accounts"

Hello Newbie,

See if running a sfc /scannow can find and fix bad system files that may be responsible for this.

Hope this helps,
Shawn

Read other 16 answers