Recent content by aph

Thanks for the reply MajP

Hi All, I have a form where users can attach word docs too (in the form the data is classed as "attachments"). What I would like to do when the form is printed as a report I would like at the attachments associated with the report to be printed at the same time is this possible? Any info...

Cheers Andy thats what i was trying to think of the name of

Hi all I have a colum report that has a number of headers for the data E.G Date, Operator, Quantity, Disposition what I want is when the Disposition field data = "Scraped" (this is an text input drop down from a form)then that in the Report is highlighted red. I have doenthis before but cannot...

Ok had another go with the same code with same result control name control sourse are as follows Start date is Control name Text7 Control source =[Errors Via Type 2]![StartDate] Finish date Control Name Text9 Control Source =[Errors Via Type 2]![EndDate]

yup used the code i'll re do it tomorrow and post back

the sql is listed above control name, and the control source don't know what you mean?

Hi finally got to try it and I'm getting this appearing in the text boxes #Name?

Cheers I'll give it ago tomorrow at work [thumbsup2]

here it is :-) SELECT error_log_table.ppl_date_el, error_log_table.unit_el, error_log_table.d_number_el, error_log_table.customer_el, error_log_table.bag_reference_el, error_log_table.error_type_el, error_log_table.quantity_el, error_log_table.disposition_el, error_log_table.notes_el...

err don't know how do i see the code?

Hi PHV, Via Text box that appears when Query is run E.G Please enter start date "user enters date" Please enter end date "user enters date" Done via Criteria in the query

Hi all I have a report that has a graph in it from a query the data from the query is generated via a user input of the user entering two dates. Is there any way of not only displying the graph which is working correctly but also to dates entered from the user in the report? Kind regards Andy

Cheers dhookom for the info, maybe if I create a new form customers from a table then inspection from another table then setup as you say I may be in luck :)

Have a table with a list of inspections listed via numbers and customer names (plus other inspection data) so the list of inspections is 1 - whatever but different customers are entered at different times. EG. Inspection / Customer 1 / A 2 / B 3 / C 4 / B 5 / B 6 / A But I want to create a form...