Over 1 million tech questions and answers.

Query re POP Vs EMAP

Q: Query re POP Vs EMAP

At the moment I quite like the fact that mail items that I discard/delete from my Outlook account ane still available on my Gmail account. This is automatic as I currently have the account set as POP. As I would like to access my Outlook account from my lap taop whilst I am away I understand I could do this by registering the Gmail account as IMAP but I inderstand that anything I delete from my outlook account would also get deleted from my Gmail account.........Is this correct, or is there a way of deleting items from Outlook but retaining hem oon the Gmail server.

Any help would be appreciated

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Query re POP Vs EMAP

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

RELEVANCY SCORE 47.2

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 46

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 40

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 40

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 38.8

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 38.8

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 38.8

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 38.8

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 37.6

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 37.6

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 37.6

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

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 del... Read more

Read other 8 answers
RELEVANCY SCORE 34.8

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 28

My new SSD is plugged into the one of the 6Gb/s sockets on my motherboard. I?ve been reading other posts here regarding NOT using the marvell controller for the SSD. My drive?s performance is no where near the quoted figures. How do I NOT use the Marvell controller when my drive is plugged into the socket. What other controller is there to use. I?m confused. Asus P6X58D-E motherboard Intel Quad Core i7 950 Crucial M4 128GB SSD Thanks

A:Query regarding SSD

Do you have any other 6GB ports?

And with the performance nums you have to be careful. The advertised ratings are at maximum blocksize which the system never uses. Run Atto and post the results. Then we can have a look. http://www.techpowerup.com/downloads/1749/ATTO%20Disk%20Benchmark%20v2.46.html

Read other 7 answers
RELEVANCY SCORE 28

Hi Guy's
hopefully somebody can answer my query.... I have a memory (RAM) question.
Currently have a PC with 3Gb of RAM installed, 2 Hdds.... XP Pro & Vista H Premium, dont use the Vista option very often..my query is.... the 3Gb is recognised as being 3Gb, I have just purchased another 2Gb stick & removed the 1Gb so now I have 4Gb however the PC only recognises 2.50Gb in both XP & Vista? tried both sticks on there own both show as being 2Gb

Motherboard Max Capacity: 4096
Memory Slots: 2

Both sticks 400MHz DDR2 800

Any advice

A:Ram Query Xp Pro Sp3

Hello frazzeld,

From what I understand, Vista uses a portion of memory to perform other functions. This ammount is then discounted from the total.
With XP, do you have intergrated graphics? If so you may find that the graphics is using some of the RAM.

Read other 3 answers
RELEVANCY SCORE 28
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 28
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 28

According to my device manager I have one USB 2 port and 4 USB 1 ( I presume), is there a way to find which is the USB 2 port. For instance will one be marked as such or is it trial and error to find the faster port.

A:USB query

This Wikipedia website might help you.

https://en.wikipedia.org/wiki/USB#Colors

Read other 4 answers
RELEVANCY SCORE 28

I have 512 Mb ddr ram but this registers on analysis as showing only 478 MB. Does this mean that some faulty areas have developed? The system still generally performs well.(XP)
The only other issue which I think might be connected is that occasionally the display goes haywire with icons changing places and the taskbar moving around. I sometimes cannot regain control at all as the mouse control is also lost.
This usually happens if I am trying to multi-task quite hard with several windows open at the same time. Am I overloading the system or does the loss of control mean the possible faulty RAM is causing the problem?
many thanks for any ideas.
James
 

A:RAM query

Read other 9 answers
RELEVANCY SCORE 28

right so I have the worst internet (300kbs max when downloading as well as a download limit) so downloading games etc is a nightmare. I had a think and came up with a plan but I'm not 100% sure itl work. The plan was to buy an internal ssd (samsung evo 850 500gb) as well as a usb to sata adapter. While I'm away from home with a better internet connection I would download games, apps etc theough my laptop onto the ssd and then when I'm nack home id connect the ssd to my desktop and run the games and apps from it. The thing I'm not sure about is whether the pc will have difficulties with follwing/finding the paths?

Sorry for the paragraph and thanks for reading

Sent from my CUBOT CHEETAH 2 using Tapatalk
 

A:SSD query

You may have to install the games onto your Desktop PC's hard drive before you can run them but apart from that extra step your plan should work.
 

Read other 3 answers
RELEVANCY SCORE 28

According to my device manager I have one USB 2 port and 4 USB 1 ( I presume), is there a way to find which is the USB 2 port. For instance will one be marked as such or is it trial and error to find the faster port.

Read other answers
RELEVANCY SCORE 28
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 28
Q: Query

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

Read other answers
RELEVANCY SCORE 28

I have noticed in the last days in start/msconfig/services/AVG Antispyware Guard is enabled (it is ticked) but is showing 'stopped'. I go into start/controlpanel/administrave tools/Event viewer and restart it, but each time I shutdown then reboot it is again stopped.
I have never noticed this before - Could there be an answer to this little problem please?

Kind regards,
 

