Search results

Thanks so much. I've just dug out an old laptop which has an earlier version but I think it's steam driven and it's taken 30 minutes to boot it up and get chrome to open!!

I hope ghudson is still about!! I'm having a load of problems validating a form and then skipping to the enxt record and this seems like it may be of help but I've got access 2016 and it's refusing to open a previous version Any chance in someone that has an old version of access saving this as...

Yeah I think you got them but this still doesn't quite work. This scenario is unlikely to happen on this form but it could on others. So user goes in and blanks the description out only. He then tries using the combo box to skip to another record. The logic tells him there is an error and sets...

OK this almost works but not quite. What do I want? This is a simple form but I have more complex ones with validation on more than 1 field. The user can make changes to none or more of the the controls on each form. He can then move off the current record by using one of the navigation...

still not quite there. i'll add explanation tomorrow as i'm ready to drop.

Yes. In a nutshell all the validation works but those 2 fields are only updated when the combo box is used to select another record. And they are always updated. They should only be updated if the record has been changed. I'll take a lok at the attachment in your next post

The closest I've ot is by moving the me.updatedby into the beforeupdate and having a boolean that doesn't do the update if set to false so I have for 2 subs Private Sub cboStartTaxCategory_Click() Dim rs As DAO.Recordset updateme = True If Not IsNull(Me.cboStartTaxCategory) Then...

LOL I thought I was going mad there as when I first read your unedited post in the email you didn't have the PS in and then when I downloaded your file I didn't even look at the text so didn't even realise you'd edited it and didn't see the PS again! I couldn't work out why the DB was...

Finally managed to load. Hope you're still around theDBGuy!!

I spoke to soon. The form I gave you is quite simple! In my first post I mentioned "I do have a slight problem as I have a combo box which allows me to jump to a specific record but I'll post about that later.". The combo box I refer to is in the form header. If you blank out the description and...

OK I could blame this on inheriting a database with missing error handling but it's all my fault! I got carried away with getting the code complete that I've missed quite a few modules without any error handling So basically I need to add a number of lines to each module. 1 at the top and...

yes it does!!

No it's not it's I get a run time error 2101. The setting you entered isn't vali for this property. I think it's because access knows I'm about to go into an infinite loop! I have if me.dirty=true the me.dirty=false end if This forces the code into the beforeupdate which I want to put a cancel...

I suppose I could use validate form or duplicate validation code which I don't want to do

Thanks for this. I didn't actually mean the navigation buttons at the top which I'm probably going to get rid of. I meant the ones at the bottom where it says 1 of 5 etc etc. However your changes work for those as well so appreciate it! One thing though the Me.txtDescription.Undo doesn't...

OK so this should open a tax category form. If you blank out the description, a field that is required, and then click the close button (door in top left hand of form) then you get an error and the form is not closed. Doing the same thing and clicking the navigation buttons at the bottom of the...

OK I'll cut it down and send something

OK just when you think it's working it's not! I have a catch 22 situation here. I said at the beginning "This works if trying to move to another record using the navigation bars." which was true. When capturing the error i had Cancel = True in the code. This I believe prevented selection of...

OK looks like the If Me.Dirty Then Me.Dirty = False forces the beforeupdate Thanks again

Thanks I'll take a look