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 derfloh 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: BakerUSMC
  • Order by date
  1. BakerUSMC

    3 combobox values as query parameter

    Hello to all again.... Using the sql that PHV and post for me has been working great but I need to add an option to select all for each criteria. How would I add this to the sql? SELECT [orphans].[Active?], [sponsoring].[Sponsorship ID], [orphans].[Country], [orphans].[Orphan ID]...
  2. BakerUSMC

    Delete current on form that is based off query

    Thanks for your help anyways... I thought of a work around. I just had a delete button open another form that is based off the the actual table with the joined table as a linked subform. Then deleted the record. Works perfectly!!!!
  3. BakerUSMC

    Delete current on form that is based off query

    Thanks for the suggestion but I tried adjusting all the joins and nothing worked.... Any other suggestions? Thanks again
  4. BakerUSMC

    Delete current on form that is based off query

    The query does have 2 tables with 1 join... is there are workaround? Thanks
  5. BakerUSMC

    Delete current on form that is based off query

    Hello to all, I have a form that is based off a query. I have put a cmd button to delete the record but it only deletes from the screen. When I go to the actual table, its still there. I am not sure if the problem is because the form is based off a query or not. How would I be able to...
  6. BakerUSMC

    3 combobox values as query parameter

    PHV, You know, I was hoping you would answer my posting... because you have always been consistant with your correct responses to my problems... Thank you so much... My headache is now gone... You always deserve a star from me... THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!
  7. BakerUSMC

    3 combobox values as query parameter

    Hello to all, I have a form that contains 3 combo boxes. I need the value of the combo boxes be passed to a query that another form is based off of. 1st field passes a -1 or 0 to the query for a yes/no field 2nd field passes text for the country selected 3rd field is bases off a...
  8. BakerUSMC

    Passing Is Null or Is Not Null from VBA to Query Criteria

    Another question: If I have multiple parameters in the query, how do I ensure the calculated field will only refer to the field I need to know the Null values in? I have 3 combo boxes on frmViewOrphans that the user needs to select a value from. Sometimes it works with the right criteria...
  9. BakerUSMC

    Passing Is Null or Is Not Null from VBA to Query Criteria

    GingerR, Thanks for your help... Worked great and it was a simple solution. I haven't done that type of thing in a query before so it was a good learning experience for me. Plus... I posted this same question in the VBA coding forum and got 2 responses that didn't work... I appreciated...
  10. BakerUSMC

    Passing Is Null or Is Not Null from VBA to Query Criteria

    Hello to all, I have been searching these threads all afternoon, but can't find anything that comes close to what I need. I feel its a simple solution but just can't figure it out. Here's the situation: I have a form (frmViewOrphans) that has a combo box on it (cboSponsoredStatus). When...
  11. BakerUSMC

    Passing Is Null or Is Not Null from VBA to Query Criteria

    Hello to all, I have been searching these threads all afternoon, but can't find anything that comes close to what I need. I feel its a simple solution but just can't figure it out. Here's the situation: I have a form (frmViewOrphans) that has a combo box on it (cboSponsoredStatus). When...
  12. BakerUSMC

    Thru VBA, reference a field that is in query twice

    I believe so... I am requesting the user to enter a Sponsor ID and the query will find all records that have a Sponsorship ID from the Sponsoring table and any records with a matching Sponsorship Id from the Sponsoring_options table...
  13. BakerUSMC

    Thru VBA, reference a field that is in query twice

    PHV, Thanks for your post... I tried what you suggested and also tried to incorporate that into my If/then clause but when I ran the form, I got the following error: The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation Object...
  14. BakerUSMC

    Copy a record to another table before deleting the record

    PHV, Thanks again for your posts... this was another issue I needed help on and sure enough, there you are with the answers... BakerUSMC
  15. BakerUSMC

    Thru VBA, reference a field that is in query twice

    I can't because its needed to update the fields in its table and both tables are linked by the Sponsorship ID field....
  16. BakerUSMC

    Thru VBA, reference a field that is in query twice

    No, I only need the (Sponsorship ID) from the (sponsoring) table to do that calculation that I need... THanks
  17. BakerUSMC

    Thru VBA, reference a field that is in query twice

    Hello to all, I have a form (frm_paymentform) that has a subform (subfrm_paymentform_payment) on it. On the Form_Load event of frm_paymentform I have the following code: If DCount("[Sponsorship ID]", "qry_paymentform", "[Sponsorship ID]=" & Me.[sponsoring.Sponsorship ID]) <> "0" Then...
  18. BakerUSMC

    Add year(s) to current date

    PHV, Thanks so much for your quick help... It worked perfectly... You've always been a big help for me and others... You definitly deserve a star!!! Thanks again!!!!
  19. BakerUSMC

    Add year(s) to current date

    Thanks for your quick responses... In the field 'Term of Sponsorship' where the user selects either 1 Year, 2 Years and so on... The value stored in the table for the field is 1 year or 2 Years... there is no numerical value stored. How can this be done?? Thanks again
  20. BakerUSMC

    Add year(s) to current date

    Hello to all, I have a form that contains the fields 'Term of Sponsorship', 'Start of Sponsorship' and 'End of Sponsorship'. In the field 'Term of Sponsorship', the user picks from a combo box either, 1 year or 2 years, or 3 years and so on... In the field 'Start of Sponsorship', the...

Part and Inventory Search

Back
Top