Search results

Excellent - thanks very much - all working

I'm trying to access my db via a DSN less connectoins but keep getting this message: Microsoft VBScript compilation error '800a03ea' Syntax error D:\K\F\KFIRTH\WWW\HORSESITE\FILES\../../../Connections/newttf.asp, line 7 MM_newttf_STRING = Set Conn = Server.CreateObject("ADODB.Connection")...

many thanks - problem solved - i created an invisible field in the detail that totals the column then pulled that value into a new text field in the footer

well progress is being made, i think - I have the total field working but it willonly work in the "detail" if i put it in the footer it doesnt work ?? in the detail it replicates itself after each record? is there a way of positiioning at the end of the column (in the detail) but only once? ie...

This is probably really easy - i have created a report from a query and i would like a total of one column? do i create a text box in the footer & use control source to build an expression using "sum" ? because it dosnt seem to work - if anyone could give the expression i would be extremly...

many thanks - I'l have at look at that forum - I could use Dreamweaver to manipulate the data but my web host doesn't suport ODBC you have to use a "custom string" yet another thing I am not familiar with. i thought the data access pages would be nice & straightforward - alas no ! I'll let you...

re - dap I am just starting to use daps too & have a similar problem, I dont to want to tab thro records rather display them all on one page - did you have any success on this one? reqards Kev

Does anyone know how to display all the records on one page when creating a DAP from a query? rather than tabbing thro using the navigation bar ?

I am trying to set up a DAP based on a table & it all works fine but when i select a certain field (horse_id1) from the drop down list of fields available it returns the data from another field (horse_id) which is held in a different table ?? is it something to do with relationships - any help...

many thanks - I think I see where you're coming from ... will keep in touch:)

thanks - I've just read all the info on CCB's & autopopulate & am still none the wiser - I'm off to buy a huge book !

I have just started using Access & all was going well until .... I have 2 tables - one (HorseList)contains a list of horses field & a points field - the other (Selections)contains a name field & ten combo boxes populated from the the horses field in the other table. I have created a form using...