Recent content by dhans

I think I may have solved this problem. Instead of using the report and querying from that, I'll just create a form from the query. I'll let you know if it solves the problem or not. But any other suggestions are welcome.

http://tinypic.com/r/sgs55x/8 Now I can :) here it is. I've taken off the cb until I can figure it out.

Can't post a screenshot of what my navigation menu looks like until I post one more time.

The report is embedded in a tabbed navigation form/menu--a subform(?). I suppose I could put in a command to open the report and then another cb to filter from that, but I have several other forms/reports in this menu with this same sort of cb that works just fine without doing that. It's...

Do you think it could be because I'm calling for 2 parameters? I'm using the same logic in other forms in my navigation menu which only use 1 parameter in the query and they work fine.

There's a setfilter command that calls a query which uses 2 user input parameters. (solving this one will point me in the right direction for the same type problem in the 'print' cb) Setfilter Filter Name Semester & Year Query Query SQL: PARAMETERS [Year:] Text ( 255 )...

No ideas? No ideas at all? :(

I have a couple of forms in a navigation menu that have command buttons, one which is a print function and on the other form I have a command button that calls up a query that performs a filter function (the query has 2 user input parameters). The commands perform perfectly fine, however they...

Ah, I see that now. Could the same be accomplished (aside from being able to adapt default printer) with adding a DoCmd.OpenReport line previous to DoCmd.PrintOut?

I don't have a problem getting it to a printer, my problem is in the format of what is being sent to the printer. The print command is sending what is sending, essentially, a screenshot that includes the tabbed navigation menu, and not the report exclusively which is what I want. I don't see...

Help. I want to print a report from a tabbed navigation menu and when I do, it prints the entire screen including the navigation menu. I only want the report to print. I tried to put in a docmd.printout event in a command button on the Report, but it still prints out the entire screen and not...

My name is Dee and I have some programming background, but by no means a professional. I've recently started using Access to assist in a number of processes at my work. I have a limited knowledge of VBA, but understand programming structure and the basics, so I can usually solve any problems I...