Over 1 million tech questions and answers.

Query ~ Instructions For Hijack This Log ~ Query

Q: Query ~ Instructions For Hijack This Log ~ Query

...ookie crumbs?

Point 3. Clear out your temporary internet files and temp files.

What does this mean, is it....

Get rid of them?

Clean them of stuff?

What if there are things that i want to keep in these files, should i move them to a more permanant place?

orrrr, is this just a consequence i gotta put up with. Ok, so i lose lots of stuff i've saved (if there is lots, dont often check) but my computer will be clean and safe?

If there is something REALLY important in the temp file and clear means get rid of, is there a way of salvaging the contents that arnt bad?

RELEVANCY SCORE 200
Preferred Solution: Query ~ Instructions For Hijack This Log ~ Query

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: Query ~ Instructions For Hijack This Log ~ Query

You should not have any files that you want to permanently save in Temporary Files. I have included directions for cleaning IE.
These instructions explain how to delete Temporary Internet Files. Microsoft Internet Explorer (IE) uses the Temporary Internet Files feature to store copies of Web content on the local hard drive. This feature improves network performance but can fill the hard drive with large amounts of unwanted data. IE allows many aspects of the Temporary Internet Files feature to be controlled, including the ability to delete temporary files as needed.
Difficulty: Easy
Time Required: < 1 minute
Here's How:

1. Open either Microsoft Internet Explorer or the Windows Control Panel.

2. In Microsoft Internet Explorer, open the Tools menu and choose the Internet Options... menu. In Control Panel. open the Internet Options list item. In either case, a new window titled "Internet Properties" appears.

3. In the Temporary Internet Files section of the Internet Properties window, click the "Delete Files..." button. A new "Delete Files" window appears.

4. In the "Delete Files" window, optionally check the "Delete all offline content" checkbox to also remove temporary files IE has saved for offline viewing. Click OK. A delay of up to several minutes may occur as IE proceeds to delete the temporary files it has cached. If the "Delete all offline content" checkbox is not checked, IE will not delete temporary files associated with offline content; otherwise, all temporary files will be deleted.

5. Click OK to close the Internet Options window.

Read other 8 answers
RELEVANCY SCORE 94.8

NOTE: I could not post code because I must be really careful to protect proprietary information.

I work in an assembly plant and I've designed an Access 2003 program to deliver a set of 4 crucial parts to the floor all within a very narrow degree of tolerance. Further, the program integrates FIFO.

Ive done this by assigning each of the essential measurements codes and then running a series of queries:

Query 1 identifies the oldest Part A by sorting the available parts by the date they were inspected then by serial number (to break ties) and delivering the TOP 1.
Query 2 identifies the oldest Part B that is compatible with that Part A using the same method.
Query 3 identifies the oldest Part C that is compatible with that Part B.
Query 4 identifies the oldest Part D that is compatible with the other end of Part A. I have the parts in this order because we can begin assembly if we don't have a Part D on hand, but we must have Parts A, B, and C.
Finally, query 5 simply pulls the information from those queries into one location for a report.
As long as we have enough stock, life is good; but the moment a match cannot be made, it blows up. I cannot figure out how to make it go back to choose the next Part A. I need to figure out how and where to add code to each query to tell it that if no stock is compatible with the Part A produced by Query 1, to go back and pick the next one in line.

Can anyone help? Is the way I've gone about matching parts completely... Read more

A:Access 2003 – Query Based on Query – need code to rerun earlier query

Read other 11 answers
RELEVANCY SCORE 92

Hi there,

I'm very new to access and I hope I will get the simplest solution on my question below.

I have a table named "PurchaseOrder" and I'd want to create a query that will display the invoices that will due.

Eg:

Table1
PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
8697 D 888 $88 18-Oct-2010

I want to create 2 queries.

The first query will display all the invoices that will due 5 days before the exact due date.
Eg:
The invoice due date is 15-Oct-2010. The query will display information on 3241, 6589, and 2234.

For the second query, I want to display all the invoices that have exceeded the due date. The information on the respective invoices will be transfered from the query as mentioned earlier to the new query.

The scenario is as below:

Date: 16-Oct-2010

Query1

PONo Customer Quantity SalesPrice InvoiceDueDate
3241 A 421 $12 17-Oct-2010
8697 D 888 $88 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
Date: 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
8697 D 888 $88 18-Oct-2010

Query2

PONo Customer Quantity SalesPrice InvoiceDueDate
6589 B 521 $19 14-Oct-2010
2234 C 987 $32 15-Oct-2010
3241 A 421 $12 17-Oct-2010
Hope someone can help me with this. Really appreciate and hoping for ur help.

 

A:Query Access 2007 (how to transfer data from a query to another query)

The first query needs the following first Criteria Row of the InvoiceDueDate
between date() and date() + 5
The second query needs
< date()

I haven't tested it, just worked from memory. so let me know how it goes.
 

Read other 2 answers
RELEVANCY SCORE 80

I've got a lending table in which we lend items out, now they can be loan or permanent.

I can run a report with the query parameter on the ReqDate_Fld criteria Between [Report Start Date] And [Report End Date]

