 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / January 2008Creating Searchable Database
I am new to creating an Access database, but have worked in Access when there has already been a database completed. I am trying to create a database in which I can create a new record for each of my customers. I would like to be able to search by each of the fields in my record. I also want to be able to input dates underneath each of the records(for each date we service them). I worked for a company who had a database like this set up, but never looked into it to see exactly how it was set up. Any advice would be appriciated! Shari, You have a couple of very distinct issues. As for creating a searcheable form to retrieve your client records, take a look at http://allenbrowne.com/ser-62.html it illustrates the principle. You can then customize it further to suit your exacting needs. As for inputing dates (underneath?) your records.... This is a question of table setup. You need to have a field in your table to add in the date. Then add the field onto your data entry form. Also, for enetering date you should use a calendar/date picker to facilitate data entry. For this look at http://allenbrowne.com/ser-51.html or http://www.lebans.com/monthcalendar.htm both are very good.  SignatureHope this helps, Daniel Pineault > I am new to creating an Access database, but have worked in Access when there > has already been a database completed. [quoted text clipped - 7 lines] > > Any advice would be appriciated! Have you tried the built in filter by form feature? When you use the filter by form, you simply look at your current form and type in the values for each field to match. Whack the filter utton and access off goes and gets the records. in addition to using your current familiar form, some of the fields actually get automatic converted into drop down boxes for you. before you go off and do a bunch of work to build a custom search screen, you might wanna give the above feature try go records->filter->filter by form..... SignatureAlbert D. Kallal (Access MVP) Edmonton, Alberta Canada pleaseNOOSpamKallal@msn.com Thank you Albert. That could work, although it is not what I am looking for. What I was able to do at the previous company were click on buttons, already placed on each form, that would allow me to search by the individual fields. I cannot for the life of me figure out how to add those buttons. I also used to do a mailing with a merge to Word. There was a box on each form I could check, and it would add it to a list to merge into Word. Any idea how to get that? > Have you tried the built in filter by form feature? > [quoted text clipped - 9 lines] > > go records->filter->filter by form..... Shari, Albert is the right person to ask questions about MailMerge. Take a look at his sample solution at http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html about half way down the page entitled 'Super Easy Word Merge'. You will have to do some programming to get it to behave in the exact manner that you describe but this is the way to go. SignatureHope this helps, Daniel Pineault > Thank you Albert. That could work, although it is not what I am looking for. > [quoted text clipped - 19 lines] > > > > go records->filter->filter by form..... |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.