Search results

I can't understand how this would work, as BandMemberPK isn't related to any specific user, it's just the primary key in that table, it serves no real function. The table BandMember just relates users to bands and the dates they were in those bands. I also tried adding another instance of...

All users will have an assigned band, whether it was past or present, every user will have one. No, Steve may be able to play both, which will show up in his record, but he only played one in that specific band which is what I'm trying to track. How would I relate tblBandUserInstrument to...

Hi All, Thanks to pr2eugin I managed to get my concatrelated query working how I wanted it. However now I've tried using the same principle in a different query and it's not working in the same way. Currently my table relationships are like this; My query looks like this; The...

Brilliant, that's exactly what I was after! Thank you so much! I assume I can just copy this accross to the other query and it'll work the same?

The form I'm looking at is "frmsubUsers - CurrentBands" and the query is "CurrentMembers" Thanks for the help so far!

Even with just those 3 fields in, it has the exact same results :confused:

Nope.. My SQL is currently this; SELECT tblBands.BandPK, tblBandMembers.BandFK, tblBands.BandName, tblBandGenres.GenreFK, tblGenres.GenrePK, First(tblGenres.Genres) AS FirstOfGenres, tblBandMembers.UserFK, tblUsers.UserPK, tblUsers.FName, tblUsers.LName, tblBandMembers.MemberDateFrom...

How do I change the Query to a GroupBy? I can't find any options for it, so would I have to recreate the Query in a different way? EDIT; never mind, I've found that but it's not changed it how I was hoping

Ok so I've got it half fixed now, I've managed to concatenate the results, but it's come out like this; My control source looks like this;

Well the underlying query looks like this so far; The form looks like this; And the control source for the text box looks like this; I've gone through the example on the website so many times and tried googling around for any problems other people have had and I can't get it at...

I've tried using that before but I cannot for the life of me seem to get this to work.

Bump, anyone got any ideas at all?

Yeah the query is to show Current members with the bands, genres, instruments etc, which is then used in a sub form for each User. The PK and FK fields are so I can find the related records on the main form, but in the form it looks similar to the repeated results in the query;

As far as I'm aware my tables are properly normalised, I had some help on that beforehand. Here is the SQL for the query; SELECT tblBands.BandPK, tblBandMembers.BandFK, tblBands.BandName, tblBandGenres.GenreFK, tblGenres.GenrePK, tblGenres.Genres, tblUsers.UserPK, tblBandMembers.UserFK...

Hi All, In my query, I have several results that relate to the same PK overall, and I'd like to concatenate these records into one expression/one field in a form. Currently my query looks like this; As you can see, the BandPK/BandFK are repeated where the GenreFK/GenrePK are different...

That's definitely worth considering in that case then, the application itself relies quite heavily on VBA and I don't want to have to re-write it all in Macros, if I even could anyways! I'll keep an eye on the Citrix Lite and see what's said about it and then see what recommendations I can make...

Hi All, To make life easier on some of our employees who don't have access on their pc's, we want to create a web-based front end for those users (and also users on tablets, but that's another story). Firstly, is it possible to have a web-based front end linked to a server on our LAN? (i.e...

Hi All, I'd like a command button to open Outlook and create a new email message with the To and Subject fields already populated with what I want, is there anyway to do this? Thanks

Oh, I see. Well the actual forms and reports aren't going to form any part of the web backend, just the tables. The forms are just currently meant for testing things work so far, we'll no doubt convert the tables and queries to web-compatible when we role this out. Besides, the web based part...

add these to where sorry?