Search results

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

Looks like If CountriesFormPass = "pass" Then DoCmd.Close acForm, "Countries" End If

Actually I'm still missing something here. When the button is clicked to close the form the beforeupdate hasn't taken place so at this stage I don't know if there are any errors as the variable won't have been set. I told you I'm cracking up

D'oh!! Thanks.

I want to validate the fields on a form over and above the definitions that exist in the data definition (i.e. numeric, must be filled in etc). I thought all I needed to do was put a bunch of ifs and elses in the beforeupdate part of the form with a setfocus a cancel = true possible a me.undo...

I have a custom ribbon set up in usysribbons. The ribbon is so the user can navigate around his forms The ribbon contains some access commands that I've put on whilst I'm developing it I want to be able to dynamically alter the ribbon depending upon 1. whether or not it's me running it. if it...

I couldn't resist in trying this. I can concatenate my numbers in the query but can't separate them So if i put Expr1: [Units] & [totalwithtax] i get the righty figures but if I put Expr1: [Units] & " " & [totalwithtax] i get data mismatch