Recent content by NDD

Dan, I pasted it in on a button and got: Run Time Error '5' Invalid Procedure Call or Argument Set objPrinter = Application.Printers("Adobe PDF Printer") Highlighted in the debugger

2010. Thanks

Thanks Dan, I'll look into it. I made need more instruction. I'm not very conversant in VBA yet. I'm learning, but it's a process.

Access 2010 Acrobat X Standard I have reports on both 11X17 and 8.5 by 11. When I convert the 11 X 17 to Acrobat, it changes the paper size to 8.5 X 11 on both the PDF and the print view of the report in access. If I set Acrobat to 11 X 17, it still does it. I'd appreciate some help if...

One last thing to do and I can take a break for a month or two. Have to research putting user names and passwords. I shall peruse your website.

Yes ma'am. I've got them both working now. Is it Gina or Genius?

[Forms]![Main]![NavigationSubform].[Form]![General Safety Reports]![Status] Worked on the first one.

Forms![Main]![NavigationSubform]! Forms![Report Center]![General Safety Reports] ![Status] Is what I ended up copying I got an error message: The expression you entered has an invalid dot or ! or invalid parenthesis You may have entered an invalid identifyer or typed parenthesis following...

So: Where I put the number for Status is an unbound text box "Status" It is on Subform "General Safety Reports" Which is on Navigation Subform "Report Center" Which is on Navigation Form "Main" So I need: Me!.Main.Report Center.General Safety Reports.Status ?

I need a little more help with this. I have this in my query: [Forms]![Main]![NavigationSubform].[Subform]![Status] and it works fine as long as the status is put in the parameter subform of the navigation form. What I would like to do is put the parameter subform in a navigation subform...

Thanks Gina. Yes, pretty much. I'm playing with it now (and having a blast). I really like it when things start working the way I see them in my head.

I have the parameter query working to open the form, just changed the event to open the form instead of the query. The paramter query form works good when I open it by itself, put when I put it in my navigation form, it doesn't work. Any suggestions? Thanks. Edit: Fixed. Have to reference the...

I made a parameter query and am using a form to put the data and run the query per these instructions http://ms-access-tips.blogspot.com/2011/06/using-unbound-form-to-obtain-query.html It works good. Now what I need to do is get my parameter query form to pop up when the auditor clicks on...

http://www.techrepublic.com/blog/microsoft-office/run-a-parameter-query-within-an-access-form/ I did this and it's working great for the query. How can I turn this query into a report without showing the query after I run the parameter? I have a form called "Report Center" with all my...

Thanks, Can you expound while I research?