Search results

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.

It is clear that the ACCDE file is not editable and I don't want to edit an ACCDE file. I have an ACCDB file and I am making a Settings form. My Setting form can change the font, font size, color and ... and I want to add another options like changing logo of all forms and reports by one click...

Yes so I want to know is there a macro or code to update an image in all forms without using design view. And there are many codes that change all designs in forms not in design view.

Thanks for your attention, I want only who can access the setting form can change the logo and title. It is possible with subform but Is there an easiest way with dlookup? I used dlookup for an attachment field in a table and it work good but after closing and reopening the database it doesn't work.

Yes. I designed a database for schools. so every school wants to put its logo and title on the forms and reports. i want to make a form with the name of Setting to change the titles and logos in all forms and reports.

Hi, (insert image) in form Design Tab. when inserting some image it shows a title with the name of (Image Gallery)