Search results

Dear All Your help would be much appreciated once again. I have two subforms on an unbound form. Subform1 has a list of clients as a continuous form. Subform2 has detail of each client and is set to invisible. The forms are linked with a common child/parent field. I am trying to get subform2 to...

Hi Thanks for that had never thought of having two controls for the same value in a row doh I set conditional format to same colour for background and text and sent it to the back and it works a treat. An example of KISS I guess Cheers Eric

Hi I use: Me.Detail.Height=Me.ANY CONTROL IN THE ROWS NAME YOU WANT.Height or a multiple thereof: Me.Detail.Height=Me.ANY CONTROL IN THE ROWS NAME YOU WANT.Height*x Any thoughts on the colour issue? Eric

Dear All Your help would be much appreciated. I am running Access 2003 and have a database where I have a tab form listing a series of records. To aid user visualisation I would like to set the row background colour so that it is different depending on the value shown in TxtBox Events_place...

The control which has the link child and master fields options shows: Name frm-LastViewed Source Object frm-LastViewed ie the same as the form frm-LastViewed which as originally constructed as a standalone form opened by a button on a main form although this is no longer the case.

Thanks for your reply The subform name is frm-LastViewed Appreciate the naming is screwy but we started this with no access knowledge and learning the hard way I guess having never constructed a data base before What we are trying to do is fine tuning for a relatively simple data base Just...

Dear All More help needed if there is a solution. I have a form with a list box on it. When I select a record it opens another form with the full record using the OnClick event with the following code: Private Sub ListPts_Click() On Error GoTo Err_ListPts_Click Dim stDocName As String...

Many thanks for your help your advice worked perfectly. All the best Eric

Dear All I have an unbound list box which is populated from an unbound text box. I wish to use the OnClick event of the list box to open a form with the full record of the row selected in the list box. The code I have so far is: For the unbound TextBox: Private Sub TextSurname_AfterUpdate()...

Many thanks I thought something like that would be the answer but every time a tried I seemed not to use the correct syntax after the If. Didnt realise I had posted in the wrong place was finding the site difficult to find my was round. Once again thanks your suggestion works perfectly...

I have a table of names and unique ID numbers which I want to search from an unbound textbox on a form and return the result to a listbox. I can do it using name but would like to use either name or ID to return either a list of people with the same name or a person with a particular ID number...