Search results

Not sure about dragging and dropping images, but in this example after you add a few images to the main form, clicking the browse button will display the images on one form. Hope it helps your problem. Dave

If Me.cboSelectStudent & "" = "" Then Dont understand & "" = ""

How is the Value list constructed? Can you manipulate the data when adding to have the record they want to view first at the top?

Did you download the attachment in the link I pasted? It will do EXACTLY what you want:confused:

When developing an application, the path to the back end will often be different than that when installed on site, so an easy to use interface is vital. Also networks drop out etc and there are always those "Necessary" IT updates try the attachment here...

Dim Counter As Long Dim rs as Object Counter = DCount("*", "tblContractors", "ContractorName = Forms![frmAddContractor]!ContractorName") If Counter > 0 Then If MsgBox ("This Contractor already exists, Do you want to view details. ", vbExclamation + vbYesNo) = vbYes then Set rs =...

Opps, I think I should have read the question. I use a DCount to find existing records Put it in the Before Update event of the field... Dim Counter As Long Counter = DCount("*", "tblContractors", "ContractorName = Forms![frmAddContractor]!ContractorName") If Counter > 0 Then...

Access wizard creates code when you add a listbox or combobox and select the 3rd option "Find a record on my form" The code would go something like this: Dim rs as Object Set rs = Me.Recordset.Clone rs.FindFirst "SSN = " & Me.SSN Me.Bookmark = rs.Bookmark Just substitue the fields in the...

If you look at the Row Source property of the list box, if you click in the field, a little box with 3 dots will show. If you click on the button, the query builder will open and allow you to sort the data how you like. Dave

One way you might be able to goto the last record: In the forms load event Dim i As Long i = Me.listboxname.ListCount Me.listboxname.Selected(i - 1) = True Dave

Custom icons, yes, animated icons - more difficult. Create a module and paste the following code: Private Declare Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long Private Const WM_SETICON = &H80 Private Const IMAGE_ICON = 1 Private Const LR_LOADFROMFILE = &H10 Private...

Check the field names. If] you copied# this code from another Db ~ you will get this error if the code cant find the correct field name,(

That brings back memories. Two men selling watermelons. Buying for $1.00, seling them for $1.00 The first man says "We dont seem to be making much money!" "Yeah," the second man says, "Think we better get a bigger truck"

Confusious say, man who go through airport turnstyle sideways going to Bangkok

There are 10 kinds of people in this world; Those who understand binary code, and those who don't. .

Try the attachment here.... http://www.access-programmers.co.uk/forums/showthread.php?t=136493 Dave

And for our Biology experts: What the the fatty tissue around a ****** called? . . . . . . . . . . . . . . . . . A Wife

Why not just use the scroll bar

Search form 2 is the way I search Dave

All you have to do is ask!! The page break control is on the toolbox menu. Dave