Search results for query: *

Thanks for the reply, yes it is

...<---------------------------------------- Getting 438 error on this line ' Get the search path. MyPath = MyFolder & "\" & "*." & [SearchExtension] ' Get the first file in the path containing the file extension. MyFile = Dir(MyPath, vbNormal) Do While...

Thanks for the reply but everything sorted now. B

I have a select query script that runs fine. I am trying to create a mview with it but when I try to create the view,it runs and runs and never creates the view; I have to cancel. I let it run for an hour without success, the actual select query takes about 5 seconds. create materialized view...

Yep connecting the 4pin 12v atx power connection sorted the problem. thanks for the replies

Have discovered a 4pin 12v atx power connector in addition to the usual 20 pin so maybe I need that as well as 20 pin, will get a knew power supply tommorrow and see what shakes out. Will post and let u know. Thanks for the help warm beer is better than no beer though :)

didnt know I had given u a star? I cant access the bios or anything there is no video signal and when I power on, the cpu fan starts and thats it; nothing on the monitor.

Hi thanks for the reply, ok tried that just m/board and processor and nothing happens except cpu fan starts. Only thing connect is PWRSW so I can turn it on.

I have installed new motherboard and cpu. New cpu is intel celeron D 2.4ghz processor m/board is foxconn 865a01-pe-6ls RAM is 512 mb ddr pc2100 I hit the power on button and the cpu fan starts up but nothing else happens no beep so post isn't happening. Any help much appreciated.

Thanks skip

I have a dropdown list in a cell on a spreadsheet where the user selects a name and then all jobs associated with that person are displayed. I want to display only the jobs currently being worked on/ not completed. Completely new to excel although have done some access programming. I imagine an...

Tom, I have decided to put the onus on the user to have a correctly entered name in the outlook contact list. By inserting... If Not objOutlookRecip.Resolve Then MsgBox "The recipients name [" & recipient & "] cannot be found in the outlook contact list. Please check to see that recipients...

Thanks Tom, I will spend a couple of days looking at this and see if I can work it out :). I will need to see if the close event runs without the send event running as the order table will be updated only if the send event has run. Danvlas thanks for the input. B

Thanks Tom, I'm not a programmer as such, how would I go about testing to see if close event fired before the send event? if(.send=true)....? Bob

Hi, I have an email sub procedure that sends an order as an attachment. However if the company does not exist in outlooks contacts then outlook opens and asks the user to select the recipient. I want to be able to test to see if the order was sent or cancelled and output an appropriate message...

I have just upgraded my pc to xp pro from win 2k and can no longer access my other drives (win 2k). other drive(e:) shows in bios and in my computer but cannot open. c: drive is raid array 0 using 2 drives and hot rod 100 pro card, e: drive is also connected via raid card rather than m/board...

thanks for the replies, I have solved the problem. In TCP/IP properties I set the primary dns to the server and the alternate to the router. Now I have internet without having to do the renew/release and can join the domain when the server is up without a problem. Thanks again for the replies. B

Thanks for the reply, I have been doing what you suggested its the only way to get internet access. Once the server is switched off I have to a release/renew before I can access the web. and when the server is on I have to do release/renew before I can join the domain. pc's are set to obtain...

Hi I have a win 2k server + home network; one of the local machines running win2k pro is used a lot as a standalone pc but is also able to connect to the domain. However after it has been used as standalone for a while it will not reconnect to domain, gets as far as applying computer settings...

Sorted, some of the textboxes where touching.