Search results for query: *

Is there an easy method, using API function(s), that can be used to rename a file without opening it? Thanks in advance TJLMO

I loaded MDAC 2.5 to the user's machine and this did not solve the problem. Any other ideas? Thanks.

Call me a beginner, but what is an alpha machine?

I need to include various dll, olb, and tlb files with a VBA application I have created for Business Objects. This works fine on my PC because the files are already there. When I move it to a user's PC, however, and I attempt to run the function CreateWorkspace from the DAO360.dll library, I...

I am attempting to use two workspaces to conduct different transactions on two different databases. The reason I am using two workspaces is the following: the user creates the initial workspace that they use for all of their database inserts, updates, etc. The second is created without the...

I am attempting to catch or disable the user's ability to use the 'Cancel' button when they need to enter a prompt value in the pop-up prompt box. In essence, I want to force the user to have to enter a value. Any ideas? Thanks in advance.

I am attempting to run a page using the WebBrowser control and then once it has completed, I want to unload the browser. I have tried using: Do Until frmBrowser.wbbBrowser.ReadyState = READYSTATE_COMPLETE Loop to determine when the page has loaded. When I debug, it works fine. However, it...

I am attempting to upgrade my VBA .dll to VB6. However, in the references path there are various .dll's with the name Visual Basic For Applications. When I select the library for VB6, it states that the name conflicts with an existing object library and when I try to remove the VB3 library, it...

I am attempting to hide a browser window that is opened when I use the following script: lReturn = ShellExecute(hWnd, "open", sWebsite, vbNull, vbNull, _ SW_HIDE) sWebsite is a string that contains the url. This only opens a maximized window for me. Any ideas? Thanks in...

I am attempting to create a security prompt in VBA and am wondering where to get started. The help docs from BO aren't too helpful. I want to use a form so that a user can enter his/her password to make an odbc connection to a database. Any help would be appreciated. Thanks in advance.

I am guessing this one will be easy: If I have a function with an error handler and it calls another function, do I need to use On Error GoTo 0 to turn off the error handler from the first function before creating a new error handler for the second function? Thanks in advance.

I am attempting to replace all existing prompts in the dataprovider SQL so that I can run the query through a VBA database connection as opposed to running it through Business Objects. Any ideas? Thanks in advance.

I am wondering if there is anyway to retrieve the full length string of an ODBC error so I can show it to a user in a message box. I tried Errors.Description, but the description is very brief. Thanks in advance.

Is there any way to "catch" a SQL error when updating BO SQL through VBA using DataProvider.SQL? (I need a DAO workspace to rollback if there is an error.) Also, if I use this DataProvider.SQL to change the SQL and the user is required to enter a prompt and they select 'Cancel' the...

I am attempting to ensure that a user enters only positive integers into a textbox on a form. I am attempting to use the function IsNumeric() as part of this check. However, when I enter 555 and then move the cursor inbetween the last and middle 5 and enter a 'd' or 'e' (i.e.- 55d5 or 55e5)...