OLE1 field problem -
I want to display apicture from my database, and I have a OLE1 field in My table "Employees" called photo. How can I display this photo onto a form, I did some think like this but it is not working.
rst.MoveFirst
with rst
do while not rst.EOF
Text1.Text = FirstName
OLE1.Picture = !Photo
Text2.Text = !Notes
.MoveNext
Loop
End With
Everything is displayed on the form except the photo field, so I would like to know, if I am doing any stupidity?
How I do retrieve a picture in OLE1 -
How I do read a picture from database?
I have a OLE1 field on my form and I cannot retreive this field onto the OLE1 field. I need to know how to code in vb because this code do not work. I do not want to do it with a data control because the program is DAO code.
Ole1 = rstCon
OLE1 field problem -
I want to display apicture from my database, and I have a OLE1 field in My table "Employees" called photo. How can I display this photo onto a form, I did some think like this but it is not working.
rst.MoveFirst
with rst
do while not rst.EOF
OLE COntrol Activation -
Below is the code which I am using for opening other application in OLE control,which I need to put in one picture-box control.I am not able to figure out how to keep activatio of my application in the ole-container control unless I write a code to close the application.The problem I a
Display a drawing on a MS Access Form -
Hi there i would like to display a drawing (test.dwg) on my form in a
vb code. The form has an Bound Object Frame - OLE1 area. AT the moment i'm getting only the icon and file name displayed in the OLE1. When i click on the icon then it opens up the the diagram in SmartSketch which i
How to use OLE control to display a Microsoft Word document (RESOLVED! THANKS) -
How to use OLE control to display a Microsoft Word document in a vb form, by clicking its name in a Listview?
I DONT WANT TO RUN WORD (SHELL COMMAND)
Thanks and sorry for my english!
I RESOLVE THE PROBLEM, THANKS ALL!
I USE:
OLE1,AUTOACTIVATE=0
OLE1.SOURCEDOC= MY DOC
How can I shut winword down programmatically -
I made an app that copies the contents of a .doc file and populates an OLE object with it. Everything works great the first time around but when I try to run the app a 2nd time I get errors telling me that a font is too big and that I'm low on system resources. When I look in the tas
saving word document using VB -
I have a OLE control on the Form which contains a word document as an embedded object.
my code for generating the word file is as follows
ole1 is the name of the OLE Control
rtb is the name of the RichTexBox Control
freefilenum = freefile
OLE1.doverb -2
OLE1.datatext = rtb.RTFt
Embedding word documents in vb6 -
I have a vb6 form where I want an embedded ole Word97 document. The document
is saved in an access db where other fields on the form are in also. It's
easy to bind the control to the daodata control. But I want to do that in
code. So I can decide in code if the user can update the
Ole1 control (where to find) -
Hi, can anybody tell me what is the name of the OLE1 controll so that I can find it on the harddisk.I need to include it with my project for people who don't have VB installed.
Thanks.
Missing Word File Menu w/ OLE Control -
I am embedding a Word document into an ole container control. When the document appears, the menu which shows on the MDI form is missing the File menu. I've checked that the
CommandBars("menu bar")..Controls(1) item is enabled and visible. Also, all the file related icons o
Problem with OLE and Word format! -
Hi all, I'm using the OLE component to change a Word Document
then pass the contents of the OLE object to a new Word Document and then send it to the printer as a postscript file.
The problem is that the content on the OLE object is saved on the Word Document as in the format of th
Sizing an excel spreadsheet in VB -
Hi,
I was able to put an excel spreadsheet in VB using OLE. The only problem is is that the data is being cutoff in VB. How do I make it to where it looks exactly like the spreadsheet in excel.
All I use right now is
OLE1.SourceDoc
OLE1.Action
I am new to this so any hel
How to save a Word Document opened in a OLE Control -
How to save a Word Document which is opened in a OLE Control
ole1 - OLE Control
ole1.SaveToFile filename
ole1.SaveToOle1File filename
both these lines give errors. Please advise. Thanks
OLE1.object | scroll down the sheet -
Hi,
there is an ole object, and I can write a number to excel by it, it is ok.
but I want to scroll down the sheet inside the ole, say 3, and ı can not do it
I tried ""xlBook.Worksheets("Sheet1").SmallScroll"" but I don't know exactly the syntax
Anyone know a better way -
I have an Access 97 MDB with a Memo field and an OLE Object field (among other fields). My VB6 app allows users to add, edit, and view the Memo field contents from an RTF control and allows them to add and change the OLE Object from within an OLE control.
Users can then select any n
MS Word Embedded Objects -
I am having all sorts of trouble using embedded MS Word OLE's in a Visual Basic application.
I am a novice with VB and what I am trying to do should be as simple as pie.
I want to click a button which will allow me to read an OLE field from an Access database and store it on a form.
ole container and seltext -
Is it possible to reference the text selected in an ole container?
(Ex. I have a form with OLE1. In the container is a word doc with the first sentence selected.)
How can I reference form1.ole1.seltext?
Stephen Robertson
How to get accordance between MS Excel reference and OLE1.Class property -
Hallo my Dears!
In my VB6.0 application I need to get access to data saved in Excel file ”ExcDatTest.xls”.
At design and run times this file is seen in OLE control box.
But when trying to execute
Set AppExcelF1 = GetObject("ExcDatTst.xls"), – erises MsVB anouncemen
display excel sheet in vb -
I want to display an excel sheet in visual basic and I can display it right now using ole in the following manner:
OLE1.SourceDoc = "c:\my documents\expenses.xls"
OLE1.Action = 0
However, if the sheet is not the size of the ole container then it does not show everythin
Program runs to slow! Help -
I'm writing a program that stores the contents of a OLE object to a word document. Then sending this document to the printer as a postscript file. I've tried p_WrdApp.Documents.Add, then p_WrdApp.selection.TypeText = ole1.DataText but the contents on the file isn't what was in the OLE
How do i freeze panes using OLE -
Anyone
How do i freeze panes using OLE
I tried the following
OLE1.object.Sheets(1).Range("A1").Activate
OLE1.object.Sheets(1).ActiveWindow.FreezePanes = True
I get Activate Method Range of class failed
Run time Error no 1004
Regards
Sam F
how to play wav files from an OLE1 -
hi, i would like to know how to play .wav files from a OLE1
any help?
embed OLE object at run time -
I am trying to show an image (.tif) file in an OLE object when a related record is selected from a database table. The database table has a field called DOC_NUM which is the same as the file name of the .tif image. I can show the first such image, the Sourcedoc of the OLE object, when
OLE Problem.. -
Hi ppl,
I have an access table where I have an OLE type field. I want to send the OLE objects from the database directly( that is, without saving them into temporary files) to a mail item, that I create with Outlook object model, as attachments. I use a data control and bind an OLE
OLE Container -
Dear all,
I am trying to save a text file as an OLE object. I am using the OLE container control for this. My code is
OLE1.CreateEmbed("Name of text file")
F1=FreeFile
Open "New file" for Binary Access Write as F1
OLE1.SaveToFile (F1)
F1.Close
This code
OLE/Runtime Error -
I have a program that runs fine in the IDE but when I compile to an executable and try to run on the same machine, I get a run-time error. The error occurs when I make the following call:
Call OLE1.CreateEmbed(App.Path & "\Template.xls", "Excel.Sheet")
no one to help -
Hi ppl,
I have an access table where I have an OLE type field. I want to send the OLE objects from the database directly( that is, without saving them into temporary files) to a mail item, that I create with Outlook object model, as attachments. I use a data control and bind an OLE
ole1 - help -
How do you use this control.
Example using worpad etc.
Thanks.
"kill" OLE Object -
I have an OLE on my form and I wish to "kill" or unload it after opening a file in the OLE. I don't want to hide it, cos i intend to use only one OLE control to open any .doc/xls file.
I want to be able to unload the OLE when i right click it. However, the code below is no
embedding column of an excel worksheet in an OLE object -
Hello
Can you guys tell me if my understanding is correct on this piece of code
Code:
a = Str(12)
b = Right(a, 1)
link = "e:\DenseUrban.xls!" & "Link Budget 1" & "!R5C" & b & ":R32C"
crystal report problem regarding field objects. -
hi all,
i need help on how to set a field to expand vertically depending its contents. i set the cangrow property to true which fixes one of my problems. the only problem with this is if there is another field just below it, it overlaps the data of that field below it. is there ano
how do I manage this -
Hi,
I will give an example of my problem
Well, you have 2 tables, table1 and table2
in table1:
first field: autonumbering
second field: number (e.g. 1, 1, 2, 2, 2, 3, 4, 5, 5, 6, 7, 8, 8, 9, ...)
third field: text (in all records different)
in table2:
first field: auton
OLE Problem -
I want to know how to play with an OLE (or with any other thing) an AVI movie, BUT without showing the Play/pause button and the bar showing the time of the movie. I actually use the command: OLE1.DoVerb
------------------
--Alex
regexp help for a tag -
I'm having trouble formulating a regular expression in a search (in Word VBA) to look for either an opening tag or a closing tag. I can get it to work for one or other but not both.
I want it to be able to find the following tags in a document:
<field: 1>
<field: 2>
open excel file in OLE runtime. -
Private Sub Form_Load()
Dim xl As New Excel.Application
Dim xlsheet As Excel.Worksheet
Dim xlwbook As Excel.Workbook
Set xlwbook = xl.Workbooks.Open ("c:\book1,xls")
Set xlsheet = xlwbook.Sheets(1)
OLE1.CreateLink "c:\book1.xls", "Excel"
end sub
I did
Problem in Access DB with field -
Hi to all:
I had create a field in my table in an DB access...The field is a text field and i would like to insert in this field values like this:
21.1.503283320....but the field only accept this:
21,1,503283320...
Anyone know the way to do this?
Thanks
Can a Prod_ID field be use as barcode field -
I am having a problem using barcode,
1.do I have to create a field scpecially for barcode or just use the Prod_ID field to be a barcode field ?
2. Is there all scanner can read barcode forward and reverse barcode and what is the two ways dimentional description in a barcode mean
Not opening correct JPG File in OLE Container Control -
Hi i want open a jpg file in a OLE Container Control
it's opening the jpg file but not the correct every time it's opening the Same on the Double Click
the code is
Private Sub Form_Load()
Text1(0).Text = "D:\18.jpg"
Text1(1).Text = "D:\15.jpg"
Text1(2).T
BUG: Cannot edit Word document in OLE or WebBrowser control -
Please follow this link and have a look
They are suggesting following workaround.
Quote:
A workaround for this problem is to activate the Word document in its own Window, rather than using in-place activation. To accomplish this, set the MiscFlags property
Variant field in SQL Server 2000 -
I have a field of data type varchar which stores different types of data, e.g. integer, string, date and so on. The problem is that when i try to apply greater than or less than comparisons on the field, i dont get the desired results. That is understandable since the field is a charac