Recent content by allenEd

It gets a litte tricky, when I save the form as a report. Then using .column(1) dosn't appear to work... thanks

Thanks Remou,

Hi, SQL VBA form question. example of the problem. If I have two tables, table one tblnames with fields FirstName, Lastname, Dept in it. table two tblProject, with a combo box cboLastName, which is linked to tblnames, so you can see all the fields of tblnames in the drop down. How do I...

Hi, I have a form with a continuous subform in it. In the subform, if I make a VBA button to disable a text box called txtBox, every txtBox in the form (continuous) is disabled. How do I get the button to disable only the record that the button is clicked in to be disabled. eg. the code is...

Thanks Duane, thats really simple! The db was just an example, the "surname" wont be the same. I just wanted to know how you do it. cheers

Hi, Best explained as the example. Say I have two tables tblContacts and tblServices. In the tblContacts, there are the fields lastname, firstname, address1, address2 In the tblServices there is a lookup to the field "lastname" in the tblContacts table. In a form with recordset tblServices...

Hi PV, many thanks for that, that works ok, .....until I set the default view to forms to "continuous form", any ideas, thank you, again. my code is now:... Private Sub Department_AfterUpdate() IDPersonel.SetFocus Me![IDPersonel].RowSource = "SELECT IDPersonel,Surname,FirstName From...

Hi PV, The trouble now is that when I go back to the previous record in frmProject. The personel field is blank, because the secect row says SELECT IDPersonel,Surname,FirstName From tblPersonel WHERE IDDepartment=1 Any ideas please.. thanks Allen

Thanks PV, it worked on the got focus of the IDpersonel field.

Thanks PV, I entered Me![IDPersonel].RowSource = "SELECT IDPersonel,Surname,FirstName From tblPersonel WHERE IDDepartment=" & Me![Department] Into the expression builder, dosn't seem to like the me! part. (I get an error) I see the idea.... I will keep trying! thanks Allen

Hi I have 3 tables, tblpersonel IDPersonel autonumner FirstName text Surname text IDDepartment number ---(many)-------------- | tblDepartment | IDDepartment autonumber-(one)--------------...

I have fixed it using IFF. thanks

Hi PHV, Sorry, I have attached a rough (very rough) sample of what I mean. There is a combo box. If chkbox1 is true, then I only want to to see "ORA" in the drop down, if false then SQL. Sorry If I dont make sense, thanks http://www.box.net/shared/5ebv7qjsvr

Hi, It is a value list the row source is "ORA";"SQL" If the check box is true in form 1, I need the criteria to be ORA (then it will filter), if the check box is not ticked, then SQL. thanks

Hi, I have a problem trying to get a check box value from one form, as a criteria of a query in a subform. I have 2 forms, form 2 is a subform of form 1. form 1 has a checkbox called chk1 In form 2, there is a combo box which has a drop down field (with two options) which needs filtering...