Recent content by Maclain

Thanks for the responses all. I'm still trying to get this together using the query criteria. Using the suggested criteria from arnelgp everything works except the pattern number filter.

Hi Ridders, I'm unable to guide the user through a combo selection as the search process can be complex, requires some vague searches and there are thousands of records. We also have the option to find a similar item and append the information to the new item..

Hi all, I've created a form, frmTechniqueAllocate that displays data from the query qryTechniqueMasterFilter On the form I have 4 unbound text boxes, the idea behind these is to allow the user to progressively filter the results to find what they need: Unbound text boxes: CustomerFilter...

Hi Both, Thanks for the info, I've included the Cancel = true and Exit sub as mentioned. You're correct in that the changes will not be saved if the user exits the form, this is the problem as the user will/may think the changes HAVE been saved. I'll have a look into the resources you...

Hi Minty, I've removed the checkaccountsaddress. Thanks, What I'm trying to achieve is continuity in a separate billing address for clients. So a client has a main address, and then if they require, we can add in an accounts address. The problem is this is on occasions only being partly...

Thanks Minty, I would change the controls, but the database is over 12 years old and I daren't change legacy items in case I break something else! New additions to the system are much, much nicer! Thanks for the amended code, however I still have an issue: After the .setfocus of sub...

Hi all, As per the subject I'm attempting to make Text104 mandatory if any of a series of other fields contains a value. So far I have: Private Sub Form_BeforeUpdate(Cancel As Integer) Dim addlength As Integer addlength = Len([Text106] & [Text108] & [Text110] & [Text112] & [Text114] &...

*Slightly confused face* I'll keep an eye on it..

Oh now there's a hint of sarcasm!! :D It *appears* to work just fine, however, what's your concern?

it would appear that this: Like IIf([Forms]![Job Register and Report Log]![Customer ID]="FUR001","*" & Mid([Forms]![Job Register and Report Log]![Serial No],3),[Forms]![Job Register and Report Log]![Serial No]) works, Apparently all I needed was to move the 'like' to before the iif statement.

I thought you might say that. I've tried breaking it apart into the required forms query's tables, but everything just errors. There's far too much data to try and strip out to make it worthwhile. Don't worry about it, it'll suffice until I figure another way. Thanks very much for your...

Hi Ridders, I've stripped out everything from the BE to just the customer and main table.

Hi Ridders, I don't follow, I'm passing the criteria a choice based on the value of Customer ID. Which part of the iif statement would cause it to show me all the records? Thanks,

Expanding on this a little, I only want the criteria to apply if the Customer ID is fur001, else I want it to use the whole serial number field... IIf([Forms]![Job Register and Report Log]![Customer ID]="FUR001",Like "*" & Mid([Forms]![Job Register and Report Log]![Serial...

Like "*" & Mid([Forms]![Job Register and Report Log]![Serial No],3) works