The report prints and counts everything borrowed.

Now I want to add more records to the report to include everything borrowed that was returned during that period specified by the criteria Paramenter set in the query. But using the Return Date (RetDate_Fld)

How can I select rows from the query based on the parameter date filled in when the query ran?
[Report Start Date] and [Report End Date].

I can build a separate report just for the returns using the current parameter but on the RetDate_Fld Between [Report Start Date] And [Report End Date] set by the query.

I've got it grouping at 3 levels to get it to break by Borrower, ReqID, and Request Date

Does this make any sense?
Thanks
 

A:Solved: Access query report query paramater use the param

You would have to have another group for whether or not the RetDate_Fld was filled in or not.
Add a new column to the query with the following Heading

RetDatefilled: iif(not isnull(RetDate_Fld), 2, 1)

That should place a 2 in the new column when there is a date and a 1 when there isn't.
You can now group on that data.
 

Read other 2 answers
RELEVANCY SCORE 80

I have written a macro to make a table from data in an existing table. Then I use the data in the new table to select information in another table. That select query does not allow me to update the information in the 2nd table. It is like the records are locked. Even if I create a new table myself the select queries are locked but all my pre-existing queries work fine. Is there some type of setting I am missing that causes the information to be locked in select queries? I am thinking somehow the setting may have been changed. Any thoughts would be appreciated.
 

A:Solved: Access Make Table Query and Select Query

Read other 7 answers
RELEVANCY SCORE 78

I have a previously designed Access DB and there is a query that I am trying to understand. It has several tables that are queried more than once in a single query. First how do I determine the actual table name? I can only see the alias name. Also what is the purpose of using the same table twice in a query?
 

A:Solved: Access Query using tables more than once in same query

It is normally to do calculations or comparisons on prior or next records. It is the one weekness of Access Queries, the Totals function has some good arithmetic calculations like average, Count Sum etc but manipulating previous records like add or subtract values from the current record it can't do. So it requires more advanced SQl. Which is apperas you have.
Have you looked at the query in SQL view?
It should use the word "As" to designate the alias.
 

Read other 2 answers
RELEVANCY SCORE 78

Hi there,

Once again I need your help in Access. I'm trying to do a calculated field in a query that based on a query. For example, query B is based on query A. I want to add a calculated field called Totals in query B. The field totals does not exist in any of my tables.

Here is an example.

Totals: [Field1]+[Field2]+[Field3]

In the totals line I clicked on Expression. But the totals do not appear when I view my query. I get no errors on the formula. What at I doing wrong??

Mario
 

A:Calculated field in a query based on a query

Read other 7 answers
RELEVANCY SCORE 78

For a report I have a customer table, an invoice table and a revenue or payment table.

I need to produce a report that shows all the invoices created during a given month and year - that part is easy.

But then I also need to show the first payment given on that invoice. This is a situation where there is always a down payment made at the issuance of the invoice - but sometimes people will make more than one payment during a month.

Example:

I want the customer listed for each new invoice, the total amount of that invoice and what the inital payment on that invoice was: [CustomerID][Customer Name] [Invoice No][Total Invoice Amount] [Payment Amt]

So if there was an invoice issued for $100 and they paid 50 and 25 during the month it was issued and the balance on the next month, I still want to show it on this report as a $100 invoice with a $50 downpayment only.

(The tables are established and populated so it is too late to change the payment table to allow for a unique downpayment field. They all go in as payments.)

My problem is that if they made more than one payment during the month, the whole line with the customer name and invoice number shows up for each payment made. I only wnat the FIRST payment. I need a payment query that shows only the first payment in the month of invoice issuance.

Does that make sense?
 

A:SQL Query question for Access 2010 query

Yes it makes sense, I would create a pre-query that uses the Month & Year but is set to "Totals" and Date Minimum.
Then create the Report query using the pre-query linked to the new query's table via the InvoiceID this will limit both the month, year and minimum payment.
 

Read other 1 answers
RELEVANCY SCORE 78

I have created a search engine for a data base using Access 2007
The Form Basically Runs a query of multiple fields and loads the result into a Combo box.
The problem is the data base is not fully complete and the records with blanks in some of their fields do not appear in the search results.
For example lets say I am looking for a People with the same surname and in my database is
Name Surname
Mike Norris
Chuck Norris
Norris
The query will not find the record only containing Norris
Here is the query I have used.
Like "*" & [Forms]![Entry]![txtSurname] & "*"

 

A:Query, Query Searching Blank Matches

Read other 8 answers
RELEVANCY SCORE 75.2

hi there,

I have a large Access database and some of the queries are based on other queries (sql or other).

Now when I try and view the design mode of some of these queries, it takes an astonishingly long time as it appears that Access runs the child query contained before it allows the 'parent' query to show in design mode.

I can kind of see why it does it - but is there any other way of quickly viewing a query in design mode without Access first running the other queries it's based upon?

(NB: Someone said in the 'old days'(!) Access used to have this feature, but it is no longer there?!?!?!)

Thanks
 

A:Trying to look at design of query based on another query...

Bounce in case of new eyes to the forum!
 

