Results 1 to 4 of 4
  1. #1
    Meccer is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    17

    Create Multiple Records


    I've got a reporting system with table fields:
    id (AutoNumber); start_date (DateTime); end_date (DateTime); description (Text); slide (Attachment)

    At the moment I have to add one slide at a time, which can sometimes be up to 50 slides.

    Can I attach all of the slides at once and create a record for each slide (the start_date, end_date and description will be exactly the same)?

    I don't know if I'm going at it the right way, any ideas will be greatly appreciated.

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what's a SLIDE??

    and no, you cannot add multiple records at once, but you can loop form data, or do append operations from temp tables to perm tables, and the like, which all serve as a workaround to the same thing.

    for instance, using a form to enter multiple transactions of an invoice at one time

  3. #3
    Meccer is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2011
    Posts
    17
    Oh, sorry a slide is an image

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    so take the advice I gave you in the last post and use an attachment field for your image.

    I don't work with those much, so it'll be trial and error for you, in order to see if an image path or another medium would work on a form with that kind of data type. I'm doubting it, but it only take a minute to try it yourself.

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

Similar Threads

  1. How to use a create a DSum with multiple criteria
    By FlyingDisc in forum Reports
    Replies: 1
    Last Post: 01-05-2011, 08:31 PM
  2. Create multiple records with 1 form?
    By bergjes in forum Forms
    Replies: 4
    Last Post: 04-14-2010, 06:16 AM
  3. Trying to create multiple records from a form
    By ed_hollywood in forum Forms
    Replies: 4
    Last Post: 04-02-2010, 10:57 PM
  4. Replies: 1
    Last Post: 12-10-2009, 08:41 PM
  5. Replies: 3
    Last Post: 06-01-2009, 01:41 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