I have created a form that with an image control called imageview with the following code.
Private Sub Form_Current()
Me.ImageView.Picture = Me.AlbumCover
End Sub
Albumcover is a text field containing the path of the bitmap.
All is fine unless i move to a new record in which i get an invalid use of null error on the code. Can someone help me remove this.
Thanks
Hello,
I am sorry to post this as I did do an extensive search through the forums. I am looking for a way to link images to a form from an image folder I have created outside my database. As I said, I did do a search and there is a lot of information listed. For some reason, I understand non of it. I am a bit of a novice as my personal database is quite simple.
Below is a screen grab from my database showing how I want to link my images; how I want them to look. This image is taken from an old incarnation of my database when I thought I was linking images but in fact was storing them on my computer. Like I said, I am sorry to bring this up but all of the help is a little over my head, of someone would not mind telling me VERY simple steps to achieve what I want to do, I would be very appreciative.
I want to be able to have the pictures change for each record.
http://i18.photobucket.com/albums/b117/Gregbert/Database1.jpg
Take care,
Greg
I thought this would be pretty simple, but I cannot figure out how and wasn't able find the solution here or anyway.
I have a source form. (I can resort to having a Table with OLE Object if I must, but prefer not to.) On this source form I wish to include different things such as company logo. This will determine what logo shows up in all the reports, so all the reports will have an image linking back to this embedded image on the source form.
Pseudo-code Example:
frmSource contains imgLogo
rptSample contains an image whose
control source = Forms!frmSource!imgLogo
How can I do this or achieve the same effect in a more-or-less simple way?
TIA
in 1 table there are are 3 feilds
folwer_name
no_of_flowers
total_cost
another table (2 fields)
name
price
eg:
name price
rose 15
tulip 20
Now I want o make a form
with 3 fields
folwer_name
no_of_flowers
total_cost
eg: if some one select 'flower_name' 'rose' and quantitly '10' then total_cost = 150
How can I do this ? using query or anything else plz gimme detals
Hi, i have created two tables, containing the same fields. One table if for '1 day tests' and the other is for '2 day tests'. I need to keep these two in seperate tables.
At the moment i have two seperate forms, one for each type of test, but as the fields are all the same, i was wondering if i had a combo box, so the user could choose whether they wanted a one day or two day test and filled in the rest of the fields, the record would then be stored in the appropriate table. Ie 2 day test table, if the chose 2 day test on the combo box
Thanx
Hi all,
I have two date and time fields which format are like: 15/09/05 09:48:43,I have another field which calculates the time difference between these two fields. I am doing a calculation on the time difference field and want the time to be displayed as for example 03:00, but at the moment it just shows 3:00.
This is the control source which has some formatting in it:
=Int(CSng((([txtDateDel]-[txtdateRO])-[closed])*24)) & ":" & Format(([txtDateDel]-[txtdateRO]),"nn")
I have tried adjusting this but am having no luck.
I would be grateful of any help,
Thanks :)
How do I use a wildcard in a query, see attached .mdb
Table "myDATA"
Sam and Zeb have serial number 23a4224A and 23a4224 in their records.
I want to locate a serial number(s) in multiple fields of a table, based on the users input with a wildcard.
query "Serial Number query"
Enter Serial Number: the user enters: 23a4224*
What am I doing wrong?
Thanks
My combo box problem is still at large!
I've tried every way i can, and i cant get the rowsource query right.
If someone could look at this and post a fix, so that when one uses the "training record" form it allows you only to select course dates that are already in the tbl_course_dates table.
Thanks so much
http://www.suicidenotesmusic.net/nonworkingcombos.mdb
:( I changed my input mask in my form to 99/99/0000;0;_, but my form dates still look like 1/1 /2005. I want the 0's to be visible. Please help.
View 1 Replies View RelatedI'm trying to create a little dbase for personal keeping track of a number of companies I deal with, so that i store their details and also the products they distribute.
In more detail, I want to have 'fixed' product categories, which will be assigned to supplier, and each category will include the product models I have set, including their details (such as price, manufacturer, country of origin, etc).
My point is to be able to create several customised reports and listing:
1. All product models I have in a category including their details.
2. Report per supplier to view their details and the products they distribute
3. Certain product models in a list with their local distributor (companies I deal with).
I assume it involves a couple of many2many relationships, however I have created a file in MS Access but never managed to have it work properly.
Any1 have an idea, or template maybe?
Regards ;)
I want to delete a relationship temporarily so that I can delete a record. After the record is deleted I will restore the relationship immediately. But I am concerned that this will ruin any queries I have already established or ruin my other records.
Could you let me know if this is possible without making a mess of things that have already been established.
Thanks
Carrie
I have pasted the code that SJ posted on another thread that any changes to a record will ask the user to save before closing the form, this located in the beforeupdate event.
Private Sub Form_BeforeUpdate(Cancel As Integer)
If MsgBox("Save changes?", vbQuestion + vbYesNo) = vbNo Then Cancel = True
End Sub
The problem i am getting is that if the user selects no it pops up another message saying "You can't save the record at this time" followed by a description.
How do i prevent this second message appearing i cannot find a thread with this in?
Thanks as always
Mike
Hi all, long timer viewer, first time poster
Any way, im not nearly as experience as all you, I have a small form, on the form I have a combo box, the form shows the relevant info with regards to what is selected in the combo box, the source of the combo box is a table, the data in the table is alaphabetical, but when you select the combo box the data shown to select from is not alphabetical its all over the place!
Hope that explains it, its driving me nuts!
I have a form that I would like to update a picture on using VBA. The source of the picture path is in part a query that is not bound to the form. So far I have the following code that is pretty much working, but with a couple flaws.
Code:
Private Sub Form_Current()
LoadDefaultPicture
End Sub
Sub LoadDefaultPicture()
Dim db As DAO.Database
[Code] ....
This is working. However, when I change the record the picture flashes the current picture once and then loads the new picture. It is like it reloads the current picture then loads the new one. I'm hoping there is a way to get rid of the flash.
Also, the code fails here:
strDefaultPictureName = rs.Fields("AttachmentName")
When the query does not return a record. I can definitely fix this by adding an if statement to check for a record, but I'm kind of perplexed at why it is failing at that line. I would expect it to assign an empty string to that variable name and then fail on the next command where I try and set the ".Picture" property of the image.
Hi all ,
Can anyone tell me about how to embedd image in image control using imagelist.
I added the 5 images in imagelist at design time and added the following code.
image.picture=imagelist.listimages(1).picture
but iam getting error.error no :2110,cannot open the file .
thank u,
Siva
Hello,
I have a very strange problem:
I have a table linked to an SQL Server table in my MS Access 2000 Application containing 5 text-fields (SQL Server Type, in Access seen as MEMO-fields) and several other fields (in total about 140 fields). Updating any field works fine except for some records. In those records I can only edit the non-text-fields in my application. When I try to edit one of the text-fields I get a error message telling me that another user has edited the record and i have to discard my changes.
The strange thing is that this problem only crops up for some records. (1 in a 100 or so) All other records work fine.
Does anyone know what happens here? And how this can be fixed?
Thanks.
Kaine
Hi guys,
I'm in desperate need of help and want to know if it is possible to load an image on a form once a hyper link is created.
For example, I have a form with a hyper link to an image created, currently, when you click on the hyperlink, it opens the picture in the browser, can you change it so that it loads teh image embedded into the form instead of loading it into a browser?
If so, how?
Thanks
Hello:
I need to update a graphic on my form as part of the record information. Specifically, I have a graphic of the human body, and need the user to be able to mark the area where it hurts-scribble or put an "X" there-whatever. This modified graphic then needs to be stored somewhere and associated with that particular record.
Has anybody done this? Any suggested starting places?
Thanks,
Matt
:confused:
How can I get an animated image on my switchboard? I found an animated image on the internet and I copied it. I went into design view and pasted it onto the switchboard then I went back to form view. I can see the image but it is not animated. How do I animate it?
View 1 Replies View RelatedHi
I have a table with this fildes:
name - family - PathImage
I have 400 records.
and I have 400 pictures for 400 person to a folder
and I want fill them, but is an easy methode for finding and filling pathImage for each person? and insert it to table cell?
I want insert Name of image file to PathImage filde.
Is there any thing such browse bottom to find file name?
Thank for your lead
I am going to show some images
I have stored the links of photo in a table
how can I show the different pictures in a form at the same time?
i have a cars database
because it is difficult to add 4000 pictures i want to know
if is it possible to add a field that opens an ie page in google images to show results of images for that car?
ex :
model : Ferrari
foto link :http://images.google.com.gr/images?hl=el&lr=&q=Ferrari&btnG=%CE%91%CE%BD%CE%B1%CE%B6%CE%AE%CF%84%CE%B7%CF %83%CE%B7
Hi
i have a form, with a command button, which when you press it automatically sends an e-mail
At the moment, that e-mail is just text. What I want is to insert the company image in the e-mail?
Have tried doing this but keep getting error message (put image on the form and then referenced Me.logo behind the code)
Anyone know if this is possible
Chris
hi
i have a form with the fields
PhotoID
PhotoName
PHotoPath
PhotoDate
PhotoSize
ImageFrame
my Imageframe is showing the image
image format .jpg and size 200kb each
Problem
when i click next record , my mouse is flashing and my db is freezing for 2sec.
I have place a code by www.mvps.org which hide the insert dialog message.
Also , i have change the registry to No (read the article at the www.mvps.org).
I need something that will make my photo to load faster.
thxs
__________________
Alexandros
So far I have used this code:
Private Sub Form_AfterUpdate()
On Error Resume Next
If IsNull(Me![ImagePath]) Then
Me![ImageFrame].Picture = ""
Else
Me![ImageFrame].Picture = Me![ImagePath]
End If
End Sub
Private Sub Form_Current()
On Error Resume Next
If IsNull(Me![ImagePath]) Then
Me![ImageFrame].Picture = ""
Else
Me![ImageFrame].Picture = Me![ImagePath]
End If
End Sub
To make a form which will show a picture (different for each record) if the field 'ImagePath' has an entry in it. If not, it does not show.
The table containing the image is 'tblAnimal' and the field name where the path is stored is 'ImagePath.'
I would like my user to be able to click a button on the form 'frmAnimal' which says 'Add/Change Picture.'
This would then open a File Dialog window where they can navigate to an image (.jpg or .bmp) and select it.
The file path of this image will be subsequently placed into the 'ImagePath' field of the current record that the form is showing (based on 'tblAnimal.'
I saw a similar technique on the Northwind example database but this uses an extra part and I am a little confused as to which VBA code I need as the OnClick Event of the button.
New to all of this :confused:
I have a form that has an image name. The image is stored on a web server. The image can be accessed through a URL. The problem is how can I show the image on my form. When I try to change the picture property of my image control it tells me that it cannot use a web address. Any help would be greatly appriciated
View 6 Replies View Related