User Profile
Collapse
-
I have already included reference to Access 11.0 library in package even then problem arises. -
DoCmd Without Access-2003
I have designed software with VB6.0 as frontEnd & access-2003 as backend. For running action queries & for importing text files to my database i am using DoCmd object for which i have add reference to Miscrosoft Access 11.0 object library. In my PC it works fine as i have installed Access 2003 in my PC but in other PC's where Access -2003 is not installed it is giving error "Can not create ActiveX object" and other errors also.... -
Copy Import Specification from one MDB file to another.
I have created and saved Specification for Importing Fixed With Text file inbto Access Database. Now I want to copy this specification to another MDB file. Can anybody tell me how to do this?I am using Access-2003
Thanks
Neelesh -
I think you are selecting Row of datagrid for Editing, transferring this to form and transferring back to grid after Editing. If it is so then in AfterColEdit Event of Datagrid use following code:
adodc1.recordse t.update
I think this will solve ur problem.
RegardsLeave a comment:
-
Run Setup file in Domain security
Hi all,
I have developed Setup file of my VB6.0 based software using innosetup. But i can't run this setup in machines where domain security is applied. I dont have administrator privalages. Pls tell me how can I run the Setup file.
Thanks -
Copy from recordset method on Filter Recordset
Hi all,
I have project with VB6.0 and Access-2003. I have datagrid and ADODC as datasource to retrieve records from database. To export the data of datagrid to Excel I am using Copy From Recordset Method. It works fine but when I apply Filter on Adodc Recordset, The Copy From Recordset Method Export All Records in Excel File. I want to export ony Filtered Recordset to Excel File. How can I do this?
Thanks
Neelesh. -
-
I could not attach Image in Last Post as File size was more. So I have attached the Image here....Leave a comment:
-
-
I think there is no need for moving Records to get Record count. Refresh the recordset & then use RecordCount. I think it will work.
e.g.
rs.refresh
if rs.recordcount= 0 then
.
.
Else
.
.
EndifLeave a comment:
-
-
I have add two pages of my Report. In Last row of First page there is data without border and in next page the first row has border without data.
...Leave a comment:
-
-
Borders In Data Report
I have project in vb6.0 with Access as back-End. I Have used Data Report For Reporting. For Borders for Text Field in Detailed Section I have used RptShape. The problem is that in last line in Bottom part of report the Text Field is Printed without border and Blank Border without data is printed on First line of Next page. I Adjust top & Bottom Margin of Datareport To overcome this problem in my PC but as Datareport uses Default Printer Settings,... -
Add new Form. Select Form type as About Dialog. There is SysInfo command button which will solve your problem.Leave a comment:
-
-
Actually I want to grab the value of a Particular Cell in Datagrid and Fill this value in succeeding cells of Datagrid in Particular column by Dragging these Cells.
e.g. suppose in column 5 of my datagrid 8th Row contains Value Baroda, I want to grab these value "Baroda" and I want to Fill This value in Succeeding Rows in Same column by Dragging mouse over the Rows.
I hope you get me.
Thanks
NeeleshLeave a comment:
-
My problem is still unsolved. Can anybody guide me?
Thanks
NeeleshLeave a comment:
-
Setting DataReport Report Size
Hi all. I have Project in vb6.0. In my PC printer have default page letter. Now please tell me how can I set Report size of Data Report so that it doesn't show Error "Report width is larger than Paper Width?".
Thanks -
Protect database
Hello friends,
I m having project with access as backend and vb6.0 as frontend. Now I want to protect my mdb so that noone can edit it and no one can see my table design and it can Edit only through VB code. One way I know is using Password to mdb. But i need some other way to do it. Is it possible?
Thanks in advance
No activity results to display
Show More
Leave a comment: