User Profile

Collapse

Profile Sidebar

Collapse
edsuk
edsuk
Last Activity: Jan 26 '10, 06:51 AM
Joined: Jul 16 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • edsuk
    replied to MS Access Calendar
    in Access
    hi ADezii

    1) Yes I did have to modify this line to the UK date format. Thanks for the heads up on this - would have taken me ages to figure out otherwise.
    2) I do have a reference to both DAO and ADO in my Db with DAO being higher, good to know that you spotted it for for future reference.
    3) OK
    4) Yes, always good to perform this action periodically.
    5) Significant update - I think not LOL

    Again...
    See more | Go to post

      Leave a comment:

    • edsuk
      replied to MS Access Calendar
      in Access
      hi ADezii

      I have made one very insignifficant mod to the populateCalenda r sub.

      Which you may like or not to include in the future.

      the mod is at line 74

      Currently:
      Code:
      If bytBlankBlocksAfter > 6 And bytBlockCounter > 35 Then
   ctlDayBlock.Visible = False
End If
      Amended To:
      Code:
      If bytBlankBlocksAfter > 6 And bytBlockCounter > 35 Then
   ctlDayBlock.Visible
      ...
      See more | Go to post
      Last edited by NeoPa; Jan 25 '10, 11:42 PM. Reason: Please use the [CODE] tags provided

        Leave a comment:

      • edsuk
        replied to How do I stop my vba code from continuing to surround my comments with parentheses?
        in Access
        Just for curiosity, why are you using the 'LostFocus' event, surely it would make more sense to place this sub procedure in the 'AfterUpdate' event. So that the code only runs after the data has been modified?
        See more | Go to post

          Leave a comment:

        • edsuk
          replied to MS Access Calendar
          in Access
          ADezii

          Thanks for the Calendar Db, exactly what was required. Really appreciate all your help.

          And regarding the comments from NeoPa, thanks and yes I do understand Normalisation and Table Structures and agree that this goes against the grain, but the EmployeeTbl has less than 20 records - so I stand by my comment that space is not an issue in this particular Db.

          Cheers and thanks ADezii once again.
          See more | Go to post

            Leave a comment:

          • edsuk
            replied to How to uncheck the check boxes in a single click
            in Access
            Hi

            Amend it to:

            Me.requery
            See more | Go to post

              Leave a comment:

            • edsuk
              replied to MS Access Calendar
              in Access
              ADezii

              Totally agree and I don't. The table actually has EmployeeFirstNa me and EmployeeLastNam e as columns. Plus the full name which is not displayed in the form but gets updated when either of these two records get data entered/modified.

              Having the full name in addition does make displaying the information easier when it comes to combo boxes, list boxes etc as saves having to concatenate the data every time I write a query...
              See more | Go to post

                Leave a comment:

              • edsuk
                replied to MS Access Calendar
                in Access
                ADezii

                Thanks for the update, I am not asking you to do my coding for me, you have done the 'hard work' already in providing the calendar/schedule functionality.

                I can modify the code for populating the calendar controls and the list box myself.

                I have been searching for a long time for an Access calendar like this and am so grateful that you have provided this for others to use.

                Once done I will...
                See more | Go to post

                  Leave a comment:

                • edsuk
                  replied to MS Access Calendar
                  in Access
                  Hi ADezii

                  Missed your earlier reply due to time difference, UK vs USA.

                  Anyway, really appreciate your offer to help, the data is held in only two tables, I have only included relevant columns:

                  T_Job:
                  JobID PK
                  JobNo
                  EmpID FK
                  StartDate
                  ReqDate

                  T_Emp
                  EmpID PK
                  EmpName


                  T_Job
                  24 'JN132' 204 '10/01/2010'...
                  See more | Go to post

                    Leave a comment:

                  • edsuk
                    replied to MS Access Calendar
                    in Access
                    Hi ADezii

                    We are definitely not the same !

                    Thanks for replying on this subject. I have spent ages trying to find a solution like this. Actually the calendar option I would prefer is the 'Date Range' option where the task can span a number of days or even may be just the one day.

                    As mentioned a version in Access 2000 or 2002 would be so much appreciated.

                    Once again, thanks.
                    See more | Go to post

                      Leave a comment:

                    • edsuk
                      replied to MS Access Calendar
                      in Access
                      I have been asked to provide a calendar facility within an Access database. I have looked at a number of threads on this subject and Adezii has included a database as an attachment.

                      If an Access 2000 or 2002 version could be attached it would really be appreciated.

                      Thanks in advance for any help you are able to provide.
                      See more | Go to post

                        Leave a comment:

                      No activity results to display
                      Show More
                      Working...