Hi,
I am willing to do the grunt work with figuring out why my own programming doesn't work correctly, however, when bringing a copy of the database file home from work to modify on my own computer, the code hangs up on the DATE command in the macro because "Compile Error: Can't find project or library." I use Access 2007 at work and Access 2000 at home. I feel however I am doing stuff basic enough not to worry about the two different versions. Further explanation of what the macro does is below but this was my basic problem and I need to know if and how I need to somehow redirect Access to look on MY computer for the library rather than what I think its doing, which is looking at a path that only exists at work and not on my computer (ie, a network drive instead of my C: drive). Thanks!
I have a macro that determines whether a user's input Due Date and Time makes their order/request an ASAP or not. If the requested service is due within 4 BUSINESS hours, its considered an ASAP (meaning the request is needed As Soon As Possible). The macro will calculate and suggest a due date/time of 4 business hours in the future and ask if that is acceptable. If not, it is considered an actual ASAP request. ASAP requests require the user to get someone from our support group to enter the request for them, forcing them to notify us of ASAP requests in person, and not just in the computer. That way they can't 'sneak' in an ASAP and we get to ask why it has to be ASAP and whether 4 business hours will suffice, etc.
Anyway, apparently my code isn't calculating the 4 business hours properly in certain situations, like around 3pm, when some users swear the calculated suggestion of 4 business hours from moment of entry is LATER than if they just waited until opening time the next day and make the request. That is, for example, waiting until Wednesday morning opening (next day) to make the request gets the desired service SOONER than requesting it at 3pm Tuesday (the previous day).
I am willing to do the grunt work with figuring out why my own programming doesn't work correctly, however, when bringing a copy of the database file home from work to modify on my own computer, the code hangs up on the DATE command in the macro because "Compile Error: Can't find project or library." I use Access 2007 at work and Access 2000 at home. I feel however I am doing stuff basic enough not to worry about the two different versions. Further explanation of what the macro does is below but this was my basic problem and I need to know if and how I need to somehow redirect Access to look on MY computer for the library rather than what I think its doing, which is looking at a path that only exists at work and not on my computer (ie, a network drive instead of my C: drive). Thanks!
I have a macro that determines whether a user's input Due Date and Time makes their order/request an ASAP or not. If the requested service is due within 4 BUSINESS hours, its considered an ASAP (meaning the request is needed As Soon As Possible). The macro will calculate and suggest a due date/time of 4 business hours in the future and ask if that is acceptable. If not, it is considered an actual ASAP request. ASAP requests require the user to get someone from our support group to enter the request for them, forcing them to notify us of ASAP requests in person, and not just in the computer. That way they can't 'sneak' in an ASAP and we get to ask why it has to be ASAP and whether 4 business hours will suffice, etc.
Anyway, apparently my code isn't calculating the 4 business hours properly in certain situations, like around 3pm, when some users swear the calculated suggestion of 4 business hours from moment of entry is LATER than if they just waited until opening time the next day and make the request. That is, for example, waiting until Wednesday morning opening (next day) to make the request gets the desired service SOONER than requesting it at 3pm Tuesday (the previous day).