Search results

I use the following code (got from this forum somewhere a while back) to open a "browse" box which enables my user to link a file to the database. it works from an "add" button which then places the string for the file into a field and turns it into a hyperlink using another bit of code. I now...

I have a database for measurement requests and i would like to link it to our company intranet so that my uninformed users can just fill in one form and press a button to send it off without actually touching the database. I think i know how to do this - i'm planning to convert an existing form...

I have a "model line" drop down box on a form. This is comes from the main table. When i set up the main table i set it to lookup the options in another table. The problem i have is that when i add new model lines to this table they dont show up in the form drop down menu unless i delete...

I am using the following code to send emails from Access. Is there any way to format the text in these emails? At the moment they just come out as a big long line of text and i would like to be able to put the text in different rows, maybe change colours etc. Any help would be appreciated...

I am working on a database for measurement requests and i want the database to send an email to the administrator when a button is pressed. I can get everything to work apart from getting the database to look up the name of the admin in a seperate table. I have been using the following code...

I have a form which people enter details of an evaluation drive they have taken. They fill all the details of the drive in, date etc and then click a button to add any problems with the car. The button click opens a pop up form which closes when they click "add". The first form has a subform...

I found a module on this forum that provides me with a function to calculate the number of working hours between two dates/times. It works really well but now i need to be able to take out bank holidays/company shutdowns etc. I have made up a table called "Holidays" with a field called...

Hi - i got the following piece of code from this site and it works brilliantly for calculating working hours only and removing weekend days from the calculation. However - the removing holidays bit doesnt work and i cant figure out why! I'm not great with the VBA side of things, i can adapt...

Ok - really need some help here. I have searched and searched but i think my problem is slightly different to the ones i am finding. Basically i have a form and i want to force users to fill in one out of 4 tick boxes. If none of them are ticked when they press the close button i want the...

I have searched the forum for this answer but no luck. :( I'm trying to calculate the amount of WORKING time between two dates in an Access database. At the moment i am just subtracting one date from another but this gives me all of the time in between including weekends and evenings. I need...