I'm not brilliant at using MS Access - can't use the VBA codes or anything like that.
basically, I want to set up a database of photogrpahs where you store thephotograph in Access, and then run a query to search for specific photos, which brings up a form showing the picture.
I seem to be OK at doing all of this so far except I can't get the photo to appear in the form - it just displays a link which you double click on to get to the photo.
I've tried to look up how to sort this on the web but don't understand the way people speak about access :confused:
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?
I am looking for a way to export my database and all linked files into one folder with automatic updated links. I would like to transfer the complete project to an other computer. Is this possible? How to do? Thank you.
What's in the fields is irrelevant but i'd like to change that to ***** the original value should stay there but when you view the record it should only give *****
for example
field value : HELLO when viewed: *******
Does anyone know how this could be done I ones knew how it was done but can't find it anymore
I have completed a db and am satisfied with the structure and forms. The object window is hidden when the database is opened, and the main entry form automatically opens for the user. This db will be in a network folder and several users will have access to it. I want people to be able to enter data and run reports, but not make any changes to the database itself, or accidentally delete the database file or some other change to the structure. What is the proper way to set up the folder rights and anything else associated with the previous question?
I'm getting an error (SQL command not properly ended) but main thing is, I can't get it to recognize the ms access db. In a nutshell...I want to query the oracle db for a number and count, then scan a number into msaccess and have it 'find' the matching number in oracle and return the count only to ms access. More comments below between the code and here are table names for both oracle and access: ORACLE: Table name is: batch_status bs Field names are: batch_num and Batch size
MS ACCESS: Table name is tblbatchstatus Field names are: batchnum and idcount
CODE in PASSTHROUGH QUERY: select batch_num,BATCH_SIZE from batch_status bs (this works and selects all batch numbers and sizes from oracle) (If I say 'where batch_num = 60024 -----this works also....) However...when I add the below part...I get errors...it can't seem to match to access database....
SELECT tblbatchstatus.Batchnum, tblbatchstatus.Idcount FROM tblbatchstatus;
where batch_num = tblbatchstatus.batchnum
And I want to just say: where batch_num = <<<scanned batch number>>> and return the id count.
I am a first time user of access. i am trying to create an Data Access Page which will list all entries in a table and then allow me to add, change and delete them. I have created the page using the wizard but it will not let me add, delete or update. i view all the entries at one time but that is all. the navigation toolbar shows up at the bottom but it is grayed out. any ideas on what i may be doing wrong?
I have a two level security system to protect my date. The first uses the MS Access security, the second is a simple login system wherby a user enters their name and personal password to gain a customised view of the data eg if the user is me, I can see all tool bars, other users cannot. What I would like to be able to do is write a query wherby I can use the users login details to diplay only their data. An example of the script I built is as follows
'IF USERNAME AND PASSWORDS CORRECT THEN LOGIN TO THE MAIN SWITCHBOARD
If Me.qpwd.Value = DLookup("PWD", "AUTHORISED", "USERID = '" & Me.quserid.Value & " '") Or UCase$(Me.qpwd.Value) = "abcd" Then DoCmd.Close DoCmd.OpenForm "Course Booking System" Else MsgBox "Invalid Password" End If
Is there a way of including a select criteria like the following
SELECT USERID, DETAIL FROM COURSE WHERE USERID="Me.qpwd.Value"
I have tried several differnet versions for this syntax without success!
Hi, Im looking to place photos into a form. The situation being a members data base and for every member record there is a mug shot to go with there information. Is it possible to store photos in this way so it is shown on the form as your browsing though them??
I've linked about 10 photos in my database and the size of it has swelled to alarming proportions. I linked rather than embed to keep the size down but it has still grown quite sizeably.
any ideas as to how I can overcome this kind of growth??
I am a newbie in db creation..what I would like to accompish is this
I frontpage I have created a web site within the web I would liek to disply images similar to the built in display result in FP but would rather havea DB either imbedded photos or external
photo page
table 2 cells cell 1 large photo (created a iframe) cell 2 table 2 cell x 6 cell (total of 12 thumbs
easiest enough to place the thumnails into the second column and edit the image to point to the large image and direct the large image to display in T1 (iframe) works like a charm
however with over 100 images I need an easier way to auto add the thumbnails and large photo to each page
my question
how do I create a DB that either contails both thum and image or asscess from folder...and ultimaley display into front page as per above
yes I ahve seach high and wide which is why I am here..seeing if any of you Access gurus can assist me
I've created a database where a query who'se result is loaded on a form uses following function --
DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date])
I've notice that 2 ppl get an error message when they try to open database, with thatt function coming on an error message Does this mean they have older access version ? How can I tell ? Any advise on what to do ?
So here's my problem. I'm trying to update a listbox in excel with values that are being pushed in a table in access. The problem is that there are repeated values in the column in access, but I only want to show each value once, regardless of how many times it appears in the table. I would give a code sample but I'm having trouble getting started...
Hi, I've got some id card templates in publisher than i want to merge in access. i can merge the text details into access but i dont know how to link the photos. should i store the file path of the image in the database or should i embed the file.
would this work with publisher or do i need to use some code?
any help on this would be appriciated as i have no experience with pictures in access.
I've got a database that tracks name/address/phone, etc for a large group of people. I've recently added the ability to include a person's photo on the forms and reports. I've done that by saving the photos with the naming convention of [firstname]_[lastname].jpg and then using VBA, the database checks to see if there is a file with the corresponding name of the record and displays the picture if so.
It works very well, but I can see where I would have some problems in the future. For example, if someone gets married and changes their name, the corresponding photo must also be renamed to display properly. And if there are any misspellings, that becomes a problem. Also, if James decides he wants to go by Jim, the photo would not be displayed, either.
I'm wondering if anyone has any other ideas on how I might accomplish my goal. I know I could name the photo based on the record ID, but that's not a good option, since I'll be handling the photos, while someone else will be inputting the contact details. So I won't know the recordID easily.
Is there some way to have another field in each record that points to the corresponding photo? Then if James goes by Jim, his first name can be changed, but the corresponding picture name could remain the same.
Is there some great idea that I'm missing that would make this process much simpler and scalable? Or do I just have to deal with the maintenance issues?
I am wondering if it is possible to embed all of the photos that I have into my photo table automatically. I have the table set up with all of the data that needs to be there but I have over 1500 photos that need to be embedded and wanted to save myself some time and automate the process somehow. I already know that embedding these photos is going to make my database huge but that isn't an issue for this particular project.
As far as I can tell from this forum, the help and the Northwind database this isn't possible without manually going through every photo but I am pretty new to Access so thought I would throw the question out there.
I have tried to find information on how to do this but everything I try fails.
I have a form on which I want to display JPG photos which are stored in a folder called FCP. The path to each photo is stored in the database table. Each record will have one photo only and the path looks something like this:
C:Documents and SettingsBKALProjectLRFCP4.jpg
Can someone tell me exactly how to design a form picture field that will display the relevant photo?
I have created a profiling database for my school. Each student can access their own form via the school's admission number - which I use as the primary key for most of the tables on the form. One section of the form shows a photo of the student. I take this photo from the school's SIMS photo file which had all the children's photos. Each photo in the file uses the school's admission number as its filename (for example 000358.jpg ).
I want to update the photos in my table by using a macro or piece of CBA code. Unfortunately, I don't know how to do this. When I set the database up I did each photo one at a time, so it took several hours.
I have created a tabel in access 2003 which has information about employees and i have to put even their photos as records so i can see them in a report that i have created too.
I have created a DB to store my students records, eg: Student Number, English Name, Chinese Name, Birthdate, Class Number, Age, and exam scores, I also have a photo frame to display the students photo.
In the data sheet I have an ole object field where I add the photos, the thing is it means I need to manually add this to the data sheet, whereas I can add all the other details directly from the form "Add New Record" and also search, delete or edit all from the form.
I have searched and searched but I cannot find any info that accurately explains how I may add the photos to the c where I have placed a button "Add Photo". I assume I need to create a macro and assign it to the button (on click) then this would need to open a search file location box where I can find the photo and select it to be added to the file.
The point is I wish to be able to do all the adding, deleting and editing from within the form and not have to enter into the data sheet at all.
