Search results

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

Thanks for your reply. Normally I would agree but in this case I see it as the most practical way of addressing other issues I have. I need to to provide analysis of records in various time bands, i.e during office hours, vs peak 8am-5pm or 10am-3pm or 10-12. and also take into account...

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