On a continous form I have a button with the on click event tied to VB. The code is this:
DoCmd.RunSQL "UPDATE [Fleet Assignment], fromPDA SET [Fleet Assignment].sup = 'C:\Program Files\PTS\TracerPlus 2.2\Data\YVTS\FromPDA\Signatures' & [frompda].[sup]WHERE ((([Fleet Assignment].g481_dt)=[frompda].[date]) AND (([Fleet Assignment].starnum)=[fromPDA].[AgentStar]) AND (([Fleet Assignment].fleetnumber)=[fromPDA].[VehicleNumber]));"
It seems to work. In the table though, all I get is the words:
Long Binary Data
On the form, I don't see anything. If I go to windows explorer and find the file then copy/paste the file into the table in datasheet view, I can see the image fine. The table says bmp image.
What is the code to copy/paste or do whatever the h*ll I am trying to do. I am quite familiar with VB and Access but I have never worked with images before. Mr. Alan Warren says to use BLOB's, the problem is that it requires the Microsoft ActiveX Objects Library 2.6 and above. All of the terminals only have 2.5 and it is impossible to upgrade all of them. Does anybody have any idea at all? Thanks for any help.
DoCmd.RunSQL "UPDATE [Fleet Assignment], fromPDA SET [Fleet Assignment].sup = 'C:\Program Files\PTS\TracerPlus 2.2\Data\YVTS\FromPDA\Signatures' & [frompda].[sup]WHERE ((([Fleet Assignment].g481_dt)=[frompda].[date]) AND (([Fleet Assignment].starnum)=[fromPDA].[AgentStar]) AND (([Fleet Assignment].fleetnumber)=[fromPDA].[VehicleNumber]));"
It seems to work. In the table though, all I get is the words:
Long Binary Data
On the form, I don't see anything. If I go to windows explorer and find the file then copy/paste the file into the table in datasheet view, I can see the image fine. The table says bmp image.
What is the code to copy/paste or do whatever the h*ll I am trying to do. I am quite familiar with VB and Access but I have never worked with images before. Mr. Alan Warren says to use BLOB's, the problem is that it requires the Microsoft ActiveX Objects Library 2.6 and above. All of the terminals only have 2.5 and it is impossible to upgrade all of them. Does anybody have any idea at all? Thanks for any help.
