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 Databases section. This forum, and the thread "Opening a specific report by matching user input to report ame are both part of the Program Your Website category.



Go Back   Webforumz.com > Main Forums > Program Your Website > Databases

Notices


Reply
 
LinkBack Thread Tools
  #1 (permalink)  
Old Apr 26th, 2007, 15:06
New Member
Join Date: Apr 2007
Location: New Jersey
Age: 33
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
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
Reply With Quote

  #2 (permalink)  
Old Apr 26th, 2007, 15:23
New Member
Join Date: Apr 2007
Location: New Jersey
Age: 33
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
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
Reply With Quote
  #3 (permalink)  
Old Apr 26th, 2007, 17:32
spinal007's Avatar
Moderator
Join Date: Mar 2004
Location: Good Ol'London
Age: 23
Posts: 1,649
Blog Entries: 1
Thanks: 0
Thanked 4 Times in 4 Posts
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.
Last Blog Entry: Random String in Javascript (Apr 21st, 2008)
Reply With Quote
Reply

Tags
opening report, report name, user input

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 Webforumz Cafe 0 Feb 15th, 2008 14:03
[SOLVED] My Web Page Speed Report. Feedback wanted Oak Search Engine Optimization (SEO) 2 Dec 30th, 2007 18:13
Sequential Number on a Report cbuccieri Databases 5 Dec 3rd, 2007 12:33
E-mailing a report based on current record on form easydoesit Databases 0 Aug 27th, 2007 23:07
Printing single record from Access via Report in Web Page Neotekk JavaScript Forum 0 Jun 18th, 2007 15:20


All times are GMT. The time now is 07:32.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

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