Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 15th, 2006, 08:48 PM
Registered User
 
Join Date: Jan 2006
Location: Wetumpka, Alabama, USA.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default Entering Multiple Parameters in a Paramter Query

I have a Microsoft ACCESS table that has over 15,000 records. I need for the user to enter multiple paramters in a query to pull all of the records for types entered in one parameter msg box. For example, When a macro button is pushed to run the paramter query, a MSG box will appear asking the user to PLease Enter License Types. The user would enter say, 10,11,30,31,32,60, 70 and 80 for example. I would want Access to pull all of the records for all of these types.

ANother question along this line with this same file. I have Issue Dates in this file coming in as a Mainframe Text File. The dates appear with 11006, 21006, 12506. The leading zero is chopped off. I want to add this zero back to have 011006, 021006, and 012506. I have 15,000 records to do this on, is there a script that will do this in an Update Query?

Joel Carmack
  #2 (permalink)  
Old February 15th, 2006, 09:20 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Joel,
What datatype do you have your IssueDate field set to? If you set it to "Date" and the format property to "short date" does that fix it?

HTH,
Loralee

PS How many parameters do you want your user to enter?


  #3 (permalink)  
Old February 15th, 2006, 09:36 PM
Registered User
 
Join Date: Jan 2006
Location: Wetumpka, Alabama, USA.
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The Issue Date Field is coming in as a text field from a mainframe program Cobol. THe issue date field will be later changed to a Date?time once I put the chopped zero back. I will then convert the text data to date/time using another script which I know how to do.

I need for the user to enter up to 12 data types at one time.

Joel Carmack


Similar Threads
Thread Thread Starter Forum Replies Last Post
2000 Multiple Parameters jpenn Reporting Services 1 July 19th, 2006 01:39 PM
Multiple parameters for a datagrid jgsuter ASP.NET 2.0 Professional 1 June 14th, 2006 09:31 AM
Export Access Paramter Query to Excel jcharlton VB Databases Basics 1 February 10th, 2006 08:58 AM
Passing Multiple Parameters into Access Query rit01 Classic ASP Databases 1 October 26th, 2005 04:00 PM
Entering Multiple Sale Items on a Form rika4750 Access 1 May 2nd, 2005 12:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.