Search results for query: *

Trying to get the text from a PowerBuilder datawindow. I have identified the window which the data resides but am running into difficulties getting the text of the data out. tried the Sendmessage WM_GETTEXT dim lresultDW as long 'handle for the datawindow Dim sOutput as string Dim lngLen& Dim...

I've been trying to figure this out for a while, recently we were forced to convert our Access 2003 databases to Access 2007 (company required it) after conversion the performace decreased dramatically, what used to take a couple seconds now takes a couple minutes. The database is not split and...

I am trying to link/import documents (txt) from sharepoint to Access 2007 as an access table. The Sharepoint list shows all the documents in the folder and the name of the document is a hyperlink, which i can extact the address. How can I then Link or import the document to access? The...

FantasticContraption.com is another good physics game...

Are you opening a recordset? Set Conn = CreateObject("ADODB.Connection") Set RS = CreateObject("ADODB.Recordset") '''LockType And CursorType Allow The Script To Write In The RecordSet 'Set Conn = CreateObject("ADODB.Connection") setting this as part of the recordset...

Are you trying to detrime which window the code is executing from?

Hi I have a vb6 applicaion that I create. problem is that when it is executed from attachmate it causes attachmate to become unresponsive and closes, but if i execute the program by double clicking on it it runs accross the attachmate sessions just fine. Any ideas????????

THANKS, the issue was that the sheetArray was already an array, and the Array(sheetArray)was the illegal. Thanks for the help!!!

I need some assistance with a Sheet(Array(---)).copy. I have a worksheet that contains the names of the other worksheets if indicated will be copied to a new workbook. the code loops through and creates an array for the sheets that it needs to copy, but it errors on the line...

Save your scheme settings to a network drive. Change the remote scheme settings to the network. With Attachmate 7.11 goto Options>Global Preferences>Files/Directories to change the remote scheme settings.

Thanks that works perfectly, I see where and understand where I was going wrong now. I really appreciate it.

I'm needing some help with this query/subquery to select the top 2 from each group SELECT T1.[First Name], T1.[Last Name], T2.[Record Type], T2.TimeStamp FROM T2 AS B1, T1 INNER JOIN T2 ON T1.ID = T2.ProviderID WHERE (((B1.TimeStamp)=(Select Top 2 B1.TimeStamp from B1 Where...

Thanks for the suggestions, that helped shave off a couple mins. I'm pretty sure most of it is network traffic and it getting caughtup in access. I also turned off the screenupdating which help a little bit as well.

I am trying to speed up the process of ADO connection from EXCEL to ACCESS db. I made a excel function that passes a SQL statement from each cell to access and returns the answer value for that cell. Currently running aprox. 30,000 queries that was taking only 3 mins, but now is taking 20 mins...

how about this? Sub Main Dim System As Object Dim Sess As Object Set System = CreateObject("EXTRA.System") Set Sess = System.ActiveSession Begin Dialog UserDialog 185, 52, 280, 174, "Share Aging" TextBox 95, 5, 51, 13, .freeshrbox TextBox 95, 19, 51, 13, .tfrdatebox TextBox 95...

Does this help? This is what i've done in the past Instead of the array you can use if statements or case statements if you are more comfortable with those. Sub Main Dim System As Object Dim Sess As Object Set System = CreateObject("EXTRA.System") Set Sess = System.ActiveSession Dim...

I am having an issue that is effecting other HLLAPI functions. After the macro below runs the objects do not release from memory and is causing a conflict with the HLLAPI macros. I cannot figure out why the objects are not releasing. Any help on this would be geatly appreciated...

Have you tried Sub Main dim objPlayer as Object Set objPlayer = CreateObject("WMPlayer.OCX" ) objPlayer.url="c:\musicfiles\music.mp3" End Sub

I'm having an issue with the Extra! Objects not releasing from memory and causing memory conflicts. Any ideas as to why this is happening??????'************************************** '------ Function declaration ------ Declare function Sleep(scrn as ExtraScreen)...

Hi I am needing some help trying to create a query that finds conflicting info in a table. Fields are [rule],[name],[value],[oper]. The first 3 fields can contain the same info but but may not contain the same info. The oper field contains =,<>,>,<,IN,!IN I need to compare if there are matching...