Search results

What's the point of having a table for judges if there's no data entered in it! And I'll check out those articles you linked, thanks.

Note: I'll understand if you declare me too noobish to try and help. I definately in territory where I don't have a clue what's going on. I only vaguely understand what you mean here. The thing is that a) my judges don't have any "attributes" beyond their name and b) I don't want to have to...

Ahhh... UNION, that's what I needed. Thanks. I have no idea what you're talking about :) Ideally I would be able to select three or more judges in seperate combo boxes on my form and have all three selections be saved in an array or something in the judges field. I don't think that's possible...

No, the cases I'm doing oten have more than one judge and I'd like for all of the combo boxes to have all of the judge's names which I have entered in any of the fields.

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...

Re: Hope I might hepl That's what I meant "not an actual access toolbar"!!

(If you mean floating) then that's what I mean "not an actual access toolbar". I want to make something that is like a toolbar. Hehehe, I didn't know you could do that. I just created a new form and then dragged it over the current form in design view. I should be able to get it figured 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...

Lol, figured it out, I don't need any if clause there, I can just put the code in the current event section... Thanks!

Great, that's all I needed!

Thanks for the answer. It's almost what I was looking for but not quite. I was talking about when browsing the current records, I have all my data in there already, I want this picture to display for records which are already entered into the form. So instead of ".NewRecord" ise there's...

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...