Search results

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

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

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

Hi. I'm trying to build a simple form which allows users to filter and edit/add new records. .mdb/.adp front end SQL server backend. I want to have a few optional fields at the top which allow the user to filter/limit the records they see in the datasheet view. (and reduce I/O) It seems like...

I have created an MS access database, which sits on the LAN and contains a single table. (The back end table has primary key). I have created a 2nd Access db, to act as a front end, which attaches via a linked table. Each user has their own local copy of the front end. I just want...

Hi I am trying to write a query to report vehicle utilisation of fleet cars. I have records for each booking with a start and end date. The booking could start and finish on the same day, or could span many days. I want to expand each record that I have one entry for each day of the booking...

Hi. I'm using SQL Server 2005 as a back end, with MS-Access 2003 as a front end is attached via ODBC linked tables. MS-Access is used mainly for queries and a couple of forms. I now want to update data in the table via the form. I can query data, and insert data without any problems, but...