Search results for query: *

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...

cheers MazeWorX i'll give it a try Merry Christmas & Happy New Year to you. :-)

Hi i have a form where customer names are shown as they type in. EG as I type A it will start to show Andrew blah blah blah The names for the form are in a table of customers names. I now want to write a query so you can list all records for a given customer BUT when I run my current Query at...

Hi main main link is you have to enter the job number into the main form and the sub form I'll have another go and see what happens. "OK, I created a sample using two tables. The main form based on the first table and dragged the second table on to the form thus creating a sub form. I entered...

Ok basically the main form is for recording production data E.G customer, job number, type of material used etc.. The data sheet is because some of the data recoreded needs alot of enteries E.G in this form we record measurments every half hour and so over a 12 hour production run there are...

Hi I've a form from one table that has within it a datasheet from another when I click on a standard new record button it creates a new record for the main form but the data sheet stays as is showing all the previous data entered on it is ther a way that when you click new record for the main...