Search results

Hi Good People of AWF So about 8 years ago I wrote this fabulous (I think) application for a client who then decided he didn't want it (long story) so it lay in folder untouched gathering dust. Anyways, the bit you've been waiting for, I've been asked for exactly that db and when I tried to...

I have a listbox on a form which displays properties(realty) that match the CityID of the property applicant. I also have an areaID within the city. I want to create a query which will return all property in the city the applicant is interested in but will order by the properties which match...

Hi All, Opening a form with filter ([ContactID] IN (SELECT ContactID FROM tblBuisnessAddress WHERE tblBuisnessAddress.postcode LIKE 'w1*')) takes a crazy amount of time. (60 sec for 450 records and a few minutes for 1000's). BUT... ([ContactID] IN (SELECT ContactID FROM tblBuisnessAddress...

Hi, I have a search form which allows to search for various criteria such as postcode. The code for building the filter is as follows: varWhere = (varWhere + " AND ") & _ "([ContactID] IN (SELECT ContactID FROM tblBusinessAddress " & _ "WHERE...

Hi I am having real difficulty here. I have tblStudents (StudentID, Name etc.) and jtblStudentSession (SessionID, StudentID). Can someone please advise how I would query which Students are not registered for Session x. The unmatched records part is simple, what I cant work out is if how to...

Hi I have a continuous form which displays contact names and addresses, and a search box to filter records. Once the required records are displayed I would like to use a cmd button to send the records to MS Word. Can anyone tell me please how could i reference the form recordsource in the SQL...

Hi I have in my sales database tblOrders and tblOrderDetails. In tblOrders there is an option to flag this order to be repeated yearly until further notice. The trigger will be a button to generate this years repeat orders. Please can someone advise the ideal way to create these new...