Web Design and Development Forums

Opening a specific report by matching user input to report ame

This is a discussion on "Opening a specific report by matching user input to report ame" within the MSSQL & Access section. This forum, and the thread "Opening a specific report by matching user input to report ame are both part of the Databases category.


Go Back   Webforumz.com > Databases > MSSQL & Access
Reload this Page Opening a specific report by matching user input to report ame
Register All AlbumsBlogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Welcome to Webforumz.com.
Register Now Register now!

Reply
 
LinkBack Thread Tools Rate Thread
Old Apr 26th, 2007, 15:06   #1 (permalink)
New Member
 
Join Date: Apr 2007
Location: New Jersey
Age: 33
Posts: 5
Opening a specific report by matching user input to report ame
I have a form that asks for a vin# and matches the info giving to a table that finds the matching model code ona particular vehicle. I want this model code to open a report also in this databse, whose name matches this model code.

Can I open a specific report by matching a piece of information to it? How is it done?

i.e. if ModelCode=report.name then openreport.123abc


Thanks
Adam
autoIT is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old Apr 26th, 2007, 15:23   #2 (permalink)
New Member
 
Join Date: Apr 2007
Location: New Jersey
Age: 33
Posts: 5
Re: Opening a specific report by matching user input to report ame
nevermid figured out:

vin# will search for modelcode
modelcode gets put into a variable
docmd.openreport variable, cnopenform

it's amazing what some slight thinking will do for you
autoIT is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Old Apr 26th, 2007, 17:32   #3 (permalink)
Moderator
 
spinal007's Avatar
 
Join Date: Mar 2004
Location: Good Ol'London
Age: 22
Posts: 1,609
Blog Entries: 1
Send a message via ICQ to spinal007 Send a message via MSN to spinal007 Send a message via Yahoo to spinal007 Send a message via Skype™ to spinal007
Re: Opening a specific report by matching user input to report ame
thank you for posting the solution.
might help somebody else who comes across this thread.
__________________
Diego - SEO Consultant London (My Blog | Fight Me)
jQuery: Star Rating - Multiple File Upload - FCKEditor/Codepress
 Before we work on artificial intelligence why don't we do something about natural stupidity?
spinal007 is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
opening report, report name, user input

« Access application on internet | Converting Access to SQL Express 2005 »
Thread Tools
Rate This Thread
Rate This Thread:

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
Report Spam Received in your Private Messages Ed Webforumz Cafe 0 Feb 15th, 2008 14:03
Sequential Number on a Report cbuccieri MSSQL & Access 5 Dec 3rd, 2007 12:33
Report Spam Received in your Private Messages Lchad Webforumz Cafe 0 Oct 1st, 2007 11:27
Report Spam Received in your Private Messages Lchad Announcements and News 0 Oct 1st, 2007 11:27



Latest Updates

All Points SEO Security Advisory - CHECK YOUR SITE NOW!

Creative Coding :: February 2008
Webforumz is sponsored by: WESH UK Web Hosting
All times are GMT. The time now is 06:14.

Sleep Study Scoring :: Free Bet :: Website Templates :: Online Betting :: Bookmakers :: Funny Quotes :: Internet Recruitment Software :: Microsoft CRM Experts :: Online Casino :: Decorated Christmas Trees :: Midwife Forums :: Football Betting :: Ecommerce Software :: Web Hosting :: Football Stats :: Dry Cleaning Collection :: xtreme wales - extreme clothing :: Apuestas :: Sharepoint Consultants :: Website Optimisation :: Office Clearance London :: Sharepoint Experts :: Sports Betting :: Casino :: Website Templates :: Web Design Development India :: Online Gambling

Powered by: vBulletin Version 3.7, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
© 2003-2008 Webforumz.com : All Rights Reserved
Search Engine Friendly URLs by vBSEO 3.2.0 RC6


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