View only records with uppercase letters for a certain field
Thank you for taking the time to report an issue.
What's wrong... Please write below.
But I need a way to show the girl with the most letters written to her. A top value is what I need.
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
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?
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
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,
Name | School | Home | Child
1. x | x | x
2. x | x | x
3. x | x | x | x
4. x | x | 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.
- 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.
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?