Search results for query: *

It has been a while since I last used VB 6, but I thought I used to have the ability to use the scroll wheel on my mouse in the code window. Is there something in the options I am missing? Hopefully someone can help Thanks JJ

I know this is simple, but I am drawing a blank this morning. What is the syntax to get the current row. I want to put this value into a variable as I am doing quite a bit of data parsing. intRow = ???? Thanks JJ

Thanks. Hopefully that works.

I am using MS Outlook 2003. Due to the location I am in, I am using a dial-up connection. I am currently unable to send any messages using Outlook, but I can receive messages and access the web without problems. I get an error message that says something about the connection was interrupted...

Thanks for the direction. I needed to add a Where clause in the Not Exists portion to fix things. All seems right with the world again. Thanks! JJ

I am trying to run a simple query using the not exists, but it is not work. I forced in a test record in the DFAddress table that is not in the Address table. Below is the query I am using... select AddrType, AddrLine1, AddrLine2, AddrLine3, AddrLine4, AddrCity, AddrState, AddrZipC...

In case anyone else decides to look this up, the faq for this forum to check is faq707-2115

I want to be able to find where the last cell that has data in it using a macro. Similar to using the <Ctrl> <End> key combination. I would like to select a starting point and then go to the end of the data set. It will span multiple columns and the rows will vary each time. Thanks JJ

This is getting frustrating. When I minimize my Excel App, then restore it, the menus and quick buttons disappear. I am left with the formula bar and window title. I hope this is just a quick keystroke combination to fix this. It happens sporatically. Thanks JJ

Basically I am receiving a variable value (1,2,3 , A, b ,C) into the procedure. I need to remove any extra spaces and insert quote marks to make each value a string value. The above example should result as ('1','2','3','A,'B','C') The rest of the statement will not change. I am thinking...

I have the following select statement that is not working as I expect. This will run and pull out data, but it acts as iff the not in clause does not exist. Select * FROM ##BatchTransaction bt join Terminal t on bt.TrNo = t.ATTrNo join Agent a on t.AgentID = a.AgentID where a.agenttype...

I have been assigned the task of converting our site from Java Viewer to Active X Viewer. While internally this is working fine, as soon as a client attempts to run things it doesn't work. The window will open up and display the forward/back buttons, but no view of the report. We are using...

That is a great start...but I need it to print out the whole page with boxes so that the appointment titles can be displayed in the corresponding date box. Thanks for the quick response, just need a little bit more. JJ

Using V 9.0. I have a table that holds some appointment information and I wanted to display it in a calendar format similar to Outlook. The user does not have outlook though. Basically I want the user to select a month and then have the report print out all their appointments for the month...

Simple question I hope. I want to do: CASE WHEN AcctStatus IN ('a','c','o') THEN AcctStatus ELSE NULL END. Is this the right syntax? Can someone set me on the right path? Thanks all JJ

I am trying to further my skills with SQL Server Programming/management. Does anyone have any recommendations for books that I could read to further enhance my skills. Mainly the areas of concern for me are Stored Procedures and DTS packets. I am using SQL server 2000. Thanks All.

I am learning JavaScript on the fly right now, so a quick answer is greatly appreciated. I am trying to receive two date values from a user web page and convert them to date values for comparison. Date1 Date2 1/1/01 1/1/06 I am trying to do a simple comparison of if (Date1 == Date2) {...

I am using a cursor to manipulate my data from individual records to one long string (for reporting purposes). I am using the following: Exec('DECLARE PM CURSOR FOR SELECT * FROM '+@UserTable99+'') OPEN PM FETCH PM INTO @PM8sub WHILE @@FETCH_STATUS=0 BEGIN SET @JJ = 'SELECT PopDesc FROM...