I am trying to find the highest value I have a site_number and a site_program_year. I need to find the highest site program year for each site number. I was told to use this DMAX("site_program_year","tblsss","site_number=" & "****")but all this is doing is pulling up the highest site program...
I need to create an expression that will allow me to pull largest value from field in a table. Can someone help me
The field name is site_program_year and the table is tblsss.
Thanks!
Hello,
I have created a delete selection in my combo box on my form. When I choose delete from the dropdown from the combo box in the form the job from both the table and the form should be gone.
Here is what I have thus far:
Private Sub Combo16_CmdOk()
If Me.Combo16 = "Delete"
Then...
I have this as my code
Private Sub Combo16_AfterUpdate()
If Me.Combo16 = "Completed" Then
Me.Date_Closed = Date
End If
End Sub
I have a form set up so that when a user selects "Completed that job dissapears from the form but is still in the table. However I have jobs that are completed but will...
All information I type in on my 1st Record in an Unbound text box is repeating on all of the other records in my form. I am trying to create a different job on each page and in the unbound text box I would like to enter a description of the job. So each record needs to stay empty until I write...
All information I type in on my 1st Record in an Unbound text box is repeating on all of the other records in my form. I am trying to create a different job on each page and in the unbound text box I would like to enter a description of the job. So each record needs to stay empty until I write...
All information I type in on my 1st Record in an Unbound text box is repeating on all of the other records in my form. I am trying to create a different job on each page and in the unbound text box I would like to enter a description of the job. So each record needs to stay empty until I write...
Help! I have movie clip called pages and all my pages are layed out as movie clips in different frames in the pages movie clip. I have placed buttons on each page created and want to link them to other pages. Does anyone know how I do this? Please help very frustrated!
I am creating a word template for my users and want to restrict them to use only certain colors and styles. Does anyone know how to restrict users from using these?
I am new to access and am creating a database that keeps tracks of the jobs in our department. My manager has asked me to create a combo box with: "In Queue", "In Progress", and "Completed". When completed is selected the date completed will be added to the job and it will automatically close...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.