Search results

I'm really bad with queries. There's two I'm having problems with. 1) I want the value of a combo box to be made up of all the distinct entries in two seperate fields. The following query works, but it only gets values from .judge, not .judge2 SELECT DISTINCT Cases.Judge, Cases.Judge2 FROM...

Continuing my spammage of questions, is it possible to create a custom toolbar in a form? I don't mean an actual access customised toolbar or anything, but a floating sub-form or something which looks and acts like a toolbar. Currently all my action buttons are just cluttering up my design, it'd...

I want an identifying picture at the top of my form which changes depending on the value of a list field. An example is this: If Status.Value = "leading" Then imgPlus.picture = "c:\...plus.bmp" ElseIf Status.Value = "cautionary" Then imgPlus.picture = "c:\...question.bmp" End If The...

I'm trying to create command button which will select and go to a random record in my form and my VB is woefully inadequate. Here's what I've got so far: Dim rndRecord As Integer rndRecord = Int((100 * Rnd) + 1) DoCmd.GoToRecord , , acGoTo, rndRecord This script will picks a random record...