Re: Foreign Language in Menu items

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Wed, 3 Dec 2008 20:46:02 -0800, Frank Situmorang <hfsitumo2001@xxxxxxxxx> wrote:

Mike:

Further to my previous email, I have tried to understand the table and the
VBA. I can make the table's fields with their primary key, but I do not know
where is the CHECK (In ('Caption','ControlTipText'). Is it
('Caption','ControlTipText') to be typed in lookup tab of the field property?.

The other thing is the VBA Public Sub LanguageControls() a module? not part
of the form VBA?

Thanks for your advice

Public Sub LanguageControls() should go in a module. One thing to keep in mind is that this code
opens forms in Design View. I think this can only be done in a .mdb file, not in a .mde file.

The In("Caption", "ControlTipText") is a Validation Rule on the column CtrlProperty.
.

Relevant Pages

  • Re: Foreign Language in Menu items
    ... understand how the primary key could duplicate data in it. ... I can make the table's fields with their primary key, ... The other thing is the VBA Public Sub LanguageControls() a module? ... I think this can only be done in a .mdb file, ...
    (microsoft.public.access.formscoding)
  • Re: From VB .Net, how obtain ref to Access project?
    ... Essentially, I'm trying to do in VB .Net what is done in VBA under Access, ... I see the commands in the VB ... get the commands to talk to the approrpiate .mdb file. ... > Beyond that, you're mixing automation and data access, which are really two ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Run-time error 94 Invalid use of Null
    ... "Form_Load" in the code you posted indicates VB6, not VBA. ... MDB file, do not open it in MS Access before making a backup. ... sure that you don't convert the file format and that you have a backup. ...
    (microsoft.public.vb.general.discussion)
  • Re: Upsizing .mdb for split DB
    ... the queries from another .mdb file. ... The forms, reports, VBA etc. would ... Server back-end. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Moving backend to secure folder
    ... It wasn't used in VBA module code. ... post on how one might get Access to compact a back-end database ... COM automation to have Access compact an MDB file to a temporary ...
    (comp.databases.ms-access)