Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by strangeBrew12

  1. strangeBrew12

    Mouse wheel (scrolling) won't work

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

    Getting the current row number in Excel

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

    I can receive, but CAN'T send! MS Outlook

    Thanks. Hopefully that works.
  4. strangeBrew12

    I can receive, but CAN'T send! MS Outlook

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

    Problems w/ Exists and not Exists

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

    Problems w/ Exists and not Exists

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

    MS Excel Last record

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

    MS Excel Last record

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

    Menus disappear

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

    Select Statement not working....

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

    Select Statement not working....

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

    Active X Viewer for Reports

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

    Calendar Style Report

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

    Calendar Style Report

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

    CASE WHEN statement

    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
See more

Part and Inventory Search

Back
Top