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!

  • Congratulations bkrike 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: *

  1. ShannonSkipper

    How do I open a subform's content in new window?

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

    d

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

    Reporting results of a parameter query?

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

    Determining Month as Integer from Date

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

    How do I use this Module in a query???

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

    DateSerial Expression in a Query

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

Part and Inventory Search

Back
Top