Search results

In frmsubUsers - Current Bands, I'd like the Genres textbox to be the concatenated field (currently it's Unbound as I deleted the faulty controlsource). Thanks

If I upload the database, would you mind showing me how to fix this? That's definitely helped, but I'm still not managing to get it right :confused:

Hi All, I have a query that I want to concatenate some of the results onto a single row, but I'm having trouble. I've followed Allen Browne's example, but when I run the query, I either get the #Type, #Name or a 3201 error (I believe, I can't recreate it now). I'm pretty stuck on what to...

I know, but the idea is that users can jump between forms and records this way, it's also not meant the be the user frontend but the design of a web backend, I've just put the forms in so I can test it all and so the admins and I can easily see what's what. So is there any way to put those...

The form is more for viewing data rather than data entry, so yes it is updatable but it doesn't matter to me if it isn't. It isn't essential to have the Genre field in there and I've tested it without it and everything works as expected, it'd just be a nice addition to give a little bit more...

Well it's essentially showing the same Band each time with the seperate genre, where ideally I'd like just one line with all 3 genres in the same box. I know I could simply get rid of the genre field in the subform, but if there is a way to do what I'd like, I'd much prefer that.

I've fixed that by creating a link table for the Genres sub form; Eventually I will do the same for Instruments but I want to get it right for Genres first and then apply the same rules. So now I've got it like that, how would I go about changing the repeated records in frmUsers?

I want to see each Band with their name, genres, current members and previous members, and I also want to see each User with their name, instruments, current bands and previous bands.

Essentially, there are 2 main forms called Bands and Users. In frmBands, it shows the BandName, Genres(subform), CurrentMembers(subform) and PreviousMembers(subform). In frmUsers, it shows FullName, Instruments, CurrentBands(subform) and PreviousBands(subform). I've managed to make genres...

Hi All, I need some help normalising my data properly, and then showing the values in a form. Currently, my table relationships look like this; However, there can be multiple Genres per Band and each Genre will be applied to mulitple Bands, and I know this is a Many-To-Many...

So I think the solution to this will be to properly normalise the data again, but I'm not sure how so I'll start a new thread on the topic and post the information needed

Ok so I've changed the table design to a listbox, multiple values set at no, but (I should've seen this coming), in my form it won't store the multiple selection of the listbox, is there anyway I can get around this or will it have to be a multiple value field? After changing it to back a...

Ah, woops! That'll be why then! So how would I change this to a proper listbox and then have only the selected values show?

Hi All, So I have a multi-select listbox with tick boxes and values in on my form. Is it possible to make so only the checked values are showing up and then not display the tick box? I know I can use a combo box to display several values, but using a listbox like this would be easier on the...

Oh trust me I do understand all of that now, me and the other developer have improved so much that we're thinking it could be worthwhile re-designing the entire thing, especially with the lookups. The attachment fields are more meant for uploading small emails and pdf's so we can quickly see...

I've removed everything except the relevant form and query (and the underlying tables). What should happen is that the user enters their criteria into the search form and then hits Postage Report to view the results, except that won't happen in this as it now runs off of the query which has no...

So I've tried to implement this code and nothing seems to work, the button doesn't open the query whether I change the list box to single or multi select and whether something is selected or not, I've tried typing in the code by hand and copying and pasting, but I can't seem to get this working...

Ok, I'll give this a go when I get a chance. To add in the criteria for regular textboxes and comboboxes, how would I add that to the query using VBA?

Sorry to be slow, but I don't really get what you mean, the field type in the underlying table is a lookup field, which looks up a text field, if that's what you mean. The listbox name and the field in table have the same name too (MAIL PROVIDER). I know it's bad design to have lookup fields...

Thanks for your help, I've actually managed to create subforms within the 2 main forms, but I will definitely take a look at your example, however I can't see any attached files to your last 2 posts?