Refreshing Pictures
Mar 24, 2006
Hello all,
I have search the forum for two days and can not find anything about this promble so any help would be good.
I am using a linked picture i have then browser setup and works ok but my issue is that i can not get the picture to refresh its self, with out going into design view and then back to my form, i would hope that there is a solution to this.
Any links would be good or general help would be great as i am starting to loss sleep over this now.
Thanks in advance
Alastair
View Replies
ADVERTISEMENT
Jan 31, 2005
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)
View 2 Replies
View Related
Oct 20, 2007
I like to make a small code in access to take pictures with any camera, then store with file name, date and time? please I need help.. if someone can give me an idea I appreciate this. thanks again..
View 3 Replies
View Related
Jun 17, 2005
Hello all I hope that you can help
I got a database that has lots of subform which are all locked, I got a button that open the same subform in a pop up form with a macro that insert a new record. But when I close the subform after puting the information in the new record does not update on the main form untill you go away from the current record and come back again
Any Ideas
Postieman
View 1 Replies
View Related
Apr 19, 2006
OK, I asked this question a day or so ago and got some feed back. What I would really like is a difinative answer. Basically Yes or No. Is it possible to add small picture, (icon size) to a comobox. I realise its not good practice to have pictures embeded in the DB but on this occasion its what I need to do. Ive found software on the web that allows you to do it, which leads me to belive that it can be done, any ideas!
View 6 Replies
View Related
Nov 12, 2006
:confused: Could someone please help me. is it possible to add an animated microsoft GIF to an Access 2003 database splash screen. the picture works but the animation doesnt. If someone could please help i would be very grateful as it is needed for an assignment very soon. Thanks in anticipation.
View 2 Replies
View Related
Jun 18, 2007
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 Related
Jun 27, 2007
I need to do something in excel but I have never used excel before. I need to make a form with a box. When you click on the box it shhould promt you to add a picture to the box. It should also format the picture so that it is the same size as the box. So far we have the box, but we still need to figure out what code to input so that it prompts you to add an image and then resizes it to fit the box. This is the code we have so far:
With Application.FileDialog(msoFileDialogFilePicker)
.Title = "Seleccione la imagen"
.Filters.Add "All Files", "*.*"
.Filters.Add "JPEGs", "*.jpg"
.Filters.Add "Bitmaps", "*.bmp"
.FilterIndex = 3
.AllowMultiSelect = False
.InitialFileName = Application.Path
result = .Show
If (result <> 0) Then
fileName = Trim(.SelectedItems.Item(1))
Image1.Picture = LoadPicture(fileName)
End If
End With
I am not sure if this can be done in excel or if I have to use another application to do this. I need to figure this out within the next couple of days, so if you have ANY idea of how to do this please post a response.
View 2 Replies
View Related
Apr 19, 2005
I have trouble adding pictures to my forms.
On the form when I add a picture, it just shows me the link and when I double click on it, it displays the .gif file. ( I did define it as an OLE object in the table)
I am not sure if there is something specific I need to do in order to display the picture right there on the form.
View 4 Replies
View Related
Sep 27, 2006
Hi There,
Can someone help me please. I have designed a product management database for a friend. He would like to be able to upload pictures of his products onto his database to be viewd later. So on the products form, I'd like two command buttons (I guess), one to define the file path and another to open that file path.
ANy help would be appreciated.
Kerry.
View 2 Replies
View Related
Nov 11, 2005
Any help on how to approach this would be very much appreciated!
I have two tables: one with data about compounds, the second with data about graphs of these compounds. (There may be many graphs for each compound).
I need a form that displays data about each compound, and in this same form, I'd like to show what graphs are associated with this compound and display a picture of each graph as it is selected.
I've tried both subforms and comboboxes and have not been successful.
Thanks so much!
View 2 Replies
View Related
Jun 21, 2007
I know if you use pictures in forms it makes the database file size very big, if you have a products database and want to show a picture of each product, therefore each picture is different, is there a way of doing this and keeping the database size reasonable?
View 9 Replies
View Related
Nov 22, 2005
Hi there.
I have a form with two sub forms on it. The form loads with a reference number that I pass to a function that in turn requeries the first sub form. The function call is in the on load event of the main form.
This part works fine.
The second sub form uses a similar requery function to the first one. The only difference is that the query for the second sub form is based on a reference number from the selected record in the first sub form.
If I put the function call for the second sub form in the on click of the first one all is well and the second sub form displays all records with a matching reference number.
The problem is that when the main form loads the first sub form will display the correct data but the second remains blank or displays the wrong data.
I know this is happening because the first sub form has not loaded fully and so the second sub form cannot get the reference number. I just can’t find a way to make the second sub form display the correct data when the main form loads.
I have tried calling the requery function for the second sub form from most of the events on the main form and many of the events on the first sub form but to no avail.
I also tried putting a meaningless sub form at the bottom of the main form and putting the requery function for the second sub form in the on load event but that was no good either. This surprised me as until that point I was assuming that access was loading the sub forms sequentially from top to bottom.
Can anyone tell me how I might determine the point at which the first sub form has been loaded so that I can get access to the reference numbers needed for the second sub form query. I would prefer not to use a timer for this as there is no way to determine the maximum time it will take access to load the rest of the data but at present it looks like the only option left.
Any comments would be much appreciated and sorry for the lengthy explanation.
View 6 Replies
View Related
Nov 24, 2005
I just added a ActiveX control to my program and I have a scroll mouse, and there when the user used the mouse to scroll through the records, the record changes but the ActiveX Control doesn't. My activeX Control is used for a digital signature. Anyone Have any ideas?
View 2 Replies
View Related
Jul 27, 2006
This is a lot more complicated than the title suggests. I was asked to reset the work order numbers used by the maintenance department. When they reach work order #9999 they want to start over. My best bet is to make a backup of the tables and create new ones that include the last 2-3 weeks of activity. If I do that I'll have two potential problems:
The next autonumber needs to be lower than the pre-existing records but not start at 1
Recombining data from the old table (for whatever reason) will create false relations
Does anyone know a possible solution to these problems or is there a better method to refresh the database?
View 8 Replies
View Related
Apr 1, 2007
I have a 'Snapshot' report, which gives up-to-the-minute data on a business - sales year-to-date, month-todate, week-to-date and today. They run this many times a day, but ideally, they would like to have the information display on a monitor, and be updated automatically every few minutes.
Is there any way that a query can run by itself every few minutes, and gather the current information?
Robert
View 4 Replies
View Related
Jul 4, 2007
Hi Guys
Quick question, in Access 2007, i created a table that pulls data out of our system via ODBC. No if the system gets updated, how do i refresh data in access? Please advise. Thanks in advance.
View 1 Replies
View Related
Feb 24, 2005
I have an orders form which contains an items subform.
To populate the items subform I have a button which opens a separate pop-up form.
Is there a piece of code which would allow me to click a button on that pop-up form which actually refreshes the other opened form (orders form)???
Anyone know if this is possible?
Thanks,
Paul.
View 2 Replies
View Related
May 16, 2005
Hi all,
I have a form (sub_Main) that opens and has an openargs value (Department) from my main form when user clicks on a cmd button. However, if I were to go back to my main form and click on another department the openargs value is not passed along. I have tried using Me.Refresh under LostFocus but it doesnt seem to work.
What is causing the openargs value from updating? Any help?
Thanks!
View 5 Replies
View Related
May 26, 2005
Hey All,
I have a field "NameView", irrelevant but it grabs a name from a seperate form from an ODBC connection.
The purpose for the field is simply to grab the data from another form.
On the same form As NameView theres another field "Name"
This Grabs the data from NameView and writes to the main table.
Everything works fine but "Name" will only update from "NameView" on a new record only and not on the current one.
I have a VBA Statement on an afterupdate which Me.Name = Me.Nameview
I've tried Me.Refresh and Me.Requery but no help.
Any thoughts?
Much appreciated
Thanks
View 4 Replies
View Related
Jul 15, 2005
Hi,
I know this is probably something really simple - but I'm relatively new to VBA.
I'm trying to run an update query from a form, then refresh the form having all the input boxes and checkboxes etc set back to normal.
The problem being that I have a list box to select a record to update from.
Now, if I just refresh the form this list box updates properly - but none of the other controls (text boxes and check boxes) reset to their defaults.
If I try to reset them manually in the code then a) they don't reset and b) the list box no longer updates (depending on the location of the reset code).
Though the code I'm using to reset things works when the query is not executed.
The code I'm using is currently:
Private Sub Save_Record_Click()
On Error GoTo Err_Save_Record_Click
Dim stDocName As String
DoCmd.RunCommand acCmdSaveRecord
stDocName = "Return to training"
'DoCmd.OpenQuery stDocName, acNormal, acEdit
Me.Refresh
Current.Value = False
Exit_Save_Record_Click:
Exit Sub
Err_Save_Record_Click:
MsgBox Err.Description
Resume Exit_Save_Record_Click
End Sub
I should add that in the above version of the code the list box does update but the check box still does not.
I'd really appreciate any help you can give me.
Thanks!
View 2 Replies
View Related
Dec 8, 2005
Hi
I double click a combo box which takes me to a new form. e.g. a purchase order form does not have an employee so they need to be added. When the employee form is closed i would like to refresh to combo box so the new employee appears in the combo box.
Please help
Thank you
View 3 Replies
View Related
Jan 27, 2006
I have no VB skills at all have to do everything with macros etc. So please keep any replies simple. I have a database for students, courses and tutors - all worked fine until the customer wanted each student to do 2 courses at a time. The whole database is designed for statistical returns ie females with child care responsibilities living in a rural area etc., and the Course Id has to be the same on each course table. I split the course table into 2 tables with the same data, made a course entry form which appends new courses to both tables. My problem is that when I select a course ie no 234 for course 1 and 345 for course 2 I cannot get the subform to show the data unless I go to the next/previous record and back again; when I do this the main form opens at record 1. Is there a macro or piece of code I can use to automatically refresh OR a macro that will go to next record and then reopen the mainform at the place where I started?
View 1 Replies
View Related
Feb 26, 2006
Hi!
I'd like to ask for your help in the following issue:
I wanted to refresh the filtering of my combo-list on a subform according to the change of a field on the main form.
With this
Private Sub supplierID_AfterUpdate()
Forms![invoices]![details1 Segédűrlap]![KombináltLista4].Requery
End Sub
it succeeded. But when I turn a page on the main form (to see records registrated in the past), the combo-list on the subform doesn't change (because Access doesn't get any after-update info - I guess).
But I'd like to use a solution that always watches the actual value of the main form displayed on the screen and so it changes the filtered list of the sub-form - combo-list according to it.
Please help if you have a good idea/solution to it.
(take care I'm beginner at Visual Basic)
Thanks
xxyyy
View 1 Replies
View Related
May 23, 2006
Is there a way where you can send the data on a form to a detination table without closing the form?????
It's probably the easiest solution but it's 4pm and nearly home time so a memory blank is upon me!
View 2 Replies
View Related
Aug 23, 2006
I have modal pop-up form1 showing list of items. There is a button that opens a new modal pop-up form2 (not subform) to add items to form1, form1 is still open behind form2. This all works fine, but when you click save button on form2 it saves new data to database and closes taking you back to form1
but does not refresh new data to form1 unless you (shift F9) or close form1 and reopen or use refresh button on form1.
I would like to have form1 refresh data as soon as form2 is closed from the save button. I can do a timer event on form1, but this flashes the screen...which is annoying. I have tried various methods to make this work but just can't seem to get it to work. If form2 was a subform of form1 then refreshing mainform would not be an issue. Can anyone shed some light on this?
View 3 Replies
View Related
