I am using access 2000.
I have two questions
Question 1
I have 3 tables. tblFlight, tblAircraftType, tblFlightProgramIN/OUT.
tblFlight has a 1 to many relationship with tblAircraftType, tblFlightProgramIN/OUT.
I have used tblFlight Pk FlightID as the foreign key in tblAircraftType and
tblFlightProgramIN/OUT.
However, I was testing some data and realised that the value of the tblFlight PK FlightID key does not autoupdate to equal the value of the FK FlightID in the tblAircraftType, tblFlightProgramIN/OUT.
Is this correct? Should'nt they have the same value eg tblFlight.FlightID =1(PK)
tblAircraftType.FlightID=1(FK)
Question 2
I am implementing a Global Popup Calendar from the following link.
http://www.fontstuff.com/access/acctut09.htm
However I get an error that says "You entered an expression that has no value".
When I hover the debugger over the value I get an error that says You "cboOriginator.Value has no starting value".
I entered a default value of Date() in the properties section of the cboOriginator.Value(combobox on the form). But I still get the same error.
I entered a test value in the table that links to the combobox but still get the same error.
Before I made the calendar cboOriginator a Global Variable it worked ok.
However I am using a number of comboboxes on the form to pick dates from each day of the week corressponding to arrival and departure dates eg.
Arrival Date:
Monday(cboArrivalDate1) Tuesday(cboArrivalDate2
Departure Date:
Monday(cboArrivalDate1) Tuesday(cboArrivalDate2
The name of my combobox is cboArrivalDate1.Value
Here is the code below.
Here is a the code below
Private Sub cboArrivalDate1_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
Set cboOriginator = cboArrivalDate1
ocxCalendar5.Visible = True
ocxCalendar5.SetFocus
If Not IsNull(cboArrivalDate1) Then
ocxCalendar5.Value = cboArrivalDate1.Value
Else
ocxCalendar5.Value = Date
End If
End Sub