[Year 12 IT Apps] Access Question

[Robert Timmer-Arends]

Hello Jarrod

I found two problems with the db you sent:
1. the easy one: on the order form, the field labelled 're-enter cost' is not bound. I bound it to the 'cost' field (click on the field, click properties, select source)
2. the not so easy: When you enter data into a form, Access does not send it to the underlying table until you move to another record or close the form (that's as I understand but it may be more complicated than that!). So, once I had done 1 above, records were saved if I closed the form or started a new record. If I did neither of these things, then when the view all was clicked it appeared the data had not been saved. One fix is to place a 'requery' command after the save command in the approve macro. This has the side effect of moving the record pointer back to the first record but maybe that's ok.


Regards
Robert T-A

----- Original Message ----- 
  From: Robinson, Jarrod J 
  To: Year List 
  Sent: Thursday, May 30, 2013 12:13 PM
  Subject: [Year 12 IT Apps] Access Question


  Hi All


  Just wondering if anyone can help me with a simple solution I'm sure to the following Database issue which you can find attached. 


  Essentially the form allows entry and calculates the costs of a service, however when they run an update query to add the entered record to the orders table nothing happens. Driving me nuts




  Any insight into this would be great. Im certain I'm missing something very simple




  Jarrod Robinson

  Physical Education Teacher

  Boort District School

  Malone St, Boort

  Victoria, Australia 3537   

  T +61 3 54552201  

  robinson.jarrod.j at edumail.vic.gov.au 

    www.boortds.vic.edu.au



  Please consider the environment before printing this email



  Important - This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education and Early Childhood Development.



------------------------------------------------------------------------------


  _______________________________________________
  http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
  IT Applications Mailing List kindly supported by
  http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority <br>
  http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc <br>
  http://www.swinburne.edu.au/ict/schools - Swinburne University
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4cfd23dc/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 12897 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20130530/4cfd23dc/attachment-0001.png