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 set up a custom icom to run that particular macro and it will select the desired area but only copy the initial cell.

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 attempted all suggestions but to no avail. The ProjectNo is a text field and the control source is a query. When I used the last suggestion for the 'text' field I didn't receive an error and the subform did appear. The record appearing in the subform was not the same as in the main form...

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 changes would need to be implemented to move two fields from the form over to another table. For instance, what if I wanted to move the ProjectNo and System fields from the Project form to the testing table? The above code that I am using is only moving the ProjectNo field from the...

That worked for the warning, but now there is a new issue. The following code: Private Sub Form_AfterUpdate() Dim rst As Recordset Dim strSQL As String DoCmd.SetWarnings False strSQL = "Select * from Projects where ProjectNo= '" & Me!ProjectNo & "';" Set rst =...

With a few minor tweaks....that fixed it, but how do I turn off the "you are about to append 1 record" warning?

The tables are Projects and Testing and the field name for both is ProjectNo. The reason I used the term unique is because I only want new ProjectNo(s) added to the Testing table from the form Project that feeds the table Project. I do not want an entry when the form is merely editing...

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

That has resolved all problems and the table information is importing properly Thanks...

I attempted to move the rst###.Update statement directly below the loading of the fields but I receive an "Update or cancel Update without AddNew" error.

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