FormDefinir, imagen del formulario
Uso: es la pantalla que permite al operador diseñar un formulario, colocando cuales ventanas aparecerán y asignando los nombres de variable y nombre de documento, también permite editar (corregir) plantillas ya existentes
FormDefinir |
Dim combo1(3), combo2(3), combo3(3), combo4(3) Private Sub CommandButton3_Click() GRABAR Unload FormDefinir End Sub Private Sub Image5_Click() Unload FormDefinir End Sub Private Sub listBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) ListBox1.Visible = False Close posicion = ListBox1.ListIndex + 2 Open archconf For Random As 1 Len = largoC Get 1, posicion, conf TextBox1.Text = conf.Label1 TextBox2.Text = conf.Label2 TextBox3.Text = conf.Label3 TextBox4.Text = conf.Label4 TextBox5.Text = conf.Label5 TextBox6.Text = conf.Label6 TextBox7.Text = conf.Label7 TextBox8.Text = conf.Label8 TextBox9.Text = conf.Label9 TextBox10.Text = conf.Label10 TextBox11.Text = conf.nombre TextBox13.Text = conf.varrep1 TextBox14.Text = conf.varrep2 TextBox15.Text = conf.comb11 TextBox16.Text = conf.comb12 TextBox17.Text = conf.comb13 TextBox18.Text = conf.comb21 TextBox19.Text = conf.comb22 TextBox20.Text = conf.comb23 TextBox21.Text = conf.comb31 TextBox22.Text = conf.comb32 TextBox23.Text = conf.comb33 TextBox24.Text = conf.comb41 TextBox25.Text = conf.comb42 TextBox26.Text = conf.comb43 TextBox27.Text = conf.var1 TextBox28.Text = conf.var2 TextBox29.Text = conf.var3 TextBox30.Text = conf.var4 TextBox31.Text = conf.var5 TextBox32.Text = conf.var6 TextBox33.Text = conf.var7 TextBox34.Text = conf.var8 TextBox35.Text = conf.var9 TextBox36.Text = conf.var10 If conf.ftribunal = "1" Then CheckBox1.Value = True End If If conf.fciudad = "1" Then CheckBox2.Value = True End If If conf.fjuez = "1" Then CheckBox3.Value = True End If If conf.fsecretario = "1" Then CheckBox4.Value = True End If End Sub Private Sub CommandButton1_Click() If TextBox11 = "" Then Exit Sub Close Open archconf For Random As 1 Len = largoC Rem leer el indice, incrementar y grabarlo Get 1, 1, conf ultimo = Val(conf.nombre) If Val(ultimo) = 0 Then ultimo = 1 ultimo = ultimo + 1 conf.nombre = ultimo Put 1, 1, conf Rem puntero almacena la posicion donde debe grabarse el nuevo registro posicion = ultimo + 1 Close GRABAR Unload FormDefinir End Sub Sub GRABAR() Close Open archconf For Random As 1 Len = largoC conf.Label1 = UCase(TextBox1.Text) conf.Label2 = UCase(TextBox2.Text) conf.Label3 = UCase(TextBox3.Text) conf.Label4 = UCase(TextBox4.Text) conf.Label5 = UCase(TextBox5.Text) conf.Label6 = UCase(TextBox6.Text) conf.Label7 = UCase(TextBox7.Text) conf.Label8 = UCase(TextBox8.Text) conf.Label9 = UCase(TextBox9.Text) conf.Label10 = UCase(TextBox10.Text) conf.nombre = UCase(TextBox11.Text) conf.varrep1 = UCase(TextBox13.Text) conf.varrep2 = UCase(TextBox14.Text) conf.comb11 = UCase(TextBox15.Text) conf.comb12 = UCase(TextBox16.Text) conf.comb13 = UCase(TextBox17.Text) conf.comb21 = UCase(TextBox18.Text) conf.comb22 = UCase(TextBox19.Text) conf.comb23 = UCase(TextBox20.Text) conf.comb31 = UCase(TextBox21.Text) conf.comb32 = UCase(TextBox22.Text) conf.comb33 = UCase(TextBox23.Text) conf.comb41 = UCase(TextBox24.Text) conf.comb42 = UCase(TextBox25.Text) conf.comb43 = UCase(TextBox26.Text) conf.var1 = UCase(TextBox27.Text) conf.var2 = UCase(TextBox28.Text) conf.var3 = UCase(TextBox29.Text) conf.var4 = UCase(TextBox30.Text) conf.var5 = UCase(TextBox31.Text) conf.var6 = UCase(TextBox32.Text) conf.var7 = UCase(TextBox33.Text) conf.var8 = UCase(TextBox34.Text) conf.var9 = UCase(TextBox35.Text) conf.var10 = UCase(TextBox36.Text) If CheckBox1.Value = True Then conf.ftribunal = "1" If CheckBox2.Value = True Then conf.fciudad = "1" If CheckBox3.Value = True Then conf.fjuez = "1" If CheckBox4.Value = True Then conf.fsecretario = "1" Put 1, posicion, conf Close End Sub Private Sub CommandButton2_Click() CommandButton1.Visible = False CommandButton3.Visible = True ListBox1.Visible = True ListBox1.Clear Close Open archconf For Random As 1 Len = largoC Get 1, 1, conf ultimo = Val(conf.nombre) For z% = 2 To ultimo + 1 Get 1, z%, conf ListBox1.AddItem Str(z%) + " " + conf.nombre Next z% End Sub Private Sub UserForm_Initialize() ListBox1.Visible = False End Sub |