Recent content by kiwipeet

Thanks to all who have replied so far, Lots of handy tips. I think what i'm looking for is higher level reccomendations. Is what I'm proposing doable using straight forward techniques? Looking at the whole requirement, would it lead you to take a different approach? For example, A looong time...

Yes i've scrubbed the data, and enforced constraints in SQL. Thanks for the tip, I'll no doubt come back to this. Yep. Solid advice with names and reserved words. I bear the scars of mnay years worth of being burned by this stuff :)

Thanks for your reply. I'm familiar with naming conventions and use of square brackets.

Hi. Apologies if this has been done before. I'm unsure how to tackle this as it spans several aspects. I've been given the task of updating a 20 year access db owned by our local library. It contains history about local streets. I've moved the back end to SQL Server and am trying to build the...

Is it access only? Or connecting to SQL Server?

Ensure you have the primary key defined correctly. edit: I recall getting errors like that when connecting MS Access to SQL Server. This was resolved by ensuring the primary key was defined either n SQL server itself or in the linked table manager. (I can't recall which.) :confused: From...

Into a table and create a view which does the conversion on the fly?

What about importing the data

Will do. Can't do that from phn.

Traced issue to missing primary key definition. The sql table had a primary key but access was unaware of it. Apologies for taking 6 years to reply :)

Eureka!!! I changed the code so that it's using a Clone, it was hard to tell if it made much difference.. However.. The fact that it was working faster on small test table than it was on my large suggested to me it wasn't the loop causing the delay. It suggested to me it was Server side...

Cheers, I will try that. The numbers of records could vary worse case ~17,000, diminishing down to a single record. So far that part is performing really well. I have 266,000 records in a table, and the filtering works remarkable well. However I was thinking I could exclude records once they...

Woohoo!!!!!! Private Sub Command7_Click() Dim rs As DAO.Recordset Set rs = mapto_subform.Form.Recordset MsgBox mapto_subform.Form.Recordset.RecordCount With rs .MoveFirst Do While Not .EOF .Edit !priority = Me.maptofield.Value .Update...

Many thanks for your quick reply. I'll start investigating that. :) <Deep breath> About to venture into the VBA wilderness ;)

Hi All. I have a table of data in SQL server attached via Linked table (200K+ rows). I have created a form which has a a subform which displays the contets of my linked table in datasheet view. I can filter rows and reduce my visible record set. (very cool so far :) ) The number of...