Search results

Hello, No, What I want now is to display the value-All- in the top of my columns. I know how to do it when I have a single column in a table. This can be done using an "Union" query. For example if i have this: StudentName ------------- John Lisa Zac And I apply this quey: SELECT StudentName...

Hello, And if i want to show the "-All-" value in all fields using the union statement, what i'm going to add to this: SELECT CustomerID, CompanyName FROM Customers UNION Select Null as AllChoice , "(All)" From Customers ORDER BY CustomerID; ??

Do you mean, that if I use your code, I must delete the where clause in my query?? Also I didn't understand your code (sory I'm still beginner in VBA).

When I open: AllaQuery: It displays All the records because it's a Select * from Student; CompleteQuery depends on the selected items, because i put in the where condition: ... Where ([MyQuery].[MyField]=[Forms]![MyForm]![MyList]) When I tested my queries it worked, also when I tested to put...

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...

Thank for your Help. The code you gave me is in VBA, I prefer to work with macros (because I am poor in VBA). when I feed my listbox from a sql query like: select Mark from student; and in macro "open form" executed by the button, in the where clause I put: [MyQuery]! [Mark] = [Forms]...

Thank you very much. This code Works perfectly. Thank you. No, I just meant what you gave me in the first code. But it's good if i need to make my application more beautiful ;). But I have another control on my form, listbox that allows me to choose records, I want to add in the top of the...

Thanks. Yes it works, but i think that it eliminates Null records bcause of the Nz. I tried to use it without Nz, but it gives errors.

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...

Yes i'm opening a query where I have only the field of Names

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...

Yes it's a text datatype in SQL Server This code supposes that i've already a date datatype field no?? Also I didn't see in it where i can put my field's name??!! So can u tell me how to apply it?? (Sorry i'm not very good neither in Access nor in VBA)

I think that DateSerial can resolve my problem, but what I've noticed is that I must give a specific date to the function and it changes values one by one, thing that i can't do beacause I've to change the format to all data by using only one query.

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, Thanks for your response and your help. For now I just converted my database to *.accdr in order to set it in the read only mode. I think that the idea of ​​splitting the DB in FE and BE is good but I do not know how to do it.

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...

Good morning and thank you for your answers. Yes I tried to put my database in *. Accde mode but it allows the user to see the forms in creation mode, so they can change them. For the *. Accdr (runtime) I tested it, it meets my needs but when I launch the database, I see a message that is a...

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.