Just double checking to be sure: Did you remove the AC power plug before trying the CMOS resets? If not, try them again.INT Graphics should have been internal graphics which should have worked with the motherboard's graphics ports unless you happen to be using a DVI to VGA adapter which only works oRead more
Just double checking to be sure: Did you remove the AC power plug before trying the CMOS resets? If not, try them again.
INT Graphics should have been internal graphics which should have worked with the motherboard’s graphics ports unless you happen to be using a DVI to VGA adapter which only works on DVI-I ports and not on DVI-D ports which do not support the feature.
Is is possible that you changed the settings from PCIe 16X to plain old PCI? This would require a PCI graphics card to get any signal. Of course, the reset should have changed it back to factory defaults as far as the graphics are concerned so after that, one or the other of the graphics ports should be supported.
Last thought: If you are using display port or HDMI ports, try the VGA or DVI ports to see if that makes a difference.
You have to be a little bit crazy to keep you from going insane.
First, a posting tip:If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done. To mRead more
First, a posting tip:
If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done. To make it easier for us to understand the layout of your data, it should look like this:
A B C
1 Last Name First Name ID
2 Johnson Michael johnsmi01
OK, the easy part is the creation of the basic string e.g. johnsmi01. The harder part is dealing with the duplicates.
This will get you your basic string:
=LOWER(LEFT(A2,5) & LEFT(B2,2)) & “01”
The LEFT function extracts the specified number of characters from the referenced cell. The Concatenation operator (&) combines the results of the functions into one string. The LOWER function converts all letters to lower case.
However, you need to increment the digit at the end to account for duplicates, triplicates, etc. One method for doing that is to use a Helper Column so that you can count how many times any given “partial ID” (e.g. johnsmi) occurs.
Note: This method will work for up to 9 occurrences of a partial ID. If you will have more than 9, then things get a little more complicated, but it can still be done. Let us know if you need more than 9.
OK, so let’s say you have the set up described above. You need to create a Helper Column, which you can then hide so that it doesn’t show. I’ll use Column A, but you can use any unused column that you want, the concept is the same.
1 – Insert a new Column A. this will move your names to Columns B & C 2 – Place this formula in A2 and drag it down:
=LOWER(LEFT(B2,5)&LEFT;(C2,2))&”0″
This will give you your partial ID without the final digit, e.g. johnsmi0
3 – In D2, enter this formula and drag it down:
=A2&COUNTIF;($A$2:A2,A2)
Note the placement of the two $, they are required to lock the beginning of the range that we are counting.
This will pickup the partial ID in Column A and append a digit representing the number of times that partial ID appears in Column A.
Although there are several straight talk hotspots (going on that premise, because its in your specs) I would say the easiest way is to go to the ip address of the unit Enter 192.168.1.1 in the browser’s address bar.default loginuser name is adminpassword is 12$(last three of pin, on your activationRead more
Although there are several straight talk hotspots (going on that premise, because its in your specs) I would say the easiest way is to go to the ip address of the unit
Enter 192.168.1.1 in the browser’s address bar.
default login user name is admin password is 12$(last three of pin, on your activation card) for example if your pin is 123456 your password is 12$456
from there you should have options to change things.
This presumes that you have already set up the hot spot and not changed any password.
Go to game directory and find this file "config.cfg" the back up the file(paste it in another location).Open the file with notepad and find seta "r_ImageQuality 1" and the value from 1 to 0 save and start the game then check the image quality setting in game settings.Don't use crack from another groRead more
Go to game directory and find this file “config.cfg” the back up the file(paste it in another location). Open the file with notepad and find seta “r_ImageQuality 1” and the value from 1 to 0 save and start the game then check the image quality setting in game settings. Don’t use crack from another group.
You know the real meaning of peace only if you have been through the war.
"What do I have to do to get past this message on Windows 98?"You actually have TOO much memory. Set the Win98 guest memory allocation to less than 512MB.
“What do I have to do to get past this message on Windows 98?”
You actually have TOO much memory. Set the Win98 guest memory allocation to less than 512MB.
You listed your system specs but left out the most important item - the PSU. What is the make/model/wattage & amperage specs?"I shall remove the battery to clear the CMOS tonight hopefully"You don't need to remove the battery, just use the CLR_CMOS jumper (that's why it's there). I've seen postsRead more
You listed your system specs but left out the most important item – the PSU. What is the make/model/wattage & amperage specs?
“I shall remove the battery to clear the CMOS tonight hopefully”
You don’t need to remove the battery, just use the CLR_CMOS jumper (that’s why it’s there). I’ve seen posts where some people take the battery out & leave it out overnite to make sure the BIOS clears – it only takes a couple of second to clear, not minutes or hours. Just make sure the power cord is unplugged because the PSU standby power can prevent the BIOS from resetting.
From your motherboard manual:
• To clear the CMOS values, use a metal object like a screwdriver to touch the two pins for a few seconds. • Always turn off your computer and unplug the power cord from the power outlet before clearing the CMOS values.
Certainly not a pen drive as they are not reliable enough and are therefore only suitable for short-term storage.DVD media is the best option.The number of pics you have is not the real issue, it's their total size in megabytes which will determine how many blank DVDs you will need, but for argumentRead more
Certainly not a pen drive as they are not reliable enough and are therefore only suitable for short-term storage.
DVD media is the best option.
The number of pics you have is not the real issue, it’s their total size in megabytes which will determine how many blank DVDs you will need, but for arguments sake let’s say each JPEG file is 500 kilobytes:
500 Kb x 4000 = 2,000,000 Kb = 1,954 MB = 1.9 GB
In the above example, your 4000 pics will easily fit on a single-layer 4 GB DVD.
No, it's possible with IE. Consider the following VBScript:For Each w In CreateObject("Shell.Application").Windows If InStr(1, w.LocationURL, "google", 1) Then _ w.Quit() Next 'wHow To Ask Questions The Smart Way
No, it’s possible with IE. Consider the following VBScript:
For Each w In CreateObject("Shell.Application").Windows
If InStr(1, w.LocationURL, "google", 1) Then _
w.Quit()
Next 'w
Changed Bios Video Settings–Now No display
Just double checking to be sure: Did you remove the AC power plug before trying the CMOS resets? If not, try them again.INT Graphics should have been internal graphics which should have worked with the motherboard's graphics ports unless you happen to be using a DVI to VGA adapter which only works oRead more
INT Graphics should have been internal graphics which should have worked with the motherboard’s graphics ports unless you happen to be using a DVI to VGA adapter which only works on DVI-I ports and not on DVI-D ports which do not support the feature.
Is is possible that you changed the settings from PCIe 16X to plain old PCI? This would require a PCI graphics card to get any signal. Of course, the reset should have changed it back to factory defaults as far as the graphics are concerned so after that, one or the other of the graphics ports should be supported.
Last thought: If you are using display port or HDMI ports, try the VGA or DVI ports to see if that makes a difference.
You have to be a little bit crazy to keep you from going insane.
Solved Combining Partial Text From 2 Or More Cells In Excel
First, a posting tip:If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done. To mRead more
If you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done. To make it easier for us to understand the layout of your data, it should look like this:
OK, the easy part is the creation of the basic string e.g. johnsmi01. The harder part is dealing with the duplicates.
This will get you your basic string:
=LOWER(LEFT(A2,5) & LEFT(B2,2)) & “01”
The LEFT function extracts the specified number of characters from the referenced cell. The Concatenation operator (&) combines the results of the functions into one string. The LOWER function converts all letters to lower case.
However, you need to increment the digit at the end to account for duplicates, triplicates, etc. One method for doing that is to use a Helper Column so that you can count how many times any given “partial ID” (e.g. johnsmi) occurs.
Note: This method will work for up to 9 occurrences of a partial ID. If you will have more than 9, then things get a little more complicated, but it can still be done. Let us know if you need more than 9.
OK, so let’s say you have the set up described above. You need to create a Helper Column, which you can then hide so that it doesn’t show. I’ll use Column A, but you can use any unused column that you want, the concept is the same.
1 – Insert a new Column A. this will move your names to Columns B & C
2 – Place this formula in A2 and drag it down:
=LOWER(LEFT(B2,5)&LEFT;(C2,2))&”0″
This will give you your partial ID without the final digit, e.g. johnsmi0
3 – In D2, enter this formula and drag it down:
=A2&COUNTIF;($A$2:A2,A2)
Note the placement of the two $, they are required to lock the beginning of the range that we are counting.
This will pickup the partial ID in Column A and append a digit representing the number of times that partial ID appears in Column A.
Let us know if you have any questions.
Click Here Before Posting Data or VBA Code —> How To Post Data or Code.
Solved How Do I Retrieve Message Showing On My Hotspot Device?
Although there are several straight talk hotspots (going on that premise, because its in your specs) I would say the easiest way is to go to the ip address of the unit Enter 192.168.1.1 in the browser’s address bar.default loginuser name is adminpassword is 12$(last three of pin, on your activationRead more
Enter 192.168.1.1 in the browser’s address bar.
default login
user name is admin
password is 12$(last three of pin, on your activation card)
for example if your pin is 123456 your password is 12$456
from there you should have options to change things.
This presumes that you have already set up the hot spot and not changed any password.
::mike
Solved Modern Warfare 3 Blurry Graphics
Go to game directory and find this file "config.cfg" the back up the file(paste it in another location).Open the file with notepad and find seta "r_ImageQuality 1" and the value from 1 to 0 save and start the game then check the image quality setting in game settings.Don't use crack from another groRead more
Open the file with notepad and find seta “r_ImageQuality 1” and the value from 1 to 0 save and start the game then check the image quality setting in game settings.
Don’t use crack from another group.
You know the real meaning of peace only if you have been through the war.
Solved I Am Getting a Message Of Insufficient Memory For Windows 98
"What do I have to do to get past this message on Windows 98?"You actually have TOO much memory. Set the Win98 guest memory allocation to less than 512MB.
You actually have TOO much memory. Set the Win98 guest memory allocation to less than 512MB.
How To Move My Computer Screen To The Left
double click the top of the browser, or hit the maximize button.or is it a weird bugg/glitch?Simple solutions are often the best
or is it a weird bugg/glitch?
Simple solutions are often the best
Solved Reset BIOS After Inserting/Removing GPU
You listed your system specs but left out the most important item - the PSU. What is the make/model/wattage & amperage specs?"I shall remove the battery to clear the CMOS tonight hopefully"You don't need to remove the battery, just use the CLR_CMOS jumper (that's why it's there). I've seen postsRead more
“I shall remove the battery to clear the CMOS tonight hopefully”
You don’t need to remove the battery, just use the CLR_CMOS jumper (that’s why it’s there). I’ve seen posts where some people take the battery out & leave it out overnite to make sure the BIOS clears – it only takes a couple of second to clear, not minutes or hours. Just make sure the power cord is unplugged because the PSU standby power can prevent the BIOS from resetting.
From your motherboard manual:
• To clear the CMOS values, use a metal object like a screwdriver to touch the two pins for a few seconds.
• Always turn off your computer and unplug the power cord from the power outlet before clearing the CMOS values.
message edited by riider
Solved How Can I Enter BIOS In An ASUS Model X551MA?
YOU must disable fast boot in WIN8 not the bios (boot into WIN8). as per the links I posted.
Solved I Have 4000 Photos. How Many DVD’s Will It Take To Hold All
Certainly not a pen drive as they are not reliable enough and are therefore only suitable for short-term storage.DVD media is the best option.The number of pics you have is not the real issue, it's their total size in megabytes which will determine how many blank DVDs you will need, but for argumentRead more
DVD media is the best option.
The number of pics you have is not the real issue, it’s their total size in megabytes which will determine how many blank DVDs you will need, but for arguments sake let’s say each JPEG file is 500 kilobytes:
500 Kb x 4000 = 2,000,000 Kb = 1,954 MB = 1.9 GB
In the above example, your 4000 pics will easily fit on a single-layer 4 GB DVD.
Solved Vbscript To Close Particular Abs In Browser
No, it's possible with IE. Consider the following VBScript:For Each w In CreateObject("Shell.Application").Windows If InStr(1, w.LocationURL, "google", 1) Then _ w.Quit() Next 'wHow To Ask Questions The Smart Way
For Each w In CreateObject("Shell.Application").Windows If InStr(1, w.LocationURL, "google", 1) Then _ w.Quit() Next 'wHow To Ask Questions The Smart Way