Search results

  1. P

    Open form with criteria from another form

    Anger management issues? Yes, that is extremely rude. You should not assume things about people, and remember, there are people behind these threads and people have feelings. I have been working on this problem for a long time. I have searched the help menus and the other forums. I am new...
  2. P

    Object Required Error Message

    Almost Thank you so much for the help. Sorry, I don't know very much VBA. I am much closer now, but when I click the command button I am prompted for parameter values for employee name and vendor name, but not for the date. Shouldn't it be getting those values from what the user has entered...
  3. P

    Object Required Error Message

    I have a form with subforms that people use to make orders. When the button on the switchboard is clicked to fill out a form, a new blank order form opens. I would like to make it easy for people to access previous order forms for editing. I tried doing this by creating another form where...
  4. P

    Open form with criteria from another form

    I used the where condition: stDocName = "frmAcquisInfo" DoCmd.OpenForm stDocName, (((tblEmpName.[Employee Name]) = Forms!frmedit!cboEmpName) And ((tblVendor.[Vendor Name]) = Forms!frmedit!cbovendor) And ((tblAcquisInfo.Date) = Forms!frmedit!txtDate)) When I click on the command button I get an...
  5. P

    Open form with criteria from another form

    I have a database that people use to place orders. I have a switchboard that opens a new form each time the order button is clicked. If someone wants to edit their order, they open another form where they enter their name, the vendor name, and the date of the order. I would like a button on...
  6. P

    print report command button

    One more thing Thanks ByteMyzer, that worked great. The only problem is that when I push the print command button, the screen goes to the report. I want the the screen to keep the form displayed so that people don't have to go back and forth to the report and the form. Thanks purplecruz
  7. P

    print report command button

    I have a command button that prints a report. When the user clicks the button, instead of automatically printing from the default printer, I would like the printer window to appear, so the user can choose which printer to use. Is there an easy way to do this? Thanks purplecruz
  8. P

    Update List Box

    I have a list box that has values I typed in. The user can choose one of these items from a combo box or type in their own value. I would like any values typed in to be added to the list in the combo box so that they may be used again. Is there an easy way to do this? Thanks, purplecruz
Back
Top Bottom