Recent content by MA04

Thanks for that Ace, sorry for the delay I just read the thread, i ended up using the query route of building the rowsource. I speeded up the second part of my process which compensated for it. which was that when the rowsource gets populated the user selects one option and 4 other textboxes get...

Thanks PH, the thing is because my form is unbound which it needs to be for other operation, using a query to build the recordsource of the combobox is still a bit slow. I think what Crowley16 suggested using recordsets and making the combobox record source type a "Value list" will speed up the...

AddressCombo is a combobox and is spelt correctly and I am not referencing another control on another form. I am using access 97 could that attribute, although on the help files additem method is listed. i.e. syntax expression.AddItem(Text, Index) expression . An expression that returns a...

Hi, Thanks again but I get an error when I enter addresscombo.additem rs.fields("A1") inside the loop, i get error compile error: method or data member not found, highlighting the additem part. Any ideas? M-.

Hi, Thanks for the reply, I have been trying to use recordsets to build the rowsource, this is what i have so far: strSql = "Select A1 From Address Where A4 = '" & Forms!DOMESTIC!EnterPostcode & "' ;" ' Open recordset Set db = DBEngine(0)(0) Set rs = db.OpenRecordset(strSql...

Hi all, I want to populate a combobox recordsource with a query result, by using recordsets. I have done this using a query but is too slow. Me.AddressCombobox.RowSourceType = "Table/Query" Me.AddressCombobox.RowSource = "SELECT DISTINCTROW [Query3].[field1] FROM [Query3];" The user enters a...

I thought they were because i had my Form2 unbound and the dlookup called the fields, I guess I may have got the illusion of speed? However i have bound the form as you suggested PH and done something similar to Remou's code it works and does not appear to be too slow thanks again, M-.

Thanks for the reply PH, the thing is the form will be used when a enquier phones, the user then enters his details and adds record to table, but before this happens the user enters the enquier postcode if it exist a command button is activated and the user can view his/her details. Now the...

Hi guys, I have 2 forms say form1 and form2. Now in form1 the user enters a code in a textbox say EnterCodeTxt, now if that record is already present in a table say table1 then a command box is activated and the user can press it to view the existing record. The command box opens form2 and some...

Hi, Try something along these lines: Hi, Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me![Days outstanding] > 120 Then Me![Days outstanding].ForeColor = vbRed Else if Me![Days outstanding] < 120 And >= 90 then Me![Days...

Thanks PH, it did the job, M-.[thumbsup2]

Thanks for the reply PH, I will give it a go tomorrow and get back to you if it worked, Looks like what i am looking for though, M-.

Sorry for poor explanation; field1 = STRD, Field2 = STR, Field3 = Locdd, Field4= Locd M-.

Hi Guys, I Can't seem to get my IIF statement correct i am working with 4 fields Say field1, field2, field3, field4. What i want to do is display field1 and field2 together seperated by a comma if both are not null and field3 or field4 are not null, if field1 is not null and both field3 and...

can you paste your query, or explain how many fields you wish to show with your query result, M-.