Search results

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

Another thing to think about is that in order to create your forms i.e the one you already have created correctly you are going to need to create a query for the form to be based upon. Use a query to bring together the information required on the form so that you can bind the form to said query...

make the flight number field in the "flight information" table a PK (primary key). Change the field names of journey type and trip type to journey id and trip id. by doing this the last 3 fields in the table are now your FK's (foreign keys) Then open the relationships window by clicking "tools"...

if the date to fly information from your "Passenger Booking" table is going to be different data from that held in the "Flight Information" table then it would sense to leave the column in but surely if the customer wants to fly on say 16.10.05 they would only be able to fly on this day if there...

also a good tip would be, when naming forms, tables, queries etc try to keep to a standard format such as tblFlightInformation for tables qryFlightQuery for queries and rptFlightReport for reports etc...

if you have a form that you have already done in another database and you want to import it into your new database just click on "file", "get external data" and then click "import" locate the old database on the computer and select it. you will then get a new window asking you want you want to...