Read other 1 answers
RELEVANCY SCORE 75.2

Hi Access bods.
Can anyone tell me how to do an expression to query from DATATABLE (the name of table), containing

ID: Auto ID key for the table
SITEID: There are multiple sites
ITEMID: Each site will have multiple Items
QUALITYID: This is set to either F, or is left blank
Id like to find the Percentage of Non-F, to each SITEID and ITEMID combo. I hope this makes sense.
 

A:Solved: Access Query, Query

Read other 6 answers
RELEVANCY SCORE 73.2

First of thanks for letting me join, great site!!! Im just wondering if someone can help...I new to this software 'hijack this', can someone help to find anything on this list that's a little suspect!? thanks lee
 

Read other answers
RELEVANCY SCORE 72.4

Hi guys,I keep getting a pop up message from security sayin g it will not install this file naed "rdgUS2405.exe". On the blue banner on the top of the box it says "universa application - security warning"I downloaded Hijack This and ran it and got a list of suspect files. It said to seek advice before deleting. Can someone please help me? below is the log file.Logfile of HijackThis v1.99.1Scan saved at 9:27:53 PM, on 25/02/2006Platform: Windows XP SP2 (WinNT 5.01.2600)MSIE: Internet Explorer v6.00 SP2 (6.00.2900.2180)Running processes:C:\WINDOWS\System32\smss.exeC:\WINDOWS\system32\winlogon.exeC:\WINDOWS\system32\services.exeC:\WINDOWS\system32\lsass.exeC:\WINDOWS\system32\svchost.exeC:\WINDOWS\System32\svchost.exeC:\WINDOWS\system32\spoolsv.exeC:\Program Files\WIDCOMM\Bluetooth Software\bin\btwdins.exeC:\WINDOWS\system32\CTsvcCDA.exeC:\Program Files\Network Associates\Common Framework\FrameworkService.exeC:\WINDOWS\Explorer.EXEC:\Program Files\Network Associates\VirusScan\Mcshield.exeC:\Program Files\Network Associates\VirusScan\VsTskMgr.exeC:\WINDOWS\system32\nvsvc32.exeC:\WINDOWS\System32\svchost.exeC:\WINDOWS\system32\MsPMSPSv.exeC:\WINDOWS\system32\CTHELPER.EXEC:\Program Files... Read more

A:Hijack This Query Log File

Hello and welcome to the site.. Yes, you have few infections there, lets get started.==Please print these instructions out, or write them down, as you can't read them during the fix.Please download ATF Cleaner by Atribune.This program is for XP and Windows 2000 onlyDouble-click ATF-Cleaner.exe to run the program.Under Main choose: Select AllClick the Empty Selected button.If you use Firefox browserClick Firefox at the top and choose: Select AllClick the Empty Selected button.NOTE: If you would like to keep your saved passwords, please click No at the prompt.If you use Opera browserClick Opera at the top and choose: Select AllClick the Empty Selected button.NOTE: If you would like to keep your saved passwords, please click No at the prompt.Click Exit on the Main menu to close the program.For Technical Support, double-click the e-mail address located at the bottom of each menu.==Please download Ewido Anti-Malware, it is a free version of the program.Install Ewido Anti-MalwareWhen installing, under "Additional Options" uncheck..Install background guardInstall scan via context menuLaunch Ewido, there should be an icon on your desktop, double-click it.The program will now open to the main screen.When you run Ewido for the first time, you may get a warning "Database could not be found!". Click OK. We will fix this in a moment.
You will need to update Ewido to the latest definition files.On the left hand side of the main screen click update.Then click o... Read more

Read other 26 answers
RELEVANCY SCORE 72.4

Any assistance in interpreting the results of this logfile would be appreciated. Thanks!

Logfile of HijackThis v1.95.1
Scan saved at 3:28:27 PM, on 07/21/03
Platform: Windows 98 SE (Win9x 4.10.2222A)
MSIE: Internet Explorer v5.51 SP2 (5.51.4807.2300)

