Search results

That is what I was looking for. Almost perfect but it seems that anytime you open or design any Access object the window disappears and needs to be reopened from the button on the toolbar. The only other option is to put it in modal but then it stays on top of everything. Thanks for the info.

I miss the old database window format of Access 2000 with the tabs for tables, queries, forms, reports, etc. In 2010 I have to scroll top to bottom when I am switching between queries, reports, etc. and it's time consuming and hard to find my place because there are so many of each. Is there...

Yes, that is how I have it set: This is the result of the query (partial): This is for the entire year. When the report breaks it up by month, JOHNNY WAD only shows up in JANUARY, THE PRESIDENTS only show up under July, THE COUGARS only show up under AUGUST, etc. Each of these bands...

SELECT Count(tb_Jobs.Contract_Price) AS CountOfContract_Price, tb_Jobs.Artist_Name, First(tb_Jobs.Job_Date) AS FirstOfJob_Date FROM tb_Jobs WHERE (((tb_Jobs.Job_Date) Between #1/1/2017# And #12/31/2017#)) GROUP BY tb_Jobs.Artist_Name HAVING (((Count(tb_Jobs.Contract_Price))>0)) ORDER BY...

The query pulls the correct results until I add the date field, and since I need to group by month, I have to have the date field in there. It doesn't seem to affect the results when I select "First" or "Last" for the group option, however when I run it in the report grouped by month, the...

In the totals query, what would I choose for the date field in the "total" row? Group By? The order of the fields in the query is important as well, isn't it?

Hey all, I am having a bit of trouble figuring out how to do a specific type of report. I want it to show totals (count of records) from most to least, broken down by month, like this: January ------- Apples 20 (20 records exist for apples in January, etc.) Oranges 18 Bananas 12 Grapes 10...

Yeah, that's what it looks like. You would think it would be easier than doing all that :) Thanks

The report I am running lists dates from today forward and when you group by month it puts Jan 2017 first and November 2016 is grouped with November 2017 dates toward the end of the report.

This should be pretty simple but I can't get it to work. I have a report that lists events in order by date. I want to use a group header or footer to create a space in the report anytime the month changes, so each month's dates are grouped together. If I group by month and then sort by date...

You should be able to get the ribbon to display at run time. Actually, I had a hard time getting it to NOT display. Isn't there a small down arrow button just below the X in the upper right corner? If you want to add a macro to the QAT, first you need to create the macro. Then when you go to...

Well, usually an extra page on a report that is completely blank is a sign of the report running beyond the margins, even by as little as .1", but since my extra page had the header and footer data displayed it was almost like Access thought the report had more data to print on page 2, although...

Finally created a blank report with the same margins and sizing and copied/pasted everything from the other report and it was fine. Must have been some kind of formatting from the previous Access version that it didn't like. That's all I can come up with.

We recently converted to Access 2010 after using 2000. This problem has suddenly appeared. It doesn't happen on every report but there is one in particular right now and I can't figure it out. The first page of the report is complete but it prints a second page containing only the page header...

Sometimes smart but very green when it comes to macros because I had never used them before :)

Got it figured out. I just created a function: Function MacroPDF() DoCmd.OutputTo acOutputReport, Application.CurrentObjectName, acFormatPDF, , False End Function ...which will grab the name of the current report, and convert it to PDF. Then I created a macro that ran this function. Easier...

OK, there are 3 options for macro. There is macro, then macro with an icon next to it, and macro & code. 1 and 3 have a drop down button next to it but it does nothing. I am assuming it's because there are no macros to pick from. Which one do you think I should use? I will toy around with...

Can a button created from a macro be added to the QAT or only the ribbon. I have found ways to add a custom button to the ribbon but not the QAT.

I would like to create a command button that saves a report as a PDF. Currently I am using the built in "PDF or XPS" button but it always opens Adobe reader at the end and also a dialog with the option to save export steps. I want nothing other than a simple save dialog like I can do with a...

Actually this refers to creating a PDF using the "PDF or XPS" button on the quick access toolbar. I have created another thread asking about creating a custom button on the quick access toolbar.