Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Modules / DAO / VBA / February 2006

Tip: Looking for answers? Try searching our database.

Strange Error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kou Vang - 02 Feb 2006 21:06 GMT
What do I make of the error, when Access doesn't appear to recognize the
".additem"?  Do I use ItemSelected somehow?
Alex Dybenko - 03 Feb 2006 14:11 GMT
Hi,
perhaps you post code, which cause this error

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> What do I make of the error, when Access doesn't appear to recognize the
> ".additem"?  Do I use ItemSelected somehow?
Kou Vang - 03 Feb 2006 16:09 GMT
It's as simple as this:

   Dim V As Variant
   Dim I As Integer
   Dim Fname As String
   Dim F

       V = GetFiles
           
           If Not IsEmpty(V) Then
               For I = 0 To UBound(V)
                   Fname = StrReverse(Split(StrReverse(V(I)), "\", 2)(0))
               
                   LstXlsFiles.AddItem Item:=Fname
               Next I
                       
           End If

It works on my machine as is always the case, and bombs on others.  Thanks.

> Hi,
> perhaps you post code, which cause this error
>
> > What do I make of the error, when Access doesn't appear to recognize the
> > ".additem"?  Do I use ItemSelected somehow?
Alex Dybenko - 04 Feb 2006 10:19 GMT
Hi,
and what error do you get?

Do you have same access version on both PCs?

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> It's as simple as this:
>
[quoted text clipped - 23 lines]
>> > the
>> > ".additem"?  Do I use ItemSelected somehow?
Kou Vang - 06 Feb 2006 21:29 GMT
Yes, I have 2002, meaning versions 2000 and earlier do not have additem and
cannot read this.  I have read that there is no workaround this.  If I cannot
use the additem, how am I to get data into the listboxes?

> Hi,
> and what error do you get?
[quoted text clipped - 28 lines]
> >> > the
> >> > ".additem"?  Do I use ItemSelected somehow?
Alex Dybenko - 07 Feb 2006 14:54 GMT
Hi,
you can use this code:
http://alexdyb.blogspot.com/2005/11/additem-and-removeitem-for-listboxes.html

for me it works fine in any access version

Signature

Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Yes, I have 2002, meaning versions 2000 and earlier do not have additem
> and
[quoted text clipped - 35 lines]
>> >> > the
>> >> > ".additem"?  Do I use ItemSelected somehow?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.