Search results

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.

Glad you found a way but here's an alternative which I prefer because it's just good old math. If you want to round 23006 Up but round 23004 Down then the Int() function will do it. You would use it like this: =INT(((myNumber+5)/10))*10). If myNumber is 23006 it will be rounded UP to 23010...

Hi all, It's been a while. I’m trying to avoid Make Table queries. The result needed is a where records that match are grouped and totalled along with a list of the Refs (item references) for those records that are the same specification. This is a simplified version, in reality it is, as...

If you always want the first word, then =Left([yourField;InStr([yourField];" ")-1) but you'll have issues if the first word has been entered as an initial only. Sorry, just re-read your question and this does not check for a space character. Try this. =Left([yourField],abs(instr([yourField],"...

Another option is to use the Microsoft Web Browser control from your toolbox. I use it because files are .pdf .doc or .xls and we can view/zoom/edit/save (can't save .pdf's) while we are working in the form. I retreive all files from a designated folder then filter and show them in a list box...

This is not as easy as you might imagine. You'll need a field in the underlying table that is the Row Source for the list box. This field will be Numeric (Integer) and could be called Seqnc. The field will be included in the list box Row Source but with a 0cm column width so that it's hidden...