[Yr11 Information Technology] Access Database Help

[Paragreen, Chris J]

Thanks Brett,

I can confirm that the form is being shown in form mode, so that’s not the problem.

Regards,

Chris

From: yr11it <yr11it-bounces at edulists.com.au> On Behalf Of Edumail
Sent: Friday, 25 May 2018 8:39 AM
To: Year 11 Information Technology Teachers' Mailing List <yr11it at edulists.com.au>
Subject: Re: [Yr11 Information Technology] Access Database Help

Hey Chris,

The from needs to be open and not in design mode or layout mode for the criteria or be picked up. If any one of these conditions is not met you’ll get a blank query

Regards
Brett G
Sent from my iPad

On 24 May 2018, at 7:01 pm, Peter Repse <PRepse at maranatha.vic.edu.au<mailto:PRepse at maranatha.vic.edu.au>> wrote:

Send through the database file and I reckon it will make it easier for us to help out.



Kind regards,

Peter Repse
Secondary Teacher
Maranatha Christian School, Casey Campus Endeavour Hills
104-108 Reema Blvd, Endeavour Hills, VIC 3802
Direct:  9709 7285
________________________________
From: yr11it <yr11it-bounces at edulists.com.au<mailto:yr11it-bounces at edulists.com.au>> on behalf of Paragreen, Chris J <paragreen.chris.j at edumail.vic.gov.au<mailto:paragreen.chris.j at edumail.vic.gov.au>>
Sent: Thursday, 24 May 2018 5:35 PM
To: Year 11 Information Technology Teachers' Mailing List
Subject: [Yr11 Information Technology] Access Database Help

Hello everyone,

I’m stumped on an issue in Access. I’ve created a simple database for a music library. I’m creating a report of songs that belong to a particular album. The album is selected using a combo box in a form, which is populated by the entries in the “Albums” table. However, when I try to use the value of the combo as a filter for the report query, I always end up with an empty dataset. Can anyone shed any light on what might be missing/wrong?

Regards,

Chris

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 Training.


________________________________

The information in this email is confidential and may be privileged or subject to copyright. It is intended for the exclusive use of the addressee(s). If you are not an addressee, please do not copy, distribute or otherwise act on the email. If you have received the email in error, please contact the sender immediately and delete the email. The unauthorised use of this email may result in liability for breach of confidentiality, privilege or copyright.
Whilst we have used appropriate software to alert us to the presence of computer viruses, we cannot guarantee that this email or any files transmitted with it are free from viruses.

Maranatha Christian School
_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
Year 11 It Mailing List kindly supported by
http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority
http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc
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 Training.



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 Training.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://edulists.com.au/pipermail/yr11it/attachments/20180525/64594ec6/attachment.html>