Search results

  1. C

    hiding sub forms with no records in it

    if you've replaced [SubformName] with the actual subform name, then it should work for you. The code looks at the results in form's recordsource(RecordsetClone) and sets the visible property to true or false depending on the number of records returned.
  2. C

    loading blanks

    put the following code in the OnOpen Event for your form Me.YourComboBoxName=null or Me.YourComboBoxName="" You can do the same thing for any form fields as well. HTH
  3. C

    mutually exclusive UNION query

    I guess I could figure it out using separate queries and instead of citing reasons for doing it the way I have, I'll try to get it working using separate queries. Thanks once again
  4. C

    Requery main form vs. subform problem

    I'm noticing that your QueryDef may not be resetting your subform's recordsource either. I'm not completely sure of the procedure you've submitted, but couldn't you set the recordsource directly, therefore bypassing your query. SQL = "SELECT * FROM [Forecast] " & (" WHERE " + Mid(vWhere, 5))...
  5. C

    Requery main form vs. subform problem

    Double check your form names. What do have them called on the form. For instance, when a subform is dropped on the mainform sometimes it defaults to a "Child" name even when the form's named something else. Make sure this is not the case. frmMainFormName should be replaced by the actual name of...
  6. C

    mutually exclusive UNION query

    Pat, despite your warnings about subqueries, I had to use them for this application. As it stands, it's pretty quick and I think it will be O.K. because the database is relatively small (about 40 to 50 records). How many records would it take to slow the query down to where it would be...
  7. C

    Requery main form vs. subform problem

    Try the full reference name to the form... Forms!frmMainFormName.frmArchivesubform.Form.Requery instead of... Me.frmArchivesubform.Form.Requery
  8. C

    Query criteria

    I'm not exactly sure of the set-up, but perhaps if you've used the following criteria for your query... Like [forms]![formname]![dropbox] instead of... =[forms]![formname]![dropbox] I don't know if that helps. Let me know.
  9. C

    Calendar Control

    It worked! I can delete the command button now and free up some space on my form. Thank you again.
  10. C

    Calendar Control

    Rakier, I did what you suggested and I've found the Click Event for the calendar I'm using. I will give it a try and from what I can tell, that should do exactly what I need. Much appreciation for the advice!
  11. C

    Calendar Control

    I got it to work by adding an apply button to the form as you suggested. The apply button accomplishes the task. Because of space restrictions, I like to limit the use of command buttons as much as possible. Although this requires the user to make one extra step, the fact that is works is what...
  12. C

    Calendar Control

    O.K. I thought that I could get this to work w/o creating another control. Again, things work differently than I had expected them to. It seems odd to me how many controls need to lose focus before their values are updated. The control I'm using would work the way I need if it would update...
  13. C

    need a solution

    I'm unsure of the VBA you're doing and I don't know if you tried this, but if you get duplicate results, you can usually eliminate them by using the "distinct" keyword in your query Try... Select Distinct TOP 4 ... I would continue to work w/ your query if your'e trying to get the data to a...
  14. C

    Calendar Control

    Hello all, I'm trying to implement a calendar control to insert dates into a textbox that filters a subform on a range of dates. I've read that some people have used the OnClick Event for this control. However, the OnClick Event does not show up for the calendar 9.0 that I've inserted. I see...
  15. C

    Mail Merge 1 to many

    Got it O.k. I figured out the mail merge by record#. Goody, I can put that on my resume under the mail merge heading.
  16. C

    Mail Merge 1 to many

    Hello all, I'm trying to Mail Merge data from two tables into Word using a query. I made a query to join the two tables. As I look at it now, it seems that mail merge prefers to display data record by record while, in this situation, each Product has several Comonents which each show up as a...
  17. C

    Major Linked Forms Problems!

    Sounds fishy! 1.) You could check the recordsource for each of your forms and make sure you've included the linked field. 2.)If you're sure that you've included the linked field in each form's recordsource, then check the joins between the tables (in the form's recordsource, not the...
  18. C

    Carrying a value to a different field on a new record

    Sorry that wont work ...
  19. C

    Subform Validation

    Have you tried putting the VBA in the Form's OnCurrent Event instead? If not, give it a try and let me know.
  20. C

    method or data member not found

    I think I see your problem. Try... dim R as DAO.Recordset HTH
Back
Top Bottom