List Page not Formatting Correctly

Julie,
It sounds like some error happens on this page that prevents data from

displaying.
To see exact error message open ..._list.asp file in any text editor

and change the following line:
On Error Resume Next
to
'On Error Resume Next
After that you can run this page again and see error message which you can post here.

Hi again,
Many thanks for the reply.
The error code is:
**

ADODB.Recordset- Error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/qryAllClients_list.asp, line 684

****
This is the line of code that corresponds to 684 (and a couple more)


if (rs.Fields("tblClientDetails.FirstName").Attributes and 128) and ( rs.Fields("tblClientDetails.FirstName").Type = 204 or rs.Fields("tblClientDetails.FirstName").Type=205 ) then [/COLOR][/COLOR] Response.Write Label("tblClientDetails.FirstName") & "</td>"

else

%>


This actually gives me a clue. I have two FirstName i.e. tblClients.FirstName and and tblConsultants.FirstName (also Surname) and these keep disappearing of the 'List' page. When I set it up it is okay, but when I go back they have gone. I will try giving an alias to the field names so they have different names and see if that helps.
If you think it is something else then let me know.
I will let you know if this solves my problem.
Regards
Julie

www.simply-access.com

Hi again,
Yes that definately solved the problem.
I should have known as the cause of many of our headaches is our own sloppy database ettiquite.
Thanks for getting back to me quickly and pointing me in the right direction.
I will try to keep up with the aliasis to ensure all field names are different.
Cheers
Julie

www.simply-access.com

Hi again,
A follow up question to the above. Changing the field name, appears to change them in the List form (which now works well) but not in the View or Edit forms (the old field names remain)- so now I get an error when I go to these forms (as per below)
Is there any way of quickly fixing this, or do I have to do it all over again?
If I have to do it all over again, well it will certainly embed the lesson for me. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3107&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />
Many thanks
Julie

www.simply-access.com
***

ASP error happened
Technical information

Error number -2147217900

Error description [Microsoft][ODBC Microsoft Access Driver] Invalid bracketing of name '[tblClientDetails.FirstName]'.

URL /qryAllClients_view.asp

SQL query select [EnquiryID], [CurrentAddress1], [Current Emplyment], [NOKName], [tblClientDetails.FirstName], [CurrentAddress2], [EmploymentBusinessName], [NOKAddress1], [MiddleName], [CurrentSuburb], [EmploymentAddress1], [NOKAddress2], [tblClientDetails.Surname], [CurrentPostcode], [EmploymentAddress2], [NOKSuburb], [DOB], [CurrentState], [EmploymentSuburb], [NOKState], [Gender], [PreviousAddress1], [EmploymentPostcode], [NOKPostcode], [LicenceNumber], [PreviousAddress2], [EmploymentState], [NOKPhone], [ExpiryDate], [PreviousSuburb], [EmployerContactName], [MaritalStatus], [PreviousPostcode], [EmployerContactPhone], [HomePhone], [PreviousState], [PreviousEmplyment], [Mobile], [PreviousEmploymentBussinessName], [Email], [PreviousEmplymentAddress1], [PreviousEmploymentAddress2], [PreviousEmploymentState], [PreviousEmploymentPostCode], [PreviousEmploymentContact], [PreviousEmployerContactPhone], [tblConsultants.Surname], [tblConsultants.FirstName], [TypeLoan], [Amount], [ConsultantFK], [ConsSurname], [ConsFirstName], [ClientSurname], [ClientFirstName] from [qryAllClients] where [EnquiryID]=1

Julie,
I'm glad you were able to resolve the issue.
It sounds like instead of [tblClientDetails.FirstName] you need to use [tblClientDetails].[FirstName].