Search results

it wasn't checked and either was the debug but it still didn't work. I done a work around now though, by doing it inside the subform and then refrencin the txt box within there

This doesn't work either =DCount("Forms![Monthly Report]![Monthly_below_report_calls]![Device].Form","Forms![Monthly Report]![Monthly_below_report_calls].Form","Forms![Monthly Report]![Monthly_below_report_calls].Form![Device]='DISP'")

erm.. im not sure how do i check??

Do you mean: - =Me.Monthly_below_report_calls.Form.Recordset.RecordCount That doesn't work :(

Hi, I have put this in the control source =DCount("Device","Monthly_below_report_calls.Form!","Device = DISP") The field is device, and the criteria is DISP i get #ERROR in the txt box instead. When i am just look to get the value i use this: - =Monthly_below_report_calls.Form![Call ID]...

Hi, In 2000 and xp i used this code to count the rows of a sub form : - subform_controlname.form.recordset.recordcount this no longer works in 2003 and i just get #Name? appearing instead??? Any idea's on why that is?? Thanks Adam

i take it you have no idea?

Hi, I have a sub form on my form which displays the normalised data on a datasheet. I have managed to create a txt box on my main form that contains the number of records within that subform by doing this in the control source. ControlSource --> =subform_controlname.form.recordset.recordcount...

They are all in the same database you know??

How do i do that??

Hi, I have a table that contains a list of calls made, it has a field called Line Add. Now Line Add is a certain object, so in the database there could be 20 calls based on the Line Add. What i need the form to do is have a next and previous button, but rather than just going to the next line...

Ok i have done all the first bit : - sql code = SELECT Complete_call_list.[FS-ID], Complete_call_list.[FS-ID], Monthly_cleansed_figures.[Average Availability], Complete_call_list.Reported FROM Complete_call_list INNER JOIN Monthly_cleansed_figures ON Complete_call_list.[FS-ID] =...

Is it a little unclear what i am after??

Hi I am new to this forum and fairly new to access, but i have been doing mysql for some time. Ok, i need to create a query that can do this: - I have two tables (tablea and tableb) tablea has among other fields lineAdd, reported date tableb has among other fields lineAdd, relevence date...