Lovely sir...
Thanks... Guide me another thing
In my following code i will use
As my excel file is stored in field name "table" which i am calling through variable "tabl"
Shall i use your recommended code as
Set WB = GetObject(tabl)
Am i correct?
My code is
Dim d As Database
Dim rs1...
Details are pointwise:
1 i am begginer level user
2 in a table i have different ""text" fields which are being export to word file
My new need is:
I added new field in table as attachment which contains excel file
.
I want to copy table from excel and paste in word file in which i am already...
Dear sir;
Thanks for your reply.
First all note few important points.
my project is to export data into word file. For other fields you would see my above code. data is correctly exporting into word file.
I have placed an excel file as attachment in a field
now through vba code i want to add...
Dear Experts;
So far I have created a data base that contains a table having 07 fields.
I have successfully export my data (extract from table) to word
Now i am in the need add 08 the field that is "OLE Object" each record have its separate OLE Object (Excel File)
now i want to print...
now code is CORRECTED......... BUT still appearing same error
i have table "MySelectedObservations"
fields are:
Department_Name
Observation_Heading
Observation_Details
Risk_Implication
Risk_Category
i want to export these data in the table into word file with name saved in table...
When i use this code i get error "Object Required"
Private Sub Command12_Click()
Dim cn As ADODB.Connection
Set rs = New ADODB.Recordset
On Error GoTo errorhandler
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
rs.ActiveConnection = CurrentProject.Connection
rs.Open ("select *...
Hello every one can anybody help me i have an error while executing a button "Object Required"
Private Sub Command12_Click()
Dim cn As ADODB.Connection
Set rs = New ADODB.Recordset
On Error GoTo errorhandler
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
rs.ActiveConnection =...