Recent content by drp

Hi! Thanking for quick reply I understand but exactly do not know how to use or write criteria in DCount Function Pls give me Expression Thanx

Hi! I have a form containing 4 text Boxes txt1, txt2, txt3 and txt4 I want txt1 show records from table empDetail having age between 18 to 25 txt2 show records from table empDetail having age between 26 to 35 txt3 show records from table empDetail having age between 36 to 45 txt4 show records...

Hi JHB This works as I want. Save my lot of time Thank u very much drp

Hi JHB Thank U for showing interest In your reply DB, investigations field shows only one row at a time (due to giving control source "=tbl_Sub!TestCode". It is ok But I want to display all the three rows i.e first row of column testCode (ALB) Then 2nd row of coliumn TestCode (Cal) and 3rd Row...

Hi Experts, My database has Main form and a Sub form. On main form i place one unbound text box named investigations. In subform of which datasheet there is a column named TestCode. I want unbound text box (Investigations) to display row values which selected in a column (TestCode) of...

It works fine. Thank you very much !

hi experts in my database main form with subform. subform have query as recordsource. total of one of field in subform shown on main form. all is ok and show total correctly but when subform have no records then total field on main form shows #error. I want help from experts to convert this...

Hi I have data coming from serial port which is stored in a field ; data type Memo from that data i want to create line chart. to solve this i seperated values by using Mid$ function and create a array from that. is it possible to draw line chart from the array value separated from memo...

Hi I am beginner to VB6.0 in my project1 in a form I placed one text box "text1" and "data1" data control when I run form I want to fill the "Text1" by default with a field from recordset i.e field from first record of recordset. data1 recordset have two field - "User" and "SrNo" I want...

Hi now i have problem with vb6 form my vb6 form have three text box controls one is strHex not attached to data control, but getting text value (hex value) of second control named strobj . I want to explain more- "strobj" text box contains decimal value i.e hard drive serial no., "strHex"...

Hi I am new to MS access 2003. I have a access batabase "Histodata" which is used as BE for VB project. in that Table is tbl_histodata having field like "rbchisto", "wbchisto" etc. these field have data type OLE object. Now I want to use this database and create form "frm_histodata" from the...

Hi In my databse, When I print a report using command button on form, I want to close that form instantly i.e By Clicking Single Button Report should be print simultaniously closing the same form Immediate help requires Thanks in advance

it works, but in preview mode report does not pop up. it open in preview mode but goes behind the form and the form get focus. I want to focus a form when i close the report hope you may understand my problem thanks

Thank you sir, I have another problem. My form have two list box in one there are several available report say 100 , from that list i select say 4 reports in second listbox i want these four reports( name of reports are not specific they may vary patient to patient) print with a sigle command...

Hello, i have a form with several controls, When i print a report using a command button on form the whole form lost focus also all other controls also lost focus. To focus on form I have to click on form, that i don't want. I want to autofocus form after printing report. pls Help me I wating...