Search results

Hi, I am trying to duplicate some data to avoid aching fingers. The data would be modified on the purchasing form so it is not true data duplication. The structure is as follows: Form for internal use = frmSparesProcessing subform = frmSubSparesDetail Form for External use =...

I thought I would post the code I compiled for my search . Thanks to all who helped. I can now see the SQL string to debug. Wonderful. Function SearchCriteria() Dim strSQL As String Dim lngLen As Long Const conJetDate = "\#mm\/dd\/yy\#" If Not IsNull(Me.cboEnquiryNo) Then strSQL =...

Thank you for your help. I will have to re-write my code and get my head around it. I had a look at allenbrowne.com and they suggest the same approach but I had put work into my search and didn't want to have to re-think. As they say if a jobs worth doing it is worth doing Twice! I hit...

Here is my code behind my search form with subform. Sorry I haven't noted properly. Works nicely for my little database but we will see if anyone can break it or improve on it: Function SearchCriteria() ' Set string variables Dim EnquiryNo, strSparesStatus, strDescription, strEnquiryFrom As...

Great. One step closer to world domination!. Thanks all. Hooch

Wow guys thank you . I will look at it today and see how it goes. :rolleyes: I know I open myself to noob bashing but I have the blank fields in my table because until an enquiry turns into an order there is no value in the order reference field. Or nine times out of ten the customer...

Hi, I am new to access and have been thrown in at the deep end. I am making a search form using a form with subform. The subform is based on a query. The form has a number of combo boxes which allow the user to select or type in a value. Stringing these together means that you can refine you...

I live and work in England. I have been involved in the food and drinks business for many years. We have been designing machinery layouts for a long time. To keep organised we use an Access database and keep adding functionality. I will need help over and over but eventually I will get it.