Running processes:
C:\WINDOWS\SYSTEM\KERNEL32.DLL
C:\WINDOWS\SYSTEM\MSGSRV32.EXE
C:\WINDOWS\SYSTEM\SPOOL32.EXE
C:\WINDOWS\SYSTEM\MPREXE.EXE
C:\WINDOWS\SYSTEM\TABLET.EXE
C:\WINDOWS\SYSTEM\MDM.EXE
C:\PROGRAM FILES\TV VIEWER\TVWAKEUP.EXE
C:\WINDOWS\SYSTEM\MSTASK.EXE
C:\PROGRAM FILES\TV VIEWER\ANNCLIST.EXE
C:\WINDOWS\SYSTEM\HIDSERV.EXE
C:\WINDOWS\SYSTEM\mmtask.tsk
C:\WINDOWS\EXPLORER.EXE
C:\WINDOWS\TASKMON.EXE
C:\WINDOWS\SYSTEM\SYSTRAY.EXE
C:\WINDOWS\STARTER.EXE
C:\WINDOWS\INTELDEV\DEVSTAT.EXE
C:\PROGRAM FILES\POPUP KILLER\POPUPKILLER.EXE
C:\PROGRAM FILES\LOGITECH\MOUSEWARE\SYSTEM\EM_EXEC.EXE
C:\WINDOWS\SYSTEM\STIMON.EXE
C:\WINDOWS\SYSTEM\QTTASK.EXE
C:\WINDOWS\SYSTEM\MSVCMM32.EXE
D:\PROGRAM FILES\MOVIELINK\MOVIELINKMANAGER\M3TRAY.EXE
C:\PROGRAM FILES\SCANSOFT\OMNIPAGESE\OPWARE32.EXE
C:\WINDOWS\SYSTEM\WMIEXE.EXE
C:\WINDOWS\SYSTEM\DDHELP.EXE
C:\WINDOWS\SYSTEM\PSTORES.EXE
C:\PROGRAM FILES\INTERNET EXPLORER\IEXPLORE.EXE
C:\WINDOWS\REGEDIT.EXE
C:\WINDOWS\DESKTOP\HIJACKTHIS.EXE
R0 - HKLM\Software\Microsoft\Internet Explorer\Search,CustomizeSearch =
R0 - HKLM\Software\Microsoft\Internet Explorer\Search,SearchAssistant =
R1 - HKCU\Software\Microsoft\Internet Explorer\SearchURL,(Default) = http://av.yahoo.com/bin/search?p=%s (obfuscated... Read more

A:hijack log and ipinsigt.dll query

Read other 10 answers
RELEVANCY SCORE 69.2

Hello,
I am pulling information from another program into Excel via Microsoft Query and one of the columns I want to pull in involves a date a payment is due. I am wondering how to write the query to have it always pull today's date +1 so essentially it would always pull tomorrow's payments due. Thank you!

I tried to add Where date = DateAdd("d",1,date()) but I am getting this error: "general odbc error." What does this mean and is there a way to fix it or alter query?
 

A:Help with date SQL query in ms query

Hello, in Access Queries you can just use
Date + 1
so perhaps it will work for MS Query.
 

Read other 1 answers
RELEVANCY SCORE 55.6

Hi! 1)What is the highest version of Internet Explorer that I can run on Windows 2000 OS? 2) What is Active X?
Whenever I open Gmail it says that my browser isn't fully supported. Hence I need to upgrade to a higher version of Internet Explorer. Thanks .
 

A:Query: I.E

IE6 Is currently the highest version available. IE7 is available, but it`s still in beta form and I don`t recommend you try it.

If you run Windows updates you will be able to get IE6 and any other updates for your system.

ActiveX see HERE for info.

The reason Firefox etc don`t support ActiveX is because it`s considered a security risk. The sooner websites stop requiring the use of ActiveX controls the better.

Regards Howard
 

Read other 2 answers
RELEVANCY SCORE 55.6

Hi everyone,

I have an sql query that pulls together (from a list pasted into a table) the names which go with the list... just basic cross referencing.. looks like this:

SELECT [table1].[no], [table2].[name]
FROM table1, table2
WHERE [table1].[no]=[table2].[name]
ORDER BY [no];

which works fine, but as a bit of fine tuning, can I make the query return a string such as "N/A" when a [no] is not found... instead of just omitting it from the results?

Thanks,
-Sheist
 

A:SQL query, query :)

Hi,
You can try this.
I already tested this on our Ingres DB.

SELECT IFNULL([table1].[no],'N/A'), [table2].[name]
FROM table1 LEFT JOIN table2
ON [table1].[no]=[table2].[name]
ORDER BY [no];

Take note of the LEFT JOIN Clause, and the ON Clause.

I hope this will work for you.
 

Read other 3 answers
RELEVANCY SCORE 55.6

Hi All.

I just installed AVG 7..(had in the past AVG 6).. Install - I think went okay. I seem to have it on my computer.(Dell, XP Pro)..

It says.. Virus update is out of date.. YET. it won't let me update the virus files??

Anyone else have this problem.

Also. when I sent an email to myself.. it says. AVG email scanner is out of date?? What gives.. How do I correct this.

And also.. what ARE the correct configurations for AVG 7..

I was able to have "it' check for updates daily.. but theres no place that tells you it will 'scan daily' your files?? unless I'm mistaken, and haven't seen it.

Any help would be appreciated.

thanks
helene
 

A:Query.. Re: AVG 7..

Read other 16 answers
RELEVANCY SCORE 55.6

I watch BBC I-Player on my Android Nexus 10 via an HDMI lead to my large screen TV. On trying to repeat this process with Sky GO I find that Sky have disabled HDMI acces to Sky Go applications.

Coukd I get round this using an MHL lead.

Any help would be appreciated.
 

Read other answers
RELEVANCY SCORE 55.6

Have a Vista machine here and it has 2x1Gb PC2-5300 DDR2 @667MHz in it and running very slowly. I have a 2GB stick of PC2-6400 @800MHz spare and wondering if it's ok to put it in with the PC 5300?

I know it will probably drop the speed back to 667 but am just trying to get a bit more RAM onboard. Wouldn't be concerned if it were my machine but one that I am cleaning and updating, and I don't have that much experience doing this with laptops - the main concern being the heat differential?.

