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 dencom 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: Murphette
  • Content: Threads
  • Order by date
  1. Murphette

    Limiting Record Number in Subform

    I have a main form (F-BMSClasses) with a subform (F-BMSAttendance). The main form displays one of the possible classes students can be registered for, and the subform displays who is registered or allows more to be registered. In the subform Current Event, I placed this code to limit the...
  2. Murphette

    Error 461 Method or Data member not found

    I am working on a form where schedulers can pre-register staff into upcoming classes. I keep coming up with the error message 461 with the code I have so far. What am I missing? Private Sub Add1030() 'Code to add a record to T-Class Attendance if the scheduler chooses the 10:30AM class. 'New...
  3. Murphette

    Time of Day in DCount Criteria

    I frequently use form controls that have DCount expressions as their control source, but this has me stuck. This returns an error message no matter how I edit the syntax: =DCount("StaffID","qryCPRDates","TOD = '7:30 AM'") This control is supposed to show how many staff have registered for the...
  4. Murphette

    Unbound Control in Page Header

    I have an unbound control in a report page header whose control source is a DCount function. It works perfectly well, giving me the correct calculation...except it never displays it on the first page. The correct calculation is on page two and all subsequent pages. I could almost live with...

Part and Inventory Search

Back
Top