Re: Problem with .properties("...")

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



Bob,

"Steve Richfie1d" <Steve@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3lsvguF14ck8aU1@xxxxxxxxxxxxxx

            XlateControlProperty Frm, Frm.Properties("Caption")

This logic worked GREAT in Access 97, but seems to be falling on its
face in VB5.

Any ideas what is going haywire here?


VB and VBA are not the same especially when it comes to forms and controls.
VB controls don't support a Propeties collection like that.

But, when I highlight "Properties" in the statement above, VB brings up the DAO page on Properties just like I was in Access!


I think that you are saying that there are Access Form and Control Properties that do NOT carry over to VB, and then there are DAO Properties that DO carry over to VB. Working with an object variable where VB doesn't know what the object is until execution time, I get the nastygram because it is NOT a DAO Property. Right?

This is going to TRASH much of by otherwise simplistic code to switch between languages on-the-fly. There is a list box on the main form where if you select a different language, everything changes languages on all forms, etc. This is accomplished by going through all of the relevant properties of all of the forms - something that will be MUCH more difficult without the VB Properties property.

Note that it is easy to get the VALUE of a VB property - the challenge is getting that property as an object that can be passed around, modified, etc.

Any ideas on how to do this or something like it in VB?

Thanks for the help.

Steve Richfie1d


.



Relevant Pages

  • Alter External Access Forms in DAO
    ... Does anyone know how to modify the contents (ie. controls, ... properties etc) of an external MS Access form, ... current access database using DAO? ... OpenCurrentDatabase but I have a need for do this in DAO. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Laufzeitfehler 3426, Diese Aktion wurde durch ein zugeordnetes Objekt abgebrochen.
    ... Solltest Du dagegen mit DAO arbeiten, dann brauchst Du ein DAO-DataControl ... (Data), wenn Du z.B. mit gebundenen Textboxen uws. ... wenn man die Datenströme von beiden Controls ...
    (microsoft.public.de.vb.datenbank)
  • Re: DB Listbox Issues. Help!
    ... It is so much simpler to set a reference to ADO or DAO and populate your controls with code. ... Dim RS as RecordSet ...
    (microsoft.public.vb.controls)
  • Re: A2000 & A2003
    ... Microsoft DAO 3.6 Object Library ... It is also not wise to mix DAO with ActiveX when dealing with mixed versions of Access ... You also need to check the versions of the other libraries you may have loaded. ... Create a form with only one control, then go through each of the controls until you find the one that crashes. ...
    (comp.databases.ms-access)
  • Re: Internatinalization and multiple language support without resource DLLs
    ... languages were supported...as I indicated, I did this 12 years ago, which predates the W2K ... controls I never use DBUs, ... Every single element that you find in resources is potentially ... With some tools the ease of use can be there even for resource dlls. ...
    (microsoft.public.vc.mfc)