Results 1 to 3 of 3
  1. #1
    annieo1927 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2014
    Posts
    2

    How To Populate a Form


    I receive a monthly excel spreadsheet which I import in my database and the data populated in the database form I created. Received a second spreadsheet the following month with the same data layout. The database import was successful but the data does not populate in in the form. How do I get the monthly spreadsheet to incrementally populate my form.

  2. #2
    Micron is offline Very Inert Person
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,424
    Not enough information. How is the data being imported? As a new, additional table? Data is appended to existing table? Overwritten? Linked? Is the form record source based on a table or query? If query, need to see it to examine the source and the criteria. That's all of the most likely needed info I can think of at present.

  3. #3
    annieo1927 is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2014
    Posts
    2
    The data is imported as a new table. The form record is source basd.

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

Similar Threads

  1. Replies: 13
    Last Post: 09-10-2015, 03:37 PM
  2. Replies: 1
    Last Post: 09-16-2014, 12:32 PM
  3. Replies: 13
    Last Post: 05-07-2014, 11:35 AM
  4. Replies: 63
    Last Post: 01-25-2013, 05:20 AM
  5. Replies: 5
    Last Post: 12-21-2012, 11:05 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