Recent content by Bobnz

Thanks for the reply, yes it is

gettting the aforementioned error 438.... when this code runs Private Sub cmdLoadOLE_Click() Dim MyFolder As String Dim MyExt As String Dim MyPath As String Dim MyFile As String Dim strCriteria As String MyFolder = Me!SearchFolder...

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