Results 1 to 5 of 5
  1. #1
    foxtet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    23

    Exclamation Print Service Memo

    Hi every one,


    I'm a new user of ms access. as a part of my assignment i'm working on patient database by access 2003.

    I want each patient to be given a service memo from the counter at the time of registration. and also if the patient seek any service from any department he/she will be issued a memo prior to service rendering.

    if any one can build this module for me it can be a great help....

    fox

  2. #2
    blue4512 is offline Novice
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    26
    Start by making sure you have the following tables created; patient, registration, department, service

    Create a form for the patient, with a subform for the registration and look-up fields for the other tables

    Lastly create a report that shows all relevant information

    - Patient table - first name, last name, ID, Address, City State, Zip Code, Phone Number, etc.

    - Registration - Date, time, notes, location,

  3. #3
    foxtet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    23
    Thank u
    in the price list the amount is different to locals and foreigners..what i wanted to do is that at the time of registration if the patient is foreigner that memo window must filter rates for foreigners only.... any help
    fox

  4. #4
    foxtet is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    23
    Thank you for the help

    Pls go through the attached file for more details of the problem...
    I need the rates for local as well as foreigners should filter separately in the sub form of memo window...

    pls get me a solution for this part of the database...

    fox

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,620
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 0
    Last Post: 07-15-2010, 12:13 PM
  2. Select last 2 dates of service
    By kfinpgh in forum Queries
    Replies: 1
    Last Post: 11-25-2009, 07:34 PM
  3. Database and Software as a Service
    By Hcasty in forum Programming
    Replies: 1
    Last Post: 09-11-2009, 03:03 AM
  4. SQL service connection
    By selma_ in forum Import/Export Data
    Replies: 5
    Last Post: 08-20-2009, 04:01 AM
  5. Print memo field
    By Mike McNally in forum Reports
    Replies: 0
    Last Post: 09-22-2008, 05:35 AM

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