Results 1 to 12 of 12
  1. #1
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43

    Cmms

    Did anyone of you heard before CMMS? Can access able to generate a CMMS?



    I need a expert to help. Thanks.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Like any acronym, it could have several meanings but I know it as Computerized Maintenance Management System. I worked at a company which may have been a pioneer in that discipline as their in-house built software was first released in (I think) 1991. I would not profess to be an 'expert' in the subject since I hold those people in extremely high regard for what they accomplished. In fact, when I went to maintenance conferences, it was obvious that the company's reputation was known across the world. By the time I left many years later, the expenditure on the software was in the $10 million ballpark. Not sure if that's useful info for you.

    Yes you could build such a system in Access, but IMHO, it would be ill advised if any failures in data or software security would be catastrophic to the business, or if the number of concurrent users was high. I certainly would not entertain the idea of using Access to build a marketable program.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Hi Micron,

    You got any ideas, any other than access. What software i can generate CMMS?

    My concurrent users was low. As i'm the only one that using and create it. But in future i still not sure. For security i still not sure yet.

    Thanks for the info.

  4. #4
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    I'm not a program language expert by any means (best I know is VBA for Access and a smattering of html).
    My answer would be, any program that you can write code in a different software language such as C, C++, C#. The program I referred to was created in Powerbuilder.
    If you are not experienced in any of these, you'd be looking at an enormous learning curve unless you contract it out.
    Last edited by Micron; 10-25-2016 at 09:44 PM. Reason: spellin

  5. #5
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Hi Micron,

    Sorry for late reply. I like to learn more on access. As i was allow to create my own access in my workplace.
    Where r u from? If i have a difficulty on this how can i contact you and discuss?

    Thanks

  6. #6
    AccessPower's Avatar
    AccessPower is offline Competent Performer
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    165
    Perhaps trying something like Python would be optimal if you are new to programming. It is fairly easy to learn. And there are libraries for connecting to access available:

    https://wiki.python.org/moin/Microsoft%20Access

  7. #7
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    That sort of direct contact is against forum rules, I think. Not sure I understand your meaning. I cannot teach you Access if that's what you mean. I/we can help with specific issues and/or direct you to learning resources if that's what you're asking.

  8. #8
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Hi Micron,

    Sorry i'm new here. Didn't know the forum rules. It's good to have more learning resources from all the expert here. Wish i can gain extra knowledge in access

  9. #9
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Currently i had an issue, i wish the date can be auto update the column that i keyed. As i enter date(), it will appear only at the new line. Is there any possible the keyed row will auto updated in access?

  10. #10
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    You would have to be more explicit about your meaning and what you are doing. If you are editing or entering data directly in the tables, this is not good practice.
    If you're using the Date() function to auto populate a table field by setting that field to have a default entry of Date(), this only applies to new records, which is not what updating is. If you want some date field to become the value of Date() each time you edit a record, you will have to use a query and have the form apply this update or maybe a macro step can do this. I don't know because I don't use macros.

    It sounds like you can use some links to learn more about Access. Maybe look at some of these, and find a website with video tutorials. There's LOTS of learning info out there. I strongly advise to do this before diving in to creating a database. What none of these links mention is one 'rule' that I follow, and that is, queries come before forms. If you go to all the trouble to design a form, then a query to make it work, the form is useless if you then find the query isn't updatable but needs to be.

    Normalization is paramount. Diagramming maybe not so much for some people.

    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.ca/...on-part-i.html

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

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

    Important for success:
    One source about how to name things - http://access.mvps.org/access/general/gen0012.htm
    What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
    About Auto Numbers
    - http://www.utteraccess.com/wiki/index.php/Autonumbers
    - 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
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  11. #11
    Jeremy Sng is offline Advanced Beginner
    Windows 7 32bit Access 2016
    Join Date
    Aug 2016
    Posts
    43
    Hi Micron,

    As I understand table is always a must in access. But to input date() in queries I a bit lost. Don't know what formula I should input. The below example.

    Example: datediff('h',[lastdate],[date()]). When I open the queries again It will prompt me to enter the date. Will I need to put =date()? Same I don't use macros too. Cause I feel it difficults to use it.

  12. #12
    Micron is online now Virtually Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If you haven't solved it already, post the sql of your query and explain what [last date] is and what the prompt message is. Can't tell if is a table field or not. That is likely the reason for the prompt. Sorry for the delay - I'm away on vacation.

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

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