In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?
3  4339 
This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use OLE
photos in your tables - just use the path to the image as a text field, then
when you want to view the photo, update an image control's picture property
(initially set to 'none'):
Me.imgPhoto.Pic ture = "\\server\img1. jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermai l.co.il> wrote in message
news:87******** *************** ***@posting.goo gle.com... In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?
Thanks, but this solution is not suitable for me. I must use OLE on
the table and all images should be stored on this table as embedded
and there is no way to store them as linked (company policy)(if there
was such a possibility than your solution was suitable).
Thanks again
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message news:<Rb******* *************@c omcast.com>... This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use OLE
photos in your tables - just use the path to the image as a text field, then
when you want to view the photo, update an image control's picture property
(initially set to 'none'):
Me.imgPhoto.Pic ture = "\\server\img1. jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermai l.co.il> wrote in message
news:87******** *************** ***@posting.goo gle.com... In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?
Do you have an error-trap around the statement? Usually the Access error
messages are at least somewhat more helpful then a run-time error. What is
the line of code and the error message generated (with error-trapping)?
Just an off-the-cuff guess, though, but this sounds like the kind of error
you get when you accidentally use an Access reserved-word as a variable.
Darryl Kerkeslager
"Katy" <ka***@intermai l.co.il> wrote in message
news:87******** *************** ***@posting.goo gle.com... Thanks, but this solution is not suitable for me. I must use OLE on
the table and all images should be stored on this table as embedded
and there is no way to store them as linked (company policy)(if there
was such a possibility than your solution was suitable).
Thanks again
"Darryl Kerkeslager" <Ke*********@co mcast.net> wrote in message
news:<Rb******* *************@c omcast.com>... This may not be exactly the answer you asked for, but I would avoid the
whole issue by doing a slight re-design. Common wisdom says to not use
OLE photos in your tables - just use the path to the image as a text field,
then when you want to view the photo, update an image control's picture
property (initially set to 'none'):
Me.imgPhoto.Pic ture = "\\server\img1. jpg"
Darryl Kerkeslager
PS: search Google: photo access bloat
for reasons why
"Katy" <ka***@intermai l.co.il> wrote in message
news:87******** *************** ***@posting.goo gle.com... In my project I have two tables with the same structure and second
table's data is a part of the first one. (one is the main and the
second is used to keep the results of filters performed on the first
one while doing search command. Each table has a lot of fields while
one of them is OLE Object and used to keep the picture object
(embedded not linked). By updating this OLE Object on the "filtered"
table, appropriate record on the main table should be updated with
this value to. I've tried to run SQL command UPDATE, but by executing
this line, MS Access get error and should be closed by Operating
System.
Does anybody has any idea?
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: njp |
last post by:
BlankHi,
How do I create a tightly coupled Object 1 such that when I update it in one collection, it is simultaneously and automatically updated in other collections? The collections are defined at the module level for the entire project to access as well as collections defined within different objects. Currently, I'm updating Object 1 manually in all the different collections but there surely must be a better way.
Thanks!
NJ
|
by: Jim Hammond |
last post by:
I am passing the whole object instead or parameters in my select and update
methods.
I can get the updated object if I set UpdateMethod, let ASP.NET autogenerate
an update button, and then press update after making changes, but I don't
want that update button.
How can I get the updated object when the user presses one of my other
action buttons?
|
by: Mark R. Dawson |
last post by:
Hi all,
I may be missing something with how databinding works but I have bound a
datasource to a control and everything is great, the control updates to
reflect the state of my datasource when I update the datasource - awesome,
but I have an issue with updating from a different thread.
Here is my datasource, a person class that raises the PropertyChanged event:
class Person : INotifyPropertyChanged
{
|
by: Michael Kellogg |
last post by:
I have a problem wherein a query that updates a GridView doesn't seem to
really stay in sync with a label I have above the GridView.
I have a GridView object that I'm updating with information whenever my
user enters a job number into a textbox and hits a button. There is a
SQLDataSource object on the page that does the retrieval of the data, and
the job number parameter for its query is bound to the textbox "Text"
value. In the button...
|
by: batista |
last post by:
Hello all,
I have a third praty grid control...named C1grid. Im using it in one of
my apps..
Now, I have bind this grid to a custom dataset class named
"DataViewEx".
The code of the class is below...
Now what happens is that im updating this dataviewex class from a
separate thread.....
| | |
by: Brad Coble |
last post by:
I have an activex control that is used in an old app originally written in
VB6. It works good. I updated the VB6 app to VB.net. Got it working, sort
of.
The activex control uses withevents and fires an event when there is
incoming message traffic. I need to capture that data. The event fires
sometimes. I know it should be firing more often because i run the vb6 app
and watch the traffic.
When I look at the debuger output I see a lot...
|
by: mbenedict |
last post by:
I am rather new at this code and am attempting to modify existing code to use clob datatypes, which I have never used before. The database tables have been set up for clob data. When trying to use dbms_lob.writeappend, I am getting the following error..Command text was not set for the command object.
I've researched this in the net as much as I could, but I'm lost in what I am doing wrong. Can you help please?
Here is my code...
...
|
by: steve |
last post by:
I have been fighting with trying to update a GridView for a while. I
don't want to use the "built-in" way to do it because I am using
business layer methods for updating and deleteing and I don't want to
have my parameter names in those methods have to be
"original_Parametername" or even if I change the
OldValuesParameterFormatString to get rid of the "original" I would
still have just "Parametername". I think most people user parameters...
|
by: jonbartlam |
last post by:
Hi There
I'm not sure what exactly is going wrong here. I'm writing an application that retreives a table from a database (tbl_internalfaults) and updates it. (Actually, just the status column will need updating with 'CLOSED' where necessary.)
I have been trying to use the OLEDB command builder to build the statement to update the database however it is returning an error whenever I try to do this.
I already have a dataset full of data, 1...
|
by: abdulhadi |
last post by:
I have a table contains the results of matches
and table contains the statistics
how could I fill the statistics table by getting information from the result table
the statistics table columns are :
-club
-points
-sumgoals
and the results table columns are :
-club1
-goals1
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
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,...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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();...
|
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
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
