Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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