Recent content by nsquared

Thanks Everyone again for you help, David your method does what I needed, so thanks, vbaInet your method I think will work but I was having a problem, with the LEN statement in your code as it kept losing the last letter of the name of the Qry, anyway problem fixed, thank for all your help.

Thanks for all the help everyone, sorry for not coming back sooner been out the country. vbaInet to answer you question I need the the combobox to select the event nearest to the current date,Thanks again.

Hi everyone Is it possible to have the current or nearest date in a Combo Box list display when a form first opens. The list that the combo box calls up is a list of dated events from past and future but I would like it to jump to the nearest event to the current date without having to scroll...

Thanks I will take a look

Hi All I have created a report that shows all the subscription payments made during a calendar year. The subscription amount is £12 a month, the problem I have is that some people like to to pay two, three or more months in advance. What I want the report to do is to change the backcolor of...

Can anyone help me, I am new to creating forms and there functions, what I want to achive is for the information form the textboxs CampDetails, CampDate and NoNights to be put into the into table tbl_Camps for each of the members selected by the checkbox called itemcheck when I click on...