Search results

That does exactly what I need thanks, jdraw.

What is the syntax using the keyword BETWEEN for finding characters with ASCII values in the range 192-255?

Thanks for your suggestions. Why is it that this works ... Like "*[X-Z*]" ... but this doesn't? Like "*[À-ÿ]*" If this works for a single character ... Like "*[" & Chr(192) & "]*" why doesn't this work for a range of characters? Like "*[" & Chr(192) & "-" & Chr(255) & "*]"

Thanks for your reply. Just directly typing in characters works for "Basic Latin" (English) characters but not for "Latin-1 Supplement" (other European) characters. (a) To search for records where the field contains a single "Basic Latin" (English) letter, say "X", either of these works: Like...

I am trying to create a query that will find records where a "CustomerName" field contains any invalid characters. Valid characters are (1) space, (2) hyphen, (3) apostrophe, (4) "Basic Latin" (English) letters (Aa-Zz), and (5) "Latin-1 Supplement" (other European) letters (À-ÿ = extended ASCII...

I just tried adding back the extra tables to the query to get the data for the conditional formatting, and there was no noticeable difference in performance between this and DLookUp, but with the recordset type set as "Dynaset (Inconsistent Updates)", the uneditable fields became editable. I...

Thanks for your further reply. Using DLookUp for the conditional formatting was arnelgp's suggestion in another thread, because getting the data needed for the conditional formatting from the query required some table joins that made some fields on the form uneditable. DLookUp is a tad...

Thanks for your reply. I used fictitious field names to make it easier to follow; looks like I should have picked different ones! Is there a technical reason for a conditional formatting expression like this to work in a form but not in a report? Expression is [OrderType]=2 And [Size]>0...

Thanks for your reply. I will try your suggestion. Is there a technical reason that my conditional formatting expression works in my form but not in my report?

Thanks for your reply. Yes, DLookUp returns the first match it finds. In this recordset, this DLookUp term will find a unique match for each record, so that is not a factor. The issue is that I have a form and report that both have the same conditional formatting expression; however, it...

I have a form and a report in Access 2010 that both do essentially the same thing: they both use the same query as a data source, and they both list the same fields. I have added conditional formatting to several of the fields in both the form and the report, and this works in both the form...

Thanks for your reply. I haven't used DLookUp before, but I tried this and it worked fine.

I have a form in Access 2010 where the data source is a single query (Query1). The form includes a field (Table1_Field1) that the user can edit (field properties has Enabled = Y, Locked = N, and form properties has Allow Edits = Y), and this works OK. To enable some conditional formatting on a...

OK thanks, I've got it now.

Thanks for your reply; however, I'm not very familiar with SQL code. Is there a way to do this in the Access query grid? Alternatively, as the single record in the Parameters table only needs to be read once to obtain a couple of fields from it to use as constants in a couple of conditional...

I have an application that includes a "Parameters" table containing a single record (no key) with a number of fields that represent alarm thresholds. I want to use a couple of these fields in a report, for conditional formatting when certain values exceed the thresholds; however, when I add the...

I used a different name for the field (but FYI, I tried [Level] just now, and that works too. :)

OK thanks, that explains it. Thanks again for your help with this. The solution works fine, and I learned a lot.

Thanks, that works now. However, when I changed the "Item, IsWhere, TheColor" field names (in both the code and the table) to "Id, Level, Area", and the "Back" and "Front" value names to "A" and "B", I got an error: "Run-time error 3134. Syntax error in INSERT INTO statement." Are there...

Yes, I replaced your first line with "Private Sub Run_Click()". No, I only have one (last) line with "End Sub". I'm afraid I can't post a sample database, as the tables are in a linked SQL Server database. I discovered that I needed to select the DAO object library, and when I did that, the...