Search results

Hi, I wonder if someone is able to help me as i am completely stuck :confused: . I have built an access database which is used at work by a number of people within my team. I want to add an authorise button to the database, which when clicked will stamp the record with the date, time and also...

Thanks very much - that works perfectly.... :)

Hi Guys, I am stuck on a subform problem in my DB - I would like to do something but not sure if it is possible - if someone is able to point me in the right direction i would really appreciate it. I would like to set up a subform on the main form of my DB and four command buttons, then...

Hi everyone - i wonder if someone could help. I am looking to understand the VBA code that should be used for a tick box on one of my forms. When the tick box is "True" i want an OLE object (which is on the form but hidden) to be "Displayed". When the tick box is false, i want the OLE Object to...

Great Stuff! Thanks for all your help guys - i have managed to get this to work this morning :) nice one!

Hi guys - I have only just had a chance to take a good look at this - ok so far i have got up to the second part however i am now stuck (really sorry guys). Don't quite understand how a store this as a value FX-PK? on a 1:1 relationship in the table and also how i can make the colour change...

Yep they are correct - Sorry I should have told you guys that in my original post :( - i am using a continuous view form for this list - i am in the middle of trying out the idea from DCrake - i will let you know if this is successful :o

Excellent - thanks for your help - really appreciate it - I am going to crack on with this now and let you know how I get on....

Yep - this looks really good, i know i am a pain but can you explain how i would go about implementing this, by using the date field as above...? - i have had a play with your example, but i cannot see how you have done it. :)

Hi guys - thanks for your help here really appreciate it. I have applied the VBA you have provided and it works (well sort of) everything is showing as Green. Now i am not sure if this has something to do with it, but the date field uses the =Now() function so it includes a time as well. Any...

Hi :D, I wonder if someone is able to help me as i am really stuck on this problem with my database. I have created the database in Access 2003. On one of the forms in the database, i want the "Date" field border to be displayed a different colour, dependent on how long the record has been in...