Search results

I enjoyed it thoroughly and wrapped up all of Russell T Davies's storylines, albeit it was a little bit of a cop out to see Rose go off with the cloned Doctor. Nevertheless, I thought it was a great two parter ending to the series.

For anyone interested we have enabled downloading of Blue Box on our myspace site.

Series 4 has got off to a great start! Was kewl to see the ood back in this week's episode! Video for Blue Box now posted at: http://uk.youtube.com/watch?v=xzvPe5r3RJA

All, To coincide with the start of the new series of Doctor Who and to reflect the previous series, the band I play in (The Red List ) have written and recorded an indie track based on the Doctor. The lyrics and premise of the track is based around his loneliness; both from the perspective of...

I have something very bizarre happening that I cannot figure out. I have a form with a subform on it. These are not linked. On the first form is one combo box, the records in the subform are requeried every time the combo box changes with the criteria for the subform based on the selection in...

Have now determined that if I stick a command button on the top parent form (frmClient) with : [Forms]![frmClient]![sbfClient]![sbfClientBookingConfirmed].Requery [Forms]![frmClient]![sbfClient]![sbfClientBooking].Requery then it works fine. But obviously I don't want to be clicking a button...

Thanks, But this still does not work. Except as well as it not querying I get an: "Error 3246. Operation not supported in transaction" I don't think it's a referencing problem as I use the exact lines to requery this subform else where in my database and it works just fine. It does not make...

I have a form with a number of subforms. I am interrupting the delete event so I can use my own code to delete records or amend records. My code runs fine but I cannot get the form to requery. It displays no error and other than not requerying it runs fine. My code also requeries another form...

I have cracked it!!! I have figured out now how to do it using nested queries. For the example given I have nested all three queries into the final query. It now gives me the results I want. All that is left to do now is to build this SQL in VBA which with a bit of tinkering and an array should...

Lol yes I am well aware of how to reference form listboxes or text boxes via a query, but as I keep saying this method will not work.And yes it may well be 50 sets of criteria needed. Lol I wouldn't say so if it wasn't a requirement. So as I keep saying I cannot do this with fixed queries. They...

The queries have to be built in SQL because the search screen could be searching on 1 set of criteria or 50 (as opposed to the three I have used as an example). I would have to copy and name 50 or more (as a contingency) in the query pane to allow for this. That's completely unfeasible and bad...

Thanks, I can't use a querydef then because these queries cannot appear in the query pane as they will never be fixed queries. Other than appending the WHERE clause each time but this will always have to be built in SQL due to the dynamic nature of the required queries. i have looked through...

Anyone help?

Erm I am lost now. I'm not sure I understand what querydefs are. I am building the query on the fly in vb because the query always have different criteria because it depends on what selections are highlighted in a listbox. This means I can't have any fixed queries and it has to be built up on...

Thanks very much for your response Neil, Am getting more confused now though. In my last post I have the query now that gives me the correct results. The only problem is that I can't construct the final SQL query in vb because I am not sure how to reference the previous three queries. Are...

Anyone any ideas?

OK so I now have the results working based on a number of queries, but now I am not sure how to construct the queries in vb on the fly. I have three seperate queries generated as follows, (I have named them for easier reference later): TEST QUERY 1 = SELECT DISTINCT tblCandidate.CandidateID...

neileg, I am not after a 'single' record returned. I never said anything about a single record. I am after any records where all three are matched as described. So if Joe Smith and Dave Brown meet all three then I want to see them both in the query results. If nobody meets the criteria then I...

Thanks, yeh I realise what you are saying and that is the quandry I guess. i'll try explaining it differently. I am thinking it may require a number of queries joined, but anyways let me try again. I'll try explaining it in steps describing each query that can maybe be done in one: I want a...

I am trying to construct a fairly complex query on the fly. I have it working except for the criteria side of the query which I am having trouble with. It doesn't really matter about the vb side of it because I can alter the construction easy enough. it is more a question of how I get the...