Search results

Thanks Wayne, that's solved the problem. Cheers.

Thanks Wayne. I've added an ORDER BY clause: strSQL = "Select * from tblSamples where Face_ID = '" & strCut & "' ORDER BY Counter;" Do the indexes in the subform and underlying query not sort the data selected by the SQL string? Or can the Select string produce a set of records that somehow...

Using Access 2002 SP3 on XP SP2. Database is an underground mine mapping tool. A rock face is sampled across its width, the geologist enters the Face_ID (primary key of Face table). Each face has multiple samples in the Samples table (tblSamples), linked to the Face table with a one-to-many...

Thanks for that - any idea what might be causing the corruption? This is the key because I need to stop it happening again.

I'm having lots of erratic problems with our Access database. Back end tables on the server, front ends on workstations. Running Windows 2000 server, Access 2003 SP2 on Windows XP SP2. I'm not the network administrator so don't have much detail on network. For instance, the back end is...