Over 1 million tech questions and answers.

Query, Query Searching Blank Matches

Q: Query, Query Searching Blank Matches

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
The query will not find the record only containing Norris
Here is the query I have used.
Like "*" & [Forms]![Entry]![txtSurname] & "*"

Preferred Solution: Query, Query Searching Blank Matches

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, Query Searching Blank Matches

Read other 8 answers

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

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.


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


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


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


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


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

I want to do a query linking 2 tables. In one I will know exactly what text is in the requisite field. I then want to query the other table to find the field with a name that matches the text in the first table, so I can edit the value it contains. Can I do this?

A:Access--query searching for field name??

Read other 12 answers

I'm trying to locate some photos that somehow got misfiled.  I never renamed them so they have the camera default name which is no help.  I know they were downloaded in May.  That's the only thing I'm sure of.  I understand syntax searching can be used with boolean logic, but the MS Search tool sux and the MS information has nada that I can easily find.
What I need to run is find (*.jpg or *.RAW) and date is between 5/13/2014 and 5/31/2014.
How do I structure my search?

A:need help advanced boolean searching query syntax

Camera default names are commonly sequential, things like DSC_1234 where '1234' represents a sequential series of 4 digits - 0001, 0002, 0003 and so on.  If you can locate pix taken with the same camera on 5/13 and on 5/31 that will give you a range of file names to search for.  The numbers begin over at 0001 after reaching 9999 but unless you are a busy professional that's not likely to happen within 3 weeks.
You could also sort by file date, or by date taken, which would at least make scanning each folder very quick.
Neither of these brute-force suggestions address Boolean searching, so might not be too helpful if you have professional-sized archives . . .

Read other 2 answers

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

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?

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

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


A:Calculated field in a query based on a query

Read other 7 answers

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.


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

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

Is there a way to force an Access query to display a blank column with a header WITHOUT asking the user to input a value for that blank column? I suspect not, but thought I'd ask anyway.

A:Solved: Put blank expression in query

This works, enter a new column heading
Test: ""
You could also create a table with a single field with no data and join it to the query table.

Can I ask why you would want to?

Read other 2 answers

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

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?!?!?!)


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

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

I'm using ms access 2003 and i created a table that tracks safety violations at work. I have a column that allows me to select from a couple different statuses. I have 3, Corrected, not corrected, and void. I am trying to query the table so that i can see the complaints that are either marked not corrected, or have not been looked at yet and so the status is blank. So i need a query for "not corrected" and "blank". I'm new to visual basic and the coding that goes with it. Can someone please help me. Thanks.

A:Solved: how to query a blank table or list

Read other 7 answers

I have a query that has a couple of text fields where in the criteria I put <>"Power". When I put this criteria in, it also does not show me records that the field is blank. If I leave the criteria empty, it shows me all records including the records with the blank fields. How do I get the query to exclude the criteria Power but still show records where that field is blank?

A:MS Access Query not returning blank fields

Read other 16 answers

Hi guys,

just a quick question. I have created a database that allows me to keep track of all the purchases i make each month.(i work out of country and need to provide budget sheets each month) So, instead of filling in everything on a exel sheet we have created i thought i will create an access sheet that allows me to do all this. I have tried creating multiple tables(Payments from company a, payments from company b and then invoices) but to no success as none of them can be linked to one another for my final report (they have no field in common) Now, i have created one table with all the fields i need overall but, when i run a query on a specific companies payments, it comes up blank. how do i fix this? i need a report at the end of the month that shows all the invoices for a specific company along with their payments to compare income and outcome. how do i accomplish this? Also, bare in mind that i am a noob at access and everything i hve learned comes from the internet so access specific terms will have no meaning to me.

Any help would be greatly appreciated

A:Solved: Access database query coming up blank

Welcome to the Forum.
What version of Access are you using?

Access is a "Relational Database" system so the Tables that you create have to be related for it to work.
Ideally the tables would be set up something like this.
Company Products (for choosing to go your Invoices, so prices would probably be included).
Invoices. This table would only hold an invoice number and it's date plus the Company ID if it is a one invoice to one company system.
Invoice details, holding ProductIDs and Quantities.

If you want to set it up in that way let me know and I will assist you.

However back to your current problem, if you only have one table and a query it should show all the data in the table, so how are choosing a Company?

Read other 14 answers

