Results 1 to 3 of 3
  1. #1
    Mynameissecret is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2022
    Posts
    1

    Week planner for work that sends out workplans via e-mail

    I dont know if someone can help me with this, but i give it a try. So I’m just started learning access because I want to find smarter and more effective solutions for myself when it comes to work.
    My first goal is to make an overview in access that let me set up a workplan with this type of info from different tables I made:
    Week (choose for example week 1,2,4 etc….)
    Building
    Vacancy rate building
    Monday (name of employee cleaning on that building. One employee can clean on many buildings, and many buildings can have one employee)
    Tuesday:
    Wednesday
    Thursday
    Friday

    I also want to figure out how many % of the building are filled, based on employees vacancy rate.

    And I want to automate data from this table into an workplan for each of mine employees, which automatically sends this (form. I think) to word and then I can sendt it to each employee via e-mail.

    This might be a lot to ask about, but I need some help.


    Thank you☺️

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    This might be a lot to ask about
    You got that part right and probably don't quite comprehend the scope of that work.
    Speaking for myself, sometimes similar requests are fulfilled because it involves charity organizations, although I cannot recall such an involved charity request. However, you are running a business and would probably make better use of your time running that and leave such things to paid developers. That is because the Access learning curve is quite significant and db's made without adequate knowledge of Access usually end up being big time kludges. We're not here to create apps for everybody, we're here to assist with issues in ones that have been started already.

    If you are determined to build your own, I'd suggest the following for learning the fundamentals. If you don't get normalization right you will continually have issues.
    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/

    Entity-Relationship Diagramming: Part I, II, III and IV
    http://rogersaccessblog.blogspot.com...ng-part-i.html

    How do I Create an Application in Microsoft Access?
    http://rogersaccessblog.blogspot.com...cation-in.html

    Important for success:
    Naming conventions - http://access.mvps.org/access/general/gen0012.htm
    https://www.access-programmers.co.uk...d.php?t=225837

    What not to use in names
    - http://allenbrowne.com/AppIssueBadWord.html

    About Auto Numbers
    - http://access.mvps.org/access/general/gen0025.htm

    The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
    Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
    About calculated table fields - http://allenbrowne.com/casu-14.html
    About Multi Value Fields - https://www.isladogs.co.uk/multivalu...lds/index.html
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Perhaps see if anything already exists, which you can at least adapt?

    https://www.google.com/search?q=acce...hrome&ie=UTF-8
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Work Week Calendar!
    By cap.zadi in forum Access
    Replies: 5
    Last Post: 10-10-2018, 02:43 AM
  2. Replies: 9
    Last Post: 06-19-2015, 03:37 PM
  3. Query help to summarize data by work week
    By saseymour in forum Queries
    Replies: 4
    Last Post: 07-18-2013, 07:29 AM
  4. Trying to get mail merge code to work
    By itm in forum Programming
    Replies: 0
    Last Post: 09-13-2012, 01:01 PM
  5. Replies: 10
    Last Post: 03-29-2012, 10:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums