Search results

I have a report which I need to copy in 2 different lables. I've set a table with numbers from 0-10 (0 gets "original and all the others get "copy"). The caption is changed by IIF - so now all is ok. The problem is : when users presses a print button, a small form pops up asking number of...

Thanks for your reply. I did that - I have set a form where the user indicates number of copies. When done, in a table there are 2 sets of numbers : 0 and 1's. The 0 represents the "original" caption and the 1's are the copy part (if there are 3 1's then 3 copies are printed etc'. The question...

I'd like to print diff. report but each with diff. caption. What w'd be the best approach for that (how do I determine the number of copies and how to change)? Thanks.

Thanks. I want to print the same report with as much copies of a report (defined by user) but with diferent headers ( Original and copies). How can I do it, when in the print button on the invoice form I have a loop to the number of copies user defines? The code I'm using on the form is : If...

I've created an invoice form which generates a report. I've also created a form in which the user defines how many copies he wants to print with the original (with a loop to the number of copies etc). I need to join this form to the print button in the invoice so after the user states he's...

I'm creating an invoice software (access 2000). Need to consult which is the best way to lock form and subform after saving and printing. The code I think of using is : select case me.status case 1 :'open' me.allow deletions =true case 2: 'closed' me allow deletions=false. end select. end sub...

I'm trying to set criteria for a report through a form - using this : I'm getting a synthax error = Thing need to tune the criteria somehow - can someone help pls?

Another Prob. I deleted all files from the query to start again but now I'm getting another call : the error : What is that please? I checked the report (based on a query) and all ok. Thanks.

Thanks for your help

It works, didn't need the breakpoint - it was the new save cmd you gave. Can you pleas explain what's the reason for changing the save cmd? Why wasn't mine good? Thanks for the fast reply ..

Thanks. This is the save cmd : filtering the record to the report : This is the error message : When I take of the print order from the after update, the error goes away but there's no record to print. Help??

I am creating a record in the form - I wish to save it and print it right away. The problem is that it doesn't. How do I save and print (I know the save code and the print code - the problem is combining them). I tried using the print code in the after update event but is shows an error. Can...

The query is ok. I found that if I take out the printing process from the after update event, then the problem goes away. Any idea why? Should I place printing in another event in the form? IF not, then why is this problem occuring?

I have a form (invoice) and on the after update even I have a print order (invoice report) filtered in this manner : when I move in the form to the sub form or try to print I get this message : I checked the query related or table and there's no prblem. What is it then please?

Not sure I know how. Here's what I wrote there : anythin missing?

I'm trying to run e-mail messages from access but it stops on debugging on that line in my code : What is wrong pls?

Thanks, it helps. I seem to have another problem - I need to print the current form (invoice) so I'm saving it after dmax+1. The saving code I'm using is : "DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70" The problem is that it doesn't saved the current record so I'm...

Thanks. The Invoice_no is of course a numeric data but I'm not sure I follow you regarding the form would have to be on the record in question - in what way?

Hi everyone. I'm trying to print the last record in a table but the report seems to come up with no details, as if the table is enpty (it's not). The code i'm using is : DoCmd.OpenReport "rpt_invoice", acViewPreview, , "[invoice_no]=" & Me!INVOICE_NO I tried to use the DMAX as to show the last...

Thanks, it works - I have only 1 record but there are no details in the form )it gets out empty and with errr in the calculated fields. Sorry bother you guys but help??