Search results

  1. L

    Dynamically 'fill' a combo box ?

    You're quite right, I didn't explain very well. I'll put it in logical steps, which should simplify my plan. 1. When form is loaded, combo is loaded with Client info ( same fields as in my select statement ) BUT ALL RECORDS - in this case about 1200 i.e unfiltered. 2. When user types it DOES...
  2. L

    Dynamically 'fill' a combo box ?

    The following code executes on the 'Key_Up' event of a combo box. Private Sub cboClients_KeyUp(KeyCode As Integer, Shift As Integer) strSQL = "SELECT tblClients.Client_ID, tblClients.Forename, tblClients.Surname, tblClients.DOB " & _ "FROM tblClients " & _ "WHERE (((tblClients.Surname) Like '" &...
  3. L

    NONE of Form_Current event code executing ?

    No problem. The difficulty with apparently succinct and confident 'solutions' ( without any questions obviously ) is they can come across as being provided with an absolute certainty that it will solve an issue - fine obviously when that is the case - but it's fair to say, that wasn't the case...
  4. L

    NONE of Form_Current event code executing ?

    Thank you for your interest and advice. Both you and BobLarson.
  5. L

    NONE of Form_Current event code executing ?

    It's the thread that you've responded to. i.e this one.
  6. L

    NONE of Form_Current event code executing ?

    I'm genuinely pleased for you rodmc ( it must make development easier than it might otherwise be ) , but like vbaInet, I'm a mere mortal and prone to make mistakes ( it was a general point, which I thought had been covered in the description - as it transpired a reasonable one ) I'm 'back up and...
  7. L

    NONE of Form_Current event code executing ?

    Well I'll try- good thinking ... P.S. vbaInet were you 'clutching at straws' with your confident-sounding response ? It's not that - and as I say, I made no changes to the code ! Certainly not something as fundamenatl as that ! Check your normal sub-routines' main or key events. They are, or...
  8. L

    NONE of Form_Current event code executing ?

    Hello. I've got a Form_Current event that was working perfectly ( which fires for a new record selected, on my main 'Clients' form ). I changed no code, but am now getting 'User-defined type not defined', and NONE of the code is executing ( I've tested with a message box, as the first line after...
  9. L

    #Name? error on Form Load.

    No - as you can probably imagine, they're key fields on a main form of a Client recordset. I've not changed anything. Interestingly, I began getting these when creating a custom ribbon. Along with this, I got on another form outputting just ######## on a Date() output on initial log-in screen (...
  10. L

    #Name? error on Form Load.

    No Dice man ! Same error
  11. L

    #Name? error on Form Load.

    I'm getting the above '#Name?' error, in the Header section, when it worked perfectly well before. It takes the info. from 2 text boxes on main form for Forename and Surname as the syntax shows - i.e. =[txtForename]+" "+[Surname] Any ideas ?:confused::confused:
  12. L

    How does the On_Change event work ( Edit Box on ribbon ) ?

    I've customised my ribbon, with an editBox control called Clients. I'd like it to fire an event ( On_Change, Key_Up ? ) every time I add/change a letter which will create a string dynamically, to use as a WHERE search criteria ,for an SQL SELECT statement i.e filter the records for a given...
  13. L

    Question missing or broken reference to the file 'MSOUTL.OLB' version 9.2."

    I got exactly the same issue - well, version 9.4 not 9.2 ( shortly after customising my ribbon using XML and changing settings ? ) but I'm gonna look at this 'Late Binding' solution. If it works, it looks ideal. Wish me luck.
  14. L

    Navigation Buttons - can I 'Disable' them temporarily in code ?

    Nope ! In fact Intellisense provides 'Me.Recordselectors ( i.e plural ) and then typing = ( options are True or False ), but these don't work nor setting it to 0.
  15. L

    Navigation Buttons - can I 'Disable' them temporarily in code ?

    I have a Record selector on my main form ( not surprising !) I'd like to make this 'unusable' while editing/adding data in my subform. Possible ?:confused:
  16. L

    AlternateBackColor ( datasheet view ) problem

    Hi. Experimenting with setting, the above property programatically ( as you do... ) in Load event of a subfrom, it turned every other row Jet Black, obscuring everything in these rows. I have taken out the 'offending' code, but to no avail. I've deleted, and reset new subfrom on Mainform, but it...
  17. L

    'Item not found in this collection' error ( recordset ) /

    Fret not my erudite and helpful friend. I have seen what is causing this difficulty. The sub-routine which opens the form I refer to, also edits and updates a couple of fields, before doing so. I then set the recordsource AGAIN of my subform, and requery ( to reflect the update ) However, this...
  18. L

    'Item not found in this collection' error ( recordset ) /

    No. This code is in the Unload event of a form which was opened by the subform and its recordset referred to i.e. 'Forms!frmAfAISLIVE!sfrmReferrals.Form.Recordset' here's the logic. 1. An 'After_Update' event of a field on the subform ( sfrmReferals ) opens a form. 2. This newly opened form has...
  19. L

    'Item not found in this collection' error ( recordset ) /

    Certainly. her it is. Private Sub Form_Unload(Cancel As Integer) Dim ctlSource As Control Dim CurrentItem As Integer Me.cboRefSource.SetFocus If Me.cboRefSource.Text = "" Then frm_close Else With Forms!frmAfAISLIVE!sfrmReferrals.Form.Recordset .MoveLast .Edit...
  20. L

    'Item not found in this collection' error ( recordset ) /

    I should point out - that two other fields ( in similar Sub Proc's ) are generating the same error, during the .Edit and .Update routine. This might be significant, but I can't think why at the moment.
Back
Top Bottom