Please help-have no clue - two major problems -related?

[jsonne]

Please all of you have been great in the past but I am ready to jump off cliff - can someone help?

1. Under Forms - Contacts I keep getting an #Error for number of calls (it is supposed to total from the CallListingSubform)

2-When I go to my Reports for Weekly Call Summary and put in dates its not giving me any - it is supposed to be based on the Forms - Contact CallListingSubform - NextCallDate

Would need to send zip file as I really am out of my element here.

Thanks.....

 

[bobbio]

...
2-When I go to my Reports for Weekly Call Summary and put in dates its not giving me any - it is supposed to be based on the Forms - Contact CallListingSubform - NextCallDate
quote]

Do you mean that you're putting dates in your query for your report? If so then you may need # before and after the date.

 

[jmersing]

Kind of hard to visualize your problem.
Sounds reapirable though
Zip it on over

jmersing@comcast.net

Jim

 

[jsonne]

Okay solved problem 1



problem 2 - okay hope i can explain this correctly

have a table called Calls

have a form called Call Listing Subform - which has the "NextCallDate" the control source is just that "NextCallDate" and this form is in my main form called "Contacts"

have a form called Report Date Range which controls the form when I click on Weekly Report via the Switchboard and a box comes up for beginning and ending dates which are supposed to be connected to the "NextCallDate" in my main form-i.e., if i put in begin 7/1/04 and end 7/30/04 it should give me all the calls i need to make for that time period - it worked before but has now stopped and don't know why

This is the code I have in my main form Contacts

Private Sub FirstContactDate_AfterUpdate()
Me.Call_Listing_Subform!CallDate = FirstContactDate.Value
End Sub

Private Sub NextCallDate_AfterUpdate()
Me.Call_Listing_Subform!NextCallDate = NextCallDate.Value
End Sub

Thanks for any help
[/code]

 

[jmersing]

I'm not sure I totally understand but it sounds like the query is not working properly. Can you find the source query and run it seperate from the form? If it fails to return anything it is not going to do it on the form either.

I usually take a different approach and build in the the references to my forms right in the query. i.e.

select *
from tblweeklycalls
where calldate between forms.Myform.Startcalldate & " " and forms.Myform.Endcalldate & " "

I mean you can do it on the form, just my preference. Check that query manually and see what it is doing.

 

[jsonne]

ray:
To the one who bailed me out. Thanks again!