I have a database that i have set up to run accounts for a small privatly owned bank. The problem i have encountered is that when modifications need to be made to a preexisting account searching through the records one by one is a major pain considering there are over 800 accounts/records (each account is a record). So what i want to implement is a search function of some sort. I just need to know the best way to do this in a user friendly way. Such as where they can supply input and click search and it bring them up the first account matching the criteria. I dont know if i need to do this through a query or a macro or what. Thanks for your help.
what is meant by the "+ username +" syntax, could you explain that statement a litlte more in depth. I am mainly a network technician, this database stuff is not really my thing so you could consider me to not be as adept as most.
There's actually quite a few ways to do this depending on what sort of functionality you'd like to implement here. Do you have any sort of interface setup, or are you working more or less with raw data only?
Yes i do have several forms that are the interface in which the user sees. The user actually never see's the tables, only these forms. Most of the people using this program are fairly computer illiterate.
If you're using forms, then the simplest method for searching would be to use a combo box. Combo boxes auto-complete, so they're fairly user friendly. You can then create a basic macro (or sub if you prefer) to scroll through your recordset(s) in the AfterUpdate event of the combo box.