User Profile

Collapse

Profile Sidebar

Collapse
Yannt
Yannt
Last Activity: Apr 11 '12, 07:29 PM
Joined: Feb 19 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Yannt
    replied to Query Nightmare
    in Access
    I'll try to be more precise. I need to create a student roll for each club which will display training dates for a term. Each club has different training day (some clubs have 2 training days, and some only 1). The report will need to display the different training days for a 3 months period and list the student belonging to this club.

    The training days are based on a selected first day (parameter) and the known training days for the...
    See more | Go to post
    Last edited by NeoPa; Feb 27 '12, 08:59 PM. Reason: Removed quote

      Leave a comment:

    • Yannt
      started a topic Query Nightmare
      in Access

      Query Nightmare

      I'm stuck into something I thought would have been easier that this....

      I've got 2 tables
      1. tblClubs (clubID, ClubName)
      2. tblTrainingSess ions (sessionID, ClubID, Weekday)
      Note: Weekday is the day number (Mon=1, Tue=2, etc).

      I need to create a roll for each club.

      i.e. Club Alpha has training sessions on every Tue and Fri. I need to generate the following report (1st day is a parameter...
      See more | Go to post
      • Yannt
        replied to Inefficient Loop
        in Access
        FindFirst works like a charm, speed gain is great. Thanks for your help.

        Yann
        See more | Go to post

          Leave a comment:

        • Yannt
          replied to Inefficient Loop
          in Access
          Thanks for your answer Smiley. Qry1 is no longer required (I forgot to delete it from the code). The table structure is quite complex and can't be changed at this point of time.

          I'm not sure to understand how to use the "find first" and "find Next" option, could you please give me more details?

          Thanks
          See more | Go to post

            Leave a comment:

          • Yannt
            replied to Inefficient Loop
            in Access
            I did, but got an error: "Operation must use and updateable query"; hence why I used the recordset.
            See more | Go to post

              Leave a comment:

            • Yannt
              started a topic Inefficient Loop
              in Access

              Inefficient Loop

              Hi,

              I'm trying to simplify and make this piece of code more efficient (basically would like to remove the 2nd loop); any suggestions?

              Thanks
              Yann


              Code:
                  Dim db As Database, rst1 As Recordset, rst2 As Recordset, qry1 As String, qry2 As String
    Dim intCurrentProgress As Integer, intTotalWidth As Integer, intProgressBarMax As Integer

    q = MsgBox("Are you sure you want
              ...
              See more | Go to post
              Last edited by Rabbit; Feb 20 '12, 05:26 AM. Reason: Fixed code tags
              No activity results to display
              Show More
              Working...