Recent content by saqassemi

Could you upload it as an access file.

Thanks all. I know a query can replace values of fields. For example there are 3 fields. I replace data of column 1 with data of column 2 ... I want a query to look at tblSubjects for replacing. There is a picture attached to say what i want simpler. Thanks for your times.

Mr Ranman256, Thanks for your reply. Could you attach a sample access file.

Hello every one. I am developing a database for our schools and I have to change arrangement of subjects every year because of some reason from ministry of education. So I have a table to enter scores and a table to arrange subjects titles for every year and grades. There is a query that...

Thanks all friends for your times, solutions and advices. I attached two access files in post NO 12. There is a report in each one and there is a text box in each report with same function to find max. One works normal but another one shows ERROR. Now I want to find cause of error, if one of you...

Dear Colin and Dock man: I know the file I attached has one table and it is not possible to use for several years and grades and ... And I used relationships in my database. The file I attached is a basic sample for you to help and solve my problem. I attached two file in post NO 12 please...

Thanks all: Dear JHB :cool:no it is not secret. I summarized my posts. I know it is possible to hide access tabs, navigation pane and disabling bypass but As you know tables and queries aren't secure and every one can import them (even they are hidden by using right click and navigation option)...

Thanks for your attention. Here I attached two files. in one the function works good but in the other one it shows ERROR. Thanks for your advice but I must do it in a report in some reason.

Mr JHB and other friend, thanks a lot for your attention. I have another problem like this thread you solved for me. I want to count fields with values for each record and then find max of them. Here I attached a file. If you open the query it finds the count and max of entered scores for...

Oh, very thanks. May you share a link that learn combination of access functions with samples.

Hello to every one, This is a simple file and I want to find maximum of the total field (unbound field). I know it is possible in query to get total and max and use them in a form, but is it possible in a form without using a query?

Mr. Colin thanks for your attention. Yes I do too, I hide all access options, disable bypass and save as ACCDE. But it is easy to import hidden tables in a blank database. I want to make my db one level more secure by completely hide tables and queries with the code attached at the start if...

Thanks Colin for your help. Your attached file work good and hide all tables but it is possible to unhide with Navigation Options. The file that I attached work for one table and it is impossible to unhide with Navigation Option. So thanks if you help me and complete the code in my attached file...

Hi, this is a sample access file that hide and unhide one table by clicking commands button in frmSetting. Don't forgot to press F5 to refresh after hide or unhide. Please complete the code to hide all the tables and queries by one click. Thanks for your help.

Dear arnelgp, thanks for your help. You are the best.