Search results

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

I change and still inserting but not updateing, If DCount("*", "cost", "order_no='" & Me.Text0 & "' AND pallet_cost=" & Me.Text2) = 0 Then DoCmd.SetWarnings False DoCmd.RunSQL "insert into cost ([order_no], [pallet_cost]) Values ([Forms]![Form3]![Text0], [Forms]![Form3]![Text2])"...

Hi I just tested dcount and working when returning 0 but if not showing error 3464 If DCount("*", "cost", "order_no='" & Me.Text0 & "' AND pallet_cost='" & Me.Text2 & "'") = 0 Then Please advise

Ok I found: Before: If DCount("*", "vection", "trailer='" & Me.trailer & "' AND trailer_date=#" & Me.req_date & "#") = 0 Then I changed: If DCount("*", "vection", "trailer='" & Me.trailer & "' AND required_date=#" & Me.req_date & "#") = 0 Then Many thanks working now

Exacly I using combo box, vection table content: vectiontrailertrailer_datestatusrequired_dateLANGDONS1 U31/03/2011LANGDONS2 U31/03/2011LANGDONS1 U31/03/2011LANGDONS2 U31/03/2011LANGDONS1 U04/01/2011LANGDONS2 U31/03/2011LANGDONS1 U31/03/2011 Maybe your machine is different language or...

Your check you modification and still inseritng rows even exisiting, on you machine working fine?