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 Chriss Miller 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: deweb
  • Order by date
  1. deweb

    Can edit data in subforms

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

    Can edit data in subforms

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

    Can edit data in subforms

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

    Missing: Microsoft Office 11.0 Object Library!

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

    Missing: Microsoft Office 11.0 Object Library!

    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) <>...
  6. deweb

    Dynamic Report Titles

    Thanks. This works great. Denise
  7. deweb

    Dynamic Report Titles

    Thanks. Have a star.
  8. deweb

    Dynamic Report Titles

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

    Trouble with Group Counts

    That makes sense. Thanks again. Denise
  10. deweb

    Trouble with Group Counts

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

    Trouble with Group Counts

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

    Okay. Thanks.
  16. deweb

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

    Filter Listbox by Current Year

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

Part and Inventory Search

Back
Top