Search results

Hello, In a form, I have a listbox displaying the marks. In the header of the list box I have displayed the value "--All--" based on a union query. So my listbox looks like: --All-- 18 05 13 13 02 I wanted to give the user the ability to select multiple values ​​in the list, So in the...

Hello, I have a column Mark where I type students' marks. In a form I want to display those marks in a list box.But i want to display only if the mark <10 or >= 10 to simplify the filters. To do this I feed the list box (Mark) from a query where I put the following SQL: SELECT DISTINCT...

Hello, I put a text box in an Access form where the user must enter a name, and click on the Validate button. then it appears in a new form all the information corresponding to the record having that name. I want to put All as default value for the text box. So when the user clicks OK without...

Hello, I'm establishing a connection from access to a SQL Server DB. It is impossible for me to change the tables' structure (fields, types ...) yet I have a field that is text and I want to display it in a form in date format (dd / mm / yyyy ), I read in some publications that it must be...

Hello, I connected my Access database with SQL Server via ODBC. Once changes are made, I desire that the data (tables) is automatically updated in Access. I tested by pressing the F5 button, it worked sometimes, but I think it is not an effective solution especially when i convert my database...

Hello, I'm working in Access 2010. I created a database that I want to post in a server on the read-only mode, so that users can not change forms or querys. How can I do this in Access 2010? Thank you for your help.