Search results

I am trying to print a list of attendees at a meeting, grouping them in 4 groups by surname, A-D, E-K, L-R, S-Z. I have defined a page hdr, section hdr and a detail line. The report has 2 columns. I sort on AlphaGroup, group on AlphaGroup and sort on Surname. Group hdr has properties set to...

Yes, I took some time to decide for the reasons mentioned. But why did Access not produce the correct SQL? Thanks for your help.

Bob I note your comment about the design of the simplified application I originally included only the system generated IDs from Groups and Members tables since the codification and number system of members and groups will need rationalising soon. I removed them to see if it made any...

But this was created automatically by Access!

Bob - yes exactly! What did you do to make it work?

It's a membership system of an organisation that comprises many subgroups. I developed the front end data input (other than assigning members to groups) and back end reports and queries. I came unstuck filling in the middle, so what I posted was just a simple demo of the issue I came up...

Yes - I think! But I am questioning every thing I do at the moment.

PS I do not want to get involved in Visual Basic (at least at this stage!). I Have used some macros in earlier parts of my application to do simple things like menu selection, closing forms etc, but I am absolutely convinced that my basis needs here could be satisfied by the use of simple forms...

I have already posted this problem without getting any resolution. I have had posted a working solution but unfortunately the reasons why the suggestions were made are beyond my understanding. Any help preserving my sanity would be appreciated! I have three tables consisting of: 1. A member...

Thanks for the suggestion. This will stop a future problem but I still can't move forward at all. I also meant I was using a 2010 book, not 2000!

Sorry I have been slow to follow your request to upload a sample database. I have been rather busy on other matters and also been for a fitting of a wig made necessary by my having torn all my hair out! Your solution works of course, but through lack of knowledge I do not appreciate the steps...

Try as I might I cannot get the combobox to be the basis of multiple rows. The subform allows me to step through the members of a group but displays only one at a time, in a single row. What is the setting(s) that create multiple rows?

I am still having trouble replicating your design into my environment. You have defined no relationships between your tables. Why not? How did you set up your subform? Was it a standalone form which you dragged onto the main form or did you use the subform wizard in situ? When I create a...

This is just the function I want, but can you please advise me on why it works with a query but not a table? Thanks

I renamed it and it loaded correctly. Goodness knows why it was rename in transit! I have had a 12 hour day tearing my hair out, so I will have a look tomorrow. Thanks for the response.

Can you help on downloading? When I try to download the file type gets changed to php. Do you know why?

I am new to this game! I am having problems developing a membership database - help would be welcome. I have three main tables. 1. A table of 600 members of an organisation 2. A table of the subgroups these members may join, about 80 in total. 3. A table of the members of each group. The...

I last used Access on version 1 a very long time ago!! Now retired from a sales role I have volunteered to develop a 'simple' application for a charity. Big mistake! Not having programmed for 30 years it's taking a while to get back into the swing.