Search results

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

Hang on, surely if the query is only taking the right side of the field, from character 3 then nothing will match the criteria unless there is a wildcard at the beginning?

Hi Ridders, Honestly, the database is now 12 yeas old and is integrated into every part of our business, I would start again with it, but i simply dont have the time or expertise. I intend to have a datasheet view of a form as a subform of the form [job register and report log] which pulls...

Hi Ridders, My apologies, I was attempting to hide the poor naming :) the query returns the correct record when I use: [Forms]![Job Register and Report Log].[Serial No] in the criteria, however, when I wrap this in the mid function it doesn't show any results: Mid([Forms]![Job Register and...

Hi Ridders, thanks for your response When I use a . instead of a ! for the filed name it doesn't show the field name as an option in the criteria. Eitherway, using Mid([Forms]![Job Register and Report Log]![Serial No],3) or Mid([Forms]![Job Register and Report Log].[Serial No],3) shows no...

Hi Everyone. I have an ongoing issue where related records are not found by the users. To stop this, I'd like to try and display related records in a datasheet view sub form on our main form. So, I have the following table: MainTable with fields: PKfield (unique autonumber) JobNumber...