Printable View
i want to create a fault logging system and
i dont know how a previous problem will be saved over and over again and stored for each PCs information
is this done automatically can i log all of the faults so i can view them in the future for each seperate computer xxx
Use a form bound to a table (record source) . This is what Access does easily with NO VBA code required.
i want to be able to store every piece of history of each PC forever
this will eliminate the long time of solving a problem of a PC because they can look at prevoius faults that happend and what they did solve the problem
What you want is also called a Help Desk or Knowledge Base or Support Ticket system.
I have done this type of application with Access. Access. I even integrate it into my Access applications. I have also down web based ones with ASP and a SQL server back end (not Access).
And if you do it in Access, you can upsize it later to MSSQL Server, if you need to scale it.
HTH,
Bill