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

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.

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

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

Hi I got problem with insert event in access form. I try use DoCmd.SetWarnings False DoCmd.RunSQL "insert into vection ([trailer], [status], [required_date]) Values ([Forms]![Form1]![trailer], 'U', [Forms]![Form1]![req_date]) where [Forms]![Form1]![req_date] not in (select distinct...

Hi I wrote insert query in t-sql but I need that query implement as vba script in access insert into #vttrailerm (trailer, trailer_date) select trailer_ref, Convert(char(6), required_date, 12) from #vttpstatm S where not exists (select * from #vttrailerm where Convert(datetime, '20' +...

Hi I got query with specific criteria query returning list like: Name 1 Name 2 Name 3 I loading query into Continuous Form 'sub1' Next I creating subform in dashboard form for each name I got button, default is Me.Command1.Enable = False Me.Command3.Enable = False Me.Command3.Enable =...

Hi I got form with calculated fields next step I created button which will be posted into table data from 6 fields What I want to do is create thick box and if thick box is not selected for one field and selected for 5 other fields after pressed button script will be posted just 5 fields I...

Its possible to update in field form status A to B using check box?? please advise

Hi I created simple invoice template in Access 2003 reports, I want print out on dot metrix printer (Epson), report including three section page header details and page footer, when I printing one page looks good, but when I printing second page printer starting couting new page from last line...

Hi I try use function left and len, Function: Field1: trim(left([Field0],len(Field0)-1)) not working any sugestions?

Hi I got some vba script and but function IIF not working please help Dim stDocName As String Dim prodtype As String Dim prod As String Dim copies As String copies = DLookup("scheme__ProductionPlan.template_copies", "scheme__ProductionPlan", "scheme__ProductionPlan.seq =...

Hi I got report to print for every day. Is any chance to allow user using access to print just two copiers each reports. When someone try press 3th time button "print" report will not be printed. its possible?

Hi I got 4 reports, - (rep1, rep2, rep3, rep4) each 5 pages its possible to print report like that: rep1 - page1 rep2 - page1 rep3 - page1 rep4 - page1 rep1 - page2 rep2 - page2 rep3 - page2 rep4 - page2 etc.... please help me..

Hi I had in form with box list and some subforum When I open forum showing few values in box list and opposite subform. I want hide subform when open form and box list is unselected after select value in box list subform should be visible. I try use event in form (with open) If...

Hi, I created simple table and form. Normlly i using form to add and edit data in table. I got question, its possible to keep save information what's I change in table something like job history?

Hi I got report with value Summary: 1550 I want put : "1550 Kg" Normally when I design Query I tray Summary: [table1].[value] &'Kg' - but now I can't because I using in query sum function. Is possible to put "Kg" in report?

Hi, Is any chance to lock combo box at 7am and unlock at 14pm?? Please help me and show any example. I try something like: Me.controlname.Locked=True but I don't know how use function IIF with time

Hi I using query in criteria: Like "%VOL%" and working I using: Like "EURO%" and working but when i using: Like "%VOL%" And Like "EURO%" - not working why? its something wrong??