Search results for query: *

I have an Excel project that desperatly needs a way to join recordsets; this is needed for speed. What I have read so far is it cannot be done. Currently my project opens several recordersets in Excel VBA and I have to cycle through each to create a final recordset used to update Excel...

I am working with ODBC connections for the first time and this is why I need help with a couple items. I am creating a few UDFs that will need to query our production Oracle tables to formulate results. I can use the following code to establish a connection to Oracle...

I am able to open a new Oracle ODBC connection using: Dim sConn As String, sSQL As String, sServer As String Dim cnn As ADODB.Connection 'make oracle connection Set cnn = New ADODB.Connection sServer = "SSSSSSS" cnn.Open "Driver={Microsoft ODBC for Oracle};" & _ "Server=" & sServer & ";" &...

I am able to get the names of all the tables in my access database using the following VBA: Dim lpTblDef As TableDef With CurrentDb For Each lpTblDef In .TableDefs MsgBox lpTblDef.Properties("name") Next lpTblDef End With I am not able to figure out how to get the modify...

What I meant to ask; can I send a text message to my cell phone? This will allow me to monitor for errors while away from the office. If I do not receive any error messages during the day, I know I will not need to return to the office to check for or correct any errors before heading home...

I am looking for a way to send a text message using VBA out of Access. I created a program using Access and VBA that runs many times a day. I have used proper error handeling so that errors are logged, but I am not able to monitor the program all day long. When an error is logged, I would...

I have an access application that has nearly 70 procedures or functions that run daily, with more being added as people make changes to the application. I have created a sub - prcLog(prcName as string) - that will log the start and end of each sub or function, for the purpose of tracking how...

Thanks again for you quick reply. I tried to modify the code as you have suggested, but now I get another error: "ActiveX component can't create object" Any suggestions? Again, thank you for your quick reply.

I tried the DIM as Object. I can get the following code to work: -----------------------start--code-- Dim objIE As Object Dim iURL As String iURL = "http://finance.yahoo.com" Set objIE = CreateObject("InternetExplorer.Application") DoEvents With objIE .Visible = True .Navigate iURL End With...

I am trying to use the getobject method to use the current open session of IE, but I receive an error on the following variable declariation: Dim objIE As InternetExplorer Compile error: User-defined type not defined What do I need to do to be able to declare objIE as IE? Thanks everyone for...

Thanks to Tek-Tips I am able to logon to a secured website and navigate to specific URLs. I now have a problem. I need to know how to extract data from tables once I navigate to each URL. I tried the webquery approach, but the table number is not always the same. What I need to do is look at...

I have a VBA HTML parsing function that extracts and imports data from a site directly into Access tables, saving me hours of time from manually transfering the data. I wanted to automate this further by using VBA to use my username and password to login to the site. The login page (.jsp) uses...

My website has several links pointing to relevant external sites. Is there a way to log the links that are clicked on to exit my site or domain? Any help would be useful. Thank you.

Here is the scenario: I have a web site with a link that point to an external site. I need to have a popup load - the popup has instructions for the external site - when the user clicks the link to exit my site and enter the external site. Example: 1. User is on my site 2. User clicks a...

The problem is I do not know which body forms will be open. The navigation menu allows the user to select forms to open and update different things like account, institution, or investment information. All forms or only one may be open, and I would like to resize all the forms that are open...

Are there file size limitations with Access? How many rows of detail can a table have before experiencing problems?

I created an application that uses a form placed on the left hand side as a “Navigation Menu” and other forms to the right of the navigation form as body forms so that the screen looks much like that of an internet page with frames. I created code to be able to shrink the navigation form in...

I have a database that uses Excel's web query feature to grab data from the internet. Some users do not have excel present on their PCs and it causes Access to error out when running some of these functions. Is there an easy way for Access to detect if Excel is present before running any of...