|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 5th, 2004, 04:39 PM
|
|||
|
|||
Setting Condition Expressions
I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#2
August 5th, 2004, 06:34 PM
|
|||
|
|||
|
Setting Condition Expressions
Create a combo box or two on a form that contain all the names (account
numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#3
August 5th, 2004, 06:55 PM
|
|||
|
|||
|
Setting Condition Expressions
Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box?
"Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#4
August 6th, 2004, 02:30 AM
|
|||
|
|||
|
Setting Condition Expressions
Yes, the combo box can be set to find values as you type the value.
-- Duane Hookom MS Access MVP "heath" wrote in message ... Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box? "Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#5
August 6th, 2004, 02:45 PM
|
|||
|
|||
|
Setting Condition Expressions
How? What do I put in the combo box properties to make it sure the database?
"Duane Hookom" wrote: Yes, the combo box can be set to find values as you type the value. -- Duane Hookom MS Access MVP "heath" wrote in message ... Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box? "Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#6
August 6th, 2004, 02:47 PM
|
|||
|
|||
|
Setting Condition Expressions
How? What do I put in the combo box properties to make it sure the database?
"Duane Hookom" wrote: Yes, the combo box can be set to find values as you type the value. -- Duane Hookom MS Access MVP "heath" wrote in message ... Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box? "Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#7
August 6th, 2004, 02:47 PM
|
|||
|
|||
|
Setting Condition Expressions
What perimeters do I put in the combo box properties to make it search?
"Duane Hookom" wrote: Yes, the combo box can be set to find values as you type the value. -- Duane Hookom MS Access MVP "heath" wrote in message ... Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box? "Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
|
#8
August 6th, 2004, 05:47 PM
|
|||
|
|||
|
Setting Condition Expressions
You would first create a query that returns all the over-due accounts (or
whatever you want to search for). Then add a combo box on form using the wizard. Use the saved query as the data source of the combo box. -- Duane Hookom MS Access MVP "heath" wrote in message ... What perimeters do I put in the combo box properties to make it search? "Duane Hookom" wrote: Yes, the combo box can be set to find values as you type the value. -- Duane Hookom MS Access MVP "heath" wrote in message ... Okay, bring it down a notch - we have over 500 accounts we are working on so need them to be able to just type in the name or account number. Will the combo box? "Duane Hookom" wrote: Create a combo box or two on a form that contain all the names (account numbers) that have deficiencies. Your users can use the combo box(es) to find the bad accounts. -- Duane Hookom MS Access MVP "heath" wrote in message ... I am a new user in need of guidance. I have a db set to monitor recoveries of past due accounts. I have been instructed to set it up so the counter people can put in a customer's name or account # and identify if we still have a deficiency with that individual. How do I go about doing this? Do I need to set up a dialog box or do I need to set up another query? I don't know even how to approach this. Help.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Setting Cell to Worksheet Name | javaeboy | Worksheet Functions | 4 | August 1st, 2004 04:39 PM |
| Function isn't available in expressions in query expression | Derek Ruesch | General Discussion | 1 | July 14th, 2004 11:52 PM |
| Unable to save a security setting | Eric Lommatsch | Installation & Setup | 0 | May 12th, 2004 11:51 PM |
Linear Mode
