Re: Populating ComboBox

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Feb 1, 9:19 pm, "Jeff Johnson" <i...@xxxxxxxxxxx> wrote:
<r...@xxxxxxxxxxxxxx> wrote in message

news:1170345948.684381.316930@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

But when I select an item from the ComboBox, then I get a 'Unspecified
error' which points to this line in the OnClick event function of the
ComboBox:

objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
App.Path & "/DB/MyTable.mdb"

Try using backslashes ( \ ) in the path name instead of the slashes ( / )
you currently have.

No...Jeff....that doesn't make any difference....I still get that
error.

What I find surprising is the MsgBox (bnBusy) is not even in any loop;
so what's causing the MsgBox line to fire more than 60 times!!

Any other ideas/suggestions?

.

Relevant Pages

  • Re: Populating ComboBox
    ... bnBusy = False ... the ComboBox so that I can see the records of a particular UserName, ... 'entire code of the OnClick event function of the ComboBox ... MsgBox does say 'False' correctly but it appears more than 60 times ...
    (microsoft.public.vb.general.discussion)
  • Re: Filtern im UFO klappt nicht
    ... Me!heuteKat.Form.FilterOn = True ... Argument ist der Name der ComboBox. ... Ich habe MsgBox Me!argument hinter den Aufruf ..Filteron = True eingefügt. ... Private Sub argument_AfterUpdate ...
    (microsoft.public.de.access)
  • Re: If statement for a combo box
    ... selection in the combobox by testing for any lenght of text. ... selection in the combo box) into where you have MsgBox "Something". ... Jim Thomlinson Wrote: ... Amber:confused: ...
    (microsoft.public.excel.programming)
  • Re: Msgbox delayed using AFTERUPDATE
    ... comment out the msgbox code. ... I tested a combobox with and without ... > I have numerous other afterupdates that kick in as soon as the user ... > I click on a selection (Yes/No_ like all the others do. ...
    (microsoft.public.excel.programming)
  • Re: Filtern im UFO klappt nicht
    ... Me!heuteKat.Form.FilterOn = True ... Argument ist der Name der ComboBox. ... Ich habe MsgBox Me!argument hinter den Aufruf ..Filteron = True eingefügt. ... Private Sub argument_AfterUpdate ...
    (microsoft.public.de.access)