Results 1 to 6 of 6
  1. #1
    msr71 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    17

    A data entry form with Row Names and Column Names

    I need to create a form that looks like this:



    Math Phys Bio
    Mark 99 95 98
    June 89 78 99
    Jeff 72 69 85

    The column names and the row names come from tables. Lets say Students, Subjects and Grades Tables.

    I am using Access 2007. Any ideas will be appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what ideas do "you" have? that would be a great place to start.

  3. #3
    msr71 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    17

    Ideas

    I wondered if I could dynamically create the controls like I could in VB.Net, but my internet search on this proved futile. I am now thinking about placing a number of controls on the form and managing them and the data with VBA, an idea I got from one of my google searches. Thus far I think that may solve my problem.

  4. #4
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    I don't think you have a problem. Definitely to design databases one should have & read a text book about it. Access books are easily found at Amazon or any large book store.

    Forms sit atop tables - or queries of tables. So one starts with the table design. Define the fields you need in the table first, then design a form for it.

    Hope this helps.

  5. #5
    msr71 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    17

    Relations

    A Student can take one or more Subjects
    A Student receives A Grade for each Subject taken

    Is this correct?

  6. #6
    msr71 is offline Novice
    Windows Vista Access 2007
    Join Date
    Apr 2011
    Posts
    17
    Please forgive me for posting my question in this forum. I thought that this was a familiar type of problem and that this forum was the place to post it. This problem however requires a programming solution which I thought was understood and so I am now posting to the programming Forum. BTW if anyone is interested in how I solved this problem, please let me know I will be happy to share the solution.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Create percentage from column names
    By Brian62 in forum Queries
    Replies: 4
    Last Post: 12-03-2010, 09:01 AM
  2. Customer Entry/Find Duplicate/Similar names
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-27-2010, 09:20 PM
  3. Replies: 2
    Last Post: 04-29-2010, 11:06 PM
  4. Query to get column names in a table
    By access in forum Queries
    Replies: 1
    Last Post: 07-06-2009, 05:10 AM
  5. Query to get column names in a table
    By access in forum Forms
    Replies: 1
    Last Post: 07-01-2009, 02:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums