Results 1 to 7 of 7
  1. #1
    venu_resoju is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    19

    Save button say syntax error

    I have created one form which contain some unbound fields and I am trying to save them to another "Table1" table. I have written some code for "Save" button in the after_update event but it is showing some syntax error...please



    and I want to save "Attendance Status" and "OT Hrs" values also from form to table("Table1")

    I am here with attaching my db.

    any body help me to solve this...thanks in advance...
    Attached Files Attached Files

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Why not use a bound form with bound controls?

  3. #3
    venu_resoju is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    19
    I want to create like this...

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    So it is simply an intelectual exercise then?

  5. #5
    venu_resoju is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    19
    I have to do like this

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Is it a school project?

  7. #7
    venu_resoju is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Feb 2011
    Posts
    19
    I am trying to create payroll. will give me some guidelines....

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

Similar Threads

  1. Access Form- Save/Close Button error
    By Ashe in forum Forms
    Replies: 3
    Last Post: 02-10-2011, 01:01 PM
  2. Incomplete Syntax Clause (syntax error)
    By ajetrumpet in forum Programming
    Replies: 4
    Last Post: 09-11-2010, 10:47 AM
  3. Help Require (Macro Save button )?????
    By aligahk06 in forum Access
    Replies: 1
    Last Post: 04-18-2010, 08:38 AM
  4. Save to PDF Button?
    By SpeedyApocalypse in forum Forms
    Replies: 2
    Last Post: 04-10-2010, 06:06 PM
  5. VB coding for saving when click on save button in form
    By cwwaicw311 in forum Programming
    Replies: 1
    Last Post: 02-04-2010, 11:11 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