Search results for query: *

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

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

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

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

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

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?

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

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

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

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

Got it fixed.

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

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

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.

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

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

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

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

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

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