Search results

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 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...

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...

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 have a table with a field that lists attributes (say, colours), like this. [Colour] Blue Green Red I have another table with a key field ("Item") and two memo fields ("Back", "Front") that contain these attributes, like this. [Item], [Back], [Front] Item1, Red, Green Item2, Blue, Green Item3...