Search results

  1. S

    Multiple Relationship Subform

    Hi. can anyone help me. I've spent the last two hours getting no where. I have a tbl_Enquiry,tbl_EnquiryType and tbl_Questions On the main form (frm_Enquiry), depending on which enquiry type is chosen, will depend on which questions are displayed. this is a many to many relationship so I have a...
  2. S

    Multiple Relationship subform

    Hi. can anyone help me. I've spent the last two hours getting no where. I have a tbl_Enquiry,tbl_EnquiryType and tbl_Questions Depending on which enquiry type is chosen, will depend on which questions are displayed. this is a many to many relationship so I have a junction table, called...
  3. S

    Problem with Using Tabs

    Brilliant - that worked. Thanks very much. J.
  4. S

    Problem with Using Tabs

    Hi - Could anyone please help me. I have got a form on which I am using tabs. For some reason, when that form is opened, it is not showing the full number of records from the table. It is only opening in Add mode. If I then start to enter multiple records the navigation buttons at the bottom...
  5. S

    Problem with Using Tabs

    Hi - Could anyone please help me. I have got a form on which I am using tabs. For some reason, when that form is opened, it is not showing the full number of records from the table. It is only opening in Add mode. If I then start to enter multiple records the navigation buttons at the bottom...
  6. S

    Viewing All Records

    I've just had a look at the Cycle property, it is on All Records
  7. S

    Viewing All Records

    Sorry, I didn't phrase my question properly. What I want to be able to do is use the navigation buttons at the bottom of the screen to move between records on the form. I have had this problem before with a different database, where I can only view the most recently entered. For example, if I...
  8. S

    Viewing All Records

    Hi, can anyone please help me. I've just set up a form with 2 pages which I can add data into, but for some reason, I can't view all records. I've tried using the switchboard to add buttons to both add records and view (but they both only add), and i've also set up my own button with the...
  9. S

    Splitting a Date

    Excellent - that worked perfectly. Thanks for your help.
  10. S

    Splitting a Date

    I've currently got a date of birth field in my database, but would like to query on just the birth month. Can anyone tell me how to do it. Do I have to create another field which separates out the month, and if so, how do I do that. Any help would be much appreciated.
  11. S

    Quote Generator Help

    I've been asked if I can create a database which will act as a quote generator. There will be 5 components to make up the whole product. However, the options available for components 3, 4 and 5 will be dependant on the components chosen for 1 and 2. i.e. there may be 5 options for each...
  12. S

    Drop Down Option

    Thanks. I've attached the file now. Not sure what happened last time.
  13. S

    Drop Down Option

    Apologies if this has been answered before. I am an inexperienced Access Database writer who wants to learn more - so first question, are there any Access Gurus' near to Buckingham/Milton Keynes UK that would be willing to spend a couple of hours showing me advanced access programming with a...
  14. S

    Many To Many Relationship

    Thanks for the inforamtion. I've tried changing the parameters you suggested, but it is still locked. Thanks anyway:
  15. S

    Many To Many Relationship

    Hi I'm trying to have an area on a form where I can select more than one option from a table. It is a many to many relationship, so i've also got a junction table. It maybe that i've been working on the same thing for too long and gone brain dead, or that I am a new access user and don't know...
Back
Top Bottom