[Year 12 IT Apps] Access Question

[Russo, Frank R]

Well Done Rob......this works but is it the best way?

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Robert Timmer-Arends
Sent: Thursday, 30 May 2013 7:20 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Access Question

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<mailto:robinson.jarrod.j at edumail.vic.gov.au>
To: Year List<mailto:itapps at edulists.com.au>
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


[cid:image001.png at 01CE5DD6.B327FD50]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<mailto:robinson.jarrod.j at edumail.vic.gov.au>
  www.boortds.vic.edu.au<http://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

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130530/0a36db96/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 12897 bytes
Desc: image001.png
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20130530/0a36db96/image001-0001.png