Adding Images To Records

Jul 31, 2006

Hi there,

I got myself pretty much backed into a corner here. I am trying to add images to records. For example, in my database there will be certificates scanned and put on each specific record. I have been searching high and low and found that the OLE object tool will allow me to do this. However, the only method I've found was to right click right in the table and selecting add object. I'm trying to find a more userfriendly method. I was hoping someone can point me in the right direction.

Thanks in advance!

View Replies

Adding Images Into Tables/Records

Jun 26, 2006

Hi there,

I'm trying to add an image into a table. I know I can do it manually by creating an OLE Object and so forth. I am actually trying to get the user to enter in the path of the image and add it into the record/table.

Basically this is for a database that will hold a scanned image of a certificate associated with each person entered into the database. Anyone have any suggestions?

Thanks

View 2 Replies View Related

Adding Images To Database

Sep 6, 2007

Hello

First let me apologize if I am being stupid, quite new to Access. I am trying to create a database with some pictures in it; I want to design a form that changes the image with each record, (Its for work they want a database of our employees info with a photo of each employee) reading though the help file it seams I need to add a bound image control, I have tried 2 different ways and am still getting the same problem, the first way I tried was to create a text field with the address off the photos (there are .jpg�s) and then add a bound image control on the form and link it to the field. Problem is this just displays the name of the file not the picture (e.g. as you go though the records it shows Mark.jpg, Simon,jpg, Louise.jpg�.) I then tried to add a OLE field and add the files that way, if I click on add from file when creating the object I get the same problem just displays the file name, If I click create new bitmap image it works and displays the picture, the problem is the data base file then becomes huge (it was 45 meg with 2 photos, I need to add about 150 in total!. Am I being totaly dumb, is there a way of getting Access to display Jpg�s and ideally have them linked to instead of embedded to keep the size of the database down.

Sorry for rambling! (oh yeh and I am using Access 2003)

Thanks in advance!

Matt

View 2 Replies View Related

Adding Images- Strange Problem

Jun 26, 2005

Hello,
I am trying to add a normal JPEG or JPG image to an Access 2003 form through the "Image" control.
The problem is that when I browse for images , it does not show any JPEG or JPG images, but only BMP and images of other 3-4 formats - The JPEG format doesn't exist there. When I try to add a JPEG through "all-files" it gives me an error message - "does not support this format".
There is not problem viewing JPEG images on WinWord or other programs.

Has anyone heard of such a problem and its solution?

Thank you
Gabi

View 1 Replies View Related

Reports :: Adding Images To A Report - Only File Path Displaying

Oct 15, 2014

I have to add 2 company logos and a phone graphic to a report.

I can only seem to add one logo and if i try to copy and paste a graphic it just displays the file path.

View 3 Replies View Related

Reports :: How To Print Images Saved In Database Records

Apr 14, 2014

I have created a database which has 2 images for record embedded, the method I have use for this is to link the address were the image is in order to avoid that the database gets slow, the images are displayed on the form but I cant find the way how to embed such images in a report neither how to print them with a button used for such purpose.

View 3 Replies View Related

Adding Records

Oct 10, 2005

This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks

View 2 Replies View Related

Adding New Records

Oct 28, 2005

I have am building a program that requires a staff person to enter a daily activity report on employee activity. It's initiated by adding a new record
that will allow the selection of an employees name and ID number from a drop box into respective first name, last name and ID fields. The staff person would then go on to complete the daily report by adding information in several other fields.
My form is based on a relational query built from two tables; tblClient and tbldailyreport.

Any help would be appreciated.

Regards

Timber

View 1 Replies View Related

Adding New Records

Feb 22, 2005

I have set up a form which is linked to a table. When the form is opened from a menu it goes straight into a new record which is what I want.

However by using the wheel on the mouse the user is able to scroll through all records in the table.

All I want the user to do is simply add a new record and not be able to amend the old records (this is done elsewhere in the database)

how do I do this?

cheers

View 2 Replies View Related

Adding New Records

May 5, 2005

Hi,
I am having a problem with a form in that I can no longer add new records to it!
The data comes from a query formed of 2 tables, linked by a 1-many relationship. I can add records to both the underlying tables and the query with no problem, but in the form I can't. I get no error message when I try to add a new record, just the windows error bleep. Properties for the form are exactly as they were last time it worked properly.
I have made changes to the database since - but not to this form specifically.
Any ideas of what I might have inadvertently done?
Many thanks

View 1 Replies View Related

Adding New Records

May 6, 2005

View 1 Replies View Related

Adding Records To Table

Feb 9, 2005

Hope someone can help!
I was wondering if is possible to add a series of records that are in serquence to a table by just entering the first and last numbers. For example a string of numbers starting at TP11000 and ending at TP11100, the prefix TP doesn't change. Currently I have to enter every one manually, so any help would be much appreciated!

View 4 Replies View Related

Adding Old Records To New Database

Jun 6, 2007

Hi there,

I have a bit of a dilemma here.

I have an old database, which is very comprehensive, filled with client names, addresses, and other information.

I have been given a new database, which is more relational and effectient, which splits the client addresses into a seperate table.

I need to add the old data to the new database - so is there a way of doing this whilst maintaining the links between the old addresses and the rest of the old data? What I don't want to have to do is end up going through 3000+ entries sorting out what new CompanyID I should assign...

Any thoughts?

Cheers

Hob

View 2 Replies View Related

Adding Same Data In Different Records

Sep 10, 2007

Dear All

I want a help in adding data to a table w/o writing the whole word.

e.g. if a word like " Medical " need to be repeated in many records, how can i add it w/ just typing the letter "M" and the whole word will show up? like what�s happening in ms excel.

Please help me :)