Machine is a Toshiba A210 running Vista Home

A:Yet another RAM query

Do you have a specific model number for the A210? Crucial lists about a gazillion sub-models. Most seem to have two memory slots and the A210 should support up to 4GB RAM. You might want to plug in the specific data just to make sure about the RAM specs. This is to the A210-138 just as an example.

Computer memory upgrades for Toshiba Satellite A210-138 Laptop/Notebook from Crucial.com

Most folks suggest that RAM be installed in matched pairs. However, I had no problems with an older Dell Inspiron running a 1GB stick and a 2GB stick from different manufacturers with completely different specs. RAM prices have come way down recently. (A lot of online retailers are selling 4GB sticks for under $20 US.) I think I'd ask the owner if he'd be willing to max out the RAM.

Read other 4 answers
RELEVANCY SCORE 55.6
Q: Query

I have a Linksys 4 port WRT54G wireless router,,,, all the ports are full and I need at least two more, I'm sure I need a hub, but how would I connect it to the router and modem ???
 

RELEVANCY SCORE 55.6

Have had to reinstall my entire machine - hard drive failure.

Have got it all set up with most of the stuff I had before except the WLM.

Have downloaded Live Essentials signed in etc etc - is there a tutorial on how to set it up - Ive had a quick look but cannot find what I want.

The damn application seems to have a mind of it's own and I am seriously thinking of buying either MS Office Mail or going gmail as this constant problem happens all the time on all my machines in fact not just this one really getting on my nerves.

A:Query re WLM

Is this of any help

Email setup: Windows Live Mail 2011

Read other 9 answers
RELEVANCY SCORE 55.6

Hi guys,

I'm trying to solve a little sql problem -- I need to cross reference and dump out a list of records that don't belong. The existing query uses a left join between two tables... I need to add some more 'AND' statements in the WHERE line because the query needs to take into account other tables... hence I need to include those tables in the from line. How do I do this, when there is a left join already there?

For example:

SELECT DISTINCTROW tblOne.*
FROM tblOne LEFT JOIN tblTwo ON [tblOne].[item1]=[tblTwo].[item2]
WHERE ((((DatePart("m",[Date])=[Enter Month])) And [tblTwo].[item2] Is Null));

How can I go about adding:

WHERE ........ AND [tblThree].[item3] Is Null AND [tblFour].[item4] Is Null));

To the end of that?

Quick responses will be much, much appreciated.

Thanks guys!
-Sheist
 

A:SQL query ;)

Read other 7 answers
RELEVANCY SCORE 55.6

good afternoon eveyone....

i have a question regarding my ram its not really vista related i bought 2 new sticks gskill pc8000 1000mhz 2GB (1GBx2) i wanted to find my max overclock with this ram but it means removing my current 3GB pc5300 667mhz (1x1GB 1X2GB)
once i find my max overclock i want to stick those sticks back in with the gskill i know they are different native speeds but will they work.....
if so will they run at the lowest speed - 667mhz

this is only till i get 2 more gskill matched pairs
though i might as well let vista munch its way through 5GB instead of letting them rot..

what do ya think....?

A:ram query

Hi skunksmash,

Your ram will run at the speed of the lowest mhz stick installed. What mhz is the max overclock sticks? You might experiment to see if your system will run faster with just the gskill 2GB @ 1000mhz ram versus the 5GB @ 667mhz. It may be faster with just the 2 GB @ 1000mhz if you do not have alot running at one time. If your max overclock sticks are faster than 667mhz, say 800mhz or higher, then it may be worth having them with the gskill 2GB sticks. You will just need to try each setup and run it through it's paces to see what feels faster for you.

Hope this helps,
Shawn

Read other 3 answers
RELEVANCY SCORE 55.6

hi new to the forum i have vista ultimate x64 my system appears to be using 1.5ghz idle is this normal....

it is not a problem i have never seen windows and apps open so fast but they say min requirements 512mb how is that possible.....

A:RAM query

heres a pic

Read other 3 answers
RELEVANCY SCORE 55.6

When I create SQL statements using MS QUERY, HAVING is the default term used for my criteria -- especially when I subtotal using GROUP BY. When I am using a field in my criteria that is NOT in my retrieve, I would much rather use WHERE. I do know how to edit the SQL statement so that the criteria uses WHERE, but I would rather not have the hassle, and I find that new users are very put-off by having to edit. Is there a way to set, coax or fool MS Query into using WHERE instead of HAVING?
 

A:HAVING vs WHERE in MS QUERY

It is not very efficient to use MS query that way. One tip I can give you is in the criteria row you can use [square brackets] to create a parameter query (just like MS Access).

But really you would be better off using an Access Database (assuming that is an option) and link to your source via ODBC. In Access create a new Linked table, change the files of Type to ODBC and you will see your list of sources.

The database will offer more options users.
 

Read other 3 answers
RELEVANCY SCORE 55.6

Hi

Can someone tell me what to do after I run an AVG test. Until now, I've always gone into "Virus Vault" and pressed remove. However, each time I run a fresh test, I see new trojans and viruses and am concerned I may not have done the right thing in the past and they are in fact the same parasites lurking.

