Search results

I have a main screen that has a tabbed form in it. Each of those tabs has a sub-form in it that displays information and allows some information to be updated. In one tab I have a query based sub-form that returns information related to the project. This information cannot be manipulated...

Can anyone tell me how to create a calculated field that does the following: I have a table that has about 4000 records in it. An asset can be listed in the table multiple times but I need to change the a status to "Dead" if any record with the same asset id has an action of "Kill". Any...

I am trying to get the max of an integer field if the ProjectNumber field is equal to the ProjectNumber field in the current record. I have used code similar to the one below before but it was on a date field, then add one. Me.RevisionNumber = Nz(DMax("[RevisionNumber]", "dbo_ProposalLog"...

I am using a datasheet view with dbl click code to open a form to a selected record. I was able to use pbaldy's code and it worked perfectly. DoCmd.OpenForm "Asset Status", , , "[Project Number] = '" & Me.Project_Number & " ' " Then I realized I really want to be able to go to other...