Well it turns out that I have teh wrong cable. The cable has a small chip in teh RS232 plug end... The cable came with a driver named HL340 for Windows XP... I found the seller (on ebay) and emailed them. It turns out that there is a seperate cable/chip for Vista 64bit for $23 EBay item title... USB SERIAL RS232 DB9 CABLE VISTA XP MAC LINUX Windows 7 [

Hi, Thanks for the links. I have tried the 1st one and it fails to install with just a generic application message. As for the 2nd & 3rd I was not a member so I have to wait for the server to catch up after I signed up. I have found serveral sites with different versions of the driver including what is supposed to be the original Chinese site. That is the only one that comes close but since I cant read chinese I cant answer the setup Q's and install. Some of the sites say that after installing you have to reboot and press F8 during the boot process to disable the driver signature process since the driver is NOT signed. But most of those posts are from 2004-2007 and I would have thought that it would have benn approved by now, being 2010 5 years later!!! I am trying to connect to a GPS and most GPS's are serial port connections.

Walt, Thanks for the pointer the page dose have a lot of great formats etc on it. I have added it to my favorites. I had to change the Single Quotes to # around each of the parameter dates and it worked great. Thanks for all the help and pointers. SquireDude

Hi Walt, Thanks for the sample code... It works great. But I have another issue that maybe you can help me with. The Value I am passing is a string with the DateTimeValue in it. I have put single quotes around the value and it works when I run the SQL manually... but when I run it in the app it rejectes it because the "Time" is still attached. My issue is how can I convert the string value to a Date ONLY value? I have tried Convert.ToDateTime(Value)... but that still has a Time in it. I tried DateTime.ParseExact(Value,... ,...) but I couldn't find a Date only filter. I am using this in a Forms App in C# on an Access DB, I build my SQL in the App and pass it over. Got any suggestions on how to convert the string value of "DateTime" to a "Date" only value? Thanks

Hi, I have a bit of a problem with a Forms App using Access for the DB. I have a Calendar Control that has date ranges bolded from records in a table in the DB. I have the Calendar Control populated and now the user can select a date and find the event associated to the date. The date may be the "StartDate", "EndDate", or a date within the range of the "StartDate" & "EndDate" in a row. What I need help with is wrighting the SQL to bring back the record ID where the selected date falls between the StartDate & End Date and return the Record ID value. SELECT E_ID FROM Events WHERE "SelectedDate" is Between StartDate AND EndDate OR something like that???

Okay my bad.... I had a big case of Brain Fade yesterday now I hope that it is behind me and I can move forward today.... so far so good! I appologise for not getting it... You are correct of course the new Control is on the Left (Controls) pane and can be dragged onto a form etc. Thank you for your patience and sticking with me I really do appreaciate the effort. Thanks SquireDude

Thanks for the pointer. I could not get any of the links to work but did start reading the text further down the page... I am not sure how it realates to what I was asking? Maybe I am just having very dumb day as I could not see how it related what I am trying to accomplish. But thanks anyway for your time and assistance.

Now I am feeling really dumb!!!! I got through parts 1 & 2 but how do I "Drop" the new control on the form? I tried makeing a User Control & a Class with your code replacing the generic code. I ran Build... But if I try to drag & drop the file onto the form it will not stick. What am I missing???

Thanks for the ideas and suggestion and code... First I tried your second suggestion... turing off VisualStyles... and id does kind of mess things up on other forms. Then I looked at your code and it looed simple enough! I have never put a wrapper around a class before as in you first suggestion. How do I apply the code?

Okay call me dumb!!!! dahhh.... Thansk for the suggestion. I do have one other question for you... Where do I turn on/off "Visual Styles" for the MoNthCalendar? It is not in the controls properties where else should I be looking?

I have a Forms Application which I have just added the MothCalendar control too and I am ubale to change any of the properties, such as BackGroundColor, Size, etc. I have tried using the designer and in code but the interface does not change! Is there a trick to using this control? Thanks

I just purchased a Serial Port (9 pin) to USB cable so I can plug my GPS into my laptop. It came with a disk with the drivers for XP does anyone know where I can find the drivers for Vista 64bit version? I think the cable is called an HL340? I checked on Google & Microsoft and I only found a referance to a Chinese driver which I looked at and the interface is in Chinese and of course unreadable to me. If anyone knows where do download a USB2.0-Ser! driver or some other method of connecting I am grateful. Thanks