Search results

I'm using the following code taken from one of the posts on the forum (thanks to whoever wrote it - can't think of the user at the moment) It works in Access 2000, but keeps failing in Access 2002 with a 'type mismatch' error, any reasons why this code doesn't work??? It basically scans...

Yes that works, I'm going to have a look more in detail in a minute, but while you were away I was still trying to keep it simple, so I tried these three lines that also work, and keeps the query fairly simple. Check to see if 'tick' is active and if so use [criteria.notes] [criteria.notes] And...

forgot to say, the ideal world statement gives the following error: Data type mismatch in criteria expression. :eek:

This formula appears to find all the records, regardless of whether the 'field active' switch on the form is on or off, hence the previous coding, Like IIf([criteria.notesactive]=-1,[criteria.notes],"*") in the perfect world, the following should equate to what I'm trying to do...

I may be mis-interpreting you or I might just be tired and foggy minded from working on this last night, but....... Do I need to create this new field called: FINDALLENTRIES: In my query form?

Unfortunately not :( The same result I'm afraid, still returns no results, not blank or filled entries, my head is spinning with confusion. :confused:

What am I using I am using the built in query builder to keep things (supposedly) simple, just so you know, I've got about 25 queries each with the: Like IIf([criteria.notesactive]=-1,[criteria.notes],"*") or >=IIf([criteria.notesactive]=-1,[criteria.notes],0) selection criteria's in, so VBA...

Seems not The code: IIf([criteria.notesactive]=-1,like([criteria.notes]),"*") doesn't appear to work, I can't understand why the 'like statement' has to be at the beginning of the syntax, but if you put it within, the search returns nothing. Still stuck :(

I have been programming a query based on a form with each field having an 'active' tick box and a data entry, hopefully giving the user a fairly flexible interface to make queries from, but the following code is perplexing me: Like IIf([criteria.notesactive]=-1,[criteria.notes],"*") This code...

This may help you: I just did a chart and had the same 'slice of death' he he. It was actually 1 record entry that contained no data (apart from one field entry on the record). Have a look through your data and check to see if you have any partially filled records. Hope this helps??? As to...

As yet, I've had no replies from anyone to my Access problems, so here I am, trying again! I've got a query that has a one table in it, this displays various information based on the criteria plus there is a field in the table called RecID which is a child/parent linking field. I have another...

Having a nightmare trying to work out exactly what HTML templates can offer as an output source. I would like to output a report of results to an HTML form and send the results to the web, I think the information that would be displayed would be classed as 'static' is that right? If so...

Im trying to randomize some figures into a child form, which in this code works, then I want to order the records by the random numbers, (this is the bit I'm stuck on!), then once ordered, I want to sequentially number the entries (this bit also works in the code)..... Private Sub...

Im trying to randomize some figures into a child form, which in this code works, then I want to order the records by the random numbers, (this is the bit I'm stuck on!), then once ordered, I want to sequentially number the entries (this bit also works in the code)..... Private Sub...