Thank you very much. How can I change the date-format in the results?
2 2014-08-18 12:16:53
Topic: Search between dates (3 replies, posted in General)
I have a table with a DATE field, and I would like to make a search between two dates.
I guess I must use an SQL QUERY action, but how can I refer to a date from a DateTimePicker object in the SQL query?
3 2014-08-12 13:05:00
Re: SQL query to poppulate a tablegrid (3 replies, posted in SQL queries)
Thank you for your answer.
I added id in the query, like you suggest but I received an error: ambiguous column name: id.
I changed it to Scheda.id, but now when I try to edit a record after searching, I get an Access violation error (attached picture).
Any idea?
Also: thank you for the delete_col tip!
4 2014-08-12 09:25:58
Topic: SQL query to poppulate a tablegrid (3 replies, posted in SQL queries)
To make a search and to fill a tablegrid in the main form, I use an SQL query.
After searching, if I try to edit a record, I get an error (Unable to determine the record ID). What is my error?