+ Reply to Thread
Results 1 to 51 of 51

Creating Error tracker database

  1. #1
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Creating Error tracker database

    Hi Team,

    I would like to create a new database for mainintaining and updating error done by team.

    Attached is the sample sheet of the front page where I would update all the fields and also it should get updated in the database. Also I would also need an option to retrieve the data whenever required.

    Thanks in advance as always!!
    Attached Files Attached Files

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    What kind of errors?
    I don't think the tag line explains your question. An error is something that happens while programming, I think that you're asking to register bug-lists of system errors in an incident register.
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi keebellah. This is a like internal tracker to track the mistakes done by the members of my team.

    It is basically a databasr to be maintained by each team leaders.

    I just want to create and save the mistakes done in my team throughout the year.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Where is the database? In what format is the database? You have not provided enough information about how you expect this to work.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi Aligw,

    In my sample sheet the columns that I shown in the main sheet should be considered as database. Values will be entered on all these columns and it should be saved in the background.

  6. #6
    Valued Forum Contributor dotchiejack's Avatar
    Join Date
    05-21-2015
    Location
    Antwerp,Belgium
    MS-Off Ver
    2016
    Posts
    507

    Re: Creating Error tracker database

    Hi,
    Do you mean something like this?
    See attached.
    Attached Files Attached Files
    Click the * Add Reputation below to say thanks.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    OK - let me try again!

    1. Where are the values coming from? What might they look like?
    2. What do you mean by "in the background"?
    3. What do you expect the two buttons to do? Can you please mock up manually examples of (a) data entry and (b) the results of pressing the buttons based on that sample data.

    We are not mind-readers.

  8. #8
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Creating Error tracker database

    @ dotchiejack

    Your Calendar is showing Dutch month names.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  9. #9
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Quote Originally Posted by dotchiejack View Post
    Hi,
    Do you mean something like this?
    See attached.

    This looks extremely at high end but what I would require is basically the form.that u have and also if I have to retrieve the data.

    All the values will be typed manually and it should be saved in the background. I am not sure where the data are getting saved in the sheet.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Quote Originally Posted by bakerman2 View Post
    @ dotchiejack

    Your Calendar is showing Dutch month names.
    Not here, Rudi - they are in English. It will depend on the user's locale, I believe.

  11. #11
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi @Aligw

    1. Where are the values coming from? What might they look like? --- I will type them manually
    2. What do you mean by "in the background"? - I meant that the data should be saved somewhere in the spreadsheet so I can retrieve them cumulatively if I need them.
    3. What do you expect the two buttons to do? Can you please mock up manually examples of (a) data entry and (b) the results of pressing the buttons based on that sample data.
    If I click update data - the data that I updated in the spreadsheet should get updated and saved in a database.
    If click retrieve data, the data should be retrieved from he database.

  12. #12
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    I cannot see what is wrong with the solution offered in post #6. Have you actually tried it? The database is on the second tab.

  13. #13
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Quote Originally Posted by AliGW View Post
    I cannot see what is wrong with the solution offered in post #6. Have you actually tried it? The database is on the second tab.
    Hi Aligw, that is really good but it is very high end that I require.

    I would need a simple macro so I can understand the codes behind the form.

    I am not an expert in Excel codings.

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Neither am I, but everyone can learn. What does it not do that you would want to change?

  15. #15
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Quote Originally Posted by AliGW View Post
    Neither am I, but everyone can learn. What does it not do that you would want to change?
    Well it adds the data however there should be some permission that certain persons to access the database.

    Can u modify that. Also please confirm if whatever we add in the form does that gets saved in database automatically?

  16. #16
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    It's looking like and extensive project, you get a finger and then you want the whole deal.
    Have looked at simple free CRM (Call Registration Management) tools? They might be an overkill but the basics are there and will do exactly what you want and you van even set up permissions and reporting etc.
    I suggest you take that path.
    There have been posts for similar questions so if you do an advanced search with different search criteria you might find what you need and then anyone here can help you customize it.

  17. #17
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    I am sorry, I am really not getting your point.

  18. #18
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    Have you even looked ?

  19. #19
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi yes I looked call monitoring system. It was the same form as in post 6.

    But what I need is a simple code that I can understand and modify to my original data.

  20. #20
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    I think you need to share with us the layout of the data as you would expect to see it in your database. What columns (fields) would it need to have? You won't get code you can easily update unless you give us more specific details.

  21. #21
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    Yes, I see the table but no FORM, I'll think of something and send you if when it's done.

  22. #22
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Thank you so much I will wait for the updated one.
    Last edited by AliGW; 04-15-2019 at 11:22 AM.

  23. #23
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Quote Originally Posted by AliGW View Post
    I think you need to share with us the layout of the data as you would expect to see it in your database. What columns (fields) would it need to have? You won't get code you can easily update unless you give us more specific details.

    Hi Aligw,

    The spreadsheet that I gave you is the data I want in the database. May be a simple form, with all these details.

  24. #24
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    Well, that is all I have for you.
    I don't think you realize all that comes along with it if you really want something workable.
    This is just quick and dirty no extra options, the first 4 (four) textboxes MUST be filled for the button on the form to work
    Attached Files Attached Files

  25. #25
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    I just opened it and I don't see any macro in the file.

    Can you please check if you have attached the correct attachment.

  26. #26
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

    For normal conversational replies, try using the QUICK REPLY box below.

  27. #27
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    The attachments is the correct. There are no macros to open the form you must do that

  28. #28
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    I placed a new button on the sheet and removed the ones you had

  29. #29
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233
    Hi keebellah, Thank you. So in this whatever that gets updated in the user will get automatically added to the Excel correct.

    I am looking like a similar kind of execl.like this.
    Attached Files Attached Files
    Last edited by AliGW; 04-15-2019 at 12:21 PM.

  30. #30
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    This macro has option to show spreadsheet that enables whenever required we can retrieve the data.

  31. #31
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Arunkumaramk - I have asked you not to quote unnecessarily. Please stop doing so. Thanks.

  32. #32
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    Like I said there are many ways and versions

  33. #33
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi keebellah,

    Agreed. Can umodify the code in the format I shared with you. That would be more be helpful for me.

  34. #34
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    A simple request with with a lot of work.
    If I have the time I will try, but I suggest you start learning how to do this yourself so that you do not have to depend on others

  35. #35
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Thank you.

  36. #36
    Valued Forum Contributor
    Join Date
    03-24-2014
    Location
    England
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    575

    Re: Creating Error tracker database

    Or.... an alternative if you don't want to learn:

    https://www.excelforum.com/commercial-services/

  37. #37
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    The problem with Commercial Services at the moment is that those who have been helping there have not been receiving their money from the forum owners. There seems to be a bit of an impasse, so I would not recommend it at the moment.

    Arunkumaramk - I am going to say this plainly so that you understand. What you are asking for really goes beyond what you can reasonably expect from volunteers in their spare time. It's an entire project, not just a bit of help and a push in the right direction. Your VBA skills simply aren't up to managing any solution offered without coming back here repeatedly for help. In other words, your expectations of this completely free forum are too high. You would be far better served doing what was suggested in post #16.

  38. #38
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Hi Aligw,.

    I am not pushing here anyone to my needs. I am just asking for a help here. As suggested I did search and found a code that is similar to what I am looking for.

    Atlast Keebellah replied that he will do it if he has time however for that I replied thanks. I did not ask an update after that in this topic.

    Please do not judge or comment. This is an open forum where we discuss doubts that's y we have a forum I believe. If there is no suggestion received from anyone that's fine. It is their volunteerment to help.

    So please do not comment anything without u know about me.

  39. #39
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    So please do not comment anything without u know about me.
    I am commenting based on what I have learnt about you in this thread. My comments stand. I am merely saying that what you see as 'help' is a lot more than just that. However, if you will not be advised, that's fine. You will need to take your chance and hope that someone is happy to take on the project.

    Good luck!

  40. #40
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    Aligw - if you don't like to help on this, please ignore and please stop commenting on others. I believe this is a not a forum to fight and share your thoughts.

    Thanks

  41. #41
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    I am trying to help you. I have no desire to fight anyone.

    Keebellah said this:

    A simple request with with a lot of work.
    If I have the time I will try, but I suggest you start learning how to do this yourself so that you do not have to depend on others
    Did you understand what he meant?

    You said this:

    I would need a simple macro so I can understand the codes behind the form.
    I am not an expert in Excel codings.
    If Keebellah does produce a solution for you, it will not be just a simple macro. It's extremely likely that the coding will be at a level beyond your capabilities (I mean you no disrespect by saying this). The solution will work, of course, but what then happens if something goes wrong later?

    This is why it was suggested that you might be better looking at the simple, free CRM tools that are available. I do hope you understand what I am saying.

  42. #42
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    This is what I made of it, for the next step well, follow Ali's advice
    Attached Files Attached Files

  43. #43
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    A minor extra change which you need, and there are many more things I know you will be asking but with the present code you can work on from there.
    Added the option to edit an existing record, just click the record in the listbox and test it
    Attached Files Attached Files

  44. #44
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    Like I mentioned in one of the first posts there will always be additional options and wishes, getting ahead of you I also expect that you would like to mark an error completed and finished, so I added two more columns for Completed and if Completed the date completed.
    Enjoy and hope you can put it to good use
    Attached Files Attached Files

  45. #45
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Creating Error tracker database

    Well it adds the data however there should be some permission that certain persons to access the database.
    @ Keebellah

    You missed this one.

  46. #46
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    LOL: True, forgot about it, but that my friend would be based on assumptions, whom is whom and how is the OP planning to do this.
    Wonder what comes up next

  47. #47
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    As the OP has not been back since late yesterday afternoon BST, I strongly suggest you do no more now until you have had some feedback. What you are doing is very kind.

  48. #48
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Creating Error tracker database

    I know, this was the last one, since I thought it was a missing step in it all.
    The rest is for a developer

  49. #49
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    Agreed - this is what I was trying to get through to the OP earlier. Thank you for all the support you've given him.

  50. #50
    Forum Contributor
    Join Date
    11-29-2018
    Location
    Chennai
    MS-Off Ver
    MS office 2010
    Posts
    233

    Re: Creating Error tracker database

    @keebellah,

    The last post list is exactly what I required. THANKS A LOT !!!

  51. #51
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Creating Error tracker database

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] help creating a better household spend tracker
    By Custhasno in forum Excel General
    Replies: 5
    Last Post: 03-04-2018, 11:39 AM
  2. [SOLVED] Creating a leave tracker
    By kalidindi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-19-2017, 10:32 AM
  3. Creating A Sales Team Tracker
    By khelmore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2017, 10:21 AM
  4. Creating a project tracker
    By sorensjp in forum Excel General
    Replies: 8
    Last Post: 01-17-2017, 05:45 AM
  5. Need Help Creating Bar coded Attendance tracker
    By jazwill89 in forum Excel General
    Replies: 1
    Last Post: 07-17-2014, 10:00 AM
  6. Creating an attendance tracker, Help
    By jsquarity in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2014, 12:01 PM
  7. Need help with creating an attendance tracker.
    By ksmith8128 in forum Excel General
    Replies: 1
    Last Post: 02-26-2014, 12:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1