Search results

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...

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 '" &...

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...

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

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

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...

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...

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...

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 (...

No Dice man ! Same error

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:

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...

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.

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.

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:

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...

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...

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...

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...

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.