asked on
create command button for data entry
I want to create a query logging system (query being a question asked by a customer who calls in)
I want to be able to capture each customer's questions in a table, but I do not want to over-write the previous question asked by that same customer - I want to be able to keep a log of all the questions asked so that I would be able to track whether the customer's questions have been attended to and the query closed (similar to a help-desk ticket system)
The customers already exist in the database, so there details are already in the system.
I want to do all of the above by clicking on a command button on a capture form.
Thank you.
I want to be able to capture each customer's questions in a table, but I do not want to over-write the previous question asked by that same customer - I want to be able to keep a log of all the questions asked so that I would be able to track whether the customer's questions have been attended to and the query closed (similar to a help-desk ticket system)
The customers already exist in the database, so there details are already in the system.
I want to do all of the above by clicking on a command button on a capture form.
Thank you.
Databases
Last Comment
Pavel Celba
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you so much, pcelba!
I don't know much about databases, just the very basics, like creating forms, etc. but I know nothing about making the form interactive and usable - this is obviously where the coding comes in.... and here my rocky road begins...
I am looking at some basic programming tutorials and online courses. I do realize that it is not going to be easy, but I am very keen and very excited to learn!
Thank you for the tips and advice; much appreciated.
I don't know much about databases, just the very basics, like creating forms, etc. but I know nothing about making the form interactive and usable - this is obviously where the coding comes in.... and here my rocky road begins...
I am looking at some basic programming tutorials and online courses. I do realize that it is not going to be easy, but I am very keen and very excited to learn!
Thank you for the tips and advice; much appreciated.
Author expressed thanks without question closing so I've finished it.
Yes, programming is not my strength (yet); I am new to all of this and I am still learning. After some internet searching, it is pretty obvious I will have to use some form of coding.
I do not want to use a pre-built system created by someone else; I will persevere and I will build my own system.
Thank you