Search results

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...

Thank you very much for your input. As this project has developed although my underlying requirement is still that same, How I view the problem has changed. My original request would have been the 'gold plated version'. But I believe the tool I need to do the job can be simplified a great...

The current 'Folder' structure is already in a table. I can extract/convert/manipulate it however I like, and place results in a table for my purposes. For simplicity lets assume that I have only 2 tables, the first contains a list of old folders, and teh 2nd contains a list of new folders...

Now I think about it, even showing the data in a table layout would probably be ok, rather than folder/trees (if that's too hard.)

Thanks for your quick response. It's pretty common that document management systems allow filing/classification using a folder concept. So they appear like directory tree structure, (see attached) but it truth the 'folders' are simply data in tables. It follows a pretty basic parent child...

Hi all. I'm working on a data conversion project for a a document management system. We have tens of thousands of folders to map from the old system to the new. I'd like to build a basic form which allows users to browse, filter and select folders in 2 panes. to assist mapping from old to new...