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

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

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

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

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

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

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

Hi, I have a unbound form that has multiple comboboxes that when selected sets another combobox with it's options, 1 combobox after the rowsource is updated does not have all of the information in the next combobox. This is only happening to a select few. The linked tables on reflect all of the...

Hi I'am having an issue I am running a possible 6 sessions that I will be flipping between and to scrape info from. I keep on getting an error that the Specified session is not available error -2147200922(80040200) ReDim s(1 To Sessions.Count) For sess = 1 To Sessions.Count s(sess) =...

I am having a problem I am using a VB form that will complete the web form as the vb form will be loading info to our mainframe system and a database the issue is with the first part. I have it completeing the web form then it submits the info and after it submits the info it needs to get some...

I am having a problem and getting runtime error 3770. (Microsoft Jet does not recognize Forms!Apps!Calendar1 as a valid field name or expression) I have 2 calendar controls on a form and need to use the dates from the calendar controls to pull the query. I have several select queries that work...

I am working on a macro that needs to fire accross the active session. The people using the macro could have 3+ sessions open. Is there a way to make sure the macro fires accross the session that is currently the activated window of attachmate? Any help would be greatly appreciated. THANKS