+ Post New Thread
Results 1 to 3 of 3
Office Software Thread, Access Help in Technical; I have to write part of an Access database as a demonstration to the kids in my a-level class. Most ...
  1. #1

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Location
    Gowerton, Swansea
    Posts
    2,272
    Thank Post
    967
    Thanked 325 Times in 193 Posts
    Blog Entries
    11
    Rep Power
    165

    Access Help

    I have to write part of an Access database as a demonstration to the kids in my a-level class. Most of it is done but there are gaps in my knowledge (yes a humble teacher!!) and so I wonder if anyone out there can help.

    This is what happens....

    1. Query is run. It is a parameter query that asks the user for their membership card number and then their password. There is no validation here as it is not needed in the development

    2. User enters their details and up pops up a form. This form displays the following (based on the criteria) - Guest Name, Amount of Points. On the form is 6 buttons. The Guest clicks on of them to choose their gift. If they have enough points they can claim the gift. (I haven't done that validation yet).

    3. I have created a Macro that calculates their new points total after that gift is taken off. I've avoided using code so far as it makes it easier for the pupils.

    What I now want to happen is (after pressing the button) is a report to print a voucher detailing the date and gift. This bit is easy - that is to create a general report and have the macro print it.

    However, what I also want to do is transfer some of the fields from the query form onto the report on the fly so that it creates individual vouchers for individual guests.

    I'm sure it is easy - but I'm blank. As soon as someone tells me how to do it I know I am going to swear and say several rude words as I amaze at how dull I have been.

    ANy help appreciated,

    Gareth

  2. #2

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,247
    Thank Post
    882
    Thanked 2,745 Times in 2,319 Posts
    Blog Entries
    11
    Rep Power
    785
    Add a new textbox to your report and set its control source under the data tab of its properties to the textbox that you want the data from in the dialogue box/form that triggers the print (should be a small button beside the control source with three dots). This should take the value on the opening of the report so that it is customised. The source should end up looking like this "=Forms!<form name>!<control name>"

    I would be more tempted to do this whole thing using querys and data tables though so that accurate records are kept. For example points are stored in a seporate points table and each addition or subtraction is a seporate record. Getting the current points would just require a sum of all of their points transactions. With a time stamp added each time there is a points transaction it would allow propper tracking of their habits and auditing to make sure that the system is not haywire. The voutures could also be stored in a separate table, one per record to allow for tracking of what had been claimed when and by who. This would probably be much more representitive of a production type database.
    Last edited by SYNACK; 23rd January 2009 at 06:52 PM.

  3. Thanks to SYNACK from:

    garethedmondson (26th January 2009)

  4. #3

    garethedmondson's Avatar
    Join Date
    Oct 2008
    Location
    Gowerton, Swansea
    Posts
    2,272
    Thank Post
    967
    Thanked 325 Times in 193 Posts
    Blog Entries
    11
    Rep Power
    165
    Great stuff Synak - soooo obvious when someone tells you how to do it.

    Hope you can help with my next question.... appearing in a thread soon.

    Many thanks again,

    GJE



SHARE:
+ Post New Thread

Similar Threads

  1. MS Access help please
    By RabbieBurns in forum Office Software
    Replies: 2
    Last Post: 11th December 2008, 03:24 PM
  2. M$ Access
    By Hightower in forum How do you do....it?
    Replies: 5
    Last Post: 15th June 2008, 07:15 PM
  3. MS Access files
    By timbo343 in forum Windows
    Replies: 11
    Last Post: 18th April 2007, 03:58 PM
  4. MS Access
    By wesleyw in forum How do you do....it?
    Replies: 1
    Last Post: 9th November 2006, 10:50 AM
  5. ms access request for help
    By rama1712 in forum Windows
    Replies: 1
    Last Post: 6th October 2006, 02:01 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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
  •