Search results for query: *

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

Does anyone know how to insert a picture into a database using an SQL statement? I also need to know how to retrieve that image from the database and load it into a picture box. Ken

Should I be able to print a form with a WebBrowser on it? My System was giving me an error that I didn't have a printer capable of printing an image form. I rebooted and now it is printing out a blank page even though I can see the content on the browser that I am trying to print out. Any help...

Hi gang I am looking for a way to use the loadpicture command with a picture that is online. Any ideas as to how I can do this? Ken

Hi Gang I am using the code below to try and update an access database in my VB code. I used the same code on another project and was able to make changes to the database. The database I am using is access 2000. I am also having problems with my ASP connecting to my databases now that I have...

Hi gang I am getting the error message below when I try to access an access 2000 database. When the Database was Access 97 it ran fine but as soon as the database was converted to 2000 boom. Here is the code that I am using Set MyConn=Server.CreateObject("ADODB.Connection")...

Hi Gang I am trying to do a print out to a printer based on where a user clicks. I need to be able to do a dyna mic prinout that contains an image and text beside it. Does anyone know how I can build the document on the fly in VB. The print out needs to look similar to this web page...

Hi Gang I have found a Javascript that allows me to force a page to print out. The only problem is it comes up with a print dialogue even though it is not supposed to. Any Javascript experts out there that can help me with this one. I would fiddle with it myself but I don't have a printer...

Hi Gang Is there anyway to intercept a click in a web browser that is in a VB project? Is there maybe something I could put in an HREF in the web page being shown that would be able to be intercepted by VB? I want to show a web page and have a click anywhere on the web page generate an event...

Hi Gang I am working on a project where I need to pass a couple of parameters to a VB program when it is starting up. How do I call the program and how do I access the parameters that are passed to it. TIA Ken

I need to be able to set the preinter orientation to landscape for a project I am working on. Does anyone know how to set this property in VB and then switch it back to portrait? Ken