Did anyone of you heard before CMMS? Can access able to generate a CMMS?
I need a expert to help. Thanks.
Did anyone of you heard before CMMS? Can access able to generate a CMMS?
I need a expert to help. Thanks.
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.
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.
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
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
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
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.
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
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?
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.
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.
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.