In my form frmDemographics there is a subform named frmActionNotes. For each record in frmDemographics there is an action note. The subform within the form works well, but I need to be able to open the the content of the subform in a new window. I am able to open a form (named...
I have a query that calls up the following module:Public Function SendSubscription(StartMonth As Integer, Frequency As String, CheckMonth As Integer) As Boolean
Dim F As Integer
Select Case Frequency
Case "Monthly"
F = 1
Case "Quarterly"
F = 3...
I have a form that gives the parameters to a paraemeter query. What I want to do is make a report from the results of the parameter query. How do I tell the report that I want it to use the results of the query?
Thanks,
Shannon
When I put a Date in a field called sDate I want a field called StartMonth to automatically set its value to the coresponding Month as an Integer. So if the sDate value is 9/12/1999 I need the StartDate value to be set to 9. Should I use an "on lost focus" event procedure? Any ideas?
Thanks...
SkipVought was kind enough to write the following code for me:
Function SendSubscription(StartMonth As Integer, Frequency As String) As Boolean
Select Case Frequency
Case "Monthly"
f = 1
Case "Quarterly"
f = 3
Case "Semi-Annually"
f = 6...
I am trying to use the DateSerial expression in a query to find out who is up on a given month to recieve a newsletter. The subscription period frequencies are "Monthly", "Quarterly", "Semi-Annually", and "Annually". The period starts whatever month the customer subscribes to the newsletter...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.