Search results

  1. Wiz47

    MsgBox Style

    Okay, that answers my question - thanks.
  2. Wiz47

    Add New Record Button

    If this is the exact code you are using, then you have one too many commas before stLinkCriteria in the highlighted line of code. It should be ... DoCmd.OpenForm stDocName, , , stLinkCriteria
  3. Wiz47

    MsgBox Style

    Actually, this msgbox is set up with a Case Statement. I have an If before it and Case statements afterward. I just included a snippet of it here to illustrate for Dave that I don't need to "... require constants such as 16, 32, 48 or 64 to obtain critical, information, etc icons on the...
  4. Wiz47

    MsgBox Style

    As an example, I use this to verify information before a complete autofill on a form. It could use the vbInformation, or vbCritical, or vbExclamation and all would (and have) included the appropriate icon on the msgbox. I'm not sure I follow.
  5. Wiz47

    MsgBox Style

    And vbQuestion for the question mark in the baloon.
  6. Wiz47

    print single record (yes again)

    You're welcome. Now you can tweak it using CEH's code and see if you can get it to print from within the program instead of right-clicking in preview mode.
  7. Wiz47

    Add New Record Button

    That's the correct code to do what you described. It will open up the form and go to a new (Blank) record. Are you putting this code on the ONCLICK event for the command button that calls it?
  8. Wiz47

    list box - Who's on First? (the user's mouse-click?)

    That's pretty slick code. I have a use for that in something I'm working on. :)
  9. Wiz47

    print single record (yes again)

    Fixed. Now it will preview the current record. You had the PK control named wrong. You had named it as the command button and it should have been named ID (the name of the control in the form).
  10. Wiz47

    print single record (yes again)

    This will open a preview of the current record in the report you specified in the code. You can then right mouse click and choose Print. From there you can set up the printing in any manner you like.
  11. Wiz47

    how to count a list of items?

    Check your personal e-mail :)
  12. Wiz47

    Open Form to new record, etc.

    Glad to hear that you have it under control now. If you need some help with the report side, ask the question intelligently, let the board know what you have done already to resolve it, and chances are excellent that you will get a response. :)
  13. Wiz47

    Filter subform with multiple controls

    I'm glad to hear that you got it working. An answer to your question for future use - you could inner join the tables then use nearly the same WHERE statement to pull the data after that.
  14. Wiz47

    Subform / Query problem.. driving my crazy

    That's true Bob, the great rule of referencing forms.subform.subform of subform :)
  15. Wiz47

    Subform / Query problem.. driving my crazy

    Are you using ... Me.YourSubformName.Requery That should put the data in the subform on the form.
  16. Wiz47

    Reports requery

    Private Sub Report_Open(Cancel As Integer) On Error Resume Next Set frm = Forms!YourFormName If Err.Number = 0 Then With frm If !YourComboBoxName = "YourSelectionName1" Then Me.RecordSource = "Query1" ElseIf !YourComboBoxName =...
  17. Wiz47

    Reports requery

    You can requery the control on the AfterUpdate Event ... Me.MyControlName.requery
  18. Wiz47

    Dialog Form Not Clearing

    Me.refresh
  19. Wiz47

    How Do I get Rid of this Bar ? (PIC INCL)

    Record Selectors NO in the format properties for the form.
  20. Wiz47

    Filter subform with multiple controls

    SELECT YourTable.* FROM YourTable WHERE (([TableField1]=Forms!YourFormName!ControlName Or Forms!YourFormName!ControlName Is Null)=True) And (([TableField2]=Forms!YourFormName!ControlName2 Or Forms!YourFormName!ControlName2 Is Null)=True) And Keep going to include all of the controls that you...
Back
Top Bottom