Search results

thanks very much for your help I managed to get this working on a test database. However to get this working in my actual database im having diffculty because the field i want to base the code on is in a sub form and the command button is outside of this subform this is the current code which...

* its the If me.txttotal Im having particular trouble with

Thanks for your response The name of the field with a total is number of hours and the name of the button is Btn AppendQuery Where would I place them in your code? I am having difficulty trying to get your code to work

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

Thans very much for your help, managed to get it solved :)

Hi Dcrake, Yes that is exactly what I want to achieve! Where is the code you have used on yours? Thanks

I need to use more than 3 colours. So I guess I can't acheive this? Would it be possible to do this in a report?

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