Recent content by JohnGunn

Maybe you guys all know this already, but I spent hours learning it the hard way. I hope it helps someone... Symptom: Report comes out in order, unless run as a subreport, then order is random. Obscure Rule #1: You must set the OrderByOn property to Yes ON THE MAIN REPORT. This seems to...

Wow! Thanks, I'll try it and look up all these interesting new properties.

Expert needed because this is something most people never would have a need for: In the "on open" event code of a report, I have accumulated a bunch of items in an array that need to be printed, each array row on one detail line. Naturally, if I were to create a temporary table from the array...

Dear Rich, Thanks for clarifying why the original syntax I tried didn't work. Taking the brackets off .Form and .Recordsource did indeed make it go. After a lot of frustration for the first few weeks of using Access (because I wished for all the goodies I got used to in Visual FoxPro) I am...

Here's the solution. First let me mention that I DID go looking through past posts for the correct syntax, but a re-try with a better choice of keywords is what lead to the answer. The post that filled me in is named "Subform: Refreshing Record Display After Delete". The correct syntax for...

Yes it's my actual code, except for the parts where I abbreviated the fields list and join conditions. All I want to do is to update the RecordSource of the subform from code executing in the main or parent form. I have designed a number of forms in which that form;s recordsource is updated on...

Here's a 'simple' problem (simple in the sense that it's confined to a few lines of code). I have an option button group on the parent form the user can click on to determine what records to show on the subform. So when s/he clicks the option button, I want to include some code to update the...

Got it working. Thanks for your hints. Here's how I ended up getting three different combo boxes working as independent record selectors at the top of a data entry form: 1) put 3 unbound combo boxes on the form. One lists Team numbers, the next lists teams alphabetically by name, the third...

My impression is that if combo2's contents were linked to or based on combo1's, this suggestion would work, but that's the cascading combo scenario. What I believe I'm asking for is two or three independent combo's one can use for selecting a record, and a technique for (a) moving the form's...

Man, combo boxes can be really tricky. What I want to do is not quite "cascading"--I've checked out previous posts in that area. Here's the challenge, which I'm sure many of you have already faced: Using a form based, for example, on Northwind's Customers table, you want to place two combo...

I ruled out using a listbox or combobox instead of a datasheet because my experience with these (in MS Visual FoxPro) is that when you put in more than a few hundred values you're in trouble. Very slow to populate and very slow to look up in. That's why I am trying to use a grid-type...

Here's a challenge for a kind of dataentry form I have been creating for years, but in a different language: --The form has a pageframe with 2 (or more) pages. 2 is enough most of the time. --The first page contains a datasheet with all the records in a table, view or dynaset you want to work...

Aha! Thanks. You're right that I don't yet know Access very well. I missed the Dirty Event. That's a lot more appealing than setting up code for every control's On Change event. Very helpful. Thanks.

Vis FoxPro vs Access arrgghhh! I know these discussions of "my product is better than yours" can be really tiresome. That's not what's on my mind. As a Visual FoxPro expert and an Access complete neophite, naturally there are things I miss (and nothing much is familiar), BUT I'm also seeing...