Search results

I have two problems in the attached sample. 1. If I leave the recordsource statement un-commented, the code goes straight to the "Createdby_Gotfocus" event, runs it then returns to the onload event. Comment it out and the code runs as expected. 2. With the "on error resume next" statements...

My sincere thanks to all. The brackets have been removed. I find the error messages, in many cases, do nothing but increase the angst. Messages like "Expected bracket" etc are of little, or no, value. I finished up using Arnelgp's suggestion with "Select distinct" added and the group clause...

Thank you. A constructive suggestion is most useful.

This sql string tells me it expects ")". There must be one place I haven't tried and I have no idea where that place is. The problem is in the where clause and specifically after the "And", as I read it. The where clause was originally a "Having" clause but this seemed to be causing even more...

It depends entirely on where you place the "set rs1". If it is placed before the delete * you will have to close and reopen the recordset. A .move first or last will throw an error. Incorporating the "rs1.Move 0, rs1.LastModified" construct will allow the last record to be seen but a subsequent...

And that is where the original problem started. I would, traditionally, delete before opening the recordset, but when it came to a .movefirst in the code, is when that error appeared so I have been wrestling with various configurations to try and solve this. The sample I posted was the last...

I have a simple table that acquires a few records during the operation of a module. After acquiring 4 or 5 records this table is read to indicate where action is required. My problem is that I am getting an error indicating the "record is deleted." Prior to running the module I delete all...

Correct. I set the ANSI compatible SQL some time ago as it simplifies "?" using SQL strings and doesn't affect stored queries. Thank you all for you comments.

I finished up with .Filter = "[Collector] alike '" & sFilter & "%'" This works as required. Thanks again for your help.

Thanks. Much appreciated. John

I'm not really stupid, it just seems that way sometimes. John

I have a list of names in a field "Collector" that can include the names of others in a team, .e.g. "Jones. K. Smith. W." I want to filter this field such that it will return all fields that include "Jones" . I have tried many variations of the code below but .filter always returns "False"...

I've never really got into debug.print but I do frequently use msgbox as a debugging tool. In the case of an sql string, however, the cause of the error is often a bit vague. In this particular case the error messages were just a little above useless. As for running on data, I never run...

Point taken. I wasn't considering the sql string as a whole, but just that particular part of it.

Hi. I'm not building a string, I'm restricting the result to a particular part of a field. In this case "Collection", in another case "Parks" hence the variable. Regarding the '0', I agree this should not work, but it does, or appears to. If I remove the quotations the sql string errors.. I...

I enclosed the sTable in " & sTable & ". Now it works.

I know this is an old beast but none of my reading, or various attempts, has set me on the right path. In the code below sTable is passed in from the calling sub but is not recognised by the SQL statement. Replacing the variable with a string, "Collection" in this case causes the SQL to run. I...

For what it's worth, I run my accde files from a shortcut with the window minimised. All you see is the currently opened form.

If you first remove the files to another folder then there is nothing to lose. My copy of access died with with files open. This was the only way I could clear the lock file. The files in question were development files but the folder also housed accde test files and a copy of the system back...

It's actually fairly easy. I've just had to do this after Access stopped working. Create a new folder and transfer every thing to it except the lock file. Delete the original folder with the lock file. Rename the new folder with the same name as the original. Problem solved. Obviously on a...