Results 1 to 1 of 1
  1. #1
    FelisMajor is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2014
    Posts
    1

    Access Web Services Macro Problems (SharePoint 2010)

    I am trying to migrate an Access client database to an Access Web Service database. Most of the conversion has gone smoothly, but I am completely stumped by one issue, as described below.

    FormA allows a user to do a search of a table with the results stored on a datasheet in SubFormB. A user can double click on a cell in the datasheet to open a record displaying all of its fields in FormC. This works.

    I would like the user to be able to do one of two things on FormC:

    1. 1) Click a button to Edit the record on the form and allow field changes (if the form is opened read-only),
    2. 2) Edit the form and then click a Save button, with a message to the user giving them the option of either saving the changes or cancelling them.


    Under option 1, I can set FormC to be read-only by setting its Allow Edits property to No in the property sheet. However, I can find no way to reset that property when a user Clicks on the edit button. I’ve tried using the Locked property instead, but that does not work (fields can be edited). I’ve tried setting individual controls on FormC to Locked=No via a macro, but that has no effect. I’ve tried other variations, but nothing I’ve tried works.

    Under Option2, editing works, but I’ve found no way to give the user a chance to cancel changes. The MessageBox available in the macros is strictly a message – it offers only an OK button to close it, with no way to specify the addition or reading of a Cancel button.

    Is either scenario possible in Access Web Services? If so, can someone tell me what I am doing wrong? If not, can someone suggest an alternative method that would work?
    Last edited by FelisMajor; 08-14-2014 at 10:45 AM.

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

Similar Threads

  1. Replies: 1
    Last Post: 06-29-2013, 01:49 AM
  2. Replies: 9
    Last Post: 05-07-2013, 08:37 PM
  3. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  4. Replies: 7
    Last Post: 02-19-2012, 04:40 PM
  5. Sharepoint Access Services References
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 11-09-2010, 09:42 PM

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
  •  
Tech Forums: Microsoft Office Forums