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!

Search results for query: *

  1. rib742

    Excel formula "=+"

    Thanks. Didn't think there was anything special about it.
  2. rib742

    Excel formula "=+"

    Hi there. I've searched and can't seem to find anything regards a formula I see in Excel. Taking over some reports for a colleague that's left the company and they have formulas starting with =+ all throughout the spreadsheet and I can't seem to find/determine what the significance is...
  3. rib742

    export to multiple Excel worksheets

    From my original post -- "I know that it's not desireable but this is how the requestor wants the data." I work with d/b's all the time and routinely pull back hundres of thousands of records daily and only export what I need. However, the requestor is adament that they get all the data in...
  4. rib742

    export to multiple Excel worksheets

    Thanks but what I need is for the following to hapopen and I cannot find how to do it but remember it can be done. Export a table in Access that has 140K rows. During the one time export, the first 65xxx rows are put on tab 1, then the next 65xxx rows are put on tab 2, etc until all the rows...
  5. rib742

    export to multiple Excel worksheets

    I've reviewed the multiple posts on this but nothing applies. I once was able to export an Access Table with over 100K lines of data and it would be spanned over multiple worksheets automatically; no special coding. I haven't had to do it in a while and can't seem to find how to. I know that...
  6. rib742

    Pass VBA to a SQL query

    I have some pass through SQL queries that I want to re-construct in VBA so I can pass some form based parameters. I can make some adjustments and use DoCmd.RunSQL but there are some that I really need to use the pass throughs. Is there a way to reconstruct pass throughs that I'm not seeing?
  7. rib742

    VBA to identify network places

    I've searched several posts and cannot find what I'm looking for. What I want to be able to do is have a list of all the share networks that a user is mapped to when a form opens based on their username. I've got the form to display the users name using ENVIRON("USERNAME"). however, I'm at a...
  8. rib742

    Wait for Text anywhere on mainframe (need VBA)

    Figured it out for my project. Public Sub WaitTextLoc(ctrl As Control, strText As String, X As Long, Y As Long, Optional blnDoEnter As Boolean = False) Dim strRetVal As String ctrl.GetScreen strRetVal, X, Y, Len(strText) Do Until strRetVal = strText...
  9. rib742

    Wait for Text anywhere on mainframe (need VBA)

    I'm converting some mainframe VBscript macros to VBA and can't seem to figure a piece out. In VBScript I use the EMWaitText where I look for a string anywhere on the screen to get it's X coordinate. The Y coordinate is always a constant. EMWaitText .15,strTextLoc,1,1,intRowResult...
  10. rib742

    screen scrape results

    I thought I pasted but see that it didn't stick. Sorry about that. Ended up where I forgot something on the GetScreen. code from original post above with corrections in bold: ...... PutScreen strDE, 20, 19, True PutScreen "X", 19, 20, True strRetVal GetScreen(9, 2, 6) With...
  11. rib742

    screen scrape results

    Got it fixed.
  12. rib742

    screen scrape results

    Here's the GetScreen code: Public Function GetScreen(X As Long, Y As Long, Length As Long) As String Dim strRetVal As String ocxHost.GetScreen strRetVal, X, Y, Length GetScreen = strRetVal End Function
  13. rib742

    screen scrape results

    I have code that will connect to a mainframe host, perform specific keystrokes and maneuver through screens with a given data element (strDE). What I need to do is be able to write the resulting GetScreen data into a table. I'm able to write the given data element used to maneuver through the...
  14. rib742

    Concatenate within a Pass Through Query

    When I review the results without making the table it's fine; everything is returned in no time. It's just that when I go to copy the results or make table, that it takes for ever.
  15. rib742

    Concatenate within a Pass Through Query

    Good morning. I understand the concatenate function as defined under FAQ701-4233 and am able to use it within a make table query. My question is whether or not (and if how) can a function like this be used within an SQL Pass Through query? I'm running into some performance issues (3 hours to...
  16. rib742

    Concatenate within a Pass Through Query

    Good morning. I understand the concatenate function as defined under faq701-4233 and am able to use it within a make table query. My question is whether or not (and if how) can a function like this be used within an SQL Pass Through query? I'm running into some performance issues (3 hours to...
  17. rib742

    SQL Pass Through

    Here's the query with the one field I want to group by. But when I go to run it, I get an error message stating that last field in the select is not part of the group by. When I take the last field out of the select, the error message indicates the next last field and so on. SELECT MAX(CASE...
  18. rib742

    SQL Pass Through

    Thanks r937. This is putting me on the right track but it seems that I'm having to put all my select fields in the group by clause in order for it to work. If I do the above on the excerpt sample from the whole query then it works. Is there something different for when you have a Where clause...
  19. rib742

    SQL Pass Through

    Good evening. I've been tinkering with SQL Pass Throughs to make my ODBC reports run faster but I can't figure something out. There are several fields from the records I'm retrieving that share a key. What I'm trying to do is keep these records on 1 line of the output but can't seem to get...
  20. rib742

    SQL where sequence

    Thanks r937! Just wanted to make sure before I go converting a lot of big queries.

Part and Inventory Search

Back
Top