Recent content by jcrtektip

Thank u john...I will look into these options..

Thank you once again 'K2W' I had to do some few changes to make it work.. good piece of code thank u

I have phone numbers in my access database, can i use this number and make a call ?

Thank you for your reference...I am trying with that code...

I want to force a pagebreak after printing n lines. There are three layer of group and subgroup, in each group or subgroup data may or maynot get printed (format group). each time I keep incrementing the counter. based on this counter I need to force the pagebreak. How ?

I have place a pagebreak object at the end of the report, I have to force the pagebreak only when the counter is n value till then there should not be any pagebreak, it has to be inactive. when the value of the counter is n then the pagebreak should be activated. How to do this?

use a data component populate the recordset to this data component, select the dbcombo and set the recordsource to this data1 (component) type the field to be displayed in the combo do all this in your design at run time change the recordset for that data component (data1). Private Sub...

I am not sure about the check box in your second column... but here is the code. applfile = "c:\your_excel_filename.xls" Workbooks.Open applfile Set datasheet1 = Worksheets("worksheet1") set datasheet2 = Worksheets("worksheet2") set datasheet3 = Worksheets("worksheet3") 'get the starting row...

See if this helps.... applfile = "c:\oldfile.xls" mmonth = "dd-mm-yy" 'you have to create this string from the values or date savefile = "c:\ mmonth + ".xls" finalsave = mmonth + ".xls" Workbooks.Open applfile Set datasheet = Worksheets("sheet1") 'you can give your sheet name...

I am opening an access report from my vb code. I have designed an report in access database and opening it from vb. It works fine. Now I have put password for the database. I want to include the password in this code. How do I do it ? Please help... The code is as follows.... Dim...

From my vb 6 application I am creating a excel file, which is created from a template which has a graph. I just populate the data and refresh the graph. Further I have to copy this graph and data into a ppt (power point). Is there any chance of creating this ppt straight from vb?

Thank you very much strongm.....

There are many ways of connecting a database... I will explain.... method 1 Set wsAccess = DBEngine.Workspaces(0) Set dbAccess = wsAccess.OpenDatabase(App.Path & "\x.mdb") set rsaccess = dbaccess.OpenRecordset("select * from t") 'where x.mdb is the database and t is the table method 2 strConn =...

Select the combobox and then in the property window select the '0-dbcdroupdowncolumn' in the style property. Then try again your problem is solved....

Yes If I change the connection method I can use the password. I need not create any group. In the access database I can set password and use that password in the connection method you have specified. But my problem is I have use the opendatabase type of connection and the record set used...