I used to have Norton. With subscription expired, I have now removed that and put in AVG as well as Previx, and for firewall Zone Alarm. Also run Spybot, Adaware, CWSearch, SpywareGuard and Spywareblaster. Have I missed anything else useful to have?!!!!!!
Thanks.
 

A:AVG query

Read other 7 answers
RELEVANCY SCORE 55.6
Q: Query

Can someone please tell me the difference between V.35 and G.703 standard. IT and Telecom companies tend to use them interchangably for E1s. Kindly explain the difference.
 

A:Query

What is the difference between G.703 and V.35 ?
V.35 is a balanced connectivity provided with Winchester type connector. It has 34 pin, DTE type connector terminated with end equipment. G.703 is an unbalanced connectivity using co-axial cable with BNC connector.(75 ohms) is terminated with end equipment.

http://www.querycat.com/search?q=difference between V.35 and G.703:up:
 

Read other 3 answers
RELEVANCY SCORE 55.6

Can I set DNS as 192.168.2.1 on router & systems?
 

A:DNS Query

I'm not really sure I know how to answer your question directly since I don't get it but what I can say is: if you set a DNS on your router, your wireless devices, including wired devices attached to your router will automatically use the DNS your router uses. There is no need to set them up separately. As for setting a local IP as a DNS (I'd assume it's the IP your router uses which is also used for DHCP), I'm not really sure how that would work or if it could even work. I don't imagine a router has the ability to look up and resolve IP as domain names. If it could, I can't see a reason why DNS companies like OpenDNS exist.

Hope my answer wasn't useless. I'm feeling I'm misunderstanding the question somehow.
 

Read other 8 answers
RELEVANCY SCORE 55.6

I tried to run a dvd that has stuff that can only be accessed via a dvd rom , but get told that I'm missing the software needed to run it. Is it possible to be able pick that part of Vista for free? When I got this laptop a good chunk of it was missing

A:DVD query

It might help to know what kind of data you are accessing it and the error that you are getting.

Read other 5 answers
RELEVANCY SCORE 55.6
Q: Query

Have searched for a thread but cannot find one close so....

Have just got IE9 RC on and tonight Google is telling me I cannot access Youtube without having a Google account.

Is this a genuine ask?/ as I feel that if it is that Google is taking a damn liberty - is there a way around it? and if not an alternative as I have been watching a lot of PC build vids on YT and now have to do this!!

Am really extremely angry at this action they deem to be necessary and I see just another way of Google tracking us!! Am seriously thinking of going Bing or Firebird at least I can avoid this meglomaniacal search engine from world domination!!!

A:Query

I have ie9 rc here and I can watch youtube vids without logging into my gmail account.

Read other 7 answers
RELEVANCY SCORE 55.6

I am running Windows Vista 32-bit on a Acer Aspire L5100 which is currently running with 1gb or RAM.

Over recent weeks I have noticed a major dip in performance due to memory usage.

I believe I have 2 RAM slots, 1GB currently, but instead of buying another 1GB, i was thinking of buying a 2GB stick to make it 3GB in total.

Just a quick question, would there be a problem in running with odd RAM? I wouldnt think so but before buying a 2GB stick to run with 3 i just wanted to make sure.

thanks
 

A:RAM Query

Read other 6 answers
RELEVANCY SCORE 55.6

Mate who hasn't much money came to me with his desktop a "getting on" Compaq Presario SN5540AN with an AMD Athlon dual core 5400+ ? 2.8Ghz Vista (+SP2).
He said to me saying that everything they tried to open prompted a you have a virus message and nothing would open.

Usual sort of clean up ? temp files, Ben Hur's cookies, and updating Windows (tons) and had not updated the security for a long time (cannot get into the set up tools to see what has been set). Security is Trend Titanium by the way.

Now it's going a bit better but still slow even after installing a stick with 2Gb Readyboost but think it's worth the installing of 4Gb internally instead of the 2Gb it's got now, at least it's not hanging out of the machine and liable to being pulled out etc.

Currently got 2x 1Gb Samsung DDR @ (800 MHz) what I want to know is it worth going to 1066MHz sticks or not, or is this going to be governed by the mobo?
Mind you the 1066MHz are about twice the price of 800MHz

Use is just usual stuff emails school work any help really would be appreciated.

Have found the mobo "model" ? MCP61PM-HM (Iris8)

A:RAM query

I would say no on the faster RAM.
Could be that system only supports 800 speed RAM. So even if you installed faster RAM it would still only go to 800.

Read other 4 answers
RELEVANCY SCORE 55.6
Q: A Query

I am planning to format my C drive which has SP3 installed in as it has been infected with W32 Blaster worm if there is no way to repair it.My D and E drives, i guess have also been infected.I intend to install XP or Windows 7 in the C drive then install an antivirus and disinfect the D and E drives.What i wanna know is will all the data in D & E stay intact even if it is infected whilst i format and install XP or & in the C drive.

A:A Query

You need to ask that question on the virus/malware forum as we aren't allowed to answer virus-related questions on the Windows forums in case you get bad advice from ill-informed people. Post here: Virus/Trojan/Spyware Help - Tech Support Forum

