Search results

I'm sure this can be done I'm just struggling to think out the process. (I've been out of access for some time & relearning) I want to concatenate some fields based on elements of my form. STATE=AUTONUMBER+FINANCIAL YEAR From the the job entered date which self calculates I can get Financial...

I just broke something. Oops. I was going to send a pared down version. Yes I totally want to go with your frmSearchFAYT. The verison I have of yours lets me see the macro but not the form design to ensure I have the right naming conventions.

Thanks @MajP . I am anticipating a few ways the user might like to search for jobs. Client Name, Local Government Area (LGA) or Project Title. A lot of the times the client is the LGA so I expect they would do one of the other of client name or LGA then see a list of Projects (however some times...

Oops sorry meant a number of fields. So they can choose either project name or client (mind you client could be a drop down then limit to the project names for that client) and project title could be that nice "fuzzy" ex you gave

Thats nice!!! Now I just have to work out how to add multiple fields so they can sesarh on a number. Thanks! I like that

Thanks for that! Can I still use wildcards though as I expect users wont always know the full name and the dataset is very big

Hey experts! I have a form that I want the user to be able to search for relevant jobs with a number of fields. I want to use unbound text boxes for project name and client then (at this stage while I am testing) get a query to return relevant records. I've used wildcards in each of two fields...

@theDBguy you are awesome! I got it to work (kindof) with a few tweaks only it is still displaying a dialog box for the fields I didnt enter. I want the user to be able to add all the search fields or leave some blank.

OF course!! In the examples I am looking it the AS Expr isnt there , that self generated - should I delete it, it comes up with a syntax error SELECT tblJobManagement.ProjectNumber FROM tblJobManagement WHERE [ProjectTitle] Like "*" & [Forms]![frmSearchMenu]![txtDescSearch] & "*" Or...

It just opens all records, even though I have set the filter. Im actually not sure if thats just because the query doesnt work!

SELECT [ProjectTitle] Like "*" & [Forms]![frmSearchMenu]![txtDescSearch] & "*" Or [Forms]![frmSearchMenu]![txtDescSearch] Is Null AS Expr1, tblJobManagement.OPMStaff, [Method]=[Forms]![frmSearchMenu]![cmbSearchMethod] Or [Forms]![frmSearchMenu]![cmbSearchMethod] Is Null AS Expr3...

The title is from an old thread that is now closed. I have built a form that has multiple fields, some combo box and some free text unbound. The search button calls a query which I designed from the awesome example from Jon K in the original post. The example opened the records on the query...

Thanks for your help :-)

Sorry that was an old version I think I have it. I used to do this before kids 15 odd years ago I never should have accepted this job!!!

Got them but am I still missing somewhere else? Private Sub cmdGotoJob_Click() 'Runs the a query to prompt the user to type a Project Number 'If the Project Number does not exist a message box appears On Error GoTo Handler Dim ProjectNumber As String ProjectNumber = InputBox("Type Project...

lol. I am half blind and I couldnt see yours. Once I put the screen up to 150% I can but cant really determine which sides they go.

Bummer! I thought that was it but it is like that :-( PrjNo = InputBox("Type Project Number", "Search By Project Number") If IsNull(DLookup("ProjectNumber", "tblJobManagement", _ "ProjectNumber = " & PrjNo & "")) Then MsgBox "The specified Project Number does not...

AHA. The ball drops. Yes

Sorry if I am being thick.. Might need a little more guidance... "ProjectNumber = " & PrjNo & ""))

I do dont I? Or am I missing somewhere?