Search results

Hi, I was wondering if anyone knew a way of creating a query that arranges the data in the table below Ref ID 63 ID6 63 ID5 63 ID7 63 ID11 64 ID2 64 ID3 66 ID4 66 ID10 69 ID9 72 ID1 73 ID8 into the format in a query Ref 1 2 3 4 63 ID6 ID5 ID7 ID11 64 ID2 ID3 66 ID4 ID10 69 ID9 72 ID1 73...

I'm trying to get a scrollbar so that it appears just in the Detail section of my form. However there doesn't seem to be a property in the Detail section to set scrollbars to enabled. Is another property on the form causing this not to appear? Thanks

I've got a bound control on a form that is showing the value in the AccountID field of the person who has crreated a particular record. I want this to show the persons name which is stored in a different table (linked by AccountID). This field doesn't need to be editable as it is for lookup...

I'm having a problem which is driving me mad! I'm trying to make a field on a subform become invisible depending on the selection in a combo box on the main form. I sometimes get run time error 2165 'You can't hide a contol that has the focus' even though I've included a line of code that...