Recent content by BoroLee

Mile, In case your interested, i got it to work using the following : Private Sub cboContact_AfterUpdate() If DCount("BookingID", "tblPersons", "[EventID]=" & Me.EventID) = 0 Then Me.BookingID = 1 Else Me.BookingID = DCount("[PersonID]", "[tblPersons]", "[EventID]=" &...

' Import SpreadSheet and name the table ExcelImport DoCmd.TransferSpreadsheet acImport, 8, "ExcelImport", _ "\\Tech02\TrainDB\Training_DB\Trainers Report.xls", False don't you need to change the False to True?????

Is your report based on the tables, or a query????

wot happened was i was given a spec to design this thing. i was told it was working as they wanted, then hey presto, they changed there minds and decided that people could not be a delegate, if they were not a contact already. it was kinda wot i wanted. thought i would be able to populate the...

cheers for all your help, but that does not help me. My tables have been populated so don't want to strat creating new tables. don't get why i can't do wot i wnat with the tbl's i have

I still don't think i'm getting this across correctly. tblContacts holds all the details about people. tblPersons only holds the ContactID from tblContact. Therefore no duplication of data. tblEvent holds all details about Events. tblPersons only holds the EventID from tblEvent. Therefore no...

i think that tblPersons may be confusing. SHould really have been called tblBooking

I have in my db : an Events tbl which handles the events. a Contacts tbl which handles contacts. New delegated MUST be a contact first a Persons tbl which shows the Event they have booked on from the Events tbl, there ContactID from the Contacts tbl and a BookingID. This is the number is want...

OK i understand where you are coming from. However, don't want a PersonstoBookings tbl. Why can't i just operate with the 3 tbls

The BookingID too me is the number in order that person has booked on the specific event

No-one can be in tblPersons without first being in tblContacts. Hence all delegates, must be a contact first

There is a tblContact, tblEvents, and tblPersons. Each of these tables has a primary ID key. The idea id that the tblPersons will hold the EventID, and also the ContactID from the tables. The BookingID is only in tblPersons

Ok. It's baiscally this : PersonID, autonumber and primary EventID, number ContactID, number BookingID, number the EventID is a defualt from the prvious form, the ContactID is selected from a combo on the form, and the BookingID is the one i'm trying to resolve

have changed it too Private Sub cboContact_AfterUpdate() If DCount("BookingID", "tblPersons", "EventID") = 0 Then Me.PersonID = 1 Else Me.PersonID = DMax("BookingID", "tblPersons", "PersonID") + 1 End If End Sub but i'm still only getting a 0 in the BookingID field

This is the code i've got attached to the AfterUpdate Event on the field cboContact. Private Sub cboContact_AfterUpdate() If DCount("PersonID", "tblPersons", "EventID") = 0 Then Me.PersonID = 1 Else Me.PersonID = DMax("PersonID", "tblPersons", "PersonID") + 1 End If...