View 2 Replies View Related

Need Help With Adding Multiple Records

Jul 5, 2005

I believe this can be done with a query, but am having problems with it.

What i have is a db with a table for employee another table for training items and a third table to tie them both together. These employees are divided into several "teams" (team 1, team 2 etc ...) The training items are assigned to some or all of the teams. ( i know that this is a many to many relationship and i believe that is where i get confused ) Now the problem. What i would like to do is have a form that will allow the user to assign a new training item to teams 4, 5 and 6 and have access automatically create a record in the table. Now that the 20 or so employees that are assigned these training items will have a record that the user can simply fill in a date when the training has been completed by the employee.

I believe what i am looking for is an append query. Is that right?? Have been playing with this one for awhile and have no luck so i would appreciate any help i can get on this one

thanks again

Ricky

View 5 Replies View Related

Adding Records With Realtions DB's...

Mar 7, 2005

OK, this is the database I have so far. When a new customer is added, the user can enter up to 5 items in the tbldesweight table.

I currently have tblorder as a subform in a simple form for adding customer details. When a new record is added for the customer, it adds the same custid value into the tblorder table, but the orderid (which is set as an autonumber) dosen't get added, thus stopping the tblcust relating to data in the tbldesweight table.

Any pointers on how to get this to work?

Lewis :D

View 3 Replies View Related

Automated Adding Of Records

Apr 6, 2005

Hi All. I hope this is in the right forum.
This is an example of the sort of thing that I am trying to acheive.

I am building a database to connect rooms. i.e (Building1, Floor1, Room1) connected to (Building2, Floor2, Room2)

I have 2 forms (frmBuilding) to add building names and (frmFloor) to add floor numbers.
On the other form (frmConnect) , I have the current location (Building and Floor) and I have a subform in datasheet view. I have 2 combo box's (both with a query as the source), one to pick a building I added in frm building, and the other to pick a floor I added in frmfloor. I also have a text box, where I add the room number.

This is would like to do if possible.

Try and automate the adding of records, so, for example, if I am adding records of (Building1, Floor1, Room1), (Building1, Floor1, Room2), (Building1, Floor1, Room3) to the subform, it will ask me how many rooms I want to connect, in this case 3, and then add them, keeping the building and floor numbers the same.
(I think I am explaining this more complicated than it is, sorry!!)

Can someone point me in the right direction? I have been playing about with queries.....is this correct?
Any help is greatly appreciated.

Many Thanks.

Frank.

View 2 Replies View Related

Adding Records To A Combo Box

May 17, 2005

Hi all,

I have a data entry screen that requires the user to select a assessment type from a combo box that gets its values from a separate table. So far i have 3 Assessment types, these are Quality, Manufacturing and Technical.

If the assessment type they want is not is the combo box list. I want them to be able to type in the assessement type in the combo box and have it saved to the assessment type list so that in future it will be availible directly from the combo box.

Any ideas on how i can do this as it's giving me a head ache....

Many thanks in advance.

El Cid

View 8 Replies View Related

Adding Records Through A Form

Aug 31, 2005

I have a number of tables all with there corresponding forms. I am needing to have a command button on the form for the user to easily add a new record. Obviously this is easy by just using the wizard but my problem is that I need the record to be added over all the tables.

This is an attendance database with tables for each month. So when a new member of staff joins and there record is added for that particular month I would like it to be added to all subsequent tables as well. Is there a way of doing this. It would also be beneficial if a similar thing could be done for deleting staff (i.e. a staff member is deleted from one table and subsequently is removed from the other tables)