A:AVG Query please?

Are you using the licensed version of this program? If you are not then this is one of the two options that are killed after a month.. The program works just fine you just have to update it manually and the back ground scanning no longer functions. I normally turn both of these off when I install it for some one anyways.
 

Read other 3 answers
RELEVANCY SCORE 28

can a 5"14 diskette be used as a boot disk? (you know, the primitive ones)
 

A:????Query????

Yes, provided it is set up as the A drive. Most floppy cables have two connection positions, one for A and the other for B. The A position is at the end of the cable and has a few wires that are separated and twisted at the end. The B position is between where the floppy cable connects to the main board and the other end.

You cannot boot from B, only A.

Most 5.25" drives have a connector very different from the one on the 3.5". You'll need a floppy cable that has both styles on it. These are usually found on older systems. I have noticed that no new boards are shipped with the dual-style floppy cable connectors.
 

Read other 2 answers
RELEVANCY SCORE 28
Q: Query

Does anyone know what this is ... "Se00bldsv" ?
I found it listed in services under Administrative tools. ( XP Home SP 2)
It is disabled ... but when I googled it I did not get any hits.

bob

A:Query

Definitely looks suspicious to me...I can't find anything about it either. What does it give for a description in "services"?

Read other 1 answers
RELEVANCY SCORE 28

Hi,
I hava table iwth the following data:
NAME REGION AREA POPULATION GDP
Albania Europe 28728 32000 66500
Algeria Africa 140000 8600 8500
Belgium Europe 30528 29000 60900
Benin Africa 11262 6000 3630
Chad Africa 38000 7200 4600
Mexico NorthAmerica 68000 25500 38000
Italy Europe 31200 38500 68000

Now Im trying to find out the regions having total populations less than 30000.
Could anyone help me out with this??
 

A:sql query

Read other 8 answers
RELEVANCY SCORE 28

I have an acer computer and wondered if anyone knows how to activate the option of ...'reopen last browser session' under the 'tools' option? It was highlighted yesterday and now it's now allowing me to do this. Please help? thanks
 

Read other answers
RELEVANCY SCORE 28
Q: Query

I have just loaded Windows 95 the board is chaintech 7AJAO
I am getting a message '?' in Devices Manager as PCI Bridge,
could someone explain please
 

A:Query

Hi,

Do you know what year this MB was launched?
There's a possibility that Win95 doesn't have driver for it.

TJ
 

Read other 3 answers
RELEVANCY SCORE 28

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 28

does anyone know how , please can you let me know thans..
 

A:help with query!

sam5577 said:

does anyone know how , please can you let me know thans..Click to expand...

I would suggest that you Google
 

Read other 2 answers
RELEVANCY SCORE 28
Q: query

Hi I was wondering if you could please provide me with some answers.

I recently clicked on a website unsuitable for work when searching for "the worlds most amazing places" when looking for holidays for the summer, after seeing the unsuitable page name in the url, i immediately clicked off it to prevent the page from loading, the page had not opened at this page and i managed to get off it in time.

my questions are these,

i checked my history immediately afterwards and the page was not shown there, is this because i clicked off it in time???

also if a page does not load does that mean that you have not visited it and if a page did not show in my history will it also not show in my works records.

Also is there any sort of programme to stop these sort of website s being included in internet searches

thanking you for your reply in advance
 

Read other answers
RELEVANCY SCORE 28

I have a table full of salutations (Mr., Ms., The Rev., Dr.) and a table where I'm storing user input from a PHP web form. In a PHP file I have a query that pulls the salutations from their table and spits them out into a drop-down box:

<?php
$query = "SELECT * FROM Salutation";
$result = odbc_exec($_SERVER['connection'], $query)
or die ("Error in query: ".odbc_errormsg());
print "<select name='PatientSalutation'>";
print "<option>--Select Salutation--</option>";
while ($row = odbc_fetch_array($result))
{
$opt = $row["SalutationKey"];
print("<option value=$opt>");
print $opt;
print("</option>");
}
print "<option>".null."</option>";
print "</select>";
?>

When the form is submitted, the information that has been collected is sent back to the same file. At the top there is a statement that writes the user information to the database:

<?php
$query1 =
"INSERT INTO PatientDemographicsAlpha(PatientSalutation, FirstName, MiddleName,
LastName, PatientSuffix, InfoPacket)
VALUES ('$PatientSalutation', '$FirstName', '$MiddleName', '$LastName', '$PatientSuffix',
'$InfoPacket')";

$result1 = odbc_exec($_SERVER['connection'], $query1)
or die ("Error in query: ".odbc_errormsg());
print "Data has been inserted.&qu... Read more

A:SQL Query help!

Ok, I solved it.

In the WHILE statement replace the print("<option value=$opt>"); with this:

print("<option value=\"$opt\">");

Much better.
 

Read other 1 answers
RELEVANCY SCORE 28

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 28

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 28

Guys I have [email protected] of ram + [email protected]

