Recent content by drums_4_life

well I got everything to work. As soon as I took out instrument in the query for musicians it would let me update the query. Im not sure why that is but i can do without the instrument field. Thanks all.

Yeah when i attempt to put a name in the query a window pops up and says "field cannot be updated" How can i fix this?

Hello, I have a database with two queries that are suppose to be editable. The first query works just how it is suppose to but the second one does not. I cannot find what is different between the two so i was wondering if some one could help. I have taken a screen shot of each query in design...

here is the screen shot. I am confused because the relationship is identical to the set list part and the set list part works just fine.

Hey so far everything you have told me worked great i didn't start over with the database but I did get my Set list sub form to become editable. Now that i achieved that task I want to have a musicians subform that can be editable so I can choose what musicians are going to be playing on a...

Hey thank you very much. I really appreciate your help. You have no idea. I will let you know what I come up with once I do what you explained. Thanks again.

Hey I got the Church Service Date fields to work they now show the 1 to many symbols. But I cannot get the Song Title field from the Church Service Set List table and Song Table to work with the one to many symbols. Got any advice? My song table i do not want duplicates but on my Church Service...

Hey thanks for the input but im still cant edit the form. I type the date I want at the top and click down in the subform and this pops up "The changes you requested to the table were not successful because the would create duplicate values in the index primary key, or relationship. Change...

Here is a screen shot of my Form that i need help with. I would like to be able to input the date at the top so the list comes up in the subform but then i would like to be able to add more titles to the subform. Does anyone know how I can do this? I would love the help I am really stuck here...

Thank you for that response. I understand its a pain to store the same thing in more than one location but for what i need i believe that is the only way i can do it. Here is a picture of my form. So at the top of this form I am able to search by service date, when I pick a date i would like...

I have a two tables in my database One table is a list of song titles, tempo, key signature, and author. The other table is a list of specific dates and with those dates it has song title, tempo and key signature. How do I make it so that the second table's "Song Title, Tempo, and Key...

I made a continuous form of my set lists but when i use the form and go to the specific date that i want to add or remove songs i run into this problem. I want to be able to click on the song title menu bar and pick a specific song and then have the form automatically fill in the tempo and...

Thanks for the help. I have made a separate table for the set lists. I'm a little rusty on the terms haha. like a continuous form or double-click event could you help with that? Grant

Okay, I have a database of Music. It consists of Music titles, tempo, Key signature, theme, Genre, and Author. The whole point of the database is to organize music set lists for up coming shows. So I would like to make a form that can search through set list dates and when the form goes to that...