Search results

Hi, I have a subform which calculates a number of hours. However I want to be able to run a macro if the total hours are 37 and over. For example If Field - Number of hours, total sum is greater than or equal to 37 and you click save then it runs a macro which runs an append query. If...

Hi I'm wondering if anyone can help me with my query. I have a databaase that captures the amount of hours and employee works on a project. they way the data is captured is through these field names Job ID Employee Name Week Commencing Monday Tuesday Wednesday Thursday Friday the number of...

I have a query where you enter an employee name which shows how many hours they have done on a project in a form. When entering a new record how do I get the employee name field to be the default value for the criteria I have based my Query search on. For example, query search of employee name...

Hi, Was wondering if someone could help me If written a conditional format code on VB for a form. The code is 'Select Case' which changes the colour of a rectangle (Box17) depending what is in Field1. However the problem I'm having is that when I click on a record all the rectangle's...