Hi, Thanks for allowing me to join the Lenovo forum.Upon doing a cursory search, I haven't yet found a solution, so here goes.  Need to install Windows 10 from scratch to a newly formatted, newly installedblank physical drive in a X131e Model 3371A43, Type 3371.My first attempt failed, so I should start over. I have on hand Windows 10 installation DVD on USB DVDBlank 750 gig drive mounted internal, formatted NTFS(or I can remove it and format it to FAT or FAT Ex via another computer if need be.) I have the following softwares pre-downloaded and on a USB-drive.in case 1 or more of these need to be somehow installed ahead of the windows 10 install.DriverToolkitInstaller.exeDriversDownloader_for_hmsm01ww.exesif11ww130.exesystemupdate5.07.0065.exe79oi30ww.exe79oi34ww.exeh4ds01ww.exeh4ic03ww.exehmsm01ww.exeh4mf05ww.exeh4id03ww.exeg8uj28us.exedriveridentifier_setup.exetp_x131e_wb64_201402.exesystemupdate5.07.0065.exeDriverNavigator_Setup.exe I'm not even close to being a windows expert, so I'll much appreciate beingpointed the right way or given the steps to perform install to theX131e's new blank internal drive. Thank you very much. 

Read other answers

I have Access 2007

I have tried to find the answer to this, but i have not found a simple answer. I have created a family business database ( i must state i am new to access) which works ok. I now want to run some queries but when i do they come back as blank fields. I guess its something to do with Relationships and Join Types, which i admit i dont fully understand Join Types

So not to mess up my database i created a simple 4 table database Table1, Table2, Table3 & Call.

I want to create a query from Call Table and add a field from each table Table1(LastName), Table2 (property), Table3(status). I will then set criteria on Status "Completed"

I suppose i need help on the correct way to join these tables together so the query works. Or you may say its something else.

Its probably something simple to someone.


A:Access 2007 Query returns blank results

Read other 12 answers

Hey I can't get windows 7 to return partial matches when it searches.

Like I have a file 31313131.avi and I try to search for it in a folder and type "31" to search to find it quickly but it doesn't show up.

How can I get it so it shows up?


A:Searching Partial Matches

What happens if you type .avi in the start search box?

Read other 9 answers

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

Hi all

Nub here

i have been hacking up a sheet that has a lot of hidden rows and collated data, i am trying to count events that totaled as "0" whilst ignoring blank cells with in hidden rows,

i just found an answer from bombs that got me a bit closer i think but i still cant resolve this one, it looks ok till i go to total a section of the column and it gets all the hidden empty cells

a column of cells with =IF(R530 = 0,1,0)
but the whole row of hidden cells gets marked as 1 so when i run a simple total i get my range of 12 or so + 2900 odd spare from the hidden cells

A:Solved: XL query counting cells with 0 while ignoring blank cells

Read other 6 answers

I'm trying to get a list of purchases made by customers from a single purchases table. Normally this would be easy, but I only want to return their most recent purchase based on the ID of the record. If possible I would like to keep this to a single query, and not to have to write any stored procedures and the database is running on MSSQL 7.0.
Any help would be most appreciated.



A:SQL query Help Please

Read other 10 answers
Q: query

what is the best disc you can reccomend for backing up my vista

Read other answers
Q: query

Respected sir,

Last week my pc was attacked by help_decrypt virus & i was using win xp sp3, now i hd already cleaned that virus & i hd manually removed help_decrypt files,then i hd install win 7 & i hd aleardy taken backup but the problem is that i cant open any files like doc ,docx video files, jpg files in win7 so is there any problem that it can be open in win 7 as it was earlier win xp sp3 operating system & now win 7?

So my doubt is this is the problem that i cant open winxp sp3 files in win 7 or help_decrypt virus has vanished my entire files & folder. i hd lost entire data.

Sir if u help me out to this problem ur action will be highly appreciating.

Thanking u & awaiting ur fav reply soon.

Read other answers

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:

But i keep getting #Error.

Can someone help me please.!!!!

A:Help With A Query

Read other 6 answers
Q: query

can I install windows xp on my linux laptop


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

