Search results

i want to search record in a specific period of time, i.e from one date to another date. by entering the two dates in two text boxes.

my search form is based on a query, in which you select from a list and its takes you to view record form.

if you open a form and maximize it (DoCmd.Maximize). how can you display another small form, not maxmized on top of first one

i have a form for viewing all the records in which you can go forwards and backwards. the problem i get is when i come to the desired record through another of my search form, it only displays the required record and doesn' show other records, any suggestions

thanks for all your help cheers

plz show me how

i have a memo field which i want to convert to sentece case after update. i know strconv is there but not sure how to do this. this i need to do in form, table and in report thankx

i aslso need the code. thankx in advance

plz be give me more clues. i have a form with displays result after a search in datasheet view. i want to put checkbox in front of name field. so that when a list of names comes up i can select the names which will be include in report by pressing a command button. thankx

yeeeeeh it worked great for me. thanks, it really saved me a lot of trouble. now can you put a check box on the subform in front of each record so that you can print a report from the selected records by pressing a command button.

oh great, thanx a lot jim, i really appreciate this. i also send you a email before i got your email,

i have placed a check box in front of a list of contacts. i want to print a specific report of only those who has their check box ticked. so checking the selected record and pressing a command button will print a the report of selected contacts. thanks

i really appreciate, but may be i am too junior for this, could you plz help in detail steps. i tried but it did not worked for me. thanx once again

i have list of contacts containing their job description as well. many people have same jobs. how can i find people according to their job. i.e many can be doctors. so i want to make a search form, in which a list box displays all the jobs and when you select any job like doctor, it displays all...

i have put a table on my form which displays three fields of whole database. what i am trying to do is to put check box in front of each of them so that user can select any number of records by checking the box. then by pressing a command button it prints a specific report of those checked...

i am trying to build a searchform. if i enter any part of NAME in a text box it displays list of all the available NAMEs in a subform which matches the search field. can you help me

yes dd-mm-yyyy is in table and form, but it doesn't work, if i enter 12-4-00, it writes is as 4-Dec-2000?????

i have a date field, which i have format of dd-mm-yyyy. but the problem is when i enter date it converts into american format. puzzled

i am trying to convert first letter of "NAME" to capital by using [NAME] = StrConv([NAME], 3) But when i run the form, it gives error that "the property is read only, it cannot be set". can you help me thankx

can i put a button on from that helps to lock and unlock the form for viewing or editing data. i.e if i press once it displays view only and one can only view the data, if i press again it asks some password and then displays edit and allow the editing. is there any other method to accomplish...