Search results

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

i do. have tried playing arounf with the code, but can't get it to work at all. still feeling my way around all this. Sorry

Ok guys. point taken. will be more descriptive from now on The other reason for wanting to reset the number back to 1 and then increment is because some events will have limited spaces. by resetting the BookingID to 1, the user can easilt see how many delegates are on the event in question.

The reason for this is that the owner of the DB wants to write a bookingID on each from for each event. they want the number reset to 1 when a new event is added.

Help please I am wanting to create some code which will resest a field. I have a form called frmEvent which lists Events being offered. Against each Event are a list of Delegates, and these delegates are picked from a list of Contacts. What i want to do is if say Event 1 exists, and there are...

i'm ok doing basic code stuff on the On Open, On Click events etc. Wheni open the FrmDelegate, the defualt value in the EventID is linked to the frmEvent which is the previous form