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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Murphette

  1. Murphette

    Limiting Record Number in Subform

    Hi All, I used your suggestion, TheAceMan1, in the Current Event of the subform, but the basic issue persisted. When I fill one class to the max, and then move to another record in the main form (i.e. another class) the subform shows only the field headings, and there is no opportunity to...
  2. 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...
  3. Murphette

    Error 461 Method or Data member not found

    pbaldy, You're the best...you saved me. Thanks a bunch. And SoCalAccessPro, my bound column in the combo was ok, and yes, the attended field is boolean. I was able to successfully add a record using the bang. I appreciate all the help.
  4. 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...
  5. Murphette

    Time of Day in DCount Criteria

    The light has dawned...I forgot to format time as time. TOD = #7:30:00 AM# worked nicely.
  6. 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...
  7. Murphette

    Unbound Control in Page Header

    Mystery solved... The SetValue action was carried out after the report opened and that's too late for the values for the controls to appear on the first page. I appreciate your time Ginger, your posting got me thinking about sequence of actions, and Bingo! Thank You...
  8. Murphette

    Unbound Control in Page Header

    I even created a new unrelated query to serve as the domain of the DCount function...and it still won't show on page one. The mystery deepens....
  9. Murphette

    Unbound Control in Page Header

    All the other controls in the report page header are visible on all pages of the report, including the label of my troublesome unbound control. The report opens via a macro with two actions: 1) open the report (and filter records in the where statement) 2)set value of the unbound control named...
  10. 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...
See more

Part and Inventory Search

Back
Top