Register - Members List - Calendar - Mark Forums Read -

Go Back   Just Commodores > Main > The Pub

The Pub Talk about anything not relating to cars or Commodores in general.

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 27-01-2006, 02:21 PM
minux's Avatar
.
 

Ride: 'Enhanced' Y Series Senator Sig
Join Date: Feb 2005
Location: Geelong
Trade Rating: (0)
Posts: 5,649
minux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the charts
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Sponsored Links
  #2  
Old 27-01-2006, 04:49 PM
 

Ride: 2x VS
Join Date: Jul 2005
Trade Rating: (0)
Posts: 2,145
sixshooter Statesman
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #3  
Old 27-01-2006, 05:10 PM
 

Ride: N/A
Join Date: Jul 2005
Trade Rating: (0)
Posts: 47
reecey Executive
Default

yeh state the problem and let us help you
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #4  
Old 28-01-2006, 10:19 AM
minux's Avatar
.
 

Ride: 'Enhanced' Y Series Senator Sig
Join Date: Feb 2005
Location: Geelong
Trade Rating: (0)
Posts: 5,649
minux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the charts
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #5  
Old 28-01-2006, 03:30 PM
 

Ride: 2x VS
Join Date: Jul 2005
Trade Rating: (0)
Posts: 2,145
sixshooter Statesman
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #6  
Old 28-01-2006, 09:13 PM
minux's Avatar
.
 

Ride: 'Enhanced' Y Series Senator Sig
Join Date: Feb 2005
Location: Geelong
Trade Rating: (0)
Posts: 5,649
minux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the charts
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #7  
Old 28-01-2006, 09:46 PM
Carbon Neutral -> DO IT!
 

Ride: VP 5-SPD / 24-SPD Racer Hybrid
Join Date: May 2005
Location: .....in the Valley
Trade Rating: (0)
Posts: 1,449
azkwazere has disabled reputation
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.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #8  
Old 28-01-2006, 10:20 PM
minux's Avatar
.
 

Ride: 'Enhanced' Y Series Senator Sig
Join Date: Feb 2005
Location: Geelong
Trade Rating: (0)
Posts: 5,649
minux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the charts
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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
  #9  
Old 28-01-2006, 10:36 PM
minux's Avatar
.
 

Ride: 'Enhanced' Y Series Senator Sig
Join Date: Feb 2005
Location: Geelong
Trade Rating: (0)
Posts: 5,649
minux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the chartsminux Off the charts
Default

Ok, problem is solved, i can now print a single record from a form!!!! Thanks for everyone who replied here
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Google Bookmark this Post!Yahoo Bookmark this Post!Bookmark to AskJeeves!Bookmark to Slashdot!Live Bookmark this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mechanic Skills NIC_69 The Pub 7 27-10-2007 02:02 PM
samurai skills JD Jokes/Humour 2 10-10-2006 03:23 PM
Database Changes Darren Site Feedback / Site Problems 0 15-02-2006 08:19 AM
MSN ID database dephilile Site Feedback / Site Problems 3 25-07-2005 10:34 PM


0 Credit Cards | Montana Music | Loan | German sausage travel | Personal Loans | Car Reviews


All times are GMT +10.5. The time now is 10:27 AM.



Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.2.0