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 bkrike 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: 2ShotLatte
- Content: Threads
- Order by date
-
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...- 2ShotLatte
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
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...- 2ShotLatte
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
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...- 2ShotLatte
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
