Search results for query: *

cheers for the two approaches - and thanks TheAceMan1 - i had forgotten i could do a recordset findfirst on a subform (plonker i know!) :)

from experience i get a backup prior to compact. on a number of occassions my databases have been messed up thanks to access getting somewhat confussed during the compacting process.

Auto numbers do not always follow in sequence. If you had records 1,2,3 and 4 then deleted 2,3 and 4 the next record it will create will have a value of 5. I wouldn’t worry to much about trying to get them in sequence. Rule of thumb with auto numbers is that they are used as a unique id. As...

Hi everyone, Was wondering if anyone can help me? I have a subform (datasheet) which is completely dynamic with a vertical scroll bar. Certain functions called on the parent form force the child subform to be rebuilt. When this occurs I need to locate the previous record displayed on the...

strSQL = "yardy yardy yar " & _ "dy yardy yar"

got it covered now thanks - reason i couldn't do it by name is because it's in a generic function for some mother of an application. can be done as follows: If rsCopyFrom.Fields(iFieldCount).Attributes <> 17 Then attributes of 17 is an autonumber with index

Hi All, I've got a problem and thus far no MS help has been helpful (trying to act surprised) and was hoping that the wonderful people on tek tips could help (sucking up as much as possible) :o) Simple problem really. Got a recordset say: strSQL = “SELECT * FROM tblThisTable” Set rsCopyFrom =...

the rs set line was right you just forgot the ,dbopentable. don't do a full select in an rs for all records if you don't have to! ie: Set rst = CurrentDb.OpenRecordset("Table1",dbopentable)