Search results for query: *

What is the easiest way to use if....else statements in an excel macro to skip sections of a macro if the file for that section isn't open or doesn't exist? An example of a section of the macro is as follows: Windows("als.xls").Activate Cells.Find(What:="RECORD...

I am using the following macro to find a selected range, however the macro only copies the first cell from the 'find' statement not the entire range that is highlighted. Any ideas? Sub Macro4() ' ' Macro4 Macro ' Macro recorded 9/25/01 by hclark ' Cells.Find(What:="broker&quot...

I am attempting to open a form on a {on_click} event where the Project # on the form to be opened will be that of the Project # on the form currently open and have set the following procedure: Private Sub cmdTeams_Click() On Error GoTo Err_cmdTeams_Click Dim stDocName As String Dim...

What would be the method for creating a text file from a table where some of the information in the table is variable lengths (i.e. currency) but the text file starting character positions for those fields is fixed? (Example: The text file needs the currency field to occupy positions 11-25 but...

What is the easiest way to add a field from a current record to another table in the same database through form entry. I only want new (unique) records to be added. (Also, the field is created through a 'hold table' that stores a 2 digit yy reference and a 4 digit numeric incrementing string.)

I have a script written to import a fixed text file into an access table, but while the script will acknowledge the row count and add those rows to the database table, it does not post the fields to the table. (All rows/fields are blank.) What am I missing in this script to copy the information...