Search results for query: *

guys thanks for your replies and i think im getting my head around this. let me explain a bit more,this is how we have to set it up. we are an airport, for example check in desk fails we get many complaints, this can then have many actions ie handling agents will deal as will airport customer...

Sorry, we can have one complaint with many customers that may have many actions CJB

i have set them up with relationships but i am still having problems displaying data from all three tables. i have tblComplaints RefNo PK & AN tblCustomer RefNo FK CustNo PK & AN tblAction CustNo FK ActNo PK & AN is this correct? CJB

It's a lot - the two tables are Complaint and Customer and RefNo is the PK / AN in complaint and the FK in customer thanks for responding <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <!--#include file="Connections/connMAC.asp" --> <% Dim rsComplaint Dim rsComplaint_numRows Set rsComplaint =...

Hi this is my first web application and i am finding it very difficult. i am trying to create a master detail page with data that is linked from 3 tables in an access database. i can set it up with the data from the 1 table but as soon as i start to insert from 2 it all go's to pot, does...

hi i have set up my Access database in Dreamweaver and set an insert page to the main table showing all the details but it does not input the reference number (which is an autonumber in the table) or the date which is set up as ()now, does anyone have any idea what i have'nt done that i should...

I've now found where my problem lies. I have a date field if i dont insert that on the form then the data is added to the database table but if i include the date in the insert form i get an error saying Syntax error in INSERT INTO statement, i need the date in the form and i need it to...

Hi i am setting up a web based system in Dreamweaver. i have created a form for users to insert a new record but when i add the details and press submit i get an error page and the details are not entered into the database. the ref number is an autonumber and the date is now() but neither of...

Hi i am having difficulties setting relationships with three tables. We will have one complaint with many customers and that customer may have many actions against it. tblComplaint RefNo Autonumber / Primary Key ShortDescription FullDescription tblCustomer RefNo CustomerID Autonumber...

no because one complaint would belong to only one department? CJB

Thanks both. if i use 4 tables what will i form the relationship on? as there are going to be many departments with many complaints? CJB

i have been asked to create a database to record customer complaints and am unsure how to seperate the fields into tables and form the relationship. There are not to many fields just ID number, Date, Department, Category, Short Description, Full description, customer details, action taken &...

Is it possible to change the background colour of a tab control box? CJB

Hi Jamie, Don't know what happened but have come into work this morning & tried again by creating a new query and exactly copied and pasted your last code and it's actually working and working exactly as i wanted. So thank you very much and thanks for staying with me through this, now i can...

Hi Jamie, I' getting there, first thx for pointing out my error in the naming of the fields i've been working on this project for a while now and i think you get blind to things i hadnt even noticed the mistake in the staffNo etc but thx. i hadnt taken out the Title & LastName that was strange...

Jamie, At the moment i have no errors but it is still not working, balance is showing the same figure ass entitlement and i can't edit any of the fields only entitlement. THank you very much for all the help you are giving me on this This is my SQL SELECT tblHR.StaffNo...

Jamie i have messed about a bit and now get figures in every field except balance still shows #error, plus i am unable to add any data, when i close the query i get the message "syntax error (missing operator) in query expression '([AnnualLeaveFrom] <= Format (#27/03/2002#, dd/mm/yyyy') AND...

Jamie i am using a string so it should be the same as yours, though none of your code is highlighted CJB

Jamie, once again thanks for responding, i pasted the above code into my sql and all it has given me is a load of #error's, apologise for being a bit thick CJB

Hi All I am still trying to get this to work and what i am now getting is "Circular reference caused by alias in query definitions SELECT list (Error 3103). i can understand that i am creating the circle but am still not able to rectify it???????????????? CJB