User Profile

Collapse

Profile Sidebar

Collapse
20028431
20028431
Last Activity: Mar 24 '10, 03:19 PM
Joined: May 7 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • 20028431
    started a topic Link Master / Link Child subform query
    in Access

    Link Master / Link Child subform query

    I have a main form called ’frmIssues’ which contains 2 subforms ‘sbfmLog’ and ‘sbfmLogNote’

    frmIssues is bound to table ‘tblIssues’ and has fields IssueId (PK- Autonumber), Title (txt), DateOpened (Date/Time), Category (txt) etc.

    sbfmLog is bound to table ‘tblLog’ and has LogId (PK- Autonumber), LogDate(Date/Time) , LogTime (Date/Time), ActionType (Txt), LogTitle (Txt) and IssueID (FK – Number)...
    See more | Go to post
    • 20028431
      started a topic ComboBox RowSource Query
      in Access

      ComboBox RowSource Query

      Hi Guys looking for some help please. Is a bit complex but will try to keep explination as succint as possible - here goes -

      I have a Access 2007 database allocating consultants against a programme of work for a client.
      I have created a form (frmEnterExpens es) to enter expenses against a programme for each consultant. The form has two combo boxes (cboProgramme and cboConsultant). I need to store the values from each...
      See more | Go to post
      Last edited by NeoPa; Sep 22 '09, 03:20 PM. Reason: Please use the [CODE] tags provided.
      • 20028431
        replied to Cascading Combo box and Many to Many Relationship
        in Access
        Hi Guys

        Just wanted to say a massive big thank your for all your responses but in particular to ADezii (I like unnecessary complication!!) .

        I did download the zip file to see your example and then worked through the steps you oulined only to find that my initail problem was with my AfterUpdate SQL INNER JOIN coding duh!!!!!

        Once again many thanks for your time.
        See more | Go to post

          Leave a comment:

        • 20028431
          replied to Cascading Combo box and Many to Many Relationship
          in Access
          Many Thanks to you all - will follow your suggestions tomorrow and post back to let you know how I got on.
          Once again many thanks
          See more | Go to post

            Leave a comment:

          • 20028431
            started a topic Cascading Combo box and Many to Many Relationship
            in Access

            Cascading Combo box and Many to Many Relationship

            This is driving me mad!

            I have been trying for 3 days now to work out how to do this with no success.

            I have tables for Customer, Bookings, Entertainment, Act, Agent, and several others.
            I have created a form to view existing bookings with Customer details as mainform and Bookings and Entertainment as subforms and this works fine.

            I am trying to create forms to allow the booking clerk to enter...
            See more | Go to post
            No activity results to display
            Show More
            Working...