Recent content by Snecia

Ok I'm hoping someone can help me I tried something simpler and it's not working. 1) I created a new form 2) I added a button to it 3) On the On Click event I selected Code Builder 4) Added MsgBox "Hello" 5) Saved, went to Form view and click the button, nothing happens There is obviously...

Hi, I've added a button to my form and in the On Click event I've added some code (by clicking the "..."). Here is my code: Option Compare Database Private Function DisplayReport() DoCmd.OpenReport List0, acViewNormal MsgBox "TEST" End Function Private Sub Command3_Click() Call...

Sorry to bother you guys with something like this. I have a project to hand in tomorrow and my last bit is this: "Create a suitable user interface using forms, appropriate start-up options etc. The design of the interface must be tailored to the user's needs. A customized menu-driven interface...

Hi there, I have a form that is displayed continuously and there is a text field in it (Text12). In the footer of this form I would like to add a textbox that is the sum of all Text12's on the form. I tried =Sum([Text12]) in the textboxes control source but that is just displaying an error when...

Thanks for your reply but in my case I have only one table, it's the same one used in both the main form and the subform.

I'm a first year student at Abertay Uni, Dundee. I'm studying Ethical Hacking and we have an Introduction to Databases module to learn how these things work (so that I can later find the security flaws in your databases :) ) Already asked two questions here and I have to say so far it has been...

Hi there, I'm trying to create a record for a table that has 2 attributes: ContainsTracks +album +tracks I have my main form, where the album is determined by a TextBox. My subform has a textbox that lists the tracks (in datasheet view). I have this set up and working fine. At the moment if I...

Hi there, I have a query in my subform: SELECT ContainsTracks.albums, ContainsTracks.tracks FROM ContainsTracks WHERE ContainsTracks.albums LIKE [VALUE IN TEXTBOX1 FROM MAIN FORM] As you can see in the brackets, I would like to use the value in textbox1 on my main form in this query (so I can...

Thank you for your answers CJ London. They were playing in my head all night. I managed to solve this morning (love it when you wake up with your answer!) Any way, I had to put this SQL in the Form Record Source, with Recordset Type set to dynaset: SELECT [AlbumIsGenre].[album]...

Thank you CJ London. I understand your logic but that is not how my teacher wanted us to set up the tables. She clearly wanted three tables. One for the albums, one for the genres, and one to link them both. I can't change anything to that. From this I need to create a form that can add an...

Thank you for the quick reply, I realize that I didn't express myself correctly regarding my relationships (it's late :p ) but I do understand how they work and have them set up properly. I'm really trying to understand how to make my form create the necessary record in Album before creating...

Hello everybody. I am quite new to Access so I will do my best to explain as clearly as I can what I am trying to do. I have a database that handles a collection of music. Simplified, let's just say the database has 3 tables: Album(+albumName) Genre(+genreType) AlbumIsGenre(+album, +genre)...