Search results

Well, that was ridiculously easy. Thank you.

Hello, Right now, I have a query pulling a bunch of data for a report by UnitName. I would like to group some of these units for display on a similar report. I've tried using multiple Iif statements: Group: IIf([UnitName]="Unit A","Group A", Iif([UnitName]="Unit B","Group A"...

Hello, I'm currently using this bit of code previously provided by a helpful someone to open two forms for data entry on one page (i.e. Choose A, choose B, click open and form (built with two blank subforms) opens with FormA next to FormB): Private Sub Form_Load() Dim arrSplit As...

Hello, I'm having a couple of problems with this procedure. First, I am using the 2010 version of Office, if it matters. The first problem is that when I try to export a report of any size to Excel, I get an overflow error. I haven't done extensive testing to see where the "problem...

Yes, entered in the same format by the user. By all means, be a bit "pedantic," as I'd rather learn and use the correct terminology. :) Still not quite clear on... "so you don't need from/to, you just need the user to enter 8/16 =forms!rptform!monthrequired " Right now on the report...

CJ, thanks for the explanation of how it works. Very poorly worded on my part - I should have said "I have users entering records into my table via a form." "Back to the question in hand. I'm assuming from this statement so DateOfFileReview is 9/6/2016, but they may want to change...

Hello, I have users entering records into my table. They have two different date fields: the first is DateOfFileReview, which is a Date/Time data type, using the Short Date format, and is set to default to the current day and is unchangeable in the entry form. The second is MonthForReview -...

Was able to get it working. 10 lines of code sure beats 1000. Thanks so much.

Thank you, I will play around with this. I can already see one minor issue I'll occasionally encounter - is there a way to account for differences between the combo box selections and the report names, namely spaces? For example, the combo box lists "New Hampshire", but the report name is...

Good question. There are different reports for each state because each state has different regulations (different wording and different numbers/totals). So I guess the answer is they are structurally different?

Hello, I'm looking to clean up some of my code, since I got a "Procedure too large" error. Basically I have a form where a user has a number of choices in combo and text boxes and based on those choices, a specific report is opened. When it was smaller, the code seemed to be fine, but as the...

Hello, I am creating a YTD sales report based off a query that has a date field (1/1/2016, 5/24/2016, etc.) I would like to have two separate dollar total text boxes - one for January-June and one for July-December. I am familiar with applying a filter to a whole report, but have never tried...

Hello, I have a form which allows users to choose filters for a report, such as a date range. When I try to display the criteria on the report, I use a text box with =[Forms].[FrmReportFilter].[TextDate1] as the control source, for example. This works fine unless/until the user closes the...

Doc, Thanks for the heads up. To your second point, the key as it stands now is two fields. We need to add two fields to the key. Example: Currently: 001/Apple 001/Banana 002/Banana Well it turns out that we can have two instances of 001/Apple, so fields are being added to the key...

Ranman, that's the first thing I need to do. But I'd also have to edit the front end tables (they enter data into the front end tables, then the append query runs front to back), and also edit queries that will be directly affected by the changes. Plus I'd like some time to test everything to...

I have a split database where I've distributed the front end out to users to enter data and append records to the back end. I need to add a couple of fields to some tables which will be part of the composite key. My question is, instead of having all users append their current records and having...

Hello, I'm trying to find the easiest way to perform a calculation in a report I'm creating. Basically I have a table where there are a bunch of questions that have "Yes", "No" and "N/A" answers. I'd like the report to show, for each record, the % of Yes answers. The "N/A" answers are...

CJ, just tried that. It gave me the same "error" as at first - it says I'm going to update 0 records.

CJ, you are correct. When I tested it just now, if I have 3 records in _FE and the same 3 in the BE, they update fine. When I deleted one in _FE, it updated the other two in the BE but also got a validation rule error (presumably for the one deleted). And the vast majority of use will be like...

arnelgp - When copying your version in, it works. Thank you very much. My question is then, how could I have fixed this without knowing SQL? In design view, the arrows are reversed which looks exactly like it did when I tried a right join, yet it is not a right join.