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!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Lynne41

  1. Lynne41

    Working day difference between two dates

    Thanks RoyVidar - that's solved it! Thanks to everyone for helping me with this. You've all been tremendous. I'll leave you in peace now!
  2. Lynne41

    Working day difference between two dates

    Thank you mstrmage1768 - you are fantastic! It works perfectly with the exception of 3 Bank Holidays which it is ignoring for some bizarre reason. These are uk dates of course but it is ignoring: 9 Apr 04 ("9/4/04"), (12 Apr 04 ("12/4/04") and 3 May 04 ("3/5/04")...
  3. Lynne41

    Working day difference between two dates

    Hi Michael I tried to use your code but I have Access2000 which didn't recognise the dim dbs as Database or the FindFirst or Nomatch method. As you can gather I have a very basic understanding of VBA and don't know how to get round this in Access. I changed tactics and changed over to a...
  4. Lynne41

    Working day difference between two dates

    Thanks for your help Rollie but it is still only counting one day less on the working days (ie 8 April 2004 to 9 April 2004 counts as 1 day when it should be 2). Also it is still not including bank holidays that are in the table. I've even tried american dates in case it was that but where...
  5. Lynne41

    Working day difference between two dates

    Hi Rolliee I have tried to work this function and have added the relevant UK dates. However this works on a form when called in the Control Source on the calculating no of days field, but am not sure if this is the right place to call? Also It works when there is one bank holiday but where...
  6. Lynne41

    Working day difference between two dates

    Its ok I've sorted it by calling the function in the Control Source of the txtDays field. Thanks for your help on this mstrmage1768. Lynne
  7. Lynne41

    Working day difference between two dates

    Hi Thanks for this - still doesn't work though. The fields I have on my form are: cmbStart1 (unbound cmbo box that brings up Active X Calendar) - this is my start date cmbEnd1 (as above) - this is my end date txtDays - this is where I want to put the difference in working days between...
  8. Lynne41

    Working day difference between two dates

    Thanks mstrmage1768. How would I apply to my fields on the form though? Where would the code go on my form and how would I declare the variables as my Start, End and Number of days fields? Thanks Lynne
  9. Lynne41

    Working day difference between two dates

    Hi I am trying to calculate the working days difference between 2 dates. I have set up a calendar form to do this which will enter the dates and date difference in a table by inputting into unbound combo boxes which bring the calendar up when clicked. Whatever dates and date difference is in...
  10. Lynne41

    Importing Objects from CD (D: Drive)

    Thanks Dean and Andy - I'll give these a try! What a pain Access 2k has so many bugs! Lynne
  11. Lynne41

    Importing Objects from CD (D: Drive)

    Hi Dean Thanks for your reply. I have copied over the the C: drive but there seems to be no check box with the read only option described. I cannot get into the Dbase properties - error message "Access unable to load database properties". In the past I have just created a new db...
  12. Lynne41

    Importing Objects from CD (D: Drive)

    Hi I have imported forms in from a CD and now the VBA code doesn't work on any of the command buttons. When I change the form it also won't let me save - it just doesn't do anything (no warning msg) How can I resolve this and why does this happen? Thanks Lynne
  13. Lynne41

    Appending data from one worksheet to another

    Hi ETID Many thanks for the macro. It wouldn't work as it was saying variable wasn't defined so took out the "Option Explicit" from the top of the VBA sheet. It then wouldn't work with the "Stop" in your code but did when I deleted the word ("Stop"). Bizarre! I...
  14. Lynne41

    Appending data from one worksheet to another

    ETID Cool - that would be great! I am currently playing round with the Query facility as this seems to work! Haven't tried to get it into a macro yet though!
  15. Lynne41

    Appending data from one worksheet to another

    ETID This kind of works but you can't put the calculated field (to select only those comments that belong in the 1 or 2 grade catogory) in until you have created the pivot. It also won't let me select only those grades with 1 or 2 as it selects all grades but just puts them into order of...
See more

Part and Inventory Search

Back
Top