Recent content by daherb

Have you checked to see if the default settings of the fields you are filling in and updating are set to required (no) or allow zero length (yes)???? might be the first step to identifying the problem.

OMG i'm an idiot. LOL thanks for the response, very much appreciated

I am very new to VB and i am trying to learn more and more so that i can get better control of my databases. Hopefully someone can help me with this problem. I have a form that allows music albums and tracks to be stored along with their location etc. On the form the first control is a combo...

the 4 records that are locked are these the only records in the table???

So in addition to the tables list minus tblstockingoption tblStockSheets SheetID (PK) Width Length tblStockReels StockReelID (PK) Width tblBespokeSheets BespokeSheetID (PK) Width Length tblBespokeReels BespokeRellID (PK) Width

Looking at this further as i have been doing for a while now i have noticed that the supply option table is incorrect and would not work as i need to record the sheet sizes and reel sizes. - i am going to re-organise the table strutcure and post it back up in a second.

Hi Guys, thought i would pick your brains to try and help me figure out how to build this database. Any help would be very much appreciated as this one is making my head spin. Brief:: I need to create a database that will hold information about our suppliers and the products that they stock...

Your still not thinking through exactly how things need to work, why would you need to provide passengers with a flight time after they have made the booking, the system would provide this when the booking is made. You need to sit down and think about exactly what the clerk would do when taking...

The thing i dont understand is why are you trying to have the passenger name in a drop down???? surely the clerk is going to have to enter the name of the customer as they are making the booking, because the customers name is not going to be in the system until thgey make a booking. The only...

The reason it asks you for a parameter is because you have told it to order the results by surname and firstname, yet you do not have a field called firstname, the field is called forename

Yes what you have in your bookings tbl is good, make sure you change the data types of flight, journey & trip to number, long integer not text or relationships wont work when you come to make them.

no problem

search the internet for a package. No one is going to supply a complete shopping cart script basic or not for nothing. any asp script will work with access all you need to do is link the database to the website with an ODBC link. Good Luck. One package that i can recommend for good value with...

Make the field a memo instead of a text type that way you are not limited to 255 characters.

it is not the flight numbers that are too complicated, i have recreated your database, but have split the original tables down even further than you have so each table only holds the information relevant to the table. i.e tblAircraftInfo - only contains FlightID (PK) holding the flight...