Results 1 to 8 of 8
  1. #1
    eddcole is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    5

    Advice please

    Good morning and thank you for letting me join your forum.



    I'm reasonably new to Access so will try to offer advice if I can.

    I am looking for a bit of advice at the moment though.

    I have created a form that has numerous pieces of information that is needed to form a record, this can potentially exceed 255 items, maybe I'm doing something the long way and someone could point me in the right direction.

    My form is an invoice form that contains numerous items to be invoiced. I can generate client addresses easily enough with site detail etc but when it comes to entering the detail the same detail is entered again and again for example

    Item
    Description
    Cost
    VAT
    Total

    At present each line and entry is represented by a separate column so each line will contain 5+ columns extra in the table.

    At the moment the form can handle 13 lines but it needs to the have another page generated for the additional lines (advice also needed on this)

    as you can appreciate after so many lines the table can soon exceed the 255 column limit.

    Thanks in advance

    Edd

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    How many tables do you have.


    Sent from my iPhone using Tapatalk

  3. #3
    eddcole is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    5
    At present there are different tables for different information but all the info on the form is in one table

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is online now Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    2,930
    Quote Originally Posted by eddcole View Post
    At present there are different tables for different information but all the info on the form is in one table
    That makes it sound as though the same data is stored in more than one table. It should not be.
    Also, your description, in post #1, of the fields you have suggests to me that your table is poorly designed. I would recommend that you read up on db design and table normalization.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2007
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,049
    Any chance we can see this db edd. I'm amazed how much progress can be made when we can see it. A screen shot of the forms and table layout? Relationships?


    Sent from my iPhone using Tapatalk

  6. #6
    eddcole is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    5
    Think I got there, had to do another table and a subform cheers

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,294
    From your description of your table in Post #1, it sounds like you have committed "spreadsheet". That is where you design an Access dB (tables) like a spreadsheet.
    I would suggest you stop and see these tutorials http://www.rogersaccesslibrary.com/forum/forum46.html
    Actually take the time to work through the tutorials. I think it will help you a lot.
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  8. #8
    eddcole is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Dec 2016
    Posts
    5
    Quote Originally Posted by ssanfu View Post
    From your description of your table in Post #1, it sounds like you have committed "spreadsheet". That is where you design an Access dB (tables) like a spreadsheet.
    I would suggest you stop and see these tutorials http://www.rogersaccesslibrary.com/forum/forum46.html
    Actually take the time to work through the tutorials. I think it will help you a lot.

    Thank you I will take a look

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

Similar Threads

  1. Some Advice
    By Race-winners in forum Sample Databases
    Replies: 1
    Last Post: 12-23-2015, 12:38 PM
  2. New-and need help as well as advice
    By bjd1020 in forum Access
    Replies: 8
    Last Post: 11-16-2012, 02:25 PM
  3. Need some advice and help
    By winterh in forum Access
    Replies: 9
    Last Post: 04-18-2012, 06:41 AM
  4. Database advice
    By PRINCE SWAGG in forum Access
    Replies: 29
    Last Post: 06-21-2011, 03:56 PM
  5. Need advice on what I have so far
    By rumplestiltskin in forum Database Design
    Replies: 2
    Last Post: 05-25-2006, 12:48 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 - Senior Forums