Search results for query: *

I seemed to have run up against a 256 file limitation in the FileSystemObject Files collection?!? Can anyone confirm this or point to a workaround that does not entail piping the output to a file and iterating through that? Dim objFSO As New FileSystemObject Dim objFolder As Folder...

Anyone with some sample code on this function? I have looked everywhere and cannot find anything that is MS-Access specific. Background I have an application where I want the user to be prompted to select an ODBC Data Source. I would like to then call this function to get some information...

I think the subject is pretty self explanatory but in case it isn't... I created a commandbar that has a control whose icon I would like to use as my application's icon (ie. top left hand corner). Is it possible to somehow reference that icon instead of referencing a file in my file system? The...

Can someone remind me how to create a copy of a form's current record (or recordset) without maintaining the reference to the underlying table? Basically I want to copy the current record before deleting it so I can reference some of the field values afterwards in order to perform other...

The SetWarnings action/method is used to turn system messages on or off. Is there any way (other than the use of module/global level variables) to check the system messages status? Background: I want to call a precedure that needs to turn the messages off in order to execute some code and not...

I have defined a public object variable in a form: Public TV As Object A button opens another form containing a treeview object. The user picks items in the treeview and then closes the form. When the form closes I set the public object variable to be the treeview object in the closing form...

I would like to create a menu item that when clicked opens a form and passes some information in the openargs. The following works perfectly fine in VB: DoCmd.openForm "My Form", , , , , , "My Args" I have tried to add it to my menu item OnAction property as...

Is it possible to make the treeview control transparent? I would like to add it to a form which has an image background. I want to set the lines to be white and the background transparent so that the image shows through.

Currently I have code in the form's BeforeUpdate event to notify the user if the record is dirty, telling them that they must save the record before proceeding. The event is then cancelled and everything works fine. The problem I need help with is that when the user tries to close a dirty form...

I have the need to call a form's (public) procedure from a function where the procedure name is passed as a parameter. I have managed to get this working using the EVAL function but the problem is that it runs twice. Does anyone know of how else this can be accomplished (without moving all of my...