Recent content by sampun

I've tried : DoCmd.Save acForm, FormName DoCmd.Close acForm, FormName and I've also tried: Docmd.Save Both methods give me the following error: run-time error '29068': Microsoft access cannot complete this operation. You must stop the code and try again.

Hi all, i'm trying to add some conditional formatting to a textbox within a form. The code works fine because I can see the effects of the conditional formats when I open the form in code. However, when I try to save it using: DoCmd.Close acForm, FormName, acSaveYes The changes I made in the...

It's shown through a form...does that mean it can be achieved?

Hi all, This is probably a stupid question but does anyone know how to show the grand total at the top of the pivot table instead of the bottom? Many thanks, Sam

Hi all, I tried to use =[listbox_name].itemdata(1) as the default value by setting it in properties of the listbox but it seems to throw up an error "The method you tried to invoke on an object failed" Can anyone help please? Ps - I tried itemdata(0) but i think that selects the header in the...

All, I want to add a whole recordset to a table without having to add one record at a time, is this possible? thanks,

Many thanks, works a treat!

sorry, that was a stupid example. I meant to say add 6 months in days , therefore 31/06/2007 is invalid.

Hi all, Is there a way to add n number of months to a specified date? E.g. if a date is 01/01/2007 then adding 5 months to that date should give 01/05/2007. It's easy enough to add the number of days to the date but I want to avoid situations where the date is 31/01/2007 and adding 5 months (in...

I'm trying to import a spreadsheet that has field names in the second row with the first row as a blank row (ie null values). Is there a way of using the second row as headings? Thanks.