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 SkipVought 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: Jn88
  • Order by date
  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
  16. Jn88

    One label filling entire sheet of labels?

    Put this code in the Detail onFormat Event: If FormatCount < 30 Then Me.NextRecord = False 30 stands for the amount of labels you want to print Hope this helps if not let me know Jn88 Jn88@att.net
  17. Jn88

    Help in Command Bar

    I don’t know how you want to use your help file but I would do like this Add a new menu and in the property’s in the on Action put in the function name like this: =CallHelp() and write a function in a module &quot;CallHelp&quot; and from there call the help file. Hope this helps if not let me...
  18. Jn88

    Need help renaming a table to be tablename+current date

    use the docmd.rename function Hope this helps if not let me know Jn88 Jn88@att.net
  19. Jn88

    How to print the previous page's sum

    In the footer onFormat event save the total to a variable Hope this helps if not let me know Jn88 Jn88@att.net
  20. Jn88

    Export Access Forms to VB Forms

    The forms I think is not possible but most of the code should work in VB Hope this helps if not let me know Jn88 Jn88@att.net

Part and Inventory Search

Back
Top