Search results for query: *

PHV - The 'Me.Undo' idea worked a treat - thanks a mill

Thanks PHV - have tried it before... I get RT Error 2448 "You can't assign a value to this object" ??!!??

Hi I am trying to get the user to exit my form (or move to th next record using the nav bar) without saving his changes So far... Private Sub Form_BeforeUpdate(Cancel As Integer) If MsgBox("Exit without Saving?", vbYesNo) = vbYes Then (This part I copied from MSA Help on 'OldValue') Dim...

Thanks PH - now it doesn't move to the next record. The MsgBox is displayed - when I select 'Yes' it stays on the record, if I select "no" it moves but the data I have changed is still saved...

Hi I want to ask the user if they want to exit without saving a form (after making changes to a record). I can get the code to work if I use 'Form_Unload' and close the form using DoCmd.Close. But when I step thru the records using the nav. bar this doesn't work. I have also tried ... Private...

Hi I have a report containing two subreports (all unbound). I would like to open the report and specify different criteria for each of the subreports. For example the 1st subreport contains data pertaining to an "Event Date" that the user selects off a drop down on a form - the second subreport...

Hi When I search for Help (in MSA or VB) for DAO, several options are displayed for example 'Database Property', 'Recordset Collection' , 'Parameters Collection' etc) - but when I click on any of them an error appears saying "MSAccess can't display help. An error occured and this feature is no...

Thanks for ideas so far - but I have come unstuck on the first line. 'Dim db As DAO.Database' gives me a Compile Error: User defined type - not defined! And when I search for help on DAO - its tells me help not installed - then goes into attempting to install this feature loop which returns...

I am trying to: 1. email a different report to a list of recipients (contained in a table) so that each gets their relevant data/page only - similar to 'Dawnd3' - have got some ideas from the forum so will test. 2. Export the report (RTF) but save each page seperately with a different filename...