Read other 2 answers
RELEVANCY SCORE 55.6

I have had a quick look but cannot find much but.....

I have built a SB with i5 2500 on Gigabyte GA-H67A-UD3H-B3 Motherboard and I fitted a Samsung SpinPoint F3 1TB HD103SJ but find it a bit noisy so have bought a
Seagate Barracuda 1TB ST31000524AS not only because it is supposed to be quieter but it is also a 6Gbs transfer rate, and hoping it will speed up the boot as a bonus.


Can I transfer the OS and everything on the Samsung to the Seagate and then disconnect and remove the Samsung ? keep it for another small build ? spare - easily or is it going to be a difficult task to do that.

I also have an internal Seagate Barracuda 500GB ST3500413AS as a back up as well. Can I also just put the OS only onto this drive in the event of the other drive crashing completely.

I do back up onto a 3.0 USB external as a matter of course, as I like to be overly cautious rather than stuck with zip.

Advice and direction most appreciated

A:Query re HDD's

Hi ICit2lol.
Please follow the Transfer Windows 7 Installation to a New Computer guidelines to be safe.
Hope that helps.

Read other 9 answers
RELEVANCY SCORE 55.6

I have a table that references itself and I want to get it to display similar to what a pivot table does in Excel.

Example: TableA (pk,Name,fkTableA)

I have my query written similar to this:

Code:

select * from TableA
left join (select * from TableA) as TableB on TableB.fkTableA = TableA.pk
order by TableA.pk

Is displays like:
1) 1,MyName,null,null,null,null
2) 2,MyTab,null,4,MySubTab1,2
3) 2,MyTab,null,5,MySubTab2,2
4) 3,MyTab2,null,null,null,null
5) 4,MySubTab1,2,null,null,null
6) 5,MySubTab2,2,null,null,null

I want it to display like:
1) 1,MyName,null,null,null,null
2) 2,MyTab,null,null,null,null
3) 2,MyTab,null,5,MySubTab1,2
4) 2,MyTab,null,6,MySubTab2,2
5) 3,MyTab2,null,null,null,null

Any ideas? Hopefully I haven't confused anyone.
 

Read other answers
RELEVANCY SCORE 55.6

i have an old PSU that i've been using for probably a decade. It works fine and better than an EZCool 500w that was useless despite costing my ?50.

So the question is, i'm trying to unlock my Athlon2 X3 450 3.2Ghz using my Biostar a880g+ mainboard and it wont do it. Do you think upgrading the PSU is likely to help or did i just pull a short straw with the CPU and its not stable enough to unlock?

Cheers all, thanks for any advice

A:PSU Query

Your PS will have very little to do with overclocking your CPU. Sure some might argue stability issues, and like everything else in a system it could play a role, but if you have a good quality power supply, then that's not going to be the factor on whether you can overclock your CPU.

And based on your system specs, you really don't need much more than a 500/550 watt PS.

In short, if you can't overclock your CPU now, I highly doubt you'll be able to do so after upgrading the power supply.

My two cents.

Read other 9 answers
RELEVANCY SCORE 55.6
Q: Query

Windows 7 build 7601 this copy of windows is not genuine.how to make it genuine

Read other answers
RELEVANCY SCORE 55.6

There is a PC where I volunteer, that seems to have been tampered with, all the files that were on the PC are still there, but the Microsoft Office seems to have been reset and the AVG AV has gone.

Anybody have an idea on how this was done ?

A:PC Query

What do you mean the "MS Office was reset"? == Does the PC have a password so only a few can enter it? If so those would be the people to ask.

Read other 9 answers
RELEVANCY SCORE 55.6

Hey all
I need a little help understanding fan speeds with regards to the cpu, 1st of i understand that the hotter the cpu the faster and louder it will become, now if i can explain a little or at least try

some year ago or more i built my system, specs can bee seen in my profile,

I have not been 1 for using the over clocking software that came with my mobo (U_GURU), well not so long ago but since before the hot weather i noticed that my CPU fan was running rather loud well enough to annoy me anyway, I have always had the U-GURU software installed but like i say never really used it, it just was there.
ok so with the rather loud fan noise i decided to take a look and noted that the fan was running 3,600 RPM under idle and load with temps of around 30-40 oC(is this normal?) i also tried to enable cool and quiet but i got Overclocking failed from the U-guru util, well i wasn't asking it to Overclock just to turn on the damn cool and quiet option.....so WTF? well it activated and i left it but only for the system to freeze/crash some hour or 2 later, well anyway i thought maybe i need to unclog all the dust so pulled the side of ect but no dust build up in the heat sink but still blasted it with the airline regardless to still find that the fan was running quite noisy, well i asked around in some repair shops ect and got the usual rubbish about faulty ram ect (ROFLMAO) anyway i though ok ill remove the ram ect and see if out of chance they maybe rite, nope nothing changed.
i ... Read more

A:CPU Fan RPM query

well you got a hell of a result from that cooler i might have to look at that one myself

have you checked in your bios to make sure C1E and EIST are enabled? EIST in particular as this is related to the AMD cool and quiet software (C1E is Intels)

