Search results for query: *

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...

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...

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.

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...

The light has dawned...I forgot to format time as time. TOD = #7:30:00 AM# worked nicely.

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...

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...

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....

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...

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...