Results 1 to 9 of 9

Thread: Database Skills required

  1. #1
    minux's Avatar
    minux is offline Infidel Bear
    Ride
    300rwkw FG G6ET/2011 Sti Spec R Hatch
    Mini Putt 2 Champion!
    Join Date
    Feb 2005
    Location
    Melbourne
    Posts
    6,879

    Default Database Skills required

    Wondering if anyone here has any knowledge using MS Access, when i say knowledge, im talking mor ebeyond the point of simply building a database..if you do, i need help

  2. #2
    Ride
    2x VS

    Join Date
    Jul 2005
    Posts
    2,061

    Default

    Quote Originally Posted by minux
    Wondering if anyone here has any knowledge using MS Access, when i say knowledge, im talking mor ebeyond the point of simply building a database..if you do, i need help
    Been couple of months since I was tested on it... what are you trying to do ?
    Disclaimer For The Reader ::
    The information I provide is freely given to ONLY help you with thinking on problem solutions. IT IS NOT a "How To Do It Guide".

    If you read ANY of my supplied information and use ANY of it you must accept and agree to do so AT YOUR OWN RISK
    or do not use the information at all
    .

    I accept NO liability if you damage your or anyone elses property or cause any harm to yourself or others with the information provided.
    I am NOT a Mechanic. You have been warned.

  3. #3

    Join Date
    Jul 2005
    Posts
    46

  4. #4
    minux's Avatar
    minux is offline Infidel Bear
    Ride
    300rwkw FG G6ET/2011 Sti Spec R Hatch
    Mini Putt 2 Champion!
    Join Date
    Feb 2005
    Location
    Melbourne
    Posts
    6,879

    Default

    Sorry, Just need some help in being explained how to print the report(rather than all 5000) from the form im working in in 2003. I also need to be able to email a single report from the same form(rather than 5000) and also applying a filter form to sort through records and only display certain data...Ive searched the net but it seems the questions that have been answered are for very advanced people. I am planning on doing a advance course in access, but agh for now this is driving me nuts

  5. #5
    Ride
    2x VS

    Join Date
    Jul 2005
    Posts
    2,061

    Default

    Make yourself a query to gather the info you require from your database.
    Then generate a report using that query for it's input.

    Not sure on the email stuff...
    Disclaimer For The Reader ::
    The information I provide is freely given to ONLY help you with thinking on problem solutions. IT IS NOT a "How To Do It Guide".

    If you read ANY of my supplied information and use ANY of it you must accept and agree to do so AT YOUR OWN RISK
    or do not use the information at all
    .

    I accept NO liability if you damage your or anyone elses property or cause any harm to yourself or others with the information provided.
    I am NOT a Mechanic. You have been warned.

  6. #6
    minux's Avatar
    minux is offline Infidel Bear
    Ride
    300rwkw FG G6ET/2011 Sti Spec R Hatch
    Mini Putt 2 Champion!
    Join Date
    Feb 2005
    Location
    Melbourne
    Posts
    6,879

    Default

    Quote Originally Posted by sixshooter
    Make yourself a query to gather the info you require from your database.
    Then generate a report using that query for it's input.

    Not sure on the email stuff...
    Im aware of how to generate the report, i have all that, i just would liek to know how to generate the code behind a command button that will only print off the one report

  7. #7
    azkwazere is offline Ahhh Yes, Ahhh Yes....
    Ride
    VP 5-SPD / 24-SPD Racer Hybrid

    Join Date
    May 2005
    Location
    .....SE Burbs
    Posts
    1,808

    Default

    Your query should only produce one report. The idea of a query is to pull out specific information into the one report. ie your need to refine your query so that it is only to the one page. its like a having a search with no peramiters. You could also just say "print pages 1 to 1" in the printer options..?

    aZk.

  8. #8
    minux's Avatar
    minux is offline Infidel Bear
    Ride
    300rwkw FG G6ET/2011 Sti Spec R Hatch
    Mini Putt 2 Champion!
    Join Date
    Feb 2005
    Location
    Melbourne
    Posts
    6,879

    Default

    Quote Originally Posted by azkwazere
    Your query should only produce one report. The idea of a query is to pull out specific information into the one report. ie your need to refine your query so that it is only to the one page. its like a having a search with no peramiters. You could also just say "print pages 1 to 1" in the printer options..?

    aZk.
    Yeah, i could do that, but its a pain in the ass when your talking hundreds of records, i want to be able to enter the data into a form and from there hit a command button that says print this forms report only

  9. #9
    minux's Avatar
    minux is offline Infidel Bear
    Ride
    300rwkw FG G6ET/2011 Sti Spec R Hatch
    Mini Putt 2 Champion!
    Join Date
    Feb 2005
    Location
    Melbourne
    Posts
    6,879

    Default

    Ok, problem is solved, i can now print a single record from a form!!!! Thanks for everyone who replied here

Similar Threads

  1. Mechanic Skills
    By NIC_69 in forum The Pub
    Replies: 7
    Last Post: 27-10-2007, 03:02 PM
  2. samurai skills
    By JD in forum Jokes/Humour
    Replies: 2
    Last Post: 10-10-2006, 04:23 PM
  3. Database Changes
    By Darren in forum Site Feedback / Site Problems
    Replies: 0
    Last Post: 15-02-2006, 08:19 AM
  4. MSN ID database
    By dephilile in forum Site Feedback / Site Problems
    Replies: 3
    Last Post: 25-07-2005, 11:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71