Search results

Morning Dave, I've added a very basic example of how i would like it to work in excel. The table will have a fixed number of records as these are the only halls used by the college. At present I just want to give the users a visual display of availability - using dates as a variable in a...

Hi All, I'm struggling with this expression in a text box on one of my forms and can't seem to find an easy answer via google:). =DateDiff("yyyy",[DOB],Date()) This works out the age of the person as of today I need it to work out the age of the person as of the 01/09/2008 However as I...

Yes I know :rolleyes: If this was excel i would be able to do it though:( Thanks for having a look at it 2plus2:)

Cheers 2plus2 I actually managed to change the format for one of my labels however i'm still going about it all wrong:( I have attached the form and relating table from the db im currently working on so you can see where I'm messing up. How can i make all the labels search for their 'status' in...

Hi All, I've just realised after a couple of days of staring at my editor my VBA skills are limited to functions. I have a problem - I would like to change the background colour of an unbound label depending on a value (yes/No) in a table. The labels are all captioned which match with the...

Hi All, I'm trying to create a 'Temporary' table in Access, I have created it and inputted a set amount of 'RoomIDs'(1-100). I need to enter data into the this table when I load up a form from another called Schedule Details. the reason the table is temporary is so that I can generate the...

Sorry think I posted this in worng section originally, Hi All:) Having problems with two combo boxes on one of my forms - It works fine in the sense that I can get one to populate the options in the second one like so. SELECT DISTINCT Rooms.RoomNo, Rooms.RoomNo FROM Rooms WHERE...

Hi All:) Having problems with two combo boxes on one of my forms - It works fine in the sense that I can get one to populate the options in the second one like so. SELECT DISTINCT Rooms.RoomNo, Rooms.RoomNo FROM Rooms WHERE (((Rooms.Block)=[forms]![Scheduling]![Blockcombo1].[Value]) AND...