Windows XP Home Edition
VB 2005
MS Access 2003
I am having problems importing mdb information from access to visual basic. The first application worked fine, but the second one refuses to work, giving me a list of build errors pertaining to "[whatever] not defined..." see below
Error 1 Type 'AirlineReservationForm.Sennello_06DataSet' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 28 37 AirlineReservations
Error 2 Type 'AirlineReservationForm.Sennello_06DataSetTableAda pters.FlightsTableAdapter' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 30 38 AirlineReservations
Error 3 Type 'AirlineReservationForm.Sennello_06DataSetTableAda pters.ReservationsTableAdapter' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 37 43 AirlineReservations
Error 4 Type 'AirlineReservationForm.Sennello_06DataSet' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 195 45 AirlineReservations
Error 5 Type 'AirlineReservationForm.Sennello_06DataSetTableAda pters.FlightsTableAdapter' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 197 46 AirlineReservations
Error 6 Type 'AirlineReservationForm.Sennello_06DataSetTableAda pters.ReservationsTableAdapter' is not defined. C:\Documents and Settings\msennel1\Desktop\hw6\Airline Reservations\AirlineReservationForm\AirlineReserva tionForm\AirlineReservationForm.Designer.vb 204 51 AirlineReservations
What I have in Access are two tables that link a list of passengers to a list of flights. The flight table has 4 fields: flight number (Key); departure city; arrival city; date. The passenger table has 2 fields: flight number; and name (key). They are linked via flight number. Queries were built to display the passenger list for each of the 5 destination cities: Boston, LA, Toronto, Dallas, and San Diego. The GUI contains (among other things not pertinent) a combobox, three textboxes, and a listbox. The combobox is supposed to display the flight number and allow the user to select from a dropdown list which flight number to display. The textboxes (located below the combobox) then display the rest of the flight information: Departure city, arrival city, and date. A listbox to the right of the textboxes is supposed to then display the related passenger list based on the flight number. However, I cannot get the import to work AT ALL. I am following the "Add Data Source" process to a 't' and when I debug (even with no values assigned to the controls) the above errors pop up. I know I need to give more information, but I figured this would at least be a start. Oh and the Access part is working fine in access.
In short, what am I doing wrong and how do I fix it?
ps how do I attach a screenshot to this post?