Search results

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

I have a form defined in which I prompt the user to select an ODBC data source using code similar to the following: Dim wrkODBC As Workspace Dim conPubs As Connection ' Create ODBCDirect Workspace object. Set wrkODBC = CreateWorkspace("NewODBCWorkspace", "admin", "", dbUseODBC) Set conPubs =...

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

I have created a function (below) that opens a form (whose name is passed to the function in a variable) and passes in an argument (whose value is also passed to the function in a variable). Public Function doCmdOpenForm(formName As String, openArgs as string)...

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

When I use the EVAL function to execute a procedure in a form it executes the procedure twice. Does anyone know of a workaround or a fix for this? For example: On Click: =eval(Form_AfterUpdate) where Form_AfterUpdate is a public procedure. I tried to use the EVAL function in a popup menu...