Search results for query: *

After a bit of playing around and using the code suggested I have got it working. There are two areas where I have placed the code. One in the LostFocus Event of the Field One in the Before Update Event of the Form. I had to move it back to on lost focus (I figure that because nothing is being...

Hi there, thans for your assistance. As you suggested I added the code you wrote to the BeforeUpdate Event. Then I tried it on the AfterUpdate Event. In both cases the code did not behave how I described I needed it to. In both cases the msgbox did not appear and the cursor moved to the...

I have a database created on access 2000. I have a form called aDataManipulationF. This form has a sub form on it called aStaffTrainingUpdateIndividuallyF. The sub form opens ready to add a new record. On this sub form I have a field called SSDetailsID which has a default value of 0 (zero)...

Hi there, thanks for your replies (remember I am a learner). Just a note that the problem is with viewing the report. On the assumption that the code works for viewing the report in landscape view I entered the code as part of the form's On Open command. Was this the correct place to put...

Hi all Another question - Hopefully it is easier to fix. I have created a number of reports in landscape view. They work perfectly. The problem is now and then, when I least expect it they open in portrait view. I can't work out why it does this but it more commonly occurs if I open a...

I have an Access 2000 database. I have a form called aDataInputF. On this form I have 7 tabs (Pages) called - MainP - OperationalDetailsP - SiteDetailsP - StaffDetailsP - Staff/SiteDetailsP - TrainingCourseP - TrainingProviderP Except for MainP they all have forms (sub forms) on them -...