Search results for query: *

Nevermind. My frmDataEntry was too large, which is where the error was being encountered. I split it into two, so now everything is working fine. Thanks!

I get this error message: Compile error: Out of memory The code is incredibly simple, and I'm running with more than enough memory to support it (my indicators say I'm using less than 47% when this is being run): Private Sub cmdConfirmExistingData_Click() Sheet9.Visible =...

Thanks for the response! I especially appreciate the free sarcasm & belittling you included. Much appreciated.

Well, I actually have the same question, so is there any way you could post your solution? Thanks!

Can anyone tell me if it's possible and, if so, how to password-protect all VBA in a given project so as to block users from being able to meddle? A common task, I'm sure, but I've never had to even think about doing it before as most of my Excel VBA has been for me or my immediate reports...

I have a form with (literally) HUNDREDS of entry fields. I've programmed the form with a standard naming convention, so all input fields are of the form: txt_R_Description_## (for text boxes) chk_R_Description_## (for check boxes) Description is of varying length, as is ## (though ## is...

I'm creating a user form as a sort of report, and I'm wondering if it's possible for a user to print the form? I know I can print the image from the VBA Editor window, but can the user do the same through his/her view? Thanks!

what events, exactly? This will happen in a form when a button is clicked.

I'm lost trying to figure out how to require the user to save a workbook as something else when a certain event occurs (e.g.: Private Sub cmdConfirmNewData_Click() 'NEED TO BRING UP THE SAVE AS DIALOG BOX End Sub ) Help is very appreciated! ::Bryan

I'm lost trying to figure out how to require the user to save a workbook as something else when a certain event occurs (e.g.: Private Sub cmdConfirmNewData_Click() 'NEED TO BRING UP THE SAVE AS DIALOG BOX End Sub ) Help is very appreciated! ::Bryan

This does the trick - thanks! The next problem is back in the For . . . Next loop. Public Sub Command6_Click() Dim tempSQL As String Dim ctr As Integer Dim count As Integer ctr = 1 count = 1 For ctr = 1 To NumGps tempSQL = "" tempSQL = "INSERT INTO...

I'm creating a program which, in one functional requirement, asks the user to enter a number, say n, into a form. This number will be used to append 'n' records to an existing table, where the primary keys are JobID and RowID (being {1,2,...,n}). JID is computed as the concatenation of date...