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 derfloh 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. 2ShotLatte

    Query Public Variable and Is Null Help

    Fo'gitaboutit. Word out the problem - was missing last bit of work WHERE (((tblStaff.HallID)=qryHall())) OR ((([tblStaff].[HallID]=qryHall()) Is Null));
  2. 2ShotLatte

    Query Public Variable and Is Null Help

    Greetings I have a query that uses a public variable (varHall). The query returns only records where tblStaff.Hall and varHall are equal. I also want the query to return all records if varHall is null. Here's what I've done so far, but I'm stumped after that. Select tblStaff.StaffID...
  3. 2ShotLatte

    Updating/Refreshing Subform

    I have a main form (Form1) with a subform. Subform displays selected data from Table1. The user would click on a command on Form1 to open Form2. Form2 and Subform use Table1. On Form2, the user would enter all data then close the form. Problem is Subform does not update/refresh. Any thoughts...
  4. 2ShotLatte

    Clicking in a Subform to launch another linked Form

    This worked for another fellow - Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "Form_Name_to_Open", , , "[Key_ID]=forms!Form_Name!Key_ID" End Sub
  5. 2ShotLatte

    Creating Pop Up Form

    Glad it worked. Good luck with the rest of your project.
  6. 2ShotLatte

    Filtered form/subform advice needed

    I have a form, frmRA. Users open form and select an employee from a combobox (made using the wizard, Combo86) this updates frmRA with employee data. frmRA has a subform, subfrmNote, that lists notes on an employee. Users can double click, which runs an On Double Click event (DoCmd.OpenForm), a...
  7. 2ShotLatte

    Creating Pop Up Form

    If I get what you're saying, you want to double click on a row in a subform to pull up information. I've use this on the "On Double Click" event. Private Sub Form_DblClick(Cancel As Integer) DoCmd.OpenForm "Form_Name_to_Open", , ...

Part and Inventory Search

Back
Top