Over 1 million tech questions and answers.

sql query

Q: sql query

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

RELEVANCY SCORE 200
Preferred Solution: sql 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: sql query

Read other 8 answers
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

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

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

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

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

I have the Doubt regarding on Hp X3500 wireless mouse ..Whether it is compatible with windows 10 n FREE DOS operating systems...Therefore, Kindly reply soon.Thank u

Read other 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

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 28

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

how to open windows batch file in windows7
 

A:query

Right-click -> Edit.
 

Read other 1 answers
RELEVANCY SCORE 28

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 28
Q: A query

does java jdk will be installed on windows7ultimate which has 32-bit has operating system

A:A query

  
Quote: Originally Posted by naveenkumar


does java jdk will be installed on windows7ultimate which has 32-bit has operating system



Excuse me. I dont understand the question.

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

A:Query

Can you post the specs of the rig you are working on?
&
Can you post a screen shot of Disk management?
http://www.sevenforums.com/tutorials...en-forums.html
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
RELEVANCY SCORE 28

I Need help to create a batch file to add users, groups, group memberships & passwords..? (for IT course)

So far I have managed..

Net User /add Bill.Smith [email protected] (save as bat)

e.g:

Users - Bill.Smith | Fred Bloggs | John.Blackmore
Passwords - [email protected]
Groups = Sales | Admin | Quality Control

Thanks
 

A:net.exe help with query..

Try net help user instead of net user /?
You'll get a lot more info.
Net User and Net Group will do what you want.

You can put the users and their groups into a text file and use a For loop to read the data and then run the net commands as needed

If your data file is formatted like this:
Bill.Smith, [email protected],Sales
Fred Bloggs,[email protected],Sales
John.Blackmore,[email protected],Quality Control

Read the file with this:

Code:
FOR /F "tokens=1-3 delims=," %%I In (data.txt) Do (
commands here
)
%%I will be the user name, %%J will be the password, and %%K will be the group name. As you have both user names and group names with spaces, don't forget to put quotes around the variables.
You can add other info as needed like FULLNAME, USERCOMMENT, etc. Just change the tokens= line to match the number of variables. If you need to use a comma in a comment, you'll need use something else to delimit the file. A tab can be used, but you can't copy and paste a tab (it gets converted to spaces) so be aware of that. Entering the data in a spreadsheet and then saving the file as a tab delimited text file works quite handy though.

Would be a good idea to first test if the group exists. If it doesn't you'd need to add it first. (Think pipe existing group list to Find with %%K as the search string)

HTH

Jerry
 

Read other 1 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

I am just wondering what programs are available that are like mac and ubuntu.

Here is what i am looking for:

Toolbar like mac and ubuntu have
Its like an interactive toolbar thing that you have on screen where you can place the icon for programs.
Mac and Ubuntu both have them i think.

Hope you know what i mean.

If you do could you suggest any free programs i could use as they look cool.

Also, are there any disadvantages to this??

Thanks
 

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

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

Read other 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

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

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 28

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

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

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

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

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

Read other answers
RELEVANCY SCORE 28

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 28

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.

Cheers,

jtscott99
 

A:SQL query Help Please

Read other 10 answers
RELEVANCY SCORE 28

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 28

hi guys, i have a Laptop that has 256mb of ram. now i have just downloaded the public release of windows vista and i am trying to install it.

the setup demands that i need 256mb of ram which i already have and exits. now when i go on system properties, it says i have 244mb of ram. why is this and is there any way i can make this 256mb?

thanks

Ricky
 

A:RAM query

you may have memory allocated for video - although 12MB seems a little low - but that may be the min
 

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