Search results

Right now the date is hard coded into the queries of the reports. Ideally it would be done either through a form or just from a [Input Date] criteria in the query. If I used a form, would this be easier to accomplish?

I have one report that houses 6 sub reports. What I would like to do is have it prompt for, or accept date input from a form and filter that input to all of the sub reports. I can get it to prompt, that's not the issue. What I want it to do is have 2 sub reports show for the day before the...

The other macros that I have in this project, specifically the one that minimizes Access and puts the focus only on the form that opens, works just fine. I will take a look at the macro options and see of there's something that I missed, though.

I have a macro that I have written that creates a simple right click menu on my reports in Access 07. I have added the correct entries into the reports and the menu shows up just fine when I open the database holding shift and run the report that way. However, when I just double click the db...

I have 2 separate databases built in Access, both of which have an ODBC link to a table on a SQL server. In the first db, everything is fine. All of the information that my users need pops up, and when I open it (at their desks) holding shift, all of the tables are accessible. In my second...

The report I'm working with right now has a name footer, and I would like to have it in there if I can, if not I will put it in the Page footer, but I do need the data separated by person, rather than a total for the whole report.

What I need to do is sum up the instances of Column 2 where data exists in Column 1, then divide that by the total of Column 1. This formula is very specific to the checkbox on the form, so altering the query (that also pulls multiple other reports) would not be the way to do this if I can...

I have a report that is generated via a form, and based on certain conditions, I want 2 text boxes to either have data in them, or be blank, but the data that will be in them must have a specific format if I can do it. The first box I got easily using an IIf statement to check the form and...

I see. So, with my other macro that I have written, it is possible to read any value from the table that is sourced in the combo, which I have done; but the code to actually write data into my table won't work the same way. So what I need to do is find a way to reference that particular...

In the Row Source for the Combo, the column numbers listed are defined and used. Another macro I have for the Combo itself works when using the column numbers, but I am certainly willing to rework my code so that it works correctly. The checkbox itself is not bound to a field on my table...

I have a form designed, and so far everything is working perfectly, except for being able to update the checkboxes from whatever state they were in to begin with. When I click on a checkbox, I want it to update a certain field in the table with an x if it's True, or nothing if it's False...