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 RepliesHi 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
Where I can get some better pictures for my access database. The standard ones are really not all that great. I am looking for a stock pile of pics that I can place in my files so that I can draw upon them whenever I am designing my database.
I just havent had much luck designing buttons in GIMP.
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!
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 RelatedI 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
I'm trying to add pictures to a form (not in the database, just a graphic on the form).
In 2010 there is an "insert image" button. Is there one in 2007 and if not how would I do that?
Can I add a picture as a background for a form, rather than just a colour? I can't see how, but I'm sure I've seen others do it.
NB: I have developed my database in Access 2003, to ensure that it is usable by all computers networked on my system.
Also, would this dramatically alter the size of the database?
I am using Access 2003 in a simple database and want to add digital pictures of each item in my database.
Before trying to enhance the database with pictures; the various fields are filled with either descriptive text or numbers. The size of the mdb database file is 464k.
I recently wanted to add a picture of each database entry. After adding a picture that is only 300k in size the mdb file increase to 18MD. Then after adding another picture also of 300k bytes my database grew to 25MB.
In the drop down menus Under Tools - Database Utilities - I ran the Compact & Repair Database. This did not reduce the size.
In the database Form I am using a Bound Object Frame to hold the picture and yes I am not linking the picture I am including it in the database. But, would only expect it to increase the database size by slightly more than the picture size.
I should also point out that the only way I have found to get the picture to be visible (not just an icon of the type of picture file) is to right click on the Bound Object Frame scroll down and choose Insert Object. Click on Create New and select Adobe Photoshop Image. This open adobe photoshop I make sure the picture properties are creating a picture of 300k.
So my question(s) is again. Why is my database increasing in size so rapidly? Is there a better to insert picture into a database?
Regards, Roy (HerlocherR@aol.com)
I made nice little icons for my buttons, But when i transferred the app from laptop to server and run it on desktop comp icons get resized.
Guess it has to do with desktop resolution. How can i avoid this?
I tried with adding commands to playin pictures, but there are problems with focus, so that is not the best solution.
I have Access 2003 and have trying for some time to insert pictures. I have followed the instructions step by step as outlined in the BIBLE and nothing. I recently acquired a new computer and the problems still persists. Can anyone help.
View 8 Replies View RelatedI know its possible with the right code because I put animations into my VB assignment last year. I just need to know how to do those group things where several objects of the same type (like twelve picture frames) have the same name and are told apart by a number in brackets. eg. imgThewave(1).
Thanks
we are traders of metal scrap. we have lots of material pictures on the basis of container numbers. We want make a user form where on entering the container number the relevant picture will be shown.
View 2 Replies View RelatedHello. ( First post)
I had scanned these forums, but i didn't see what I was looking for. I'm new to access, my intern ship short of threw me into it. eh' but that is not the point.
I have to build a circulation spreadsheet, and my bosses would like there to be pictures for each item. Any ideas on how I could do that? Thanks for your time.
I am using access 2013 to make a PowerPoint presentation based on the data in a query. I know how to do that much using VBA but I am also trying to make a slide with a picture on it from a saved location.
Dim db As Database, rs As Recordset
Dim ppObj As PowerPoint.Application
Dim ppPres As PowerPoint.Presentation
On Error GoTo err_cmdOLEPowerPoint
[code]....
At the moment I am not worrying about adding the data as I know how to do this and had it working before - its just adding the picture to the slide.
focking pissed off. i want to add an image to a some forms, the database is all working and that. but when i put a picture in in the design view and then go to view it the whole thing crashs. i nearly lost the whole data base from putting one on the home page, thank fock i had a back up and now ionly have to redo one form as the other one wont open anymore it will just crash every time i try to open it. i have no idea whats going on, i have other images that i put on it before, but i cant put any on now. anyone every encounted this and how do i over come it!
View 2 Replies View RelatedI have a report that links to a picture. It displayed great in earlier versions of access, but when I switched to 2007, the pictures are displayed but they look like they are posterized. They print just fine. I use an image frame, zoom size mode and centered. They are fairly substantial jpegs (2 megs), but regardless, it is the change to Access 2007 that caused the problem.
View 10 Replies View RelatedHi,
My database consists of some personal data and a photo of each person.
I am trying to include these photos when I browse the database via ADP.
I have found instructions how to do so at Microsoft website (article ID: 285820)
Link for it: http://support.microsoft.com/?kbid=285820
The problem is I cannot make it !!!!!!!!
Where exactly should I paste the VBscript in the page code to execute displaying of the photos???????
I am happy to send you the head portion of my page code if anybody knows where to paste it.....
Please help,
Jimmy
I have a access DB for my employees with pictures. The main form displays their info and a picture as I scroll page to page. But I also have contact report that will show all info and picture. I am having difficulties linking the pictures from a seperate folder on my server.
View 4 Replies View RelatedI have successfully used the recommended way to display images from a folder in a form as posted on the microsoft website.
http://support.microsoft.com/kb/210100/
These instructions were for Access 2000. I noticed that there are seperate instructions for doing this using Access 2003.:
http://support.microsoft.com/kb/285820/
My questions are:
1. If multiple users access this database using different versions of Access (2000 and 2003) will it not work for some?
2. do i have to modify code if i update to 2003?
Thanks for youir feedback!
~Bruce
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 RelatedYou 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 RelatedHi 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
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.
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%>
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