Topics Search

View only records with uppercase letters for a certain field

View only records with uppercase letters for a certain field
Views: 72
If I wanted to view only the records with Uppercase letters for a certain field, how would I do it?
Sponsored Links:

Similar posts...

 

Sort records in case-sensitive order

Sort records in case-sensitive order Icon
Microsoft Office Access 2007 sorts records in ascending or descending order without regard to case. However, by writing a few lines of Visual Basic for Applications (VBA) code, you can sort text by its ASCII character values. Sorting on the basis of the ASCII values differentiates the uppercase letters from the lowercase letters, and results in a case-sensitive order.
 

From large to small letters

From large to small letters Icon
In a field of a table the entries are either on capital letter or small letters or capital and small letters together. I want all data in that field to turn to small letters only. (as you were typing with no Caps Lock)
 

Show how many letters for each client

Show how many letters for each client Icon
So, my primary key is GirlID and the name of the girl is Girl in the table. I also have a field named Letters (in the table) and I use this code to sum up the number of girls who have beenwritten to,,, =Sum(IIf([Letters],1,0))
But I need a way to show the girl with the most letters written to her. A top value is what I need.
 

enter a schedule # that includes letters and not just numbers

enter a schedule # that includes letters and not just numbers Icon
Basically what has happen is that I need to allow the users to enter a schedule # that includes letters and not just numbers.

I think I have located the issue in the event procedure but I am not sure. I could only get intodesign view in an old test copy however in the live db the design view is grayed out? What does that mean
 

Query expression to return text string

Query expression to return text string Icon
I have a field of project numbers that vary in the number of characters (it’s a text field). What I need are the last three letters e.g. CON, TRN, MNT, etc.

This string of letters is the only thing consistent about this text string…well, I found cases where a 1 or 2 was added to the last three letters (e.g. CON1, TRN2, etc.).

Also, CON (or other three letter endings) could be contained in the first part of the text string so I can’t just filter for “CON”. Any suggestions about how I canget my query to return only the three letters that I need so that I can later group them?
 

Import data from Excel into Access with VBA

Import data from Excel into Access with VBA Icon
I have a table named tblLetter in Access this table is updated monthly by importing data from an Excel file. The monthly Excel file contains new and open letters. Any letters that were closed during the month are excluded from the next monthly report.

I need to import only the new letters and I need to update the status field for the letters in the table based on thefollowing 3 scenarios:

1) There will be letters in the Excel file that are not in the tblLetter table. The action needed is to import the letters and enter new letter in the status field

2) There will be letters in the Excel file and in the tblLetter . The action needed don’t import the letter enter open letter in the status field

3) There will be letters in the tblLetter and not in the Excel file. Action needed enter closed letter in the status field
 

Recursion or too many records lead to "Not Responding"

Recursion or too many records lead to "Not Responding" Icon
Using Access 2003, the following snipset produces 3.628.800 records. It is actually a permutation procedure, in this example, call GRListWords("", "ABBREVIATE", 10) 10 letters to form possible words in groups of 10 letters.
My problem is that I can not get them into a table - execution holds and get the message "Not responding".
Even-more, the same happens when I use Debug.Print from the immediate window! I should also note that it never runs to more than 20K-30K records.

I've heard about the Dictionary Object,
 

How to Return all Records with Blank Cells?

How to Return all Records with Blank Cells? Icon
But how do I return all records which have empty cells for the specified FIELD

Example:
Name | School | Home | Child
1. x | x | x
2. x | x | x
3. x | x | x | x
4. x | x | x
5. x

I want to return all records except #3. Because it has all of the values. I only want to see records missing a value.

I tried to use. IS NULL in each Field in Design View (under OR not CRITERIA), but it keeps returning everything.
 

How to 'visually' mark a field in a subForm in DataSheet View?

How to 'visually' mark a field in a subForm in DataSheet View? Icon
I'm displaying records in DataSheet view in a subForm.
- the records are sorted low to high by fldX which is a number field
- my vba code compares the value of the current record's fldX with the value of the previous record's records fldX
- right now a MsgBox popus up if.
-- the two are the same. or.
-- if the current fldX value is not equal to the last fldX value plus 1 (not sequential)

changing the background color of the two fields seems to be a problem in DataSheet view.
and 'continuous view' won't work here.

Is there anyway to use 'Conditional Formatting' to do this?

Conditional Formatting may work but I'm not sure how to get there in this case.
 

Bounds fields trouble

Bounds fields trouble Icon
I have a form with bound fields. So in form view, if I click on previous and next buttons you can view the different records present in the DB.

The problem is, if I change any field value then the new value is automatically stored in the db. For example, I have a field called "FirstName" and the name is "Lisa". If I change "Lisa" to "Elisa", then it automatically gets updated in the DB.

I want it to get updated only on click of a button. So to achieve that, I made all the fields unbound and used an insert query onclick of button.

But now the problem is, I cannot view the records in the table since the field is unbound. For that the field needs to be bound. If I click the next and previous buttons now, then all therecords show only the values I typed.

Is there any way to save records only on click of a button but also view all the records by using the next and previous buttons without making the fields bound to a column in a table?