Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #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
Reply With Quote
  #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?


Reply With Quote
  #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
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


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



All times are GMT -4. The time now is 02:54 AM.


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