Search results

If you will not prepare a report with controls such as textboxes in advance, you have to assign arguments for each parameter on the generated report whenever printing. Do you want to change the layout (number of controls, positioning of them) of your report dynamically every time? If not, I...

One more thing I cannot ignore is, as I previously said: : Set rpt = CreateReport If you in fact put no arguments here, you can only see a report with no controls. Without controls, that means there's no way to display the result of extract.

What I want to say is: The reason for your blank report is that the result of the record source assigned to the report is EMPTY. This means that the parameters for the record source assigned to the report are wrong or that the parameters entered do not meet the requirements of extract.

Ok. Try running this code: Sub TestReport() Dim rpt As Report Set rpt = CreateReport DoCmd.Restore End Sub Then you will see a blank report. That's the reason for my previous comment.

It's not much convincing for me to create a new report every time... But it's not the most important... Do you make setting only for the record source when generating a report in design-view mode? Won't you make setting also for the control source by pasting something like a textbox?

This doc may be help: http://www.microsoft.com/technet/scriptcenter/guide/sas_cpm_fxkq.mspx (Retrieving the Properties of the Operating System) I've not check it in detail, but I'm afraid VBA alone cannot make it possible what you want and requires WIN32API. Keizo I also have a question...

This site might be help: http://support.microsoft.com/default.aspx?scid=kb;en-us;304206 (ACC2000: Importing or Linking a Text File Fails for a File That Does Not Have a Valid File Name Extension) Keizo I also have a question: http://www.access-programmers.co.uk/forums/showthread.php?t=93171

Hello. I am trying to do printing from VB using the "Printer" object, but cannot specify the paper type (like "Plain", "Glossy",...) because it seems that there is nothing like "PaperType" as one of its properties. How can I make it or get a similar effect as a result because changing the...