Search results for query: *

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.

Great. I'll give it a try. Keep your fingers crossed. One more question. Should the combo or text control be bound to the MyFilterField field in the query? Thanks again. Denise

Hi Roy - You're an angel. I think my problem is that the trainings are listed in mmddyyyy format and I need to be able to enter only the year and filter the trainings. Possible? What's the proper syntax when I'm referring to the year in the combo or text box? Thanks again. Denise

This worked great. So well, in fact, now rather than just wanting to filter for the current year my boss wants the ability to filter by specific years. For example, all trainings for 2002 or all trainings for 2003. Is it best to do this using a combo box or a text field? How do I pass the...

What a genius -- And with so little to work with. Thanks so much!

I've developed a Trainings Database. I have a listbox on a dialog form that lists training titles and training dates. I'd like to filter the listbox to show trainings for only the current year (whatever the current year happens to be). Do I use the DateSerial function in the QBE? If so, what...