Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    ClariceT is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2022
    Posts
    8

    Sorted out!
    Thank so much! You are a gentleman.
    Cheers!

  2. #17
    NoellaG's Avatar
    NoellaG is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    859
    Hi, isn't it much easier to solve the problem in the source. I assume the linked table is on SQL server, so create a view based on the table and add the missing field there. Link your front-end to the view instead of the table. This way it's always present and no need for programming.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 08-03-2021, 08:22 AM
  2. Create a field, if it doesn't already exist
    By jeffatwork in forum Access
    Replies: 3
    Last Post: 03-02-2016, 08:05 PM
  3. Replies: 6
    Last Post: 09-15-2015, 02:18 PM
  4. Replies: 9
    Last Post: 03-02-2015, 06:05 PM
  5. VBA to create PDF and folder if doesn't exist!
    By crxftw in forum Programming
    Replies: 2
    Last Post: 08-08-2011, 08:53 AM

Tags for this Thread

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