Submit Your Article Webforumz RegistrationAnnouncements Contact Webforumz StaffContact
Home Resources Blogs Meet the Team Contact Register
 

Go Back   WebForumz.com > Putting it Together > Databases
Reload this Page Opening a specific report by matching user input to report ame
Register All Albums Blogs FAQ Members List Calendar Search Today's Posts Mark Forums Read

Reply
 
LinkBack Thread Tools
Old April 26th, 2007, 11:06 AM   #1
New Member
 

Join Date: Apr 2007
Location: New Jersey
Age: 35
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 autoIT is on a distinguished road
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 April 26th, 2007, 11:23 AM   #2
New Member
 

Join Date: Apr 2007
Location: New Jersey
Age: 35
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Altering Power: 0 autoIT is on a distinguished road
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 April 26th, 2007, 01:32 PM   #3
Most Reputable Member
 
spinal007's Avatar
 

Join Date: Mar 2004
Location: Good Ol'London
Age: 24
Posts: 1,684
Blog Entries: 1
Thanks: 1
Thanked 4 Times in 4 Posts
Rep Altering Power: 0 spinal007 has a spectacular aura about spinal007 has a spectacular aura about
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 - Web-Developer & London SEO Expert
 jQuery Plugins: Multiple File Upload, Star Rating, FCKEditor | NEW: XML to JSON
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

Bookmarks

Tags
opening report , report name , user input

« Access application on internet | Converting Access to SQL Express 2005 »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

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 The Café 0 February 15th, 2008 10:03 AM
[SOLVED] My Web Page Speed Report. Feedback wanted Oak Search Engine Optimization (SEO) 2 December 30th, 2007 02:13 PM
Sequential Number on a Report cbuccieri Databases 5 December 3rd, 2007 08:33 AM
E-mailing a report based on current record on form easydoesit Databases 0 August 27th, 2007 07:07 PM
Printing single record from Access via Report in Web Page Neotekk JavaScript 0 June 18th, 2007 11:20 AM

WebForumz.com is an iEntry Network® publication - 1998-2009 All Rights Reserved Privacy Policy and Legal
Contact Us - Web Design and Web Development forums for Beginners to Advanced - Archive - Top

Search Engine Optimization by vBSEO 3.2.0 RC8