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 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 RelatedWhat is wrong with this linked pictures in my database?
I have made OLE field in a table and I want to insert pictures in that
field with option "linked". But pictures are not exactly linked. First, they take
a lot of space in a database, almost as inserted pictures (If inserted picture takes 30Mb than linked picture takes 20Mb). I thought it is only going to save a link (target location) to a file. Also, when I insert link to a picture ina OLE field and delete this picture in windows - I can still see this picture on a form in my application. So, is it linked or inserted (only difference is that I can't edit linked picture if it's deleted in windows but I can see picture in a form).
How can I insert only link to a picture in my database so I can see pictures in forms and reports and pictures stays only in windows and takes a minimum space in my database (only for a target informations)???
Thanks!
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.
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
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 plan on using Excel as the front-end and Access as the back-end only. (all queries and forms are in Excel). A single Access database will be queried from multiple Excel files that will be located on the share drive (Linux server). Access tables contain memo, text and number fields. Data will be sent to Access tables and records will be appended/deleted; all via Excel.
There will be multiple users interacting with a single Access database via multiple Excel files located on the shared drive. Users will be interacting from different workstations with Windows 7, all have Access 2010 and Excel 2010 installed.
This process works for me from my workstation but I am not sure what will happen when other 4 people will be sending/appending/deleting records to the same Database? How do I make this work? What settings do I need to check in Access to make this possible?
I am about to allow users to access a database I redesigned for others to use.I am trying to save it as an ACCDE so they can't mess it up. The database is very very simple.6 tables each with only 4 fields or less... and none are related to one another
7 forms.
1 report.
0 queries... it's just a SKU generator.
When I attempt to save as ACCDE I get an error that reads."Microsoft Access was unable to create the .accde, .mde, or .ade file.This error is usually associated with compiling a large database into an MDE file.* Because of the method used to compile the database, a considerable number of TableID references are created for each table.* The Access database engine can only create a maximum of 2048 open TableIDs at one time.* Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Access database engine uses during the process of compiling a database as an MDE.* However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used."
I got an access database but how do i make it to be able to publish to web and allow phone browser to access and enter data as well?
View 1 Replies View RelatedI am new to access, and am having trouble getting a correct export of XML out of an access database. I am not sure if it is a schema setup or something else.
I have attached a file that shows the format that is coming from access (Bad Format) and the format I am needing (Correct Format).
Access 2013 ... Is it possible to compact a database to a new name?
(In previous incarnations of Access I regularly 'compacted and repaired' databases to USB sticks rather than simply copy the file in the (mistaken??) belief that this was a more reliable approach)...
I can't see where to do this in Access 2013!
I have created a db for a nonprofit counseling org. I had created the first half, mostly administrative tasks, called Phase1, and put the BE on a network drive and the FE on multiple users. Now in developing the clinical portion, Phase2, I linked to four of the tables in Phase1 BE file.
Now I tried to split Phase2 the same way as Phase1 and got an error "Subscript out of Range". I think because of already having some external links in it. I checked for the file and Access actually created the BE file for the new phase2, all of the tables are in it minus the four I was linking to. But, access didn't create a FE file. The original still has all of the objects, tables and forms etc. My question is; can I link to the tables in the new BE file even though those tables still exist in the original file?
I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??
View 7 Replies View RelatedIs it possible for a website to pull data from an Access database?
We have all our department's policies in a MS Access database on our server. Some of these policies need to be made available to the public on our website. I'm wondering if there's a way for the website to pull directly from the database rather than having to manually upload the policies to the site every time they change (annually, semi-annually).