Because I have the 256mb sticks of ram installed and they can only go to 533mhz my computer puts my gig sticks at the same freq. I was wondering if i should take out the two 256mb sticks out and leave the two sticks of 1gig ram in so they can run at 677mhz. Just wondering if this would be faster than having them all running at 533.

Thx

 

A:RAM query

it probably will.
 

Read other 2 answers
RELEVANCY SCORE 28

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
RELEVANCY SCORE 28

Greetings !

I am planning to build a new system, the configurations are quite clear with :

1.core2duo 6600
2.2gb 800 mhz ram (1gb ea)
3.sata2 160 gb etc.
4.nvidia 8600 gt or the 8800 gs

My machine will be used for medium gaming, movies etc

Now my question is about the motherboard, my dealer has recommended the Asus p5ne-sli, i am getting at a good price.
I have some questions about the sli board which i hope you will help me with :

1. I don't intend to buy a second graphics card and wish to have only a single hi performance card , will the board give me good performance with a single card ?

2. Is it better to buy a non sli board ie will it function better in games , since i am using only a single graphics card ?

3. Due to the sli I have to buy an expensive power supply is it worth it ?

4. Are the graphic chipset on the sli mboard only to enhance the performance of dual cards or even a single one ?

5.What other mb chipset would you recommend for my config ? Is the asus P5b dlx more superior than the P5ne sli for my present config. ?

6. Do you recommend an intel board over asus for core2duo in stability and performance?

Basically I just don't want to buy a board whose sli feature I will not be using and if u say so ................ !

Thank you

faiz
 

A:SLI query

Read other 12 answers
RELEVANCY SCORE 28
Q: Query

Hi there, newbie here.
See attached scree shot.
Question is how do I bypass this page to get into my files?

A:Query

Hi,
Thank you for writing to us!
Unfortunately the screenshot has not been attached. Kindly private message the issue also with the service tag and email address.
Thanks
Robin

Read other 1 answers
RELEVANCY SCORE 28

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 28
Q: Query

hi every body,

I Have windows 7 ultimate running on 1.5 gb ram,320 gb(4 partitions) westerndigitals HDD(on INTEL D915GAV motherboard).

Its been a month i installed win7 ultimate.I hadnt installed anything on C: drive which is of 60gb capacity.But the free space is decreasing day after day,its almost 46gb now.Since ive not installed anything into c why is the space being decreased?I know there are automatic updates installed regularly,but i am sure those few mbs files are not capable of taking GBs of space on C.Ive even cleaned disk and deleted restore points,but after cleaning it only free few MBs of space.What is happening here, its utilizing more and more GBs of space and when i use disk clean tool,it only free few MBs.Im terrified if the disk space goes on decreasing like this,in few months time the disk is going to be full even if i dont put anything there by myself.Plz can anyone make clear,what is happening here with my win7?

A:Query

Hello,

Try using a disk mapping program like Windirstat to see where your space is going.

~JK

Read other 9 answers
RELEVANCY SCORE 28

Does anyone know how to write a DB2 query to list all stored procedures in a DB2 database?
 

A:DB2 Query

Read other 6 answers
RELEVANCY SCORE 28

Hi everyone,

I have a query that I use on a report. I need to check on the request date and if there is no requested date, then I want to print "ASAP".

on my query i have this:

=IIf(IsNull([Req'd]),"ASAP",[Req'd])
But i keep getting #Error.

Can someone help me please.!!!!
THANKS.
 

A:Help With A Query

Read other 6 answers
RELEVANCY SCORE 28
Q: Query

I am wondering if there is any way from where we can make a setup CD from the running operating system that is already installed on our PC.
 
Thanx in advance.

A:Query

The only way I know of is with Sysprep.
 
It is possible to make a system image also, but it only works on the same machine...

Read other 3 answers
RELEVANCY SCORE 28
Q: Query

Hi there,
Any idea how i bypass this message, see attached screenshot.
Thanks for any help.
Peter.

A:Query

Also how do I attach screenshot? Thanks

Read other 1 answers
RELEVANCY SCORE 28
Q: query

I have the follow showing using winpatrol in services that I can not disable. As far as I know it is for XP and not W7.
Does anyone have any ideas about this.? Thanks for any info.

C:\WINDOWS\SYSTEM32\UMPNPMGR.DLL

A:query

Download Autoruns for Windows: http://technet.microsoft.com/en-us/sysinte...s/bb963902.aspxNo installation required.Simply unzip Autoruns.zip file, and double click on autoruns.exe file to run the program.Go File>Save, and save it as AutoRuns.txt file to know location.You must select Text from drop-down menu as a file type: Attach the file to your next reply.Compliments of BroniThen:We need to know more about your BSODs...Download BlueScreenView (in Zip file)No installation required.Unzip downloaded file and double click on BlueScreenView.exe file to run the program and When scanning is done, go to Edit > Select All.Then go to File > Save Selected Items, and save the report as BSOD.txt.Open BSOD.txt in Notepad, copy all content, and paste it into your next reply.Compliments of Broni

Read other 15 answers