Search results

  1. S

    Replace values of a column with another column by criterias in another table

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

    min/max functions for unbounded field without query

    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?
  3. S

    Hide all tables and queries with VBA

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

    update an image in image gallery

    Hi, is there any macro or code to update an image in image gallery? I know that it is possible with right click on images in gallery but I need to do it after saving with ACCDE file.
  5. S

    update an image and text in all forms by a setting form

    Hi, I have an access database with several forms and reports. I want everyone who have permission to setting form can update the image and title. I used dlookup in control source of image and textbox and it work good for textbox but the image work for the first time and not working when I close...
  6. S

    flicker,flashes form on mouse move event

    Hi, this is a form that change the color of fonts when mouse move on labels. But there is a problem with flash or flicker when moving the mouse on form. I used the echo off/on but no result for this problem. The sample form attached Please help
  7. S

    Shrik to fit or AutoResizeFont

    Hello, I have a report that has some textboxes with fixed size but some values are bigger than textboxes. so I find a code that change the size of fonts but there is a problem with empty fields. I attached a sample file that has two report, the first run good but the second has an error because...
  8. S

    autofill from unbound textbox

    Hi, this is an MS access file that shows pc information, I want after showing the pc information, automatic save cpu serial number in the table if it is empty. If it is not empty check both information cpu s/n and the table value, if they are equal open mainform if not equal open warningform...
Top Bottom