Recent content by krzysiekk

Hi I wrote code: DoCmd.SetWarnings False DoCmd.RunSQL "INSERT INTO scheme_job_it ([job_no],[status]) " _ & "SELECT 'R'+Right([next_job],5), [Forms]![it_form]![Text133] from scheme_job_no" when I execute I'm not receiving errors and nothing been inserted into table, when I change code to...

Hi I found problem with insert in vba. DoCmd.RunSQL "insert into SeqNo (SequenceNo) Select seq From print_all WHERE line = '01' and reqd_date = [Forms]![Production Plan]![Text5] and seq = '1'" is not possible to execute because in criteria where I specify same field. But I need specify seq...

Anyone know hot fit two pages in detail section in report??

any advise ?

I designed report for A3 double side, is not possible to fit A3 size double on detail (is not possible to setup height more than 55.873), I designed in report header first page and on detail second page, now I printing one page double sided with no problems for one row. But when I changed...

Hi Its possible to print report for every single row from query - I need print report "Report1" separetly for every singl row but pressing one button.

thanks working fine

still nothing

hmmm, when I updating same order number list and table working fine but when is different mean should be working like then still not working I checked with * and with %.

DoCmd.SetWarnings False DoCmd.RunSQL "Update scheme_tatm set status = 'R' where tran_reference ='" & List192 & "' ANDstatus = 'A'" Me.List192.Requery Working fine but still keeping same rules with my first script DoCmd.SetWarnings False DoCmd.RunSQL "Update scheme_tatm set status = 'R' where...

is not multi select list Bound column is order number (text)

not working - looking value List192 but List192 is List box where I selection value

Hi I have problem with double click event to update table DoCmd.SetWarnings False DoCmd.RunSQL "Update scheme_tatm set status = 'R' where tran_reference = List192 and status = 'A'" Me.List192.Requery Working fine, but I need setup update: where = tran_reference like List192 but I don't know...

Ok now working fine. Thanks

DoCmd.RunSQL "Update cost set pallet_cost = " & Me.Text2 & " where order_no = '" & me.Text0 & "'" still not updating, strange when I created separate event just for DoCmd.RunSQL "Update cost set pallet_cost = [Forms]![Form3]![Text2] where order_no = [Forms]![Form3]![Text0]" working fine...