Search results

  1. L

    Create a Due Date on a Form based on two other fields?

    Hello, Hoping someone will help me with my problem. I have a small Tickler Access Database just to keep track of customers and follow-ups on different things. I need to create a Due Date from the [Last Date] and then another field which will contain number of days [Days] that they want the...
  2. L

    Access 2016 Database-Options are changing

    Hello, Thank you both. This is not split, one database on the Shared Drive. Usually only 2 people use it but the Mgt Database is using these tables as well and there are 2 people that use that on a shared drive. I proposed splitting the database to Mgt a few months ago, and they declined but...
  3. L

    Access 2016 Database-Options are changing

    Hello, Our Access 2016 Database Option sometimes changes for no apparent reason. I have a navigation panel that is set in options to open with a form when a user opens the Database, I have it set on a tabbed view, and all my objects show. Occasionally, upon opening the Database, the user no...
  4. L

    Working Remotely with Access DB on Company Network

    I will let you know and like I said I might be back for help with code...you all are truly wonderful and I am so glad we have this forum to get help. Lilly
  5. L

    Working Remotely with Access DB on Company Network

    Thank you all for your help, so I am going to try using the hard-line connection to my router, I just need to order the cable to do that, and I will also try a different navigation panel with what was suggest above by CJ, but may need your help with the code--I am a novice with code and get most...
  6. L

    Working Remotely with Access DB on Company Network

    You have given me a lot to think about. Thank you. This is temporary but could go through to the end of the year. My forms are based tables. I will go through and index those fields you mentioned. Most of my combo boxes are based on tables with not a lot of data. But the forms that are most...
  7. L

    Working Remotely with Access DB on Company Network

    Yes, front end on local and back end on network for this DB. Should all databases be set up this way when you have multiple users? We are all working from home with COVID so we are logging in with our RSA tokens and accessing the Network and I am using my personal WIFI to do that. We back up...
  8. L

    Working Remotely with Access DB on Company Network

    Hello, I was just wondering if anyone could offer any guidance on working remotely and using 2016 Access Databases that are on our Company Network. I have a front-end on my local drive and the back-end is on a network folder as there are a few of that use the Database. It is extremely slow and...
  9. L

    Code for Business Hours -Help Please

    Good morning all, I did check the regional settings and the are correct. I decided to create a new database, and imported my objects from the other into it just in case something was wrong with the one I was using. I also created a new module and copied the code again within the new...
  10. L

    Code for Business Hours -Help Please

    Hi, I am home, opened Access on my home computer, just a blank database, created a module and added your code and it is working...so my question is … could there be something wrong with my Database...I wonder, that I am using at work...do you have any suggestions? ? TotalWorkHours (#8/1/2019...
  11. L

    Code for Business Hours -Help Please

    Hi again, I will do this when I get home, I can't download anything on my company laptop for security purposes. I will do this and let you know what I find out. Again, appreciate all your help... Lilly
  12. L

    Code for Business Hours -Help Please

    Hi, I did see your post, and I have no idea what is wrong...I copied and pasted your code into a new module and am not getting the correct hours for some of them like you are...I have no idea why...any ideas? Lilly
  13. L

    Code for Business Hours -Help Please

    Oh my, I just don't know...I copied and pasted the code just as you have it and am only getting 2...I have no idea why that is. Lilly
  14. L

    Code for Business Hours -Help Please

    The code given by Arnelgp is working great just not on one of the dates...and not sure why that is, it's strange... ? ExtractionHours (#8/1/2019 8am#, #8/2/2019 9AM#) 10 should be 9 but yet this works... ? ExtractionHours (#8/1/2019 10am#, #8/2/2019 9AM#) 8 Thanks again, everyone ...
  15. L

    Code for Business Hours -Help Please

    Hello there, Thank you for trying, it works if it is within the same day, but if they are different dates it does not...see below-1st example: ? TotalWorkHours (#8/1/2019 3pm#, #8/2/2019 10AM#) 2 -should be 4 ? TotalWorkHours (#8/1/2019 3pm#, #8/1/2019 4pm#) 1 Thank you for trying to...
  16. L

    Code for Business Hours -Help Please

    to answer Mark's question...we would only enter in the start date and time and then the finish date and time, we don't need to allow for breaks, if the person doing the extract needs to stop for another reason, they can keep track of that on their own...but in most cases, once we start the...
  17. L

    Code for Business Hours -Help Please

    Hello, I know, I don't mean to frustrate you and I so appreciate your help. Sorry. We work from the earliest of 7am to the latest of 5pm. We do extractions any time of the day. We get a request from the customer they need an extraction, so I would log in to the DB when I started which...
  18. L

    Code for Business Hours -Help Please

    The 9am is when we started the Monarch Extraction if that is what you are asking, not when we came in. We are trying to gauge the amount hours it takes to do an extraction for a customer.
  19. L

    Code for Business Hours -Help Please

    Hi, Some in my group come in at 7am and some at 8am and we are all paid for 8 hours, we are all salary so we don't punch in and out, most of us work 9 hours a day and some leave at 4 and some at 5...so is this what you are asking? Lilly
  20. L

    Code for Business Hours -Help Please

    Thank you again for all your help...so with this new code, I now get the 13 hours and all the others look correct too, except the first one, see below...and it was correct with the other code, I got 9 hours...now it is 10. ? ExtractionHours (#8/1/2019 8AM#, #8/2/2019 9AM#) 10 (8 hours day 1...
Top Bottom