Search results for query: *

Hi beaslyed, I had and solved this problem today. First, the purpose of the GETPIVODATA is to get a result, and the same result regardless of the amount of lines in a Pivot Table. This can be useful if you are looking for a total, but the total is on different lines based on differents sets...

Hi Bcaster, Last night I tried your suggestion of removing all but one of the machines from the Router and got the same results. I guess the router wants to keep 192.168.0.1 for itself, even if there is only one machine attached to it. I will go through the practicallynetworked checklist and...

I think this explains the Internet Connection Sharing, but what about the networing in general? Why can't the Windows 98 machine see the XP machines and the XP machines see the windows 98 machines? The XP Machines can see eachother. Why did the IPCONFIG/RELEASE IPCONFIG/RENEW on the Windows...

I tried the IPCONFIG/RELEASE IPCONFIG/RENEW and found no changes on the two XP Machines. When I tried it on the Windows 98 machine, I got the message DHCP Server unable to renew adaptor. The IP Address changed to 169.254.91.172, the Subnet Address to 255.255.0.0, and the Default Gateway, DHCP...

Bigbull, I tried, using your data and it worked. The only thing that I can think of is to check the length of the fields in Columns A and E with the =Len(Column,Row) function. If they are different lengths, if E is longer, then try: =VLOOKUP(Trim(E2),$A$2:$B$9,2,False) If that doesn't...

In Column F, starting in row 2 try: =VLOOKUP(E2,$A$2:$B$9,2,False)

I have three machines that I am trying to network. One with XP Pro, one with XP Home, and One with Windows 98 Second Edition. I am having difficulty getting the XP Pro Machines to see the Windows 98 machine and I can not get Internet Sharing to work. Does anyone have any suggestions? The...

Another method would be to turn on the Auto Filter and select the "Excellent" Rank. Then copy past the results to the other worksheet.

Hi Biswajit, I think you could use the code above. The key portion for sending e-mail is: '***creates an instance of Outlook Set objOutlook = CreateObject("Outlook.application") Set objEmail = objOutlook.CreateItem(olMailItem) '***creates and sends email With objEmail...

Hi Caryisms, On the tool bar on the bottom of the screen, you should have a white box with the word "Click" over the top and a red circle with a white "X" in it on the bottom right portion of the icon. If you do not, find the Express ClickYes Icon on your desk top or go to...

Hi Caryisms, If you downloaded the application, there should be an icon on your desk top and, when activated, an icon on the toolbar on the lower right of your screen. When you double click on the red "X", it turns into a black check and your application will not require the reply to...

Hi Caryisms, A work-around, only needed on the CPU's that send the e-mail can be found at: www.express-soft.com/mailmate/clickyes.html. You can code it so that it will automatically turn itself on for the duration of your e-mail sending, then turn itself off. Regards, Zig1

Hi gingerboy, I am sure theere are many ways to solve your problem, but I think this will work: Create a new table with two fields: Age From and Age To Create a quiry with your regular (age) field and the new (Age To) Tables. In the Query, select Age From, Age To, and Age Under Age set the...

Hi jh3016, Try this in L2: IF(ISERR(SEARCH("grapes",K1)),"","x") You can use FIND in place of SEARCH, but it is case sensitive and will not find "Grapes" if you are looking for "grapes"

I solved the problem. There are two sets of microphone and speaker connections, one in the front of the machine and one in the back. The front connections were not connected and did ot work. the ones in the back work with the microphone and speakers.

I have tried three different headsets. None of them work. I also have another friend that seems to be having the same problem.

I am using XP Home. I am trying to train the speech recognition program, but it does not recognize the microphone or headset speakers. I am using a headset that has worked with windows 98. The sound card is OK, I can get sound through external speakers. I know about the microphone mute...

An easy way to eliminate duplicates in Excel is to sort on the key field that contains the duplictes, then, in an empty colum create an equation to put in the word "Duplicate", if the prior row entry in the duplicate field is the same as the current row entry. Copy the formula to all...