Replies

Attached is an example where I have put the continuous form in the footer of the single form. In this case the single form is based on a query that uses the current record in the continuous form as a parameter.
This requires a line of code in the Current event of the subform to requery the main form.

Thanks muchly for your download sample. This’ll give me something to deal with in my ‘spare’ time.

Wendell,

It’s not so much that I’m faint of heart with respect to trying something new, it’s more with the abilities of the user to understand something beyond the standard-type screen which even they can manage to have a problem with. It’ll still be something worthwhile to look into just for curiousities’ sake.

Hi Wendel,

Thanks for jumping into the thread. You make writing a bunch of VBA sound like it’s not the ultimate good time. It would be interesting to see an example of that which you describe.

And, never having even looked into treeview, this will give me something else to do in my spare time. If you can point me in the direction of a good example of that, I’d much appreciate it.

Hi John,

Thanks for taking the time to respond. I’m using Access 2003, so unfortunately I don’t have access to the Split Form feature.

Using your other approach might be a tad messy for me based on the complexity/busyness of my current form. If I knew how to embed a
“snapshot” of it in this reply, you could see what I’m getting at.

Why are you using txtCount ?
Can you not just use =Count(*) as the function in the Group Footer

I certainly can now that I know about it! Lovely, and thanks very kindly

Cheers,

Andy

Hi Peter,

Thanks for the input. Who’d a thunk that you could have stored over 1700 Cookies! Anyway, got rid of those but not quite sure as to how to tell MS Hotmail what I want to see. As if Bill would let me have a choice. The occurences are few and far between, but still a pain. I’ll probably coming whining back if it occurs again. I find that if exit HM a couple or three times in reverts back to what I want. Glad they don’t design airplanes. Or gas pedals.

There’s no such thing as a dumb question IMHO. When I initially read your ? I thot to myself he must mean OE and that it was just a juxtapositioning of the keyboard….however, I discovered you did indeed mean what you typed and I apologize. I’m glad to discover it’s there too. I have only had my 7 machine for about a month now so I’m still in the “shock and awe” portion of the program

900 posts is ALOT of posts~! But I see you’ve been a member for a good many years too!~~!~! Kudos~!

Hey Jude

Hey Jude,

I love being able to type that! No prob with the misinterpretation. So far 7 has been a s_load more stable than, and I refuse to use the V-word, but you know what I mean. I needed IExpress to finish putting together a digital photo show using PowerPoint. And yes, chronologically, it’s a few years, but I stopped counting a long time ago. So long as I don’t see my name in the Obits in the morning, I’m a happy camper,

Cheers,

Andy

Hey Jude,

Yes, as you can see by my reply to Tony, it has been found.
I also noticed something interesting in the setup of the Lounge. Apparently I’ve been credited with over 900 posts! Amazing! It’s a good thing that they
don’t differentiate between posts and dumb questions.

Cheers,

Andy

It is still included in Windows 7. I have a clean installation of Windows 7 Professional and iexpress.exe is located in C:WindowsSystem32

Hey Tony,

Thanks kindly for the response. Yes, there it was hiding, as you suspected. The reason the whole question came up was that I did a: Run IExpress from the command line and got squat. I guess it didn’t look hard enough.

Thanks again,

Cheers,

Andh

Are you talking about Outlook Express? As I understand it there is no native email program installed in Win 7. It has been replaced by Windows Live Mail which can be downloaded and installed by the user. Windows Live includes mail, blogging, photos and more. I was hesitant to use it, but found it’s got some neat virtues and features. Check it out. “…Get multiple e-mail accounts in one program – Hotmail, Gmail, Yahoo!* and more. And now Windows Live Mail has a calendar, too. Mail combines the ease of use of Outlook Express, with the speed of Windows Live….”

Of course, Thunderbird is a replacement that has the look and feel of OE, but personally I found I didn’t like the latest incarnation of it, so I stick with Gmail and Yahoo on mine.

Hey Jude

No, actually I really meant IExpress.exe which was supposed to enable you to create an executable file out of PowerPoint. I’d never used it back then, but of course now that I’m into Windows 7, I need it. Poop Occurs!

Hmmm – don’t think so. We are running several clients with 2003 SP3 and don’t see that kind of behavior. Is it possible to upload a sanitized sample of your DB? If not, what happens if you create a field in the query you are using that takes the first letter of the surname, and you group on that and then sort on the surname at the next level. I would expect that to work for sure. I’m assuming you have a sort on the surname below the group on Prefix characters….

Morning Wendel,

Thanks to yourself and Hans and your near-identical explanations, I’m back on the road again with a readable listing

You have to add the relevant field to the Sorting and Grouping window twice. The first instance has Group Header set to Yes, Group On to Prefix characters and Group Interval to 1. The second instance has Group Header (and Group Footer) set to No; it serves to sort the names ascending within each initial letter.

Good Morning Hans,

Now that was really an interesting revelation. Works perfectly. Thanks as always for your attention and help,

Hmmm – don’t think so. We are running several clients with 2003 SP3 and don’t see that kind of behavior. Is it possible to upload a sanitized sample of your DB? If not, what happens if you create a field in the query you are using that takes the first letter of the surname, and you group on that and then sort on the surname at the next level. I would expect that to work for sure. I’m assuming you have a sort on the surname below the group on Prefix characters….

Hi again Wendel,

Thanks for responding on this thing. Unfortunately I have to get off the system for tonight, but will be back at it tomorrow and give your suggestion a go.

You should also specify that the grouping needs to be sorted as well – if you done that and it doesn’t work, then we need to know what version of Access you are seeing this behavior in.

Morning Wendel,

There was no problem with my sort params. In the Sorting & Grouping it was Surname and FirstName, which gives me the incorrect sorting, and when checking the incoming query,
it’s also in Surname & FirstName and displays correctly.

Here comes the bad news. I’m using Access 2003 (11.8204.8221) SP3

My guess is that the old SP3 “Improvements” have done me in again. Which means reinstalling and updating using SP2.

I assume this is a report in Access.
Open the report in design view.
Activate the Sorting and Grouping window.
Add the field you want to break on.
Set the Group Header property (in the Sorting and Grouping window) to Yes.
Set the Group On property to “Prefix characters”.
Set the Group Interval property to 1.
In the report, adjust the height of the group header section to about one line.

Hans,

A little more information that I find interesting. If you Group On “Prefix Characters” it does break the names on the first letter. That’s the good news. The bad
news is that it “kills” the ascending sequence of the names within that group:

Adams
Anderson
Audio
Ankleperson

Beb
Bend
Bond
Billies
Beech
Burns