Search results

Thanks Len, The fix worked great. Many thanks Chris

Hi Guys, Can anyone advise me on a chart problem. I have a form into which I want to put a chart. The data I want to display on the chart is temperature and rainfall over several months. I have a table that has the month, temp and rainfall as fields. I need the chart to display so that the...

Hi Guys, I have a form which is set to 'continuous forms' with a form footer. In the form footer I have record number fields ie 'Record 1 of 234'. On all my other forms this works by setting the current record source to =(CurrentRecord), however this doesn't seem to work with continuous forms...

The form is based on a table. I have tried several different ways to use a query instead and it just doesn't want to work. One of the tables has a field called 'BaselinePIR', 'BaselineDate' I need these two fields to be entered into table T_Data in fields 'PIRValue' and 'TestDate'. The data for...

Hi Guys, I have a form based on a table, T_InitialData, when data is entered into the form it is saved to this table, however, I also need the data from three of the fields on the form to be saved to another table called T_Data. Can this be done easily? Basing the form on a query doesn't seem...

Hi Guys, I have a field in a table called 'BaselineDate' that requires the user to enter a date. The date can be in the past or future and is formatted thus mmm yy. Whenever I put a date into the field, such as Oct 03 as soon as I leave the field the date changes to Oct 04 (it is always 04)...

Thanks MoP, Sometimes you just can't see the wood for the trees. I will now take myself round the back of the shed and give myself a good slap!!! Thanks for your help. Regards Chris South

Hi Guys, Please can you help. I want to put a cancel button on a form so that if the user clicks on the 'add new record button' and a new record is displayed and they make changes to it (or not) they can cancel what they are doing and be back where they started. The problem I currently have is...