Search results

Could I ask if anyone could answer if I can "add" excel cells to a form. The process we currently have is an engineer emails a single line of cells from an excel spreadheet containing details of parts required (Part No. etc.) we them add this to fulfilment spreadsheet and issue the parts, any...

Thanks MajP, works perfectly! Thank you :)

Thanks for your comments guys, much appreciated.

Hi CJ_London, I get an error "The IF and Else If conditions are required arguments". Any ideas?

Thnank CJ_London, I'll give it a try and let you know.

Part No., Description, Supplied By & Serial No.

Hi Isladogs, The text box is used in a search query, I have 5 options in the combo box and the search results are returned on the text value in the text box. One of the options is “Date” so I would like to give the option of selecting the date from a date picker.

Hi Guys, Is it possible to format a text box based on the selection in a combo box. What I need is when “Date” is selected in the combo box the text box needs to be formatted as a date field. Any help would be great. Thanks

Hi MajP, I think I had a typo and all seems to be working now. Many thanks to all who took the time to reply to my post, great help. Cheers. Dave

Hi MajP, I added the * to the expression ="[" & [cboSearchHeading] & "] like *'" & [txtCriteria] & "*'" and am now getting the following error Syntax Error (Missing Operator) in Query Expression '[Received From] Like *'Der*". Any ideas? Thanks

Thanks MajP, I understood the post by Galaxiom, however, I am trying to make this "Idiot" proof for the user, and just let them input a string without the *, is this possible? Thanks Dave

Thanks Galaxiom, Is there any way that I can search on partial text within the whole field?

Hi Guys, can I Ask for some advice. I'm fairly new to Access and have an issue regarding a search on a form. I have a combo box to select a table heading and a text box where I can input search criteria. The problem is that my search does not return some records based on a partial text search...

Hi Guys, I'm new to access and would like some advice if possible. I have a form with a subform that has a combo box for selecting part numbers from a parts table, is it possible to manually input to the combo box if no part number exists, which would then update the parts table. Apologies if...

👍 Would appreciate having a look as has a few issues with my database Cheers

Hi HillTL, Cant get past the login screen!

Hi HillTJ, Thanks for that, I'll have a play around with it and try and fit it to my requirements. Cheers!

Thanks HillTJ, look forward to it. 😁

Hi HillTJ, that would be great, thanks. :)

Much appreciated HillJT, I'll have a play. :)