Sir I have a problem with my built-in webcam and it doesn't work already, but before it does work. When I used it in Skype I can't see the person I'm talking to and that person can't see me as well, I tried using my webcam in facebook and the problem was I can see the person I'm talking to but the person ca't see me. I tried to check my software and webcam status at the system told me that all is working just fine and I have the latest driver installed for my webcam. Hope you can help me ASAP. . Thanks in advance.Here's the specs:

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 7 Ultimate, Service Pack 1, 64 bit
Processor: Intel(R) Pentium(R) CPU B950 @ 2.10GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 2
RAM: 1961 Mb
Graphics Card: NVIDIA GeForce GT 520MX, 1023 Mb
Hard Drives: C: Total - 259999 MB, Free - 56484 MB; D: Total - 350377 MB, Free - 41507 MB;
Motherboard: SAMSUNG ELECTRONICS CO., LTD., 300V3Z/300V4Z/300V5Z
Antivirus: Avira Antivirus, Disabled


howdy and welcome, I've removed your email address as posting that in a public forum is an excellent way to get on spam lists.



Read other 2 answers
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 ???


Hi folks,

Can anyone tell me if it's possible for multiple users to edit & save an excel spreadsheets over a VPN conection.

I have enabled sharing of the sheet but the data does not merge, the ammendments remain unique to the individual users machines.

Any advice greatly appreciated.

A:VPN Query

Sorted it!

Read other 1 answers

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


A:SLI query

Read other 12 answers
Q: Query


I was wondering whether it is possible to take a Intel Pentium 4 processor from one computer and put it into a another?
When I looked at the processor there did not seem to be anyway of taking it out?

Is it possible and if so is there a walkthrough as to how to do it?



Please provide the details of the processor. What socket does it use?

If both the PC has same motherboard configuration then it would be fine to transfer it to another. You can refer to the manual you may have got with your processor. Let me know if you have it.

Read other 4 answers

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


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

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

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,

Read other 3 answers

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.

A:RAM query

Read other 9 answers

I am testing SUS on an XP SP2 PC. The registry settings download the updates
to the PC from the server but they do not install. Why is this. The registry
settings I used are below. Thanks for any replies.



Read other answers

I hava table iwth the following data:
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

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

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

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

pulling hair out over this one. my table is like this:

food_item, action, condiment_or_basetype

and typical data would be:

hamburger_1, info, Basic
hamburger_1, add, pickles
hamburger_1, add, ketchup
hamburger_2, info, Tasty Burger 2000
hamburger_3, info, Tasty Burger 2003
hamburger_3, add, extra_onions

And I want to run a query that displays the number of changes required (from the base burger) for each order:

hamburger_1, 2 ' 2 changes
hamburger_2, 0 ' no changes
hamburger_3, 1 ' one change

Please help... (no I don't work at McDonalds)

A:T-SQL query help

When I use a group by clause, I lose the orders that don't require any alterations:

select food_item, count(*) from orders where action='add' or action='remove' group by food_item

hamburger_1, 2
hamburger_3, 1

I'm trying to do the equivalent of:

select * from orders where food_item='X' and action <> 'info'

...but within a single query. (This one returns 0 changes for food_item 'X' that has no alterations).

Read other 1 answers

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.


Read other 4 answers

Looking for someone with significant knowledge of PXE boot OS installations. Trying to learn to perform this taskt with a spare laptop, Vista Ultimate desktop and a Linksys router. Information is difficult to find.

Read other answers

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

Have a friend who bought a used machine for his young teenage son that I think is dodgy - bought it as seen from one of his wife's work mates.

I suspect the 7 he has is not an entirely genuine one as the machine was originally a Vista one and there is no MBR (I think the HDD has been scrubbed or replaced)and I can find no way of factory defaulting it -I've tried numerous ways but nothing.

The only thing I have is the OEM Product ID in "System" and I don't want to go checking too deeply as obviously as I don't want to get him into strife, as he is not computer savvy - nor am I for that matter but I can spot something not quite right like this puppy.

I did find some cookies of porn sites on it that I cannot get rid of - ideas?? I can clear them with CC but if one uninstalls and reinstalls the CC the cookies come back!


Can you post the specs of the rig you are working on?
Can you post a screen shot of Disk management?
Screenshot tools.
A Preferred Method of Uploading/Posting Screen Shots
How to Use the Snipping Tool in Vista - Vista Forums
Snipping Tool - Windows 7 features - Microsoft Windows
Use Snipping Tool to capture screen shots
Screenshot with Paint
Screenshot and Upload using MWSnap
fscapture free download

Use Snipping Tool to capture screen shots

Read other 9 answers