Recent content by banjo ben

Unfortunately, restrictions placed on me at my place of work make it much easier to just use Access.

Hi, I had a quick look and couldn't find anything relating to this, so here goes... I have a form that will eventually have around 70 images, which will all behave in a similar way. I was wondering if it is possible to capture the mousedown, mousemove and mouseup event of all images on a form...

Great, I really didn't think it would be possible. It wasn't quite what I wanted, and it seems as if it is limited to the nº records you want to display, but you got me onto the right track. I modified it slightly so that I have one textbox for each colour, rather than one textbox for each...

Chris, there should be a very simple database (one table and one form) attached. What I would like it to be able to change the detail background colour or the textbox background colour depending on the value of a certain field. I agree with Dave that it can't be done using conditional...

Chris, you seem to be correct in that I can't upload an example at the moment. At least I couldn't find a link that would allow me to do that.

Thanks for the replies. Unfortunately, upgrading to a later version is not an option for me due to restrictions at my place of work. It is either 97, or no Access at all.

Hi, I am trying to conditional format controls in a continuous form in Access97. To my knowledge the conditional formatting function didn't get introduced until later versions of access. I have managed a kind of workaround by using layered text boxes, each formated differently, and using a...

Thanks vbaInet, This works great - and it is all contained within the one query. Thanks to Dave also - I managed to get a workaround for the dlookup using inner joins on the new query with the original table joining. Cheers Ben

Hi Dave, thanks for the quick response. I was hoping to avoid the dlookup route as the multiple criteria sounded a bit daunting. I gave ti a go though, and am still not quite there yet. So now I have a query showing the following: - fld_ID, fld_Date 174, 12/01/2011 185, 01/12/2010 192...

Hi, I have a data table that looks like the following: - fld_ID, fld_Foreign, fld_Date 12, 174, 17/12/2010 13, 174, 07/01/2011 14, 174, 12/01/2011 15, 174, 20/02/2011 16, 174, 28/02/2011 17, 174, 15/12/2010 18, 174, 07/01/2011 19, 174, 17/12/2010 20, 192, 31/01/2011 21, 192, 28/02/2011 22...

I found a workaround using DoCmd.RunCommand acCmdPageSetup. This dialog opens after the report to allow the user to select their own page size at run-time. I would have like to have automated this, but this will do for now. Ben

Hi, I have a problem with an A3 size report that I created. It views fine on my computer (which has Acces 97 installed) but when other people try to view it on computers with runtime, it defaulst to A4 and the report doesn't show correctly. Any ideas?

Hi there, I have been working with MS Access for around 10 years now, but everynow and then I come across problems that I have no idea how to fix. I work predominantly with Access '97 due to work limitatations, and yes, I do play the banjo :D (kinda)