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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Jn88

  1. Jn88

    Progress Meters?

    Look for help on the "SysCmd" function (in access help) Hope this helps if not let me know Jn88 Jn88@att.net
  2. Jn88

    Password Generation

    use the time and date Hope this helps if not let me know Jn88 Jn88@att.net
  3. Jn88

    Is this possible?

    You don’t have to use subreports you could make a UNION query and base the report on that query. Hope this helps if not let me know Jn88 Jn88@att.net
  4. Jn88

    Auto report printing

    Send me your email address and I will sand you an example attachment Hope this helps if not let me know Jn88 Jn88@att.net
  5. Jn88

    How do I close a combobox after using dropdown command

    Send me your email address and I will sand you an example attachment Hope this helps if not let me know Jn88 Jn88@att.net
  6. Jn88

    Auto report printing

    Set the timer interval to 60000 and in the timer event check the time property if it is equal to 7 PM Hope this helps if not let me know Jn88 Jn88@att.net
  7. Jn88

    How do I close a combobox after using dropdown command

    I said “it is a trick” there is actually no way of closing the combo box but by sating the combo box enabled property to false and then back to true it will close itself, I hope you get it. Hope this helps if not let me know Jn88 Jn88@att.net
  8. Jn88

    Auto report printing

    Make a hidden form with a timer Hope this helps if not let me know Jn88 Jn88@att.net
  9. Jn88

    Values not appearing on printing of report

    don't put it in the Activate Event put it in the open Event Hope this helps if not let me know Jn88 Jn88@att.net
  10. Jn88

    Query and update a datasheet hi,

    Update the recordSource from the Sub Hope this helps if not let me know Jn88 Jn88@att.net
  11. Jn88

    How do I close a combobox after using dropdown command

    It's a trick ! cmb.Enabled = False cmb.Enabled = True Hope this helps if not let me know Jn88 Jn88@att.net
  12. Jn88

    Lock one record and dont alow other user to modify

    Set the forms record looks property to "Edited Record" and then use this in the forms current event (StartIssue is one of my fields) Private Sub Form_Current() On Error GoTo InUse_Err If Not IsNull(StartIssue) Then Me!StartIssue = Me!StartIssue Me.Refresh End If Exit Sub...
  13. Jn88

    Reports Open in Preview but not all data displays

    Maybe the page alignment is not good Hope this helps if not let me know Jn88 Jn88@att.net
  14. Jn88

    Print multiple reports

    Public Sub PrintReportCopys(Amount As Integer) Dim i As Integer For i = 1 To Amount DoCmd.OpenReport "ReportName", acViewNormal Next i End Sub Hope this helps if not let me know Jn88 Jn88@att.net
  15. Jn88

    One label filling entire sheet of labels?

    Don’t put the code in the property window! Select event procedure and invoke the code builder and past the code in the code window Hope this helps if not let me know Jn88 Jn88@att.net
See more

Part and Inventory Search

Back
Top