Search results

OK, I just tried deputy herb's method, but on a report rather than a form. It works beautifully. However, when I call the report from a button on another form (the form is designed to filter the results that are returned in the report), I get the following error: The expression On Click you...

I finally figured it out. I knew it had to be something more fundamental. When I originally created the form that the Offerings tab utilizes, I set the Record Source to the name of the table that provides the list of offering names. When I just now deleted the table name from the Record Source...

So I've tried a couple more things to try to isolate the problem, but I haven't gotten any closer. 1st, I added the 'offerings' field from the query to the report and discovered that, as you would expect based on the problem, the subreport, or subform, because I tried both, doesn't show the...

No worries at all. I very much appreciate your time.

Bob, With the assumption that the problem was related to displaying a report within a form, I created a form that displays the same data as one of the reports that I've been using. I then updated the on click event procedure to use the form name rather than the report name. The result is the...

Sorry, I'm just not with it today. The backend is attached. Re: the subreport vs. subform, is it not possible to display a report within a form? (sounds very basic and naive, I know, but I've done so in the past with no problem)

Oh, and I guess the username and password would help (though they are not entirely necessary). They are test and test, respectively. :)

Bob, Sorry to double up on you, but while you have the db, would you mind telling me the best way to make the subreports sortable based on the field headings? I added what I thought was the correct code to the on click event for the field names, but the result was that the 1st click made the...

Indeed. Please see attached. Thanks

No dice. I still get Run-time error '2101': The setting you entered isn't valid for this property.

I swear, sometimes the most obvious solution escapes me. I'll give it a try with a hidden column and report back. I had already tried the "srp" & Me!cmbReport.Column(0). solution, but received back error 2102.

Bob, Thanks for the quick reply. I should have specified that the values in the combo box are the names of the report, minus the srp that I use to signify a subreport. ie., the value 'History' should call the report srpHistory, just to make a slightly cleaner user experience. That's why I...

On my main nav form in my Access 2010 db, I have a tab called 'Offerings' that displays a form with 2 unbound combo boxes. The 1st combo box displays a list of offerings from a field in one of my tables, and is used in the criteria of corresponding fields in my queries that feed my reports...

I'm developing a web database in Access 2010 and I'm having a bit of trouble with a data macro. I'm trying to find a workaround for the lack of 'sum' functions (specifically the 'last' criterion) available in the web queries, and came across a post that discusses creating a new table to hold...

I'm afraid I can't be of too much help yet. I just upgraded to Access 2010 last week, and my SharePoint host is supposed to upgrade our account to SharePoint 2010 in the next couple of weeks, so my web database is not yet finished, let alone published. I'm slowly working through the various...

Thanks for the quick reply and providing your hard work! I'm actually going to try this in the same direction that you did, ie, populate the history table via the form and use the entry to update the main table. I'm working on a simple CRM web database, and I only want to update the main table...

Would you mind posting copies of your macros that got you as far as generating new records? I am trying to accomplish something very similar, and it would save me quite a bit of headache. Thanks