Re: Populating ComboBox

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Try single stepping through the Click event to see where the execution is
just after the event ends, that should tell you what is calling it. There is
probably something setting the ListIndex property.
Also in addition to what Jeff said, you should ALWAYS test App.Path for a
backslash because if the application is in a root folder (easy if in a USB
stick or a mapped drive) App.Path will already have the backslash so you end
up with 2 of them and a certain error.
i.e.:
dim s as string
s = App.Path
if Right$(s,1) <> "\" then s = s & "\"
s = s & "\DB\MyTable.mdb"

I don't use that method of interacting with databases so I really cant help
you with that, try posting a question in the microsoft.public.vb.databases
forum.

Regards
Dave O.

<rn5a@xxxxxxxxxxxxxx> wrote in message
news:1170347656.760384.302730@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: Strange behaviour
    ... I am calling the program over and over again ... ... > MsgBox LogFilePathName ... > the log file is updated, ...
    (microsoft.public.vb.winapi)
  • Re: Can I have a temporary message window appear during code execution
    ... MsgBox is modal in nature, so will stop execution until dismissed. ... If .FilterMode = True Then ... With Sheets("Open Transactions by Member ID") ...
    (microsoft.public.excel.programming)
  • RE: Numbering subrecords
    ... Maybe something in my execution? ... I enter the title field in the Criteria ... and throws a type mismatch. ... msgbox ...
    (microsoft.public.access.modulesdaovba)
  • Re: Is it possible to raise a classe event from outside the class?
    ... during processing the message would hang the sender, including calling ... RaiseEvent if the event has code that blocks, like MsgBox. ... to delegate the processing using a timer or a custom message. ...
    (microsoft.public.vb.general.discussion)
  • Re: How to use WaitforSingleObject on events
    ... msgbox "In Processor_Done" shows up. ... Private Sub Button1_Click(ByVal sender As System.Object, ... hasn't occured a second time. ... I assume that the event can not occur prior to calling Processor.Control_Update. ...
    (microsoft.public.dotnet.languages.vb)