Recent content by deweb

Thank you. For some reason when I set the Allow Data Entry = Yes as the subform's default, the text fields disappeared in the subform. (Go figure.) But, when I used the code you suggested, it worked! Have a star! Denise

Well, we're getting there. When I change the "Cycle" property to "Current Record." I can tab out of the main form without it attempting to save, but I'm unable to edit the subforms. When I include the code to explicitly inform the subform to allow edits, the main form...

I have a form for with two subforms that I use for data entry into my trainings database. The forms and subforms are bound and the tables are related. The main form has the following properties: Allow Edits = yes Allow Deletions = yes Allow Additions = yes Allow Data entry = yes The subforms...

Roy - You are my hero! You know you're right, 11.0 is 2003. I think I have Visio 2003 on my machine, perhaps that's how I have the library. Thank goodness it was only distributed in my office! Thanks so much. Denise

I have written function: Public Function IsOpen(ByVal strFormName As String) As Boolean ' Returns True if the specified form is open in Form view. Const conDesignView = 0 Const conObjStateClosed = 0 IsOpen = False If SysCmd(acSysCmdGetObjectState, acForm, strFormName) <>...

Thanks. This works great. Denise

Thanks. Have a star.

I have a report based on a parameter query that filters records by year. My question is this, is there a way to incorporate the year information into the report's title? For instance, if a user types the parameter &quot;2003&quot; into the message box, I would like the report title to read...

That makes sense. Thanks again. Denise

Have another star! It works great. Now, how do I get a &quot;grand total&quot; of the trainings into the report footer? Thanks. Denise

I have designed a report for my trainings database which is based on a query. The report is grouped by Organizations, then trainings, then the attendees (from that Organization) are listed, something like this: Organization 1 First Training Last, First Last, First...

Roy - This is just what I needed. It works perfectly. Thanks again. Denise

You are my hero!!! I got it to work with both the combo and the textbox controls. Now I'm going to try to all &quot;All&quot; to the combo box. Is there a way to do the same type of thing with the textbox? Right now if I leave the text box empty the listbox is empty. I know you are tired of...

Well, I don't know what I'm doing wrong, but the information in the listbox disappears when I add the MyFilterField field to the RowSource query. >:-< The name of my dialog form is &quot;GoToTrainingDialog&quot;, the textbox name I used was &quot;Text20&quot; and the combobox was...

Okay. Thanks.