Search results

Problem solved, it was not actually the autonumber field. It was several other fields that were set to mandatory that were not in the input sheet. Weird message!!! Thanks for the help all.

Hi, I have defined a range (import_range), and reference the range. The error message refers to line 94, which in the excel spreadsheet is the last line with data. However, it is using row 1 as a header, which mean rows of data it would actually be the next line, but that is not included in...

Thanks. There are none. It's actually the last record that reports the issue.

Thanks, I have not done that before, but happy to have a go!

Hi I have a table that has a PK that is an auto number (Contact_ID) I exported the table, added data from another source that I need to bring into the table, and tried to reimport it. I populated the Contact_ID starting with the next sequential number. I get an error message that says "Null...

Cheers

Thannks very much, I was able to make that work,

Thanks, playing with it now.

OK, so I have created that table. So how do I create the Form: Tournament - Subform Contact (as I need to see some of the the contact detail) and then how do I select a contact to appoint to that tournament?

Thank you, let me play with that.

Hello I am writing an access database to link appointing officials to tournaments. I have a table called Tournaments (contains an auto-number for Tournament_ID and a number field for Contact_ID), and a table called contacts (contains an autonumber for Contact_ID and a number field for...