Search results

1. The space is a typo, however this was done in the original naming of the table and therefore is correct in the code. 2. When I have played about with the code to try and add criteria to the Dlookup, it does seem to return a NULL value but the label is displayed as black and on the the...

I cannot seem to get this to work at all, so here goes..... I will post the whole code which I am using in the hope someone can help with my dlookup. Its not code I wrote myself as described below this is from a demo database which I found and slightly amended to suit my needs Option Compare...

Thank mate, I will have a look at that link and see if I can work it out.

I just noticed the typo the dlookup as your reply came through and have amended this. As for the criteria, not sure how this should look within the dlookup. Below is a snap shot of one of the months in the report. There should be 7.5 in 28th & 29th, once I amended the typo in the dlookup this...

Hi I am designing a holiday planner within my database which shows employee's holiday booked, cancelled and declined. I found a very helpful demo database which I have slightly amended to suit what I need, but I am having problems changing the caption labels to value's within the recordset...

Thanks mate - Worked a treat. I'm learning.......slowly....:):)

I tried that, but there is no Format option in the properties. It is a label, not a text box. I can see the format option for the text box but not in label, and i'm not sure if changing the label to a text box will work due to the code?

Hi I have the following code of my holiday calendar however I would like to convert the month into uppercase. I know about the 'Ucase' function but I am fairly new to this and have tried to place this within the code but with no success:- With theReport...

Yes, I know I just wanted a quick fix, i know you cant use the same and mix and match. I just looked back over this thread and must have missed the IIF Construct link which I checked out and I can prob use this and have a play around with it, after all I learn't most of Access playing around...

Thanks for this I will have a good read of this when I get some time, however I still need be able to limit the datediff to a maximum of 52 weeks. Is there not a 'quick win' here where I can simply add or amend the query in the update field? I know in excel you can use =MAX(52,.........etc...

Thanks, yes I noticed the [Enter Todays Date] could be replaced so i will look at that. I am pretty much self taught on Access which is perhaps why it does not seem standard practice with the way i am doing things. What I am wanting to do...... 1. I have a query which makes me a table...

Hi, Thanks for your quick reply. I am only wanting the result to be up to 52 weeks:- i.e One employee start date = 23/04/2012 - 08/01/2013 Returns 37 weeks One employee's start date = 11/10/2010 - 08/01/2013 returns 117 weeks I would want the second example to return 52 as I have another...

Hi New to these forums but having a problem......... I have a query which looks at an employee's start date, and then at todays date and returns the number of weeks they have been employed. However I need to limit this to 52 week, shoudl they have been employed for longer than on year, how can...