Search results

  1. S

    Button on my form does nothing

    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...
  2. S

    Did I understand my question correctly?

    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...
  3. S

    Continous form, calculated total field in footer?

    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...
  4. S

    Hello everyone

    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...
  5. S

    Creating record from subform, use one of the values in main form

    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...
  6. S

    Query in subform, how to use a field from main form?

    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...
  7. S

    Adding a record, need to "cascade"?

    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)...
Back
Top Bottom