Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: BGumm
  • Order by date
  1. BGumm

    Excel VBA - Out of Memory Compile Error

    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!
  2. BGumm

    Excel VBA - Out of Memory Compile Error

    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 =...
  3. BGumm

    Excel 2007 VBA - Password Protecting

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

    Procedure too long

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

    Excel 2007 VBA - Password Protecting

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

    Excel VBA - Wildcards Allowed?

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

    Excel VBA - Printing a User Form

    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!
  8. BGumm

    Excel VBA - Calling Save As Dialog Box

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

    Excel VBA - Calling Save As Dialog Box

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

    Excel VBA - Calling Save As Dialog

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

    Dynamic SQL Composition

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

    Dynamic SQL Composition

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

Part and Inventory Search

Back
Top