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!

  • Congratulations gkittelson 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: *

  1. ReillyAlbany

    Big trouble automating sending mail from Word VBA

    [Ponder] Here is some code that I've used successfully in Microsoft Access. I think that it may be helpful to you. I put it in the On Click event of a button. I've used it with Lotus 5 and Lotus 6. Depending on your Lotus and Network security conditions, it may or may not be nescessary to...
  2. ReillyAlbany

    Print Record Question

    You can supress the printing of any object on a form. Heres how: Select the object > Right-Click > Select Properties > Select Format > Set the "Display When" property to "Screen Only".
  3. ReillyAlbany

    Creating a folder when new person added

    One way to list the contents is to simply open the folder using explorer. Here's code that can be placed on a buttons OnClick event: Private Sub OpenFileFolder_Click() On Error GoTo Err_OpenFileFolder_Click Dim stAppName As String Dim stFolderName As String stPathName =...
  4. ReillyAlbany

    Display SubForm Record Count On SubForm

    Couk - Thank you sooo much! I knew that there had to be a simpler way.
  5. ReillyAlbany

    Display SubForm Record Count On SubForm

    Where do you put this code?
  6. ReillyAlbany

    Display SubForm Record Count On SubForm

    Okay, I spoke too soon. After I posted my reply I went back to my subform and reset the Navigation Buttons property "No". Now the it doesn't work anymore. Apparently, it doesn't load the the subforms entire recordset until it has a good reason to. So now my question is.. How do I...
  7. ReillyAlbany

    Display SubForm Record Count On SubForm

    Darryles, Thanks for stepping up to the plate. Sorry about leaving that code out. I think I was exausted from wrestling with the problem. to answer your question, yes I tried a variety of statements on those events and nonthing worked. I think that the root of the problem lies in the fact...
  8. ReillyAlbany

    Display SubForm Record Count On SubForm

    I have a Form with a Subform on a the second Page of a Tab Control. The Subform displays 1 child record at a time for all related records. I want to show the total number of child records without using the Record Selectors. The Text Box that I'm trying to place the record count in is called...
  9. ReillyAlbany

    How move records between boxes like the built-in Wizards do?

    I want a form that works just like the first form seen in the Access "Form Wizard". It will use a Combo Box to populate a List Box. This is List Box 1. List Box 2 will be placed to the right of List Box 1. Records will be added or removed between the two boxes using arrow buttons...

Part and Inventory Search

Back
Top