473,795 Members | 2,812 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Tree View File Browser

Lyn
What is the best way to import a picture (bmp format) via VBA from a Windows
file and embed it into a Bound Object Frame (and thence to an OLE Object in
a table)?

I found an MS knowledge base article (205635) on the subject, but it uses VB
(CreateEmbed method) rather than VBA. I can't find any similar method in
VBA.

A couple of related questions:

1) I understand that BMP is the only common picture format that can be
embedded in an mdb table. JPG can't be used (although I saw somewhere that
Access might convert JPG to BMP and store BOTH formats, inflating file
size).

2) I would like to display a gallery of pictures in a form (or subform).
Each record would comprise an autonum PK, the picture object and a text
caption. Only the picture and caption would display. I can easily envisage
displaying one picture and caption per line by using the Continuous Forms
mode. However, I would like to display the pictures horizontally as well as
vertically, say 2-4 per line depending on size. Can this be done?

As usual, thanks in advance for all suggestions and advice.

--
Cheers,
Lyn.
Nov 13 '05 #1
2 4883
Lyn
Sorry about the Subject. I started writing a post, then changed it to a
different topic and forgot to change the header.
Lyn.

--
Cheers,
Lyn.

"Lyn" <lh******@ihug. com.au> wrote in message
news:d4******** **@lust.ihug.co .nz...
What is the best way to import a picture (bmp format) via VBA from a
Windows file and embed it into a Bound Object Frame (and thence to an OLE
Object in a table)?

I found an MS knowledge base article (205635) on the subject, but it uses
VB (CreateEmbed method) rather than VBA. I can't find any similar method
in VBA.

A couple of related questions:

1) I understand that BMP is the only common picture format that can be
embedded in an mdb table. JPG can't be used (although I saw somewhere
that Access might convert JPG to BMP and store BOTH formats, inflating
file size).

2) I would like to display a gallery of pictures in a form (or subform).
Each record would comprise an autonum PK, the picture object and a text
caption. Only the picture and caption would display. I can easily
envisage displaying one picture and caption per line by using the
Continuous Forms mode. However, I would like to display the pictures
horizontally as well as vertically, say 2-4 per line depending on size.
Can this be done?

As usual, thanks in advance for all suggestions and advice.

--
Cheers,
Lyn.

Nov 13 '05 #2
Lyn,
I havent clue but to move the problem forward you might tell us what
you tried and what the result was.

Nov 13 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
3889
by: Gregor Horvath | last post by:
Hi, Before I reinvent the wheel I`d like to ask if someone has done this before since I did not find an advice at Google. The goal is to create a dynamic Tree View in HTML. Say I have a data strucure like this: structList =
0
2181
by: Tree menu using XML | last post by:
I have one XML file that has nodes and sub node and each and every node has the attribute call visible if its value is true then diplay this node else don't display thid node, but this condition i am able to check using xpath in asp.net 2.0 till MenuItem node. if i check visible attribute value till SubMenuLevel0 node then in tree it will not display the MenuItem Node at all Note: My tree Menu will start from MenuItem node and it will...
10
2532
by: dwok | last post by:
Does anyone know of a good article that discusses creating a "Tree View" control in ASP.NET? Or perhaps a Tree View Control that comes with source code? I have come across a lot of tree controls for ASP.NET however most of them are already compiled and don't come with source code. I am really just looking for an example on how to create my own Tree Control. Thanks a bunch.
3
2171
by: Brian Henry | last post by:
How would you go about doing this I have a tree view which where anything is a parent it is a folder (folder icon, and the tag for the object is a string that says "FOLDER:{name of folder here}") then each folder has items in it and possibly more folders. The root node also has items on it that are not folders... but default sorting sorts by name, so folders do not show up on top. pretty much anything that has children are to show on top...
5
11816
by: Pavan | last post by:
My goal is to accomplish the tooltip functionality for all the neodes in a tree view and i have the following three Events in my C# application. Name of my TreeView Control (AITreeView) 1) AITreeView_MouseDown(object sender, MouseEventArgs e) 2) AITreeView_MouseUp(AITreeView_MouseDown(object sender, MouseEventArgs e) 3) AITreeView_Click(AITreeView_MouseDown(object sender, MouseEventArgs e)
3
2787
by: Stefan Schwarzer | last post by:
Hello, from time to time I want to inspect the source code of projects on remote computers.(*) I've googled for one or two hours but didn't find anything helpful. :-/ I'm looking for something like IDLE's path browser - i. e. a tree view and file view side-by-side - but with the following differences: - doesn't need an X connection to the remote computer where the sources are
3
2377
by: gmail | last post by:
Hi Friends, Can any body suggest me on this. I am working on .NET 2005 Frame work 2.0 . I am facing problem using the tree stucture. I created the site map.Now i want use the site map in every page by keeping the tree structure in master page. Note: tree structure is created success fully. Now i want it display the output in the iframe which is besides the tree structure. That tree structure should display in every page with out hard...
1
2615
by: happy.john1234 | last post by:
Hi, i have got large xml file which i have to show in tree view windows form.I tried with loading all those data at once to tree view but it took a long time to render that tree view.Now i am looking to polpulate tree view selectively.Only populating those nodes that user expands it by reading xml file.Can any one plz help me with some suggestions or point out to some sample code(it would be better) on how can i accomplish this.Thank in...
1
2967
by: =?Utf-8?B?UHJhZGVlcCBFYXJsYQ==?= | last post by:
Hi I am having one windows application on my local machine and I want to display the folders(shared folders) of remote machine in tree view control of my win application. I haved added me as administartor in that remote machine. The following is my requirement. 1)The Application should show a tree view and a list view. 2) Tree view should show the folder structure and List view should list the
1
1842
by: vijay2008 | last post by:
I want to use theTree View control in ASP.NET 2005 ,but I don't know how I can use it to display the data resulting from a nested SQL query (which shows the results from multiple tables). How can I write that data in an XML file, and then how can I use that XML file with the Tree View control to display the data on the browser... Can any body help? Thanks in advance.... Vijay Singh
0
9522
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10443
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9044
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7543
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6783
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5437
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5565
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4113
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3728
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.