Any help with this would be greatly appreciated

View 4 Replies View Related

Adding Records Via A Form

Aug 31, 2005

I have set up an attendance database with tables for each month. Each of these tables has its corresponding form. I want to be able to add a command button onto the forms to add a new record. Obviously this is easily done using the wizard but my problem is I want it to be added over a number of tables.

For instance when a new member of staff arrives and is added to the database I want there record to be added over all the subsequent tables not just the one attached to the current form. It would also be beneficial if I could do the same for deleting staff (ie someone leaves they are deleted off the current table and all other tables)

Is there a way of doing this.

Any help would be greatly appreciated

View 7 Replies View Related

Subforms - Adding New Records, Etc...

Dec 5, 2005

I am creating an Access database that I want to be able to use to change a header table and its associated detail table. I have created a fmain-form that shows the header table fields. This form also has a subform which shows the detail records which are linked to a field in the header table. One header may have many linked detail records from the detail table. I have been able to easily enter information into the detail records that are shown in the subform.

I would like to know how I can add new detail records directly on the subform so that they will automatically pick up the correct header field from the main form. This way I know that the record I add to the sub-form with be linked to the open record of the main form.

Also, I would like to learn a way to sum all of the values of one of the fields shown in the sub-form and place it on the main-form. How can I do this so that I only sum those values that are in the sub-form that are linked to the open man-form record... not sum all of the values from all of the records in the database?

Thank you in advance for your help.

Mike

View 1 Replies View Related

Adding Records In Subform

Jan 18, 2006

Hi,

I am a bit stuck now and I want to validate several points with you.

First let me explain the context: I am writing a timesheet application and I've got a main form + a sub-form.
In the mainform, I select the engineer, the contract and the week to input.
My mainform calculates the first and the last day of the selected week and modifies the recordsource property of my sub-form to select the records with the right engineer + contract nbr + range of first and last of week. This means that I can only have maximum 7 records for the seven days of the week because the application records only a global time per engineer/contract/per day.

Here it becomes tricky and this is the most difficult part of the application (I hope); what I want to do is to help the user having to enter the times.

so I need to retrieve the records but if they don't exist, I
want to create new records with engineerId, ContractID, day of the week and let the nbr of hours to zero. This in fact will help the user because he will have only to complete the nbr of hours. Iw ant obviously to present those entries in the right order; I mean in ascending ordre based on the day of the week.

Eventually, when the user has completed the week, what I want to do is to update the existing records, insert the new records where the number of hours is > 0 and discards rhe records where the number of hours is = 0.

I know this is a bit tricky to understand but if you could give the main ideas to implement it would be very grateful.

Regards.

Fabiano Gaiga.

View 2 Replies View Related

Form Not Adding Records

Mar 28, 2006

Hey everyone... got a little problem, i have the followinf form/subform setup show in the screenshot below, for ages the calendar conrol there has worked fine, its control source is the date field on the left habd side.

Now however, it doesnt work, or rather it works when your editing old records, it changes the dates fine, but when you go to enter a new record in, you cannot use the calendar, it just makes the windows error sound at me. And i cant type the date in either, and i cant type into any of the other fields either, but i can edit the old ones fine....

Of course i can just go into the original table that the form runs off and type new data in there, but thats not the point, i need to be able to use this form. It worked before, but i opened it today and its screwed sideways, lol

any help from anyon would be great, dragon

PIC:
http://img381.imageshack.us/img381/8988/accesserror3oc.jpg

View 6 Replies View Related

Adding Records In Forms

Jul 27, 2006

Hopefully I have provided enough info as I have tried to keep it concise...

I am adding records to both a parent table and a child table using a form (for the parent db) and a subform (for the child db). When enterring data into the subform, I would like all previous records enterred into the subform (for a given entry in the main form) to remain visible as new records are entered (rather than simply having the view switch from one record to the next). A follow-up question would be...how do I get a unique identifier variable to increment one unit every time I add a new record into the subform, e.g.

ID var1
1 a
2 b
3 c
4 d
. .
. .

Many thanks - Zach

View 1 Replies View Related

Forms :: Adding Records Only?

Apr 3, 2014

How do I configure a form so it can only add records. I don't want users to see what is currently stored in the table, just add records to it.

View 2 Replies View Related

2 Users Adding Records At The Same Time?

Mar 1, 2006

Is it possible to have 2 or more users adding records into the same table at the same time? They would not be editing, only data entry.

I am wondering if this would cause a problem for the auto numbering for the ID field.

View 2 Replies View Related