Recent content by capone67

Hi All I have an SQL query that has several joins in it. It is for a forum. I want to select the record for the latest post in a thread along with the titles and ids of the thread/forum/forumarea. My query however is returning the content of the first post and the ID of the latest post. How to...

I have a like SQL search running on an ASP web site. The search works in general. Here is the SQL SELECT ForModels.* FROM ForModels where ForModel like '%HM%' The problem is I can't get any results for "Like '%HM%'" I am specifically looking for 50HMX96 Is there something in...

Does anyone know of a way to activate and position buttons on a Macola form using VBA? Ken

Hi Gang I am trying to use SPIF_SENDCHANGE to case my windows desktop to refresh in win98. I dont really know what the value of this constant is but I think it is supposed to be 2. When I run my code the value returned is 'Empty'. Here are the relevant lines of code that I have. Private...

Hi Gang I am working on an Outlook 2000 project that creates tasks. I am able to build the task etc but I cannot figure out how to get the contact list to pop up so that I can assign the task to someone. What I am looking for is the Select Contacts Dialogue that appears when you click the...

Hi guys I am trying to build a project that involves a database but I would preffer not to have to include the MS data control on a form. The program will eventually run with no form. Also if it can be avoided I would rather not have to run an install program. I can add and update the database...

Hi gang I am trying to get myself started on programming MS Outlook 2000. As it is right now all I am trying to do is populate a combobox with values. The problem seems to be with gettting to the combo box. I know how to use the additem and how to get my values out of a database but I cannot...

Hi all I am getting very desperate trying to find some help on how to expose properties of an activeX control that I am constructing. I can't seem to find anything anywhere about exposing properties of a control. Maybe exposing properties is not what I am looking for even. I am new to this kind...

Hi gang I have an activeX control that I have built hat runs fine on my system and several others. The control connects to an SQL server as well. when I try to get it to run on the system that it needs to run on I get Error 403 as the title for the page. The system that it needs to run on is...

Hi gang I have an activeX control that I have built hat runs fine on my system and several others. The control connects to an SQL server as well. when I try to get it to run on the system that it needs to run on I get Error 403 as the title for the page. The system that it needs to run on is...

Thanks for your help. My system has issues so I re-installed VB under a differnt administrators login and everything works beautifully now. Any idea why software installs tell me that I need administrative permissions even though when I look in the user manager I am an Administrator? Ken

I caught the jpg gif thing when I was looking at the code. I'll ave to make a slight modification to the code to del with that. I have Added the reffernce to the Miscrosoft Internet Controls to my project but I don't see anything in my tool box for it. How do I add the control to my project...

I am gonna need moe info if I go this route. The image needs to be loaded into the database suing activer server pages and retrieved using a vb application. Does this complicate things? Ken

there dosn't seem to be an edit copy in the drop down list of events and Methods. so much for tht plan. Any other ideas? Ken

I have a feeling the problem is with my system rather than the code. I'll get back to you if I still have problems. Ken