these options may not appear by default my motherboard for example requires me to tap F5 while booting into bios to display the advanced (overclocking) options

it seems your cpu fan is running flat out for some reason and im thinking the answer is in your bios , it could also be a faulty speed sensor on your motherboard (this seems unlikely as you can "hear" your fan is actually running fast) so maybe a faulty temp sensor?

have you tried "loading optimised defaults" in your bios?

uninstall your uguru software its always a good idea to things yourself

download and install real temp Real Temp - CPU temperature monitoring run the sensor test see if you have a stuck sensor , one of your cores maye me reporting a high temp keeping your fan running high

let us know how you get on , we can get to the bottom of this , ill probably think of some other stuff you can try if i do ill post ti up

Read other 5 answers
RELEVANCY SCORE 55.6

Hi Guys

I have a few computers connected to each other via a switch, the rough diagram of which is as follows:

Please help with answers with the following doubts:
I have enabled Internet sharing in PC1, which actually gets connected to the net via ADSL Modem. At present I am able to access from all PC's without a problem. Even if PC1 is not connected to the net, if I try to access the net from any other PC, PC1 automatically gets connected.
What I want to know is that is it possible to disconnect the internet connect from other PC's other than PC1.
As there are ways to switch off / restart / log off any PC in the network, is there a way to a PC to standby mode via some other PC on the network. I actually want to put PC1 to standby from PC2. Is it possible.
If I enable file sharing of any drive in any particular PC, all other PC's are able to access the files without any restrictions. Is there a way to set a password so that only the person with the correct password can see the files.
Please help.

Thank you.
 

A:LAN query!!!

Read other 6 answers
RELEVANCY SCORE 55.6
Q: query

I ask just recently about connecting three computers as a network and was informed that I should buy a router .
Which I did.
I've hard wired my computers to the router via ethenet cables and to my cable modem, The first couple of days all was fine, (my query isn't that it has busted) whenever we when o the net to watch a video stream or download anything the lights would flash whilst it happened,
however the modem is constantly flashing now. the router is a sweex wireless broadband, so it seems to me that some one has hijacked my system via the wireless, any ideas how I can turn it off ( the wireless part that is). as it is slowing up my system.
thanks
pavlos
 

A:query

you should be able to log into the router and disable the wireless, or if you want to use wireless enable the secruity encryption WPA

whats the nake and model of the router
 

Read other 3 answers
RELEVANCY SCORE 55.6

This is going to sound real dumb but I bought what I thought was 2GB of DDR form a US site for $20 now I should have read the ad a bit more carefully but whats done is done.

What I would like to know though is why does high density RAM not work the same as low density I always thought RAM was RAM except i knew you can't use the ECC stuff they use in servers in an ordinary machine.

The sticks I bought well were only chipped one side and I didn't realise what was going on until I found out what I had bought. Just seems odd to me to be selling high density sticks when it seems obvious to me that most people cannot use it.

A:A RAM query

This guide may help to explain some of the differences and problems people face when buying RAM. It's somewhat dated (doesn't talk about DDR3 or 204-pin laptop memory) but I think the basics are still valid.

eBay Guides - MythBUSTED Density Facts

Read other 4 answers
RELEVANCY SCORE 55.6
Q: query

can I install windows xp on my linux laptop

A:query

Yes you can. However, you'll lose your Linux. To run dual operating systems you need Windows on the 1st partition of the 1st hard drive. Windows followed by Linux.
If you let XP take all the drive, then Linux will automatically take the amount of disk it requires and leave Xp good. Linux will install a Boot manager. You then select which ever OS you want at Boot.
NB. After this install Xp will go to a Blue checkdisk screen, just let it run and all will be OK.

Read other 1 answers
RELEVANCY SCORE 55.6
Q: Query

I have a table of staff names who took inservice courses on different dates. I want to query the table to give me the names ofmall staff who took the inservice cours in January and not in March so I can have them take the course again
Any suggestions
 

RELEVANCY SCORE 55.6

Can't find a thread related so..

1. My new mail message to send opens in full screen and I cannot find a way of reducing it to a manageable size even on 21.5" it is ridiculous.

2. When I try to attach pics I get the photo album "version" how can I just attach a pic from my camera or saved pics as a dedicated file and not have this really irritating photo album keep coming up? I am beginning to find it getting very tiresome.

Any suggestions most welcome.

A:WLM query

  
Quote: Originally Posted by ICit2lol


Can't find a thread related so..

1. My new mail message to send opens in full screen and I cannot find a way of reducing it to a manageable size even on 21.5" it is ridiculous.

2. When I try to attach pics I get the photo album "version" how can I just attach a pic from my camera or saved pics as a dedicated file and not have this really irritating photo album keep coming up? I am beginning to find it getting very tiresome.

Any suggestions most welcome.


1) In WLM 2009 it is possible to make the double arrow appear at the right edge and bottom edge of the window and then drag those edges to make the window smaller.
2) Look for an "Insert" option or icon in the new mail window and select either "File as attachment" or "Image/Inline"; the inline option only works with the blinking cursor in the message body.

Read other 9 answers