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!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jjk238
  • Content: Threads
  • Order by date
  1. jjk238

    How to find the last record in a sequence of entries

    Hello, I have a table that has up to 5 entries of the same Application number, with the Status changing on each one. What I'd like to do is get the highest number (last in the sequence) for each application number. Here's what the table looks like: App Num Sequence Status EntryDate...
  2. jjk238

    Concatenate rows in the same table using faq701-4233

    I have looked all over, and there is a ton of info on this, but I can't seem to get anything to work. I am trying to use this FAQ: http://www.tek-tips.com/faqs.cfm?fid=4233 I have one table named Zip_Vert: State Affiliate County Zip PA PA-3 Allegheny 15227 PA...
  3. jjk238

    Changing the cursor to an hourglass while server is working

    I am trying to change the arrow cursor to an hourglass. - The user clicks a button - The onClick event (in C#) hits the server and takes about 8-10 seconds to query and populate the gridview. I would like the hourglass to show during this time. All code is written in VS.NET 2005 with ASP.NET...
  4. jjk238

    How to get the "Find" control to pop up in excel

    Hello, I am trying to get the "Find and Replace" control (ctrl + f) to pop up when the user clicks on a command button. The button is embedded into an Excel workbook. I also would like the control to be opened with the options shown and the "Within" field to be selecting workbook. I have...
  5. jjk238

    How to get the "Find" control to pop up using the onclick event

    Hello, I am trying to get the "Find and Replace" control (ctrl + f) to pop up when the user clicks on a command button. The button is embedded into an Excel workbook. I also would like the control to be opened with the options shown and the "Within" field to be selecting workbook. I have...
  6. jjk238

    Importing a pipe delimited text file into Access using VB

    I am trying to import a pipe delimited text file into MS Access. The code that I am messing with is: strPath = "C:\cooper.txt" strTable = "PIPE" DoCmd.RunSQL "DROP TABLE " & strTable DoCmd.TransferText acImportDelim, , strTable, strPath I'm not sure what to put for the first parameter of...
  7. jjk238

    Changing row colors within a cross-tab using a formula

    I am trying to change the color of certain rows using this formula in Basic Syntax (Crystal 10): If {sp_rpt_Car5000Q;1.ConActive} = FALSE Then formula = crRed Else formula = crBlack End If I have used this formula in other reports to change row colors and it has worked fine...

Part and Inventory Search

Back
Top