Recent content by micks55

Just to reassure everyone, it does have table level validations and form BeforeUpdate events so all is ok at the moment and the people who have been using the program for the last 12 years are competent and happy. The question was about adding/editing data validations or rules without issuing a...

Again, many thanks to all. Validation has it uses but the user will typically work on the job over a number of days so lots of messages popping up to nag him/her is not an option. The time to remind them of their failings is when they try to print the reports. Validation at table level is not...

Also. Personally, I would not store an ID anyway. I would expect part numbers to be unique so adding a unique ID is overkill. By storing the part number in full you will know what was fitted at the time of the repair. As Gasman and arnelgp say, your Parts table could/should have a...

Hi, Firstly, I'm no specialist so this might be rubbish. If the combo gets it's data from a table and you are actually storing the ID for a record in that table then I think you can't avoid the source table getting cluttered with a load of one-offs. However, if the Row Source of the combo...

Many thanks for all of the comments. The_Doc_Man and MajP have some great ideas for me to pursue and I've always said Access can do anything so I still think I will find a solution. I just need to find it soon because this will be my last re-write as I can see the tunnel at the end of the light...

Thanks for the advice. I'll probably give it up. I would have preferred to edit lines of code stored in a table rather than edit the vba and re-issue the program every time but if it can't be done then I'll just have to accept defeat. Mike

Hi Bob, Many thanks for your reply. I've written the vba that checks the data in the recordsetclone and it works ok. It's looping through the recordsetclone doing about 90 checks on each record (they're all If statements) and then shows a MsgBox if any errors are found. My problem is that...

My problem is that data checking can get complicated and every time a new rule is needed I have to add another If statement in the vba module and re-issue the program so I'm trying to see a way of storing the If statements in a table so that I can edit/delete existing rules and add new ones...

Thanks to bob fitz. I'd tried exactly that and had wrongly assumed the error procedure was picking up on that because it was the most recent code addition. Sadly the error was elsewhere. Thanks all.

I was going that way as a last resort but thanks to you making me think about it I have it solved. In the AfterUpdate of Text 4 the second line of code grabs whats in Text4 'check we have a good email address and it must not contain \ / : * ? < > | [ ] """ Dim myTxt As String, myMsg As...

IsNull() is working thanks. Still have an issue but it's not that so now looking again at rest of vba.

Just been checking out how to use CF to hide some of the buttons on a continuos form. Can see how it might work by using a text box that looks like a button but expecting a problem because this "hides" the button just by changing the fore colour and back colour to same as the form. As the text...

Hi DBguy, thanks for replying. I'm ok with CF to change a control's format but don't understand how it might be used to enable another control.

Hi All. I have three unbound controls on a form. If all 3 have content I want to enable a Save button but if any one of them does not then I want to disable the button. I've put vba in the afterupdate of each of them and tried Len(), Nz(), IsNull() and = "". It works fine once all three have...

arnetgp. Thank you so very much. I've had a very quick look and it looks exactly like what I need. I've spent hours and hours trying to think of a running sum solution using queries to feed more queries but just tied myself in a knot. This looks very elegant.