Code:
Private Sub Combo20_Click()
Combo20.RowSource = "SELECT DISTINCT table1.Column FROM table1 ORDER BY table1.Column"
End Sub
How should I modify the Control Source...
robertoathome
Last Activity: Apr 24 '07, 02:51 PM
Joined: Mar 26 '07
Location:
-
1) For the combo box I believe you wanted me to put the code in the OnClick property. I replaced all the instances where you had "Table" with the name of my table:
I'm afraid it didn't change the results.
How should I modify the Control Source... -
Basic search form
Hello, I successully adapted a search form from a microsoft example into my own db.
MS Example
I type search parameters in 2 boxes and the results are returned in a new, basic query window.
I created:
2 text boxes
1 Command button ( search )
1 Macro to open the query
1 query
All works fine but there are 2 problems I can't resolve.
1) The users... -
I don't know how but it put just a ' 0 ' in the text to display and deleted the original link in the "address" field....Leave a comment:
-
From what I learned the Hyperlink is made of at least 3 fields separated by # .
The first is the "text to display" the second the acutal address....Leave a comment:
-
Yeah, I put it in the original post. One of the record is supposed to have:
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
But now I only have:
040F-CY181824-MS.JPG
Thanks!...Leave a comment:
-
Adding base address to hyperlinks
Hi all. Just when I thought I was finished I realized that my table, in the hyperlink field, doesn't have the base address in each link. E.g.
I have:
040F-CY181824-MS.JPG
where it should be
T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-CY181824-MS.JPG
Since I have over 2000 records I tried to use the below update query but it only updates the "text to display" field and not... -
Ahh, fantastic! It' working great now. Thanks for your time and I hope someday, somehow to return the favor. If you ever need furniture design or cad drawing don't hesitate to let me know.
Thanks!Leave a comment:
-
Here I am again.
Same problem.
The # is still there. The code is reading from the "text to display" which is ok to me.
When I insert a new link in the table the code reads it twice and puts it twice in the len part. If I point the mouse on the last Len statement the tooltip shows a count of 142 instead of 71. Plus is still puts the ' # ' . This only happens when I insert a new link in my table.
...Leave a comment:
-
Well, I swear, if some1 asked me now to rate my intelligence I'd be very crititcal....an d confused :)
I'm still getting the same error.
I opened the 'immediate window' and the first time it showed a few lines with " "myphoto" or similar.
Now nothing, only return lines, empty.
I added the - before the 1 :
...Code:Private Sub Form_Current() 'Always declare your variables
Leave a comment:
-
Now as my brain turns ( this thing is obsessing me! ) I thought maybe importing the data put something funky in the field so I created a fresh columb in the table an put a fresh link.
Same problem which alternates with the link getting doubled.
The I put an "NA" in the 'text to display' field of the hyperlink and the error now is:
Run-tme error '2220'
Microsoft Access can't open the file 'NA#C:\Documents...Leave a comment:
-
I'm sorry to bug you one more time but now at least the problem seems almost solved.
I still get this error:
Run-tme error '2220'
Microsoft Access can't open the file '#C:\Documents and Settings\ELIAS\ Desktop\new\200 2\040F-6F182424.jpg#'
The debug highlights:
Me!Image42.Pict ure = Me!Photo
It looks like the '#' still gets added in the string. :(
I don't get it. I tried links...Leave a comment:
-
BETTER news !
I don't "have to" use hyperlinks but it is easier than changing all my database to text.
With simple text the code in the "Photo" field actually now works! I had to change the allowable number of characterd in the field since the links are long.
I tried to add your second piece of code u gaver me to 'parse the link' but I get a syntax error no matter where I place the code. Below is where...Leave a comment:
-
I'm having the opposite problem, I can't seem to print the backgound color!!
How did yoiu do it?Leave a comment:
-
BETTER news !
I don't "have to" use hyperlinks but it is easier than changing all my database to text.
With simple text the code in the "Photo" field actually now works! I had to change the allowable number of characterd in the field since the links are long.
I tried to add your second piece of code u gaver me to 'parse the link' but I get a syntax error no matter where I place the code. Below is where...Leave a comment:
-
In doubt of the syntax I aslo added the " Me!" :
Private Sub Form_Current()
If Not IsNull(Me!Photo ) And Len(Me!Photo) > 0 Then
Me!Image42.Pict ure = Me!Photo
End If
End Sub
"Photo" is the column in my table that holds the links to the pictures.Leave a comment:
-
OK, something is working but not all.
1) I'm assuming I need to use the first type of image holder, not the unbound or bound OLE object.
2) when I run the code I get an error that says"
"run-time error '2220':
Microsoft access can't open the file 'T:\SHARED FILES\Administr ation\Masters and Molds Photos\040F-6F222032-TL.JPG#T:\SHARE D FILES\Administr ation\Masters and Molds Photos\040F-6F222032-TL.JPG#....Leave a comment:
-
Need help with jpg.
We use Access 2002.
I have a table that contains a column with hiperlinks to jpgs stored on a disk on the network.
I created a form that shows all the fields in the table including the pictures. If I use and OLE object with bmp images all is good. The problem is that I can't use bmp. If I try to display a jpg on an image box/ bound or unbound object box / text box or.... nothing comes up. I put a bmp on the first 2 records and they... -
I created the pivot table in a "Page". Its below the reports in the main access panel.
When I open it the main access window always starts at the same size no matter what size the "Pages" or "forms" are.
Thanks.
P.S. The mail notification on reply to posts doesn't seem to work here even though I set it in my options.
Thanks....Leave a comment:
-
Can the answer include beginners please? I've been reading/using about using OLE ( and it only works with bitmaps) but it bloats large databases.
I've been trying to learn how to create a button that runs a macro to open a pic ( from ono of the column of a table ) in a picture box but my brain is about to fry.
Any help?
Thanks....Leave a comment:
-
Access Pages window size
I'm new to access = can't do much VB or macros.
I've been searching for answers on the web for days.
I created a Page with a pivot table. When I open this page it always starts with the same size and people need to resize it ( for those who know how).
Can the window size be set via property or a simple macro that even I can create? :)
All the properties I checked won't do it.
Thanks!
No activity results to display
Leave a comment: