working merrily on database when I want to shut down I get this dialog box
"The macro or function set to the BeforeUpdate or Validation Rule property for this field is preventing Microsoft Access from saving the data in the field."
*If this is a macro, open the macro in the Macro window and remove the action that forces a save (for example, GoToControl)
*If the macro includes a SetValue action, set the macro to the AfterUpdate property of the control instead.
*If this is a function, redefine the function in the Module window"
Problem is 1) I'm a novice so no dirty tech talk 2) not to my knowledge have I set any functions, macros or clever action stuff.
Done this several times over last few days losing any work I have done on db.
Currently not pressing the OK button since I don not want to lose work.
The whole thing seems to be hanging, can't shut down and the repair action seems to do nothing either. CTRL ALT DEL doesn't indicate any probs with Not Responding prog. Not sure what to do now but thanks for trying to help
Being the fact it is such a small database it shouldnt take long for the compact and repair unless there is a major problem. maybe tonight you should just try and let it run compact and repair all night long.
closed it down the easy way CTRL ALT DEL and lost a couple of hours work.....bummer
now can run the compact and repair very easily which whizzes thru' v quickly so not an issue there
I am multitasking between net, word, excel, notepad, DOS etc and doing a lot of cut and pasting, I'm guessing I am getting my CTRL V, CTRL X, CTRL C mixed up between apps as I whizz along and maybe at some point I press the wrong CTRL function in wrong app and balls up Access?
Thanks again for your help, do you know of a definitive list out there for all the CTRL shortcut keys, may shed some light on possibility of pressing wrong CTRL key?
Another thing you may want to try is setup an excel sheet the same exact way your table is setup... then do all of your copy and pasting. From there you can import the excel sheet into the table with the top row containing the headers. And you most likely wont lose any information. You may want to do that until you get this all straightened out.