Search results

Thanks everyone. I'd done a mockup using double-click to activate Zoom, but my couple of tame test users didn't really get it. They found the full text appearing below much more intuitive, and liked that they could see the full text without having to do anything like double click. I'd done...

Short version: Is there a way to check if the contents of a field fit in a textbox which is bound to that field? Or is it just a matter of estimating how many characters would normally be visible in the textbox, and checking the length of the field? Long version: I have a subform in continuous...

Update: The acDialog seems not to set the forms .modal or .popup properties. Having opened the form using acDialog, me.modal and me.popup still evaluate as False. OpenArgs seems the easiest way to accomplish what I want. Thanks again.

Excellent. Many thanks to you both. The openargs idea had occurred to me in another context, but I'd not followed it through, so that will be very useful too.

Here's the situation: User can type into a Enter Company Name combobox. If there's a match, the match is displayed. If there isn't a match, a NotInList event asks them if they want to add a new company. So far, so good. If they say yes, frm_companies opens using DoCmd.OpenForm...

Thanks! I hate Null ;):D

I have a table as follows WorkorderListID Workorder Workorder_Name Wo_Status All Short Text, except WorkorderListID which is autonumbered. Wo_Status contains one of two entries: N or C Running the following query, I noticed that one expected record was not being returned. This...

Thanks Ranman256, That was the prompt I needed. Here's what I've come up with and on a quick initial test, it seems to be working Private Sub cboFindOrganisationName_Change() Dim strAllRecords As String Dim strFilteredRecords As String Dim strMultiPart() As String Dim...

I have implemented a search-as-you-type function on a combobox on a form displaying company details, so that a user can can start typing an organisation's name and get a drop down of matches, from which they can pick the one they want, and that organisations details are displayed. That works...

Returning to database design after a break, and slowly coming to terms with Access2016. I started programming in the youth of personal computing in the UK with the Grundy NewBrain. Anyone remember that? It had a massive 32Kb memory and a built in LED display that could show about 16...