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
|
|||
|
|||
How do I query about a person using only their name in Access?
I'm doing data entry for the Inn I live in which is using an Access database.
The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#2
|
|||
|
|||
How do I query about a person using only their name in Access?
A quick, easy way would be to create a new form with a combo box on the
person's name. Then attach a sub-form with the remaining information you want. If the table(s) are put together correctly, should take you about 5 minutes. "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#3
|
|||
|
|||
How do I query about a person using only their name in Access?
Thank's, that's one idea but as I said, I'm not that good with Access. I would need instruction on how to do what you reccommend. Also, there are now over 2,000 names already in the database. Would I have to go back and dio this to each name? I thank you for the help. Darkhorse "Sharkbyte" wrote: A quick, easy way would be to create a new form with a combo box on the person's name. Then attach a sub-form with the remaining information you want. If the table(s) are put together correctly, should take you about 5 minutes. "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#5
|
|||
|
|||
How do I query about a person using only their name in Access?
Would I have to go back and dio this to each name?
This is what my "Not at all." response was aimed at. Sharkbyte "DarkhorseHorizons" wrote: Thank's, that's one idea but as I said, I'm not that good with Access. I would need instruction on how to do what you reccommend. Also, there are now over 2,000 names already in the database. Would I have to go back and dio this to each name? I thank you for the help. Darkhorse "Sharkbyte" wrote: A quick, easy way would be to create a new form with a combo box on the person's name. Then attach a sub-form with the remaining information you want. If the table(s) are put together correctly, should take you about 5 minutes. "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#6
|
|||
|
|||
How do I query about a person using only their name in Access?
Thank's man, I'll try and find someone or see if I can find some instructions
on it myself. Current copy of database made just yesterday as this is being dione on my network then transferred to the computer out front periodically Via "drag -n- drop" from CD. I've also been trying to get the person that set this up to help me but he's hard to catch at home. I actuall thought it would come down to my having to write something to make it as user friendly as they need. Up front they are computer illiterate which makes my job that much harder. I'll do what I can and, thanks a bunch for the info. I'm pointed in the right direction now which I wasn't ten minutes ago!! Darkhorse "Sharkbyte" wrote: Also, there are now over 2,000 names already in the database. Not at all. I'm not sure what to tell you. I don't think there is a quick-and-easy way to walk you through building a form/sub-form, to do what you want. It would take longer to write out the instructions than it would to actually build the form. If you check around (computer repair shops, perhaps) you can probably find at least a casual Access user that can do this for you. Just make sure you make a copy of the db before someone goes in and does any work on it. Good luck. Sharkbyte "DarkhorseHorizons" wrote: Thank's, that's one idea but as I said, I'm not that good with Access. I would need instruction on how to do what you reccommend. Also, there are now over 2,000 names already in the database. Would I have to go back and dio this to each name? I thank you for the help. Darkhorse "Sharkbyte" wrote: A quick, easy way would be to create a new form with a combo box on the person's name. Then attach a sub-form with the remaining information you want. If the table(s) are put together correctly, should take you about 5 minutes. "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#7
|
|||
|
|||
How do I query about a person using only their name in Access?
My email address is: , if anyone can help me with this I'd greatly appreciate it. Thanks. Darkhorse "Sharkbyte" wrote: Also, there are now over 2,000 names already in the database. Not at all. I'm not sure what to tell you. I don't think there is a quick-and-easy way to walk you through building a form/sub-form, to do what you want. It would take longer to write out the instructions than it would to actually build the form. If you check around (computer repair shops, perhaps) you can probably find at least a casual Access user that can do this for you. Just make sure you make a copy of the db before someone goes in and does any work on it. Good luck. Sharkbyte "DarkhorseHorizons" wrote: Thank's, that's one idea but as I said, I'm not that good with Access. I would need instruction on how to do what you reccommend. Also, there are now over 2,000 names already in the database. Would I have to go back and dio this to each name? I thank you for the help. Darkhorse "Sharkbyte" wrote: A quick, easy way would be to create a new form with a combo box on the person's name. Then attach a sub-form with the remaining information you want. If the table(s) are put together correctly, should take you about 5 minutes. "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse |
#8
|
|||
|
|||
How do I query about a person using only their name in Access?
On Fri, 17 Feb 2006 12:47:29 -0800, "DarkhorseHorizons"
wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse Do you have a Form for the data, or are you using the table datasheet directly? A form is a *lot* better... For one thing, you can open the Form in design view. On the Toolbox, click the "magic wand" icon to make sure it's selected, and then choose the "combo box" tool (hover the mouse over the tools to see which is which). Drag out a little rectangle where you want the combo box on the Form, and choose the option "Use this combo box to select a record". The Wizard will walk you through which field to use, etc. When it's done you should have a dropdown list of all the names in the database; when you select one of the names, it will jump to that record. John W. Vinson[MVP] |
#9
|
|||
|
|||
How do I query about a person using only their name in Access?
Thank's very much John, yes, I do have a form I enter the data on. This is
what I think I needed to know. I will backup Database and definately try this later on tonight. I'll post a thread to let everyone know how I do with thier ideas/suggestions. I will keep this threadgoing though to see what else is suggested as I'm learning things I need know if I'm going to be using this application. All the Inn's records are in Access databases and I'm the only computer wizard they got, He, he. It's a wonder with all my experience with computers (custom building, gameing machines, repair, upgrades, etc.) I've never learned that much about Access. If it's really that easy to use, I'dlike toknow more about the program. For now though I do all my personal stuff in Excell and in Word. I can't thank you enough. All ofyou whom have and are continuing to help me with this. Darkhorse "John Vinson" wrote: On Fri, 17 Feb 2006 12:47:29 -0800, "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse Do you have a Form for the data, or are you using the table datasheet directly? A form is a *lot* better... For one thing, you can open the Form in design view. On the Toolbox, click the "magic wand" icon to make sure it's selected, and then choose the "combo box" tool (hover the mouse over the tools to see which is which). Drag out a little rectangle where you want the combo box on the Form, and choose the option "Use this combo box to select a record". The Wizard will walk you through which field to use, etc. When it's done you should have a dropdown list of all the names in the database; when you select one of the names, it will jump to that record. John W. Vinson[MVP] |
#10
|
|||
|
|||
How do I query about a person using only their name in Access?
John - do you have such a simple option for putting the combo box on a menu,
i.e. the combo box will relate to my list of contacts on one form, but be placed on the menu, another form? "John Vinson" wrote: On Fri, 17 Feb 2006 12:47:29 -0800, "DarkhorseHorizons" wrote: I'm doing data entry for the Inn I live in which is using an Access database. The problem I/We are having is the person whom set up this database for us no longer works here and while I am an A+ technician, I'm not that profficient in Access. I can enter the registration card data fine in the archive input, and retrieve any person's info I want by "scrolling" the form. However, we don't have the time to scroll through names at the front desk. We need to be able to just type in ONLY the name, and retrieve the person's info (as long as their in the database of course). My question is: How do I, or better, which part/section of the database do I have to have open, and what do I click on to be able to do this? My job is riding on my finding the answer soon. Thank's. Darkhorse Do you have a Form for the data, or are you using the table datasheet directly? A form is a *lot* better... For one thing, you can open the Form in design view. On the Toolbox, click the "magic wand" icon to make sure it's selected, and then choose the "combo box" tool (hover the mouse over the tools to see which is which). Drag out a little rectangle where you want the combo box on the Form, and choose the option "Use this combo box to select a record". The Wizard will walk you through which field to use, etc. When it's done you should have a dropdown list of all the names in the database; when you select one of the names, it will jump to that record. John W. Vinson[MVP] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Access 2002 vs. 2003 | Neil | General Discussions | 51 | February 16th, 2006 10:18 PM |
Ambiguous Name Error | pm | Using Forms | 10 | June 5th, 2005 09:19 PM |
Why is a French Spellchecker a "required" update for English speak | French Spellcheck Required? | General Discussion | 23 | April 26th, 2005 01:17 AM |
How to use a Access Query that as a parameter into Excel database query | Karen Middleton | Setting Up & Running Reports | 1 | December 13th, 2004 07:54 PM |
WORD XP mail-merge FAILS using ACCESS Query | SueMackay | Mailmerge | 1 | November 23rd, 2004 01:03 PM |