Competent Performer
Windows 7 64bit 
Access 2010 64bit
I have a field which may include the phrase "submission of data". I need to find all records where this phrase is inconcluded in that field. No matter how I set up my query, I get a response that says "record deleted".
In the field where the phrase would be, in my last atempt I have set up the criteria as:
Like "*" & [enter phrase] & "*" I then, when prompted, type in submission of data. That is when I get "record deleted".
????????
Me.Dirty=True
Windows 7 32bit Access 2010 32bit
try aliasing a field using Instr() and setting the criteria to <>0.
Code:Test: instr(1,[YourFieldName],"submission of data")
Virtually Inert Person
Windows 10 Access 2016
You should post more about what's going on before and during the operation that generates the error. I suspect you're trying to delete records based on criteria for some field that was just deleted. I could be wrong, but I don't see what getting the right syntax on your criteria input has to do with the error message.That is when I get "record deleted"
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Finding records in table using DCOUNT but not finding them in SELECT
Using user-entered data in unbound fields as Variables to build a phrase.
Finding same ID that has both values in another field
Posting Permissions
Reply With Quote