 OT: Need someone VERY familiar with Microsoft Access and Visual Basic, Will pay for help with project. |
|
|
|
Porsche, and the Porsche crest are registered trademarks of Dr. Ing. h.c. F. Porsche AG.
This site is not affiliated with Porsche in any way. Its only purpose is to provide an online forum for car enthusiasts. All other trademarks are property of their respective owners. |
|
|
| Qarl |
 Apr 16 2006, 04:18 PM
Post
#1
|
|
Shriveled member  Group: Benefactors Posts: 5,233 Joined: 8-February 03 From: Florida Member No.: 271 Region Association: None   |
I have a little application my company sells. The applications is a Microsoft Access application.
I want to "improve" one of the features of it. I need help developing a VB macro for use in my application. Let me describe what I want to do... 1. I have a master list of codes Fields: Code Description 2. I have another list of data, let's call it the combination table Code1 Code2 Explanation Indicator Code1 and Code2 are various combinations of data from the master code list. 3. I want the user to be able to enter up to six codes as input criteria Input1 Input2 Input3 Input4 Input5 Input6 Each of the six inputs is limited to the codes that appear in the master code list. Basically, the user is selecting the inputs from a Combo Boxe in the Access form. 4. I want the user to be able to enter up to six input codes, and then have the program search the combination table for the following circumstances. Sometimes the users may only input two or three or four input codes. I want the program to Ouput on the Form in Access a character, say... the letter "X", next to any of the six inputs if the following criteria are met. The macro will search the Combinations table for any two of the selected inputs. Any time both input codes appear on the same line in the Combinations table, it will output a "X" next to the input code that appears in the second column (Code2) of the Combinations table. If only one of the two codes appear in the Combination table, or neither code pair appears, then it does nothing. Essentialy, the macro has to search for the following combinations... Input1 & Input2 Input1 & Input3 Input1 & Input4 Input1 & Input5 Input1 & Input6 Input2 & Input1 Input2 & Input3 Input2 & Input4 Input2 & Input5 Input2 & Input6 Input3 & Input1 Input3 & Input2 Input3 & Input4 Input3 & Input5 Input3 & Input6 Input4 & Input1 Input4 & Input2 Input4 & Input3 Input4 & Input5 Input4 & Input6 Input5 & Input1 Input5 & Input2 Input5 & Input3 Input5 & Input4 Input5 & Input6 Input6 & Input1 Input6 & Input2 Input6 & Input3 Input6 & Input4 Input6 & Input5 I will be willing to pay for your help in developing this Macro. If interested, PM me. Thanks, Qarl |
   |
 
|
Posts in this topic
Qarl OT: Need someone VERY familiar with Microsoft Access and Visual Basic Apr 16 2006, 04:18 PM
Bleyseng What are you talking about???? Apr 16 2006, 05:16 PM john rogers The easiest way is for the VB program to have two ... Apr 16 2006, 08:18 PM Qarl QUOTE
Qarl QUOTE
Twystd1 e-mail: pascal(at)ocagency.com
He is familiar wit... Apr 16 2006, 10:04 PM  |
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:
|
Lo-Fi Version | Time is now: 9th July 2025 - 10:37 AM |
Invision Power Board
v9.1.4 © 2025 IPS, Inc.