Uploading Image Name To Database
Jan 29, 2006
Hi
I am trying to simply upload an image to a image folder then take that image name and put it into a access database for retravel at a later date???
I can not work out why I am getting the following error and am going cross eyed with it ... can anyone see where I have gone wrong??
The error:
Persits.Upload.1 error '800a0018'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/UploadScript1.asp, line 26
The line of code:
Code:File.ToDatabase connection, SQLsmt
The whole code:
Code:<%dim MyConnSet Upload = Server.CreateObject("Persits.Upload")Upload.OverwriteFiles = False ' Generate unique names Upload.SetMaxSize 1048576 ' Truncate files above 1MB Upload.SaveVirtual "/images" ' Save to data directory Set File = Upload.Files("THEFILE") set connection=Server.CreateObject("ADODB.Connection") Connection.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:inetpubftprootlocalusericlay
emember ing.co.nzdb
emembering.mdb;" If Not File Is Nothing Then set connection=Server.CreateObject("ADODB.Connection") Connection.Open="PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:inetpubftprootlocalusericlay
emember ing.co.nzdb
emembering.mdb;" SQLStmt = "SELECT * FROM memorial WHERE remid = '"&setremid&"%'" SQLStmt = "INSERT INTO memorial.mainimage VALUES('"& thefile &"')" 'response.Write(SQLstmt) 'response.End File.ToDatabase connection, SQLsmt Response.Redirect ("tribute2.asp?REMID=") & intremID Else Response.Write "File not selected."End If%>
View Replies
ADVERTISEMENT
Jun 14, 2006
Hi there,
I have a problem and wander if anyone knows a solution?
I have a central database that runs on a stand alone machine (soon to run on a server with VPN connection), it has a form that enables us to report faults this works fine however i would like to be able to send the form out to our operators (all over the world) for them to fill in when needed. then what we would like is for them to send it back to usand then for us to upload it to the central database.
is this possible or is there any other option?
Thanx tom
View 1 Replies
View Related
Dec 14, 2012
Is there a tutorial on how to split a database so that it can be uploaded to a sharepoint site and one part of it allows updates and the other part only viewing?
View 3 Replies
View Related
Nov 13, 2004
I read a tutorial for displaying images from a database but ran into an error:
Within my table "teams" I have a field called 'timage' which contains the path to an image (/images/logo.jpg).
All I want to do is display that logo next to its corresponding team.
I thought I could do something like this:
<% dim pic
pic="SELECT timage FROM teams WHERE ID=1" %>
<IMG SRC="pic">
Now I am sure everyone will laugh becuase that is really wrong, but I am new and don't know the problem. The tutorial said I had to create a new .asp page to display the image, I didn' think that applied to what I am trying to do and tried to work around that. Please help me. thanks!
View 6 Replies
View Related
Apr 17, 2007
Hello Everyone,
I am in the final stages of creating a database for school coursework however I am having a few problems with a few features; any help would be much appreciated.
The database itself is meant to manage / keep are record of utility bills, it consists of two tables: Invoice and Company.
Problem 1.
In the Invoice table there are two fields called Date Due and Date Received the data type is Date/Time, how do I create a validation rule so that Date Due must be after 'Date Received' and vies versa?
Problem 2
I want each record in the database to store an image of a scanned invoice, and the main form called Transaction to show a preview image of the invoice. Much of the code I used is borrowed from the Access Northwind sample database, after some initial success I had to redesign the 'Transaction' form where the picture was shown and now I get the error message:
‘Run-time error 2135, this property is read-only and cannot be set’
I think I know what is causing the error but I have had no luck fixing it, if someone could help me that would be excellent.
Problem 3
Once I get the Transaction form to properly store and display a preview image of an invoice, I want to add a button that opens the image in an external window(ie MSPaint).
Currently my only success has been to add a button on the form that launches MSPaint (you have to manually open the image in MSPaint.)
Again, if someone could help me sort this out it would be excellent.
Sorry if my problems aren’t clear or well explained.
I have spent many hours looking for answers to my problems in forums, Access help files etc…
My computing tutor has little (no) experience with Access so he has been unable to help, hopefully the people on this forum have the expertise.
I am happy to email you my database if you need it to help me with problems 2&3.
Thanks in ALOT advance :)
-Sarge
View 2 Replies
View Related
Apr 17, 2007
Hello Everyone,
I am in the final stages of creating a database for school coursework however I am having a few problems with a few features; any help would be much appreciated.
The database itself is meant to manage / keep are record of utility bills, it consists of two tables: Invoice and Company.
Problem 1.
In the Invoice table there are two fields called Date Due and Date Received the data type is Date/Time, how do I create a validation rule so that Date Due must be after 'Date Received' and vies versa?
Problem 2
I want each record in the database to store an image of a scanned invoice, and the main form called Transaction to show a preview image of the invoice. Much of the code I used is borrowed from the Access Northwind sample database, after some initial success I had to redesign the 'Transaction' form where the picture was shown and now I get the error message:
‘Run-time error 2135, this property is read-only and cannot be set’
I think I know what is causing the error but I have had no luck fixing it, if someone could help me that would be excellent.
Problem 3
Once I get the Transaction form to properly store and display a preview image of an invoice, I want to add a button that opens the image in an external window(ie MSPaint).
Currently my only success has been to add a button on the form that launches MSPaint (you have to manually open the image in MSPaint.)
Again, if someone could help me sort this out it would be excellent.
Sorry if my problems aren’t clear or well explained.
I have spent many hours looking for answers to my problems in forums, Access help files etc…
My computing tutor has little (no) experience with Access so he has been unable to help, hopefully the people on this forum have the expertise.
I am happy to email you my database if you need it to help me with problems 2&3.
Thanks in ALOT advance
-Sarge
View 1 Replies
View Related
Jun 21, 2007
I have created my database - I now need to upload data from my old database.I have the old data in an excel spreadsheet and have edited the data so that it matches the coloums in the new database.I have one problem,I can upload all the person data into the person tableand I can upload all the organisation data in the organisation table(I'm assuming I just copy and paste it into the tables in the new database.)BUT and this is a big BUT.. the employment table is the linking table where you select an organisation from the drop downlist and you select a person from the person dropdown list, you add other details about emplyment and save the record.Does this mean I will have to do this manually, i.e create all the links manually??And is my cut and paste method above corect??Thanks is advanceEdit: I have attached the database to help you understand
View 1 Replies
View Related
Jul 2, 2007
You must have creted databases before which needed to be populated with dada from another source.I have a database with three tables.PeopleOrganisationsEmploymentI have two spreadsheets - one with organisations and one with people.Approximately 700 records for each - how will I upload these and more importantly will I have to manually make the links in the linking table(emplyment??)Please adviseThe database is attached to help
View 1 Replies
View Related
Jan 23, 2008
Hi there,
My user want to upload the PDF files to the access database using the access forms. First of all is it possible? If yes then how can i do this?
Thanks alot
Danny
View 3 Replies
View Related
Oct 25, 2006
Colm,
I can't seem to upload on this site anymore (I could do it a few days ago). Is there a problem with the uploading or am I doing something wrong? It looks like my uploading capabilities are off. Can I please have uploading capabilities?
I have some sample code I'd like to upload to answer a few threads.
View 4 Replies
View Related
May 6, 2015
I have to create a database with more than ten thousand records. There is a field on which image by clicking the image to be displayed with the default program based on the image on which you clicked.
Code:
Private Sub Campo1_Click()
Dim L As Long
L = ShellExecute(0, "Open", """" & "C:UsersNickDesktopDocumentiPicturesDioDiego.jpg" & """", vbNullString, vbNullString, 1)
End Sub
When onClick event happens on the image is displayed the same image regardless of the record on which you clicked. How do I change the code to open the image of the field that was clicked?
View 2 Replies
View Related
Dec 4, 2014
I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.
Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database
[Code] ....
This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.
Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")
When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.
View 8 Replies
View Related
Feb 21, 2008
I want to push a table from Access to a specific SQL Server database.
Is there an easy way to do this? I have an ODBC connection to the SQL Server Database and I can import tables from SS to Access... but is there a way to do the reverse?
Thanks much!
Gary
View 2 Replies
View Related
Oct 18, 2006
Hi there
im trying to build a database that stores a large number of photos and would like some suggestions on how i can upload multiple photos (20+) at one time without uploading each one individualy, preferably through a form.
To outline the problem, each member of the team has a camera that they take to jobs, when they return i want them to be able to open a new form, enter the job number (the primary key) onto the form and then somehow drag and drop the pictures from the camera onto the form to upload them.
Is this possible through Access? is this the best way of uploading multiple photos easily? and how do i build this?
Thanks in advance
MJ
View 2 Replies
View Related
Mar 22, 2013
I am currently working on a project for work on re-creating our database for our daily audits. We enter daily information on a form which feeds to the table and in return we run the queries to get the percentages and all that good information. I was asked to be able to load a picture of to a particular record. Can I do that from the form and that link to the table and to the queries that run?
View 2 Replies
View Related
Aug 6, 2015
I built a form that will allow each page header to take the info needed depending on who is using the data base. I seem to be having a problem having the Logo uploaded so that it can be used. Since I am new to Access, my only example would be like a web page. use the location of the picture in the code and it pulls it up for each page associated. I guess this would be 2 questions. How do I add to my form the upload of the graphics and how do I get the reports and forms to pull that picture into the header every time.
View 4 Replies
View Related
Jan 3, 2014
I have a large database of items we sell on Amazon, I am looking to automate the process of uploading the inventory.
I am uploading a tab delimeted text file using the following code,
With CreateObject("msxml2.xmlhttp")
.Open "POST", strURL, False
.setRequestHeader "Host:", "mws.amazonservices.co.uk"
.setRequestHeader "User-Agent:", "VBA"
.setRequestHeader "Content-MD5:", md5hdr2
.setRequestHeader "Content-Type:", "text"
.send c2a
Forms!Form1.Text3.value = .responseText
End With
I am confident I have the signature and the MD5 Header, but I cannot get the data into Amazon!
I keep getting a non-descript error "InputDataError".
When debugging my Play API, I was told that the "send" command was not uploading the file contents, it was uploading the filename! So c2a is a string variable that contains the tab delimited data. This works like a charm for Play, but no joy for Amazon.
View 4 Replies
View Related
Feb 3, 2014
I have an access database that has been written by someone else (I am a novice when comes to access!) and to which I have been asked to regularly upload data from excel.
There is a Macro written to load data from spreadsheets, and generally this works without problems. However there are a few spreadsheets which come up that result in a message box saying "Error in [name of spreadsheet] xls file in row 0" - I have checked for errors and null values in the spreadsheet but have seen this before as it generally tells me the error is in row 245 for example, but have never seen this error in row 0 before!
View 5 Replies
View Related
Feb 6, 2005
Hi all ,
Can anyone tell me about how to embedd image in image control using imagelist.
I added the 5 images in imagelist at design time and added the following code.
image.picture=imagelist.listimages(1).picture
but iam getting error.error no :2110,cannot open the file .
thank u,
Siva
View 3 Replies
View Related
Jun 16, 2006
Hi guys,
I'm in desperate need of help and want to know if it is possible to load an image on a form once a hyper link is created.
For example, I have a form with a hyper link to an image created, currently, when you click on the hyperlink, it opens the picture in the browser, can you change it so that it loads teh image embedded into the form instead of loading it into a browser?
If so, how?
Thanks
View 1 Replies
View Related
Jul 26, 2006
Hello:
I need to update a graphic on my form as part of the record information. Specifically, I have a graphic of the human body, and need the user to be able to mark the area where it hurts-scribble or put an "X" there-whatever. This modified graphic then needs to be stored somewhere and associated with that particular record.
Has anybody done this? Any suggested starting places?
Thanks,
Matt
:confused:
View 1 Replies
View Related
Jul 2, 2007
How can I get an animated image on my switchboard? I found an animated image on the internet and I copied it. I went into design view and pasted it onto the switchboard then I went back to form view. I can see the image but it is not animated. How do I animate it?
View 1 Replies
View Related
Aug 22, 2007
Hi
I have a table with this fildes:
name - family - PathImage
I have 400 records.
and I have 400 pictures for 400 person to a folder
and I want fill them, but is an easy methode for finding and filling pathImage for each person? and insert it to table cell?
I want insert Name of image file to PathImage filde.
Is there any thing such browse bottom to find file name?
Thank for your lead
View 5 Replies
View Related
Feb 3, 2005
I am going to show some images
I have stored the links of photo in a table
how can I show the different pictures in a form at the same time?
View 1 Replies
View Related
Apr 14, 2005
i have a cars database
because it is difficult to add 4000 pictures i want to know
if is it possible to add a field that opens an ie page in google images to show results of images for that car?
ex :
model : Ferrari
foto link :http://images.google.com.gr/images?hl=el&lr=&q=Ferrari&btnG=%CE%91%CE%BD%CE%B1%CE%B6%CE%AE%CF%84%CE%B7%CF %83%CE%B7
View 6 Replies
View Related
Apr 27, 2005
Hi
i have a form, with a command button, which when you press it automatically sends an e-mail
At the moment, that e-mail is just text. What I want is to insert the company image in the e-mail?
Have tried doing this but keep getting error message (put image on the form and then referenced Me.logo behind the code)
Anyone know if this is possible
Chris
View 3 Replies
View Related