Recent content by JimmyN

I have checked and both the Link Master Fields and Link Child Fields properties are null.

I have a database in Access 2000 format. It has a main form with two subforms. The data on the subforms comes from queries based on the values of two controls on the main form rather than by a Master/Child link. Everything works perfectly in Access up to version 2003. In Access 2007 one of the...

I have developed a split database for a client although there is currently only a single user. The path to the back end on the client machine is similar to C:\Program Files\Database\BE.mdb. This path can be recreated on my machine in my office so I can easily work on the front end and send it...

Thank you PH - problem solved. JimmyN

I have a form (MyForm) with many identical bound textboxes that all need the same OnDblClick event. I don't want to have code for each control but rather call a function. The function is very simple - enter a numeric value into the bound field and change the control's back colour. The function...

I am currently extending a ticket booking system to include seat allocation. I have a table which represents a block of (say) 676 seats. The first field column is called 'Row' and there are 26 records for the letters A-Z. I then have field columns for the seat numbers (1-26) making up a grid...

Hap, Thanks for your help. Option 1 worked fine. I guess I should have thought of this but Access 2003 offers you to convert to 2002-2003 format so I assumed this format would be compatible with 2002. Thanks again.

I have an MDB on a development machine running Access 2003. The database is in Access 2000 format. I need to create an MDE to distribute around machines running Access 2002. In MDB format the database works fine on all the machines running Access 2002. I understand that I cannot create an MDE...

I have 'got round' the problem by changing the generation of the autonumber in the main table from Incremental to Random. This avoids the clashes when the records are added into the gaps. If anyone has any comments on the original problem they would be very much appreciated.

I have tried the Recordset method using .addnew and .update but it is still adding records into the main table into gaps in the sequence of autonumbers in the ID (primary key) field and not onto the end of the table.

The Autonumber field is called ID

I use a form to build a list of records into a temporary table, and when the user has completed the form I run an append query to add the temporary records into the main table. The idea is to be be able to delete all records from the temporary table if a user 'abandons' without affecting the...

I have an Access application which uses automation to send emails. This works fine with the Outlook 8.0 & 9.0 object libraries, but won't work on a client running Outlook 2002 and the Outlook 10.0 object library. I think this may have something to to with the MS Email security update. Anyone...

I have a split database. Before some complex operations I need to make temporary copies of two tables in the back-end as a backup in case the operation is abandoned. I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table...

I have a split database. Before some complex operations I need to make temporary copies of two tables in the back-end as a backup in case the operation is abandoned. I cannot use the CopyObject method as this creates a copy of the link to the back-end table, not a copy of the actual table...