Publicado el 18 comentarios

Importando productos desde excel


'código de la forma PRODSEXCEL (utilizado en el Ambiente de Desarrollo)
Sub Form_load

Me.Caption = “Importando desde Excel(tm)”
Archivo.File = Ambiente.Path & “\articulos.xls”

End Sub

Sub Button_Click()

Select Case ControlEvento.Tag
Case “Aceptar”

AplicaInventario
DescargaForma

Case “Cancelar”

DescargaForma

Case “cmdButton2”

ShellRun Parent.hWnd, “Open”, Archivo.File

End Select

End Sub

Sub AplicaInventario

Set excelConnection = CreateObject(“ADODB.Connection”)
excelConnection.ConnectionString = “driver={Microsoft Excel Driver (*.xls)};DBQ=” & Controles(“Archivo”).File
excelConnection.Open

ImportaInventario excelConnection

End Sub

Sub ImportaInventario( excelConnection )
Dim rstProductos
Dim bolAfectaInventario
Dim rstArticulo
Dim rstClaveAdd
Dim Articulos
Dim Ajuste
Dim rstImpuesto

Ambiente.Connection.Execute “UPDATE prods SET etiquetas = 0”

bolAfectaInventario = True

‘——————————————————————————————————————–
‘2011_11_22 Jose Felix jofelchez@gmail.com
‘Agregamos las Lineas a la Importación

Set rstExcel = CreaRecordSet( “SELECT linea FROM [ARTICULOS$] group by linea”, (excelConnection ) )
Set Query = NewQuery()
Set Query.Connection = Ambiente.Connection
While Not rstExcel.EOF

Set rstLinea = CreaRecordSet( “SELECT * FROM lineas WHERE Linea = ‘” & rstExcel(“Linea”) & “‘”, Ambiente.Connection )

Query.Reset

If rstLinea.EOF Then
Query.strState = “INSERT”
Else
Query.strState = “UPDATE”
Query.Condition = “linea = ‘” & rstExcel(“linea”) & “‘”
End If

Query.AddField “lineas”,”linea”, rstExcel(“Linea”)
Query.AddField “lineas”,”descrip”,rstExcel(“Linea”)
Query.AddField “lineas”,”Usuario”, Ambiente.Uid
Query.AddField “lineas”,”usuFecha”, Date
Query.AddField “lineas”,”usuHora”,Formato( Time, “hh:mm:ss” )
Query.AddField “lineas”,”Numero”, 0

Query.CreateQuery
Query.Execute

Query.Reset

rstExcel.MoveNext
Wend

‘——————————————————————————————————————–

Set rstProductos = CreaRecordSet( “SELECT * FROM [ARTICULOS$]”, (excelConnection ) )
Set Query = NewQuery()
Set Query.Connection = Ambiente.Connection

Set Articulos = CreateObject( “MyBArticulos.Articulos” )
Set Articulos.Ambiente = Ambiente

nEntrada = 0
nSalida = 0

While Not rstProductos.EOF

If Not clEmpty( “” & (rstProductos(“Código del producto”)) ) Then
If Not clEmpty( “” & (rstProductos(“Descripción”)) ) Then

Articulos.recalculoDeInventario rstProductos(“Código del producto”), Ambiente, False
Set rstArticulo = CreaRecordSet( “SELECT articulo, existencia FROM prods WHERE articulo = ‘” & rstProductos(“Código del producto”) & “‘”, Ambiente.Connection )

Query.Reset

If rstArticulo.EOF Then
Query.strState = “INSERT”
Else
Query.strState = “UPDATE”
Query.Condition = “articulo = ‘” & rstProductos(“Código del producto”) & “‘”
End If

Query.AddField “prods”,”articulo”, rstProductos(“Código del producto”)
Query.AddField “prods”,”descrip”,rstProductos(“Descripción”)
Query.AddField “prods”,”linea”, rstProductos(“Linea”)
Query.AddField “prods”,”marca”, “SYS”
Query.AddField “prods”,”fabricante”, “SYS”
Query.AddField “prods”,”precio1″, FDec( rstProductos(“Precio de venta”) )
Query.AddField “prods”,”costo_u”, FDec( rstProductos(“Costo ultimo”) )
Query.AddField “prods”,”etiquetas”, Val2( rstProductos(“Existencia”) )
Query.AddField “prods”,”Unidad”, rstProductos(“Unidad”)
Query.AddField “prods”,”precio2″, FDec( rstProductos(“Precio2”) )
Query.AddField “prods”,”precio3″, FDec( rstProductos(“Precio3”) )
Query.AddField “prods”,”precio4″, FDec( rstProductos(“Precio4”) )
Query.AddField “prods”,”precio5″, FDec( rstProductos(“Precio5”) )

If Val2(rstProductos(“Impuesto”)) > 0 Then
Set rstImpuesto = CreaRecordSet( “SELECT * FROM impuestos WHERE valor = ” & _
FDec( rstProductos(“Impuesto”) ), Ambiente.Connection )
Else
If ClAt(“0”, Trim(rstProductos(“Impuesto”))) > 0 AND Len(Trim(rstProductos(“Impuesto”))) = 1 Then
Set rstImpuesto = CreaRecordSet( “SELECT * FROM impuestos WHERE valor = ” & _
FDec( rstProductos(“Impuesto”) ), Ambiente.Connection )
Else
Set rstImpuesto = CreaRecordSet( “SELECT * FROM impuestos WHERE impuesto = ‘” & _
rstProductos(“Impuesto”) & “‘”, Ambiente.Connection )
End If
End If

If rstImpuesto.EOF Then
cImpuesto = “SYS”
Else
cImpuesto = rstImpuesto( “impuesto” )
End If

Query.AddField “prods”,”impuesto”, cImpuesto
Query.AddField “prods”,”paraventa”, 1
Query.AddField “prods”,”invent”, 1
Query.CreateQuery
Query.Execute

Query.Reset

If Not IsNull( rstProductos(“Existencia”) ) Then

Ajuste = FDec( rstProductos(“Existencia”) )’ – Val2( rstArticulo(“Existencia”) )
AfectandoInventario rstProductos(“Código del producto”), Ajuste
Articulos.recalculoDeInventario rstProductos(“Código del producto”), Ambiente, False

If Ajuste <> 0 Then
If Ajuste > 0 Then
nEntrada = CreaEntrada( nEntrada, rstProductos(“Código del producto”), Ajuste, FDec( rstProductos(“Costo ultimo”) ), rstProductos(“Descripción”) )
Else
nSalida = CreaSalida( nSalida, rstProductos(“Código del producto”), Ajuste, FDec( rstProductos(“Precio de venta”) ), rstProductos(“Descripción”) )
End If
Else
Query.Reset
Query.SQL = “UPDATE prods SET costo_u = ” & FDec( rstProductos(“Costo ultimo”) ) & _
” WHERE articulo = ‘” & rstProductos(“Código del producto”) & “‘”
Query.Execute
End If

End If

If Not clEmpty( “” & rstProductos(“Código de barras”) ) Then

Set rstClaveAdd = CreaRecordSet( “SELECT clave FROM clavesadd WHERE clave = ‘” & rstProductos(“Código de barras”) & “‘”, Ambiente.Connection )

Query.Reset

If rstClaveAdd.EOF Then
Query.strState = “INSERT”
Else
Query.strState = “UPDATE”
Query.Condition = “clave = ‘” & rstProductos(“Código de barras”) & “‘”
End If

Query.AddField “clavesadd”,”Clave”, rstProductos(“Código de barras”)
Query.AddField “clavesadd”,”Dato1″, “”
Query.AddField “clavesadd”,”Usuario”, Ambiente.Uid
Query.AddField “clavesadd”,”usuFecha”, Date
Query.AddField “clavesadd”,”usuHora”, Formato( Time, “hh:mm:ss” )
Query.AddField “clavesadd”,”Dato2″, “”
Query.AddField “clavesadd”,”Articulo”, rstProductos(“Código del producto”)
Query.AddField “clavesadd”,”Cantidad”, 1
Query.AddField “clavesadd”,”Unidad”, “”

If bolAfectaInventario = True Then
Query.AddField “clavesadd”,”Existencia”, 0
End If

Query.AddField “clavesadd”,”Libre”, 0
Query.AddField “clavesadd”,”Exportado”, 0
Query.AddField “clavesadd”,”Precio”, 0
Query.AddField “clavesadd”,”imagen”, “”
Query.AddField “clavesadd”,”etiquetas”, 0
Query.CreateQuery
Query.Execute

End If

End If
End If

Detalle.Caption = “” & rstProductos(“Descripción”)

rstProductos.MoveNext
Wend

MyMessage “Catálogo importado”

If Question( “Desea imprimir etiquetas de codigo de barras”, 1 ) = True Then

Script.RunProcess “ZEBRA2844”, Me, Ambiente

End If

End Sub

Sub AfectandoInventario( strArticulo, Existencia )
Dim rstProd
Dim n
Dim Query
Dim rstInvInicial

Set Query = NewQuery()
Set Query.Connection = Ambiente.Connection

Set rstProd = CreaRecordSet( “SELECT articulo, existencia, costo_u FROM prods WHERE articulo = ‘” & strArticulo & “‘”, Ambiente.Connection )
n = n + 1

If Existencia = 0 Then
Exit Sub
End If

Set MovInv = CreateObject( “MyBInventario.Inventario” )
Set MovInv.Ambiente = Ambiente

MovInv.FechaMov = Date
MovInv.uId = Me.Ambiente.uId
MovInv.EntradaSalida = “S”
MovInv.cMetodo = Me.Ambiente.costeo
MovInv.EstacionSalida = Trim(Ambiente.Estacion)

While Not rstProd.EOF

n = n + 1

Query.Reset
Query.strState = “INSERT”
Query.AddField “movsinv”,”MOVIMIENTO”, 1

If Existencia > 0 Then
MovInv.EntradaSalida = “E”
MovInv.nMovimiento = 1
MovInv.TipoMovim = “EX+”
MovInv.NoMovim = 1
MovInv.TipoOperacion = “EX+”
MovInv.nCantidad = Existencia
MovInv.AfectaCosto = True
Else
MovInv.EntradaSalida = “S”
MovInv.nMovimiento = 1
MovInv.TipoMovim = “EX-”
MovInv.NoMovim = 1
MovInv.TipoOperacion = “EX-”
MovInv.nCantidad = Existencia * -1
End If

MovInv.nPrecio = rstProd(“costo_u”)
MovInv.nAlmacen = 1
MovInv.cArticulo = strArticulo
MovInv.AfectaInventario

Set rstInvInicial = CreaRecordSet( “SELECT * FROM invinicial WHERE articulo = ‘” & rstProd(“articulo”) & “‘”, _
Ambiente.Connection )

If rstInvInicial.EOF Then
Query.Reset
Query.strState = “INSERT”
Query.AddField “invinicial”,”fecha”, DateSerial( 2000, 01, 01 )
Query.AddField “invinicial”,”articulo”, rstProd(“articulo”)
Query.AddField “invinicial”,”existencia”, Existencia
Query.AddField “invinicial”,”costo”, rstProd(“costo_u”)
Query.CreateQuery
Query.Execute
End If

rstProd.MoveNext

Wend

End Sub

Function FDec( Number )

FDec = Replace( “” & Number, “,”, “.” )

End Function

Function CreaEntrada( Entrada, Articulo, Cantidad, Costo, Descripcion )
Dim Query
Dim rstArticulo

Set Query = NewQuery()
Set Query.Connection = Ambiente.Connection

If Entrada = 0 Then
Query.Reset
Query.strState = “INSERT”

Entrada = TraeSiguiente( “MovEnt”, Ambiente.Connection )
Query.AddField “entradas”, “entrada”, Entrada
Query.AddField “entradas”, “ocupado”, 1
Query.AddField “entradas”, “f_emision”, Date
Query.AddField “entradas”, “tipo_doc”, “EX+”
Query.AddField “entradas”, “importe”, 0
Query.AddField “entradas”, “costo”, 0
Query.AddField “entradas”, “almacen”, 1
Query.AddField “entradas”, “estado”, “CO”
Query.AddField “entradas”, “observ”, vbNullString
Query.AddField “entradas”, “tipo_cam”, 1
Query.AddField “entradas”, “moneda”, Ambiente.Moneda
Query.AddField “entradas”, “datos”, vbNullString
Query.AddField “entradas”, “usuario”, Ambiente.uId
Query.AddField “entradas”, “usufecha”, Date
On Error Resume Next
Query.AddField “entradas”, “usuhora”, Libreria.Formato(Time, “hh:mm:ss”)
On Error GoTo 0
Query.CreateQuery
Query.Execute
End If

Query.Reset
Query.strState = “INSERT”
Query.AddField “entpart”,”ENTRADA”, Entrada
Query.AddField “entpart”,”TIPO_DOC”, “EX+”
Query.AddField “entpart”,”NO_REFEREN”, Entrada
Query.AddField “entpart”,”ARTICULO”, Articulo
Query.AddField “entpart”,”CANTIDAD”, Cantidad
Query.AddField “entpart”,”PRECIO”, Costo
Query.AddField “entpart”,”OBSERV”, Descripcion
Query.AddField “entpart”,”PARTIDA”, 0
Query.AddField “entpart”,”ID_ENTRADA”, TraeSiguiente( “entpart”, Ambiente.Connection )
Query.AddField “entpart”,”Usuario”, Ambiente.Uid
Query.AddField “entpart”,”UsuFecha”, Date
Query.AddField “entpart”,”UsuHora”, Libreria.Formato( Time, “hh:mm:ss” )
Query.AddField “entpart”,”PRCANTIDAD”, 0
Query.AddField “entpart”,”PRDESCRIP”, “”
Query.AddField “entpart”,”CLAVEADD”, “”
Query.CreateQuery
Query.Execute

CreaEntrada = Entrada

End Function

Function CreaSalida( Salida, Articulo, Cantidad, Precio, Descripcion )
Dim Query
Dim rstArticulo

Set Query = NewQuery()
Set Query.Connection = Ambiente.Connection

If Salida = 0 Then
Query.Reset
Query.strState = “INSERT”

Salida = TraeSiguiente( “MovSal”, Ambiente.Connection )

Query.AddField “salidas”,”Salida”, Salida
Query.AddField “salidas”,”ocupado”, 1
Query.AddField “salidas”,”tipo_doc”, “EX-”
Query.AddField “salidas”,”F_EMISION”, Date
Query.AddField “salidas”,”IMPORTE”, 0
Query.AddField “salidas”,”COSTO”, 0
Query.AddField “salidas”,”ALMACEN”, 1
Query.AddField “salidas”,”ESTADO”, “CO”
Query.AddField “salidas”,”OBSERV”, “Salida automática por excel”
Query.AddField “salidas”,”DATOS”, “”
Query.AddField “salidas”,”USUARIO”, Ambiente.Uid
Query.AddField “salidas”,”USUFECHA”, Date
Query.AddField “salidas”,”USUHORA”, Libreria.Formato( Time, “hh:mm:ss” )
Query.AddField “salidas”,”traspaso”, 0
Query.AddField “salidas”,”almt”, 0
Query.AddField “salidas”,”estraspaso”, 0
Query.AddField “salidas”,”sucursal”, “”
Query.AddField “salidas”,”esparasucursal”, 0
Query.AddField “salidas”,”entsuc”, 0
Query.AddField “salidas”,”folio”, TraeSiguiente(Trim(Ambiente.Estacion) & “salida”, Ambiente.Connection)
Query.AddField “salidas”,”estacion”, Ambiente.Estacion
Query.CreateQuery
Query.Execute
End If

Query.Reset
Query.strState = “INSERT”
Query.AddField “salpart”,”SALIDA”, Salida
Query.AddField “salpart”,”TIPO_DOC”, “EX-”
Query.AddField “salpart”,”NO_REFEREN”, Salida
Query.AddField “salpart”,”ARTICULO”, Articulo
Query.AddField “salpart”,”CANTIDAD”, Cantidad * -1
Query.AddField “salpart”,”PRECIO”, Precio
Query.AddField “salpart”,”OBSERV”, Descripcion
Query.AddField “salpart”,”PARTIDA”, 0
Query.AddField “salpart”,”ID_SALIDA”, TraeSiguiente( “salpart”, Ambiente.Connection )
Query.AddField “salpart”,”Usuario”, Ambiente.Uid
Query.AddField “salpart”,”UsuFecha”, Date
Query.AddField “salpart”,”UsuHora”, Libreria.Formato( Time, “hh:mm:ss” )
Query.AddField “salpart”,”PRCANTIDAD”, 0
Query.AddField “salpart”,”PRDESCRIP”, “”
Query.AddField “salpart”,”CLAVEADD”, “”
Query.AddField “salpart”,”costo”, 0
Query.CreateQuery
Query.Execute

CreaSalida = Salida

End Function

 

Publicado el Dejar un comentario

¿Cómo importar un Procedimiento a MyBusiness POS?

Enfocado a: Distribuidores y Usuarios.

1. Entrar a MyBusiness POS y damos un clic en la carpeta configuracion del business manager.

2. Dentro de esta ventana buscar la carpeta personalización, y posteriormente el icono “formatos del sistema”

3. Se abrirá la herramienta Business Manager con la lista de todos los formatos

4. Clic derecho sobre cualquiera de los formatos y aparecerá una lista de opciones de la cual debe elegir la opción: Importar paquete de procedimientos.

5. Buscar el directorio donde esta guardado el archivo y selecciónalo.

6. Aparecerá una mensaje que te dice:
”Paquete importado”. Oprime un clic en Aceptar.

7. Cerramos la ventana. Para mayor seguridad, se recomienda dar mantenimiento a la base de datos y cerrar el programa.

Programar

Canal oficial de Video Tutoriales


¿Cómo Programar en MyBusiness POS?
A continuación se muestran algunas sintaxis de las funciones que utiliza MyBusiness POS, sobre todo van enfocados a los formatos de impresión de tickets (Ticket Explicado)

‘Declaración de las variables, globales o locales _
(en caso de que se encuentre en un bloque Sub)
Dim Variable

‘Salto de línea, _
el cual se asigna a la variable cLineaNueva
cLineaNueva = Chr(13) & Chr(10)

‘ Creamos el recordSet del encabezado de la venta ‘ el recordset _
“Rst(consulta, Ambiente.Connection)” es la lista de datos que nos _
interesan (con condiciones) de una determinada tabla y _
se guardan en la variable “rstEncabezado”.
Set rstEncabezado = Rst(“Consulta entre Comillas”, Ambiente.Connection)

‘Muestra el valor de la columna “Caja”, resultado de la consulta rstEncabezado
rstEncabezado(“caja”)

‘El nobre de la conexión a la base de datos actual
Ambiente.Connection

‘Valida si la consulta NO tuvo resultados
if rstEncabezado.EOF Then
MsgBox “No existe la venta seleccionada”,vbInformation
Exit Sub
end if

‘con “Exit Sub” terminamos el proceso (Sub Proceso() — end Sub). _
En este caso, se “mata” el proceso Sub Main(), porque estemos dentro de este.
Exit Sub

‘”cSalida” es la variable que almacena todo el texto que se imprimirá. _
en este caso “cSalida” se prepara en blanco. es importane ver en las _
siguientes líneas cómo es que se va alimentando esta variable “cSalida”
cSalida = “”

‘Propiedad de la estación que indica si hay Cajón de Dinero conectado (0, 1)
Ambiente.rstEstacion(“Cajon”)

‘Creación de la lista de registros a consultar
CreaRecordSet( “Consulta entre comillas”, Ambiente.Connection )

‘Borra los espacios al principio y al final de un texto o variable String
Trim( “Texto con espacios al final” )

‘Asigna una determinada cantidad de espacios para alinera a la DERECHA
PadL( “Cadena de Texto”, 11 )

‘Asigna una determinada cantidad de espacios para alinera a la IZQUIERDA
PadR( “Cadena de texto”, 11 )

‘Subcadena de texto, útil para múltiples líneas de texto (texto, inicio, largo)
Mid( “Cadena de Texto”, 1, 15 )
Mid( “Cadena de Texto”, 16, 20 )

‘ Esto manda un corte de papel
if Ambiente.rstEstacion(“ticketcorte”) <> 0 Then
cSalida = cSalida & Chr(27) & Chr(105)
end if

‘este bloque permite imprimir en una impresora _
USB (imprime en la impresora predeterminada de Windows).
IniciaDocumento
‘Fuente que tendra el ticket USB
EstableceFuente “Courier New”, 8

‘Alineación del texto en el ticket, en pulgadas
Say 0,.2, cSalida

‘Termina la Impresión USB
FinDocumento
Exit Sub

‘Impresión de ticket, corteX y CorteZ _
Enviamos a la impresorade tickets que esta definida en ESTACION01
Script.sendToPrinter Ambiente, (cSalida), prn.Pantalla

‘Permite definir la fuente (letra) del Código de Barras
EstableceFuente “C39HrP24DhTt”, 40

‘Permite un tiempo de espera 100 ms para continuar en caso de error
Dormir 100
Eventos

‘Permite tener una vista previa del resultado, sin necesidad de imprimir
msgbox cSalida

‘ Aqui se puede modificar la etiqueta utiliza un lenguaje llamado EPL2_
‘Se muestran los comandos basicos _
El comando N inicia la etiqueta _
‘El comando A muestra un dato de texto en _
donde el 250 es la posición en el eje de las X y el 15 la _
posición en el eje de las Y
‘El comando B muestra el código de barras _
donde 250 es la posición en el eje de las X y 45 es la posición _
de inicio del eje de las Y _
‘El comando P Finaliza la etiqueta y el nunero 1 indica _
cuantas etiquetas se van a imprimir

‘linea de codigo de barras de la version 2011
cSalida = cSalida & “B05,30,0,2,1,6,25,B,” & Chr(34) & cArticulo & Chr(34) & Chr(13) & Chr(10)
‘linea de codigo de barras de la version 2006
cSalida = cSalida & “B250,60,0,1,2,6,80,B,” & Chr(34) & cArticulo & Chr(34) & Chr(13) & Chr(10)

 

Para el formato de factura electrónica CBB


'Box permite crear un cuadro sin relleno
' la sintaxis es Box InicioX, InicioY, FinX, FinY
' el X y Y son las coordenadas, iniciando desde la parte superior izquierda
Box Col(62), Row(8), Col(12), Row(1) 'Cuadro que enmarca el encabezado FACTURA
Box Col(62), Row(8), Col(12), Row(3) 'Cuardo grande que emnarca la Fatura y serie

‘FilledBox permite tener un cuadro con relleno de color
‘la sintaxis es FilledBox InicioX, InicioY, FinX, FinY, RGB(Rojo, Verde, Azul)
‘donde el color RGB va desde 0 hasta 255.
FilledBox Col(57), Row(12), Col(20), Row(1), RGB( 200, 200, 200 )

‘Say permite imprimir un texto o una variable tipo texto o numero
‘la sintaxis es Say X,Y
‘ el X y Y son las coordenadas, iniciando desde la parte superior izquierda
Say Row(17), Col(07), “Texto de prueba”

‘Tambien se puede presentar el texto con las coordenadas en Pulgadas, X = 0.94, Y = 2.53 pulgadas
Say 0.94, 2.53, “Texto de prueba para pagaré”

A continuación se muestran todas las funciones que se aplican en el sistema MyBusiness POS

Función

Descripción

Librería (dll)

Tipo

Sub o Funcion

Detalle

AbreConnection
AbreConnection (cBase As String) As ADODB._Connection
BLibreria
DISLibreria
Function
AbrirCajonDeDinero
AbrirCajonDeDinero (cPuerto, cCode)
BImpresora
Impresora
Sub
Abs
Abs (Number)
VBA
Math
Function
AbsolutePage
AbsolutePage As PositionEnum
ADODB
Recordset
Function
AbsolutePosition
AbsolutePosition As PositionEnum
ADODB
Recordset
Function
ActivaMostrador
ActivaMostrador ([Tipo As String])
BVentas
Ventas
Sub
ActivaPuntoDeVenta
ActivaPuntoDeVenta ([Tipo As String], [bolModal As BooleanFalso], [bolLogin As BooleanFalso])
BVentas
Ventas
Sub
ActivaPuntoDeVenta2
ActivaPuntoDeVenta2 ([Tipo As String], [bolModal As BooleanFalso], [bolLogin As BooleanFalso])
BVentas
Ventas
Sub
ActiveCommand
ActiveCommand As Object
ADODB
Recordset
Function
ActiveConnection
ActiveConnection
ADODB
Recordset
Function
ActualSize
ActualSize As Long
ADODB
Field
Function
ActualizaApartadosPorVenta
ActualizaApartadosPorVenta (cArticulo, nCantidad, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaCuenxpag
ActualizaCuenxpag (nCuenxpag, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaPorAplicar
ActualizaPorAplicar (nAbono, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaPorAplicarEnPagos
ActualizaPorAplicarEnPagos (nAbono, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaPorRecibir
ActualizaPorRecibir (Ambiente As ?, cArticulo As String, nPartida As Long, nCantidad As Double, [bolAfectaArticulos As BooleanVerdadero])
BLibreria
DISLibreria
Sub
ActualizaPorSurtir
ActualizaPorSurtir (Ambiente As ?, cArticulo As String, nPartida As Long, nCantidad As Double, [bolAfectaArticulos As BooleanVerdadero])
BLibreria
DISLibreria
Sub
ActualizaPorSurtirEnCotizacion
ActualizaPorSurtirEnCotizacion (cArticulo, nPartida As Long, nCantidad As Double, nPedido As Long, ByVal Ambiente As Long, [bolAfectaArticulos As BooleanVerdadero])
BLibreria
DISLibreria
Sub
ActualizaPorSurtirEnOrden
ActualizaPorSurtirEnOrden (cArticulo, nPartida As Long, nCantidad As Double, nPedido As Long, ByVal Ambiente As Long, [bolAfectaArticulos As BooleanVerdadero])
BLibreria
DISLibreria
Sub
ActualizaSaldo
ActualizaSaldo (nCobranza, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaSaldoPagos
ActualizaSaldoPagos (nCuenxpag, ByVal Ambiente)
BLibreria
DISLibreria
Sub
ActualizaSecuenciaDePeriodos
ActualizaSecuenciaDePeriodos
BContabilidad
Contabilidad
Sub
Acumulado
Acumulado As Boolean
BReportes
Columna
Function
AddField
AddField (strTable As String, cField As String, [uValue])
BQueryBuilder
Query
Sub
AddNew
AddNew ([ByVal FieldList], [ByVal Values])
ADODB
Recordset
Sub
AddPath
AddPath (strPath As String, [strRemoteStation As String], [strPerfil As String], [strSubPerfil As String])
BQueryBuilder
Query
Sub
AddTable
AddTable (strTable As String, [strParent As String], [strRelation As String], [RelationType As String])
BQueryBuilder
Query
Sub
AddText
AddText (ByVal strText As String)
CodeSense
CodeSense
Sub
AfectaCuentasPorCobrar
AfectaCuentasPorCobrar (nVenta As Long, [nSaldo As Double])
BVentas
Ventas
Sub
AfectaInventario
AfectaInventario ([Inventario As Long]) As Double
BInventario
Inventario
Function
AfectaPartidas
AfectaPartidas (rstVenta As ADODB._Recordset, rstPartidas As ADODB._Recordset)
BVentas
Ventas
Sub
AfectaSaldoDeCliente
AfectaSaldoDeCliente (cCliente As String, nCantidad As Double, Connection As ADODB._Connection)
BLibreria
DISLibreria
Sub
AfectaSaldoDeProveedor
AfectaSaldoDeProveedor (cProveedor As String, nCantidad As Double, Connection As ADODB._Connection)
BLibreria
DISLibreria
Sub
Afectaflujo
Afectaflujo (rstVenta As ADODB._Recordset)
BVentas
Ventas
Function
Agente
Agente As Object
BEnviroment
Ambiente
Function
Agregar
Agregar (rst As ADODB._Recordset)
BLibreria
DISLibreria
Sub
Almacen
Almacen As Integer
BEnviroment
Ambiente
Function
Ambiente
Ambiente As BEnviroment._Ambiente
BVentas
Ventas
Function
Ancho
Ancho As Long
BReportes
Columna
Function
AnchoCelda
AnchoCelda As Double
BReportes
Columna
Function
AnchoTitulo
AnchoTitulo As Double
BReportes
Columna
Function
AplicaFormato
AplicaFormato (Text As Object, ByVal Ambiente As Object, [Formato As String]) As String
BLibreria
DISLibreria
Function
AppActivate
AppActivate (Title, [Wait])
VBA
Interaction
Sub
Append
Append (ByVal Object As Object)
ADODB
Parameters
Sub
AppendChunk
AppendChunk (ByVal Val)
ADODB
Parameter
Sub
Archivo
Archivo As Boolean
BImpresora
Impresora
Function
Argument
Argument As Long
CodeSense
CodeTipMultiFunc
Function
Articulo
Articulo As String
BArticulos
Articulos
Function
AscB
AscB (ByVal String As String) As Byte
VBA
Strings
Function
AscW
AscW (ByVal String As String) As Integer
VBA
Strings
Function
AsignaSubItem
AsignaSubItem (Item, nIndice As Integer, uValue)
BLibreria
DISLibreria
Sub
Asociados
Asociados (cArticulo As String)
BArticulos
Articulos
Sub
At
At (strSearch, strText As String) As Long
BLibreria
DISLibreria
Function
Atn
Atn (ByVal Number As Double) As Double
VBA
Math
Function
Attributes
Attributes As Long
ADODB
Property
Function
AutoIndentMode
AutoIndentMode As cmAutoIndentMode
CodeSense
CodeSense
Function
Avanzado
Avanzado As Boolean
BEnviroment
Ambiente
Function
BOF
BOF As Boolean
ADODB
Recordset
Function
BarCodeTime
BarCodeTime As String
BLibreria
SymbolCS1504
Function
BarCodes
BarCodes As Long
BLibreria
SymbolCS1504
Function
Barcode
Barcode As String
BLibreria
SymbolCS1504
Function
Bascula
Bascula As Object
BEnviroment
Ambiente
Function
Beep
Beep
VBA
Interaction
Sub
BeginTrans
BeginTrans As Long
ADODB
Connection
Function
Bitacoras
Bitacoras
BArticulos
Articulos
Sub
Block
Block (cBlock As String) As String
BImpresora
Impresora
Function
Bookmark
Bookmark
ADODB
Recordset
Function
BorderStyle
BorderStyle As cmBorderStyle
CodeSense
CodeSense
Function
BorraArchivo
BorraArchivo
BImpresora
Impresora
Sub
BorraCobranza
BorraCobranza (nCobranza As Long) As Boolean
BCobranza
Cobranza
Function
BorraDevolucion
BorraDevolucion (nDevolucion As Long)
BCompras
Compras
Sub
BorraOrden
BorraOrden (norden As Long)
BOrdenes
Ordenes
Sub
BorraPedido
BorraPedido (nPedido As Long)
BPedidos
Pedidos
Sub
Box
Box (bLeft, bTop, bWidth, bHeight)
BImpresora
Impresora
Sub
BufferColToViewCol
BufferColToViewCol (ByVal lLine As Long, ByVal lBuffCol As Long) As Long
CodeSense
CodeSense
Function
Busca
Busca (cBusqueda As String, [Tabla As String], [Campo As String], [Comparador As String], [uValor], [extList As BooleanFalso])
BBuscar
Buscar
Sub
BuscaPerfil
BuscaPerfil (strBuscaPerfil, strSubPerfil) As Boolean
BQueryBuilder
Query
Function
BuscaVentana
BuscaVentana ([strTexto As String], [strClase As String]) As Boolean
BLibreria
DISLibreria
Function
Buscar
Buscar As String
prjMultiCombo
MultiCombo
Function
BusquedaAutomatica
BusquedaAutomatica As Boolean
BEnviroment
Ambiente
Function
BusquedaFin
BusquedaFin As String
BImpresora
ParamData
Function
BusquedaFin2
BusquedaFin2 As String
BImpresora
ParamData
Function
BusquedaIni
BusquedaIni As String
BImpresora
ParamData
Function
BusquedaIni2
BusquedaIni2 As String
BImpresora
ParamData
Function
CBool
CBool (Expression) As Boolean
VBA
Conversion
Function
CByte
CByte (Expression) As Byte
VBA
Conversion
Function
CCur
CCur (Expression) As Currency
VBA
Conversion
Function
CDate
CDate (Expression) As Date
VBA
Conversion
Function
CDbl
CDbl (Expression) As Double
VBA
Conversion
Function
CDec
CDec (Expression)
VBA
Conversion
Function
CInt
CInt (Expression) As Integer
VBA
Conversion
Function
CLng
CLng (Expression) As Long
VBA
Conversion
Function
CP
CP As String
BEnviroment
Ambiente
Function
CSng
CSng (Expression) As Single
VBA
Conversion
Function
CStr
CStr (Expression) As String
VBA
Conversion
Function
CVDate
CVDate (Expression)
VBA
Conversion
Function
CVErr
CVErr (Expression)
VBA
Conversion
Function
CVar
CVar (Expression)
VBA
Conversion
Function
CacheSize
CacheSize As Long
ADODB
Recordset
Function
Calcula
Calcula
BCalculator
Calculator
Sub
Calcula2
Calcula2 As Double
BCalculator
Calculator
Function
CalculaImportes
CalculaImportes (rstVenta As ADODB._Recordset, rstPartidas As ADODB._Recordset, [nVenta As Long])
BVentas
Ventas
Sub
CalculaTotales
CalculaTotales (cCuenta As String, nYear As Long, nMonth As Long)
BContabilidad
Contabilidad
Sub
CalculaValores
CalculaValores
BReportes
Reporte
Sub
Calculadora
Calculadora (Ambiente As ?) As Double
BLibreria
DISLibreria
Function
Calendar
Calendar As VbCalendar
VBA
DateTime
Function
CallByName
CallByName (ByVal Object As Object, ByVal ProcName As String, ByVal CallType As VbCallType, Args() As Variant)
VBA
Interaction
Function
Cambia
Cambia (cInserta As String, cBusca As String, cTarget As String) As String
BLibreria
DISLibreria
Function
CambiaNumeroDeNotaDeCredito
CambiaNumeroDeNotaDeCredito (nNC As Long)
BVentas
Ventas
Sub
CambiarNumeroDeFactura
CambiarNumeroDeFactura (nFactura As Long)
BVentas
Ventas
Sub
Cambio
Cambio As Boolean
BReportes
Columna
Function
Campo
Campo
BLIstView
lvCol
Function
CanCopy
CanCopy As Boolean
CodeSense
CodeSense
Function
CanCut
CanCut As Boolean
CodeSense
CodeSense
Function
CanPaste
CanPaste As Boolean
CodeSense
CodeSense
Function
CanRedo
CanRedo As Boolean
CodeSense
CodeSense
Function
CanUndo
CanUndo As Boolean
CodeSense
CodeSense
Function
Cancel
Cancel
ADODB
Stream
Sub
CancelBatch
CancelBatch ([ByVal AffectRecords As AffectEnum = adAffectAll])
ADODB
Recordset
Sub
CancelUpdate
CancelUpdate
ADODB
Recordset
Sub
CancelaCompra
CancelaCompra (rstCompra As ADODB._Recordset)
BCompras
Compras
Sub
CancelaFactura
CancelaFactura (rstVenta As ADODB._Recordset)
BVentas
Ventas
Sub
CancelaProceso
CancelaProceso As Boolean
BClientes
Clientes
Function
CancelaRemision
CancelaRemision (rstVenta As ADODB._Recordset, [CancelaLotesSeries As BooleanVerdadero], [Cancelaflujo As BooleanVerdadero], [RemoveItemX As BooleanVerdadero])
BVentas
Ventas
Sub
Cancelado
Cancelado As Boolean
BImpresora
Impresora
Function
CapturaLotesEntrantes
CapturaLotesEntrantes (nConsec As Long, cArticulo As String, cDescrip As String, nCantidad As Double)
BInventario
Inventario
Sub
CapturaLotesSalida
CapturaLotesSalida (nConsec As Long, cArticulo As String, cDescrip As String, nCantidad As Double)
BInventario
Inventario
Sub
CapturaSeriesDeEntrada
CapturaSeriesDeEntrada (nFaltantes As Long, nConsec As Long, cArticulo As String, cDescrip As String)
BInventario
Inventario
Sub
CapturaSeriesDeSalida
CapturaSeriesDeSalida (cArticulo As String, nSeries As Long, nConsec As Long)
BInventario
Inventario
Sub
CaseSensitive
CaseSensitive As Boolean
CodeSense
Language
Function
CatalogoActivo
CatalogoActivo As String
BEnviroment
Ambiente
Function
CenterForm
CenterForm (frm As Object)
BLibreria
DISLibreria
Sub
ChDir
ChDir (ByVal Path As String)
VBA
FileSystem
Sub
ChDrive
ChDrive (ByVal Drive As String)
VBA
FileSystem
Sub
Charset
Charset As String
ADODB
Stream
Function
Check
Check As Boolean
BImpresora
ParamData
Function
CheckLeyend
CheckLeyend As String
BImpresora
ParamData
Function
CheckValue
CheckValue As Boolean
BImpresora
ParamData
Function
Clasificacion
Clasificacion As String
BEnviroment
Ambiente
Function
Clave
Clave As String
BEnviroment
Ambiente
Function
ClearData
ClearData
BLibreria
SymbolCS1504
Sub
ClearUndoBuffer
ClearUndoBuffer
CodeSense
CodeSense
Sub
Clone
Clone ([ByVal LockType As LockTypeEnum = adLockUnspecified]) As _Recordset
ADODB
Recordset
Function
CloseAllFiles
CloseAllFiles
BLibreria
DISLibreria
Sub
CloseFile
CloseFile (n As Integer)
BLibreria
DISLibreria
Function
CodeID
CodeID As Long
BLibreria
SymbolCS1504
Function
CodeType
CodeType As String
BLibreria
SymbolCS1504
Function
Codigo39
Codigo39 (x, y, xNarrow, yHeight, strMensaje, [bolBoxFalso], [CheckDigitFalso], [strData1], [strData2])
BImpresora
Impresora
Sub
Col
Col As Double
BReportes
Columna
Function
ColNo
ColNo As Long
CodeSense
Position
Function
CollectionRst
CollectionRst As VBA._Collection
BReportes
Reporte
Function
ColorDeFuente
ColorDeFuente (nColor)
BImpresora
Impresora
Sub
ColorSyntax
ColorSyntax As Boolean
CodeSense
CodeSense
Function
ColumnSel
ColumnSel As Boolean
CodeSense
Range
Function
Columna
Columna As _Columna
BReportes
Value
Function
ColumnaFont
ColumnaFont (strFont As String, dblFontSize As Double, bolFontBold As Boolean)
BReportes
Columna
Sub
ColumnaGrupoFont
ColumnaGrupoFont (strFont As String, dblFontSize As Double, bolFontBold As Boolean)
BReportes
Columna
Sub
ColumnsGrupo
ColumnsGrupo As VBA._Collection
BReportes
Reporte
Function
ColumnsTotal
ColumnsTotal As VBA._Collection
BReportes
Reporte
Function
CommPort
CommPort As String
BEnviroment
Ambiente
Function
CommandTimeout
CommandTimeout As Long
ADODB
Connection
Function
CommandToFile
CommandToFile (strCommand As String, strFile As String)
BLibreria
DISLibreria
Sub
CommitTrans
CommitTrans
ADODB
Connection
Sub
CommonDialog1
CommonDialog1 As Object
BEnviroment
Ambiente
Function
CompareBookmarks
CompareBookmarks (ByVal Bookmark1, ByVal Bookmark2) As CompareEnum
ADODB
Recordset
Function
Componentes
Componentes (cArticulo As String)
BArticulos
Articulos
Sub
CompraJoyeria
CompraJoyeria ([cModo As String”ALTA”], [nMovimiento As Long])
BCompras
Compras
Sub
Cond
Cond As String
BReportes
Columna
Function
Condition
Condition As String
prjMultiCombo
MultiCombo
Function
Conectar
Conectar As Boolean
BLibreria
DISLibreria
Function
Conexiones
Conexiones As VBA._Collection
BEnviroment
Ambiente
Function
ConfigConnection
ConfigConnection As ADODB._Connection
BEnviroment
Ambiente
Function
ConfigRecordSet
ConfigRecordSet As ADODB._Recordset
BEnviroment
Ambiente
Function
ConfirmaVenta
ConfirmaVenta (nVenta As Long, bolImprimir As Boolean, [VentaOrigen As Long], [cCaja As String], [bolflujo As BooleanVerdadero]) As Boolean
BVentas
Ventas
Function
Connection
Connection
prjMultiCombo
MultiCombo
Function
ConnectionString
ConnectionString As String
ADODB
Connection
Function
ConnectionTimeout
ConnectionTimeout As Long
ADODB
Connection
Function
Consec
Consec As Long
BInventario
Inventario
Function
ConsultaAbono
ConsultaAbono (nAbono As Long)
BCobranza
Cobranza
Sub
ConsultaArticulo
ConsultaArticulo (cArticulo As String)
BArticulos
Articulos
Sub
ConsultaCliente
ConsultaCliente (cCliente As String)
BClientes
Clientes
Sub
ConsultaCobranza
ConsultaCobranza (nCobranza As Long, [bolModal As BooleanFalso])
BCobranza
Cobranza
Sub
ConsultaCompra
ConsultaCompra (nCompra As Long)
BCompras
Compras
Sub
ConsultaDevolucion
ConsultaDevolucion (nDevolucion As Long)
BVentas
Ventas
Sub
ConsultaEntrada
ConsultaEntrada (nEntrada As Long)
BEntradasSalidas
EntradasSalidas
Sub
ConsultaFactura
ConsultaFactura (nFactura As Long)
BVentas
Ventas
Sub
ConsultaLinea
ConsultaLinea (cLinea As String)
BArticulos
Articulos
Sub
ConsultaMarca
ConsultaMarca (cMarca As String)
BArticulos
Articulos
Sub
ConsultaOrden
ConsultaOrden (norden As Long)
BOrdenes
Ordenes
Sub
ConsultaPedido
ConsultaPedido (nPedido As Long)
BPedidos
Pedidos
Sub
ConsultaRemision
ConsultaRemision (nRemision As Long)
BVentas
Ventas
Sub
ConsultaSalida
ConsultaSalida (nSalida As Long)
BEntradasSalidas
EntradasSalidas
Sub
ConsultaUbicacion
ConsultaUbicacion (cUbicacion As String)
BArticulos
Articulos
Sub
ConsultaVendedor
ConsultaVendedor (cVendedor As String)
BClientes
Clientes
Sub
ConsultaVenta
ConsultaVenta (nVenta As Long)
BVentas
Ventas
Sub
Control
Control As Object
BLibreria
TextData
Function
ControlAyuda
ControlAyuda As String
BEnviroment
Ambiente
Function
ControlhWndImpresora
ControlhWndImpresora As Long
BImpresora
Impresora
Function
ConvertirEnFactura
ConvertirEnFactura
BVentas
Ventas
Sub
ConvierteRemisionEnFactura
ConvierteRemisionEnFactura (nRemision As Long, cEstacion As String, bolTicket As Boolean) As String
BVentas
Ventas
Function
CopiaArchivo
CopiaArchivo (cArchivOrig As String, cArchivoDes As String)
BLibreria
DISLibreria
Function
Copias
Copias (nCopias As Long)
BImpresora
Impresora
Sub
CopyFile
CopyFile (Source As String, Destination As String)
BLibreria
DISLibreria
Sub
CopyRecord
CopyRecord ([ByVal Source As String], [ByVal Destination As String], [ByVal UserName As String], [ByVal Password As String], [ByVal Options As CopyRecordOptionsEnum = adCopyUnspecified], [ByVal Async As BooleanFalso]) As String
ADODB
Record
Function
CopyTo
CopyTo (ByVal DestStream As _Stream, [ByVal CharNumber As Long-1])
ADODB
Stream
Sub
Cos
Cos (ByVal Number As Double) As Double
VBA
Math
Function
Costo
Costo As Double
BInventario
Inventario
Function
CreaForma
CreaForma As Object
BImpresora
Impresora
Function
CreaNotaCredito
CreaNotaCredito (nVenta As Double)
BVentas
Ventas
Sub
CreaRecordSet
CreaRecordSet (strSql As String, Connection As ADODB._Connection, [porPantalla As BooleanVerdadero]) As ADODB._Recordset
BLibreria
DISLibreria
Function
CreaRecordSetDeActualizacion
CreaRecordSetDeActualizacion
BQueryBuilder
Query
Sub
CreaRecordSetEnCliente
CreaRecordSetEnCliente (strSql As String, Connection As ADODB._Connection) As ADODB._Recordset
BLibreria
DISLibreria
Function
Creabalanza
Creabalanza (nYear As Long, nMonth As Long)
BContabilidad
Contabilidad
Sub
CrearFacturaDeCierre
CrearFacturaDeCierre ([cCliente As String])
BVentas
Ventas
Sub
CreateFile
CreateFile (ByVal FileName As String) As Integer
BExcel
ExcelFile
Function
CreateInsert
CreateInsert
BQueryBuilder
Query
Function
CreateObject
CreateObject (ByVal Class As String, [ByVal ServerName As String])
VBA
Interaction
Function
CreateParameter
CreateParameter ([ByVal Name As String], [ByVal Type As DataTypeEnum = adEmpty], [ByVal Direction As ParameterDirectionEnum = adParamInput], [ByVal Size As Long], [ByVal Value]) As _Parameter
ADODB
Command
Function
CreateQuery
CreateQuery As String
BQueryBuilder
Query
Function
CreateSelect
CreateSelect As String
BQueryBuilder
Query
Function
CreateUpdate
CreateUpdate
BQueryBuilder
Query
Function
CrystalReport
CrystalReport As Object
BEnviroment
Ambiente
Function
CuadroDeMensajes
CuadroDeMensajes (cMensaje As String, nTipo As Integer, Ambiente As Object)
BLibreria
DISLibreria
Sub
CuantasLineas
CuantasLineas (cString) As Long
BImpresora
Impresora
Function
CurrentFunction
CurrentFunction As Long
CodeSense
CodeTipMultiFunc
Function
CurrentToken
CurrentToken As cmTokenType
CodeSense
CodeSense
Function
CurrentView
CurrentView As Long
CodeSense
CodeSense
Function
CurrentWord
CurrentWord As String
CodeSense
CodeSense
Function
CurrentWordLength
CurrentWordLength As Long
CodeSense
CodeSense
Function
CurrentWordLengthLogical
CurrentWordLengthLogical As Long
CodeSense
CodeSense
Function
CurrentX
CurrentX (XVal)
BImpresora
Impresora
Sub
CurrentY
CurrentY (YVal)
BImpresora
Impresora
Sub
CursorLocation
CursorLocation As CursorLocationEnum
ADODB
Recordset
Function
CursorType
CursorType As CursorTypeEnum
ADODB
Recordset
Function
Data
Data
BVentas
clsTextBox
Function
DataArrival
DataArrival As String
BEnviroment
Ambiente
Function
DataAvailable
DataAvailable
BLibreria
SymbolCS1504
Sub
DataElse
DataElse As String
BReportes
Columna
Function
DataFormat
DataFormat As Unknown
ADODB
Field
Function
DataMember
DataMember As String
ADODB
Recordset
Function
DataSeparator
DataSeparator (Separator, strSearch, List() As Variant) As Long
BLibreria
DISLibreria
Function
DataSource
DataSource As Unknown
ADODB
Recordset
Function
DateAdd
DateAdd (ByVal Interval As String, ByVal Number As Double, Date)
VBA
DateTime
Function
DateDiff
DateDiff (ByVal Interval As String, Date1, Date2, [ByVal FirstDayOfWeek As VbDayOfWeek = vbSunday], [ByVal FirstWeekOfYear As VbFirstWeekOfYear = vbFirstJan1])
VBA
DateTime
Function
DatePart
DatePart (ByVal Interval As String, Date, [ByVal FirstDayOfWeek As VbDayOfWeek = vbSunday], [ByVal FirstWeekOfYear As VbFirstWeekOfYear = vbFirstJan1])
VBA
DateTime
Function
DateSerial
DateSerial (ByVal Year As Integer, ByVal Month As Integer, ByVal Day As Integer)
VBA
DateTime
Function
DateValue
DateValue (ByVal Date As String)
VBA
DateTime
Function
Datos
Datos As String
BEnviroment
Ambiente
Function
Day
Day (Date)
VBA
DateTime
Function
DebugMode
DebugMode (ByVal nOnOff As Long)
BLibreria
SymbolCS1504
Sub
Decrypta
Decrypta (cTexto As String, nLlave As Integer) As String
BLibreria
DISLibreria
Function
DefaultDatabase
DefaultDatabase As String
ADODB
Connection
Function
DefinedSize
DefinedSize As Long
ADODB
Field
Function
DeleteFile
DeleteFile (filename As String)
BLibreria
DISLibreria
Sub
DeleteItem
DeleteItem (ByVal ItemIndex As Long)
CodeSense
CodeList
Sub
DeleteLine
DeleteLine (ByVal lLine As Long)
CodeSense
CodeSense
Sub
DeleteRecord
DeleteRecord ([ByVal Source As String], [ByVal Async As BooleanFalso])
ADODB
Record
Sub
DeleteSel
DeleteSel
CodeSense
CodeSense
Sub
DeleteSetting
DeleteSetting (ByVal AppName As String, [ByVal Section], [ByVal Key])
VBA
Interaction
Sub
Depurar
Depurar (Ambiente As BEnviroment._Ambiente, strProceso As String, Linea As Long)
BScripting
BScript
Sub
Desconectado
Desconectado As Boolean
BEnviroment
Ambiente
Function
Description
Description As String
ADODB
Error
Function
Destroy
Destroy
CodeSense
CodeTipMultiFunc
Sub
Detalle
Detalle As Boolean
BReportes
Reporte
Function
DeviceId
DeviceId As String
BLibreria
SymbolCS1504
Function
DeviceTime
DeviceTime As String
BLibreria
SymbolCS1504
Function
Devolucion
Devolucion As Boolean
BInventario
Inventario
Function
Dia
Dia (dFecha As Date) As String
BLibreria
DISLibreria
Function
Dir
Dir ([PathName], [ByVal Attributes As VbFileAttribute = vbNormal]) As String
VBA
FileSystem
Function
Direccion1
Direccion1 As String
BEnviroment
Ambiente
Function
Direccion2
Direccion2 As String
BEnviroment
Ambiente
Function
DisplayContext
DisplayContext ([ByVal TopicNum As Long]) As Long
BVentas
chmHelpVentas
Function
DisplayIndex
DisplayIndex ([ByVal sKeyWord As String]) As Long
BVentas
chmHelpVentas
Function
DisplayLeftMargin
DisplayLeftMargin As Boolean
CodeSense
CodeSense
Function
DisplaySearch
DisplaySearch As Long
BVentas
chmHelpVentas
Function
DisplayTOC
DisplayTOC As Long
BVentas
chmHelpVentas
Function
DisplayTopic
DisplayTopic ([ByVal TopicName As String]) As Long
BVentas
chmHelpVentas
Function
DisplayWhitespace
DisplayWhitespace As Boolean
CodeSense
CodeSense
Function
DllVersion
DllVersion As String
BLibreria
SymbolCS1504
Function
DoEvents
DoEvents As Integer
VBA
Interaction
Function
DoPing
DoPing (ByVal HostAddress As String) As Boolean
BLibreria
Ping
Function
Documento
Documento As Long
BImpresora
Impresora
Function
Donativo
Donativo As Double
BInventario
Inventario
Function
Dormir
Dormir (nMSegundos As Double)
BLibreria
DISLibreria
Sub
EColor
EColor As Double
BReportes
Columna
Function
EColorCondition
EColorCondition As String
BReportes
Columna
Function
ECondition
ECondition As String
BReportes
Columna
Function
EOF
EOF As Boolean
ADODB
Recordset
Function
EOS
EOS As Boolean
ADODB
Stream
Function
EditMode
EditMode As EditModeEnum
ADODB
Recordset
Function
EditaSql
EditaSql (Parent As Object)
BBuscar
Buscar
Sub
ElSiguienteMes
ElSiguienteMes (nMes As Integer, nDia As Integer, nYear As Long) As Date
BLibreria
DISLibreria
Function
EliminaAlmacen
EliminaAlmacen (nAlmacen As Long)
BAlmacen
Almacen
Sub
EliminaArchivo
EliminaArchivo (strArchivo)
BLibreria
DISLibreria
Sub
EliminaArticulo
EliminaArticulo (cArticulo As String, [Forzoso As BooleanFalso]) As Boolean
BArticulos
Articulos
Function
EliminaCliente
EliminaCliente (cCliente As String) As Boolean
BClientes
Clientes
Function
EliminaCompra
EliminaCompra (nCompra As Long)
BCompras
Compras
Sub
EliminaDevolucion
EliminaDevolucion (nDevolucion As Long)
BVentas
Ventas
Sub
EliminaEntrada
EliminaEntrada (nEntrada As Long)
BEntradasSalidas
EntradasSalidas
Sub
EliminaFactura
EliminaFactura (nFactura As Long)
BVentas
Ventas
Sub
EliminaLinea
EliminaLinea (cLinea As String)
BArticulos
Articulos
Sub
EliminaMarca
EliminaMarca (cMarca As String)
BArticulos
Articulos
Sub
EliminaMoneda
EliminaMoneda (cMoneda As String)
BMonedas
Monedas
Sub
EliminaPeriodo
EliminaPeriodo (nYear As Long, nMonth As Long)
BContabilidad
Contabilidad
Sub
EliminaRemision
EliminaRemision (nRemision As Long)
BVentas
Ventas
Sub
EliminaSalida
EliminaSalida (nSalida As Long)
BEntradasSalidas
EntradasSalidas
Sub
EliminaUbicacion
EliminaUbicacion (cUbicacion As String)
BArticulos
Articulos
Sub
EliminaVendedor
EliminaVendedor (cVendedor As String) As Boolean
BClientes
Clientes
Function
EliminaVenta
EliminaVenta (nVenta As Long, [bolConfirma As BooleanVerdadero])
BVentas
Ventas
Sub
Email
Email As String
BEnviroment
Ambiente
Function
Empresa
Empresa As String
BEnviroment
Ambiente
Function
Empty
Empty
CodeSense
Range
Sub
EmptySys
EmptySys (cDato As String) As String
BLibreria
DISLibreria
Function
EnVenta
EnVenta (strArticulo As String, nAlmacen, Connection As ADODB._Connection) As Double
BLibreria
DISLibreria
Function
EnableCRLF
EnableCRLF As Boolean
CodeSense
CodeSense
Function
EnableColumnSel
EnableColumnSel As Boolean
CodeSense
CodeSense
Function
EnableDragDrop
EnableDragDrop As Boolean
CodeSense
CodeSense
Function
EnableHSplitter
EnableHSplitter As Boolean
CodeSense
CodeSense
Function
EnableHotTracking
EnableHotTracking ([ByVal bEnable])
CodeSense
CodeList
Sub
EnableVSplitter
EnableVSplitter As Boolean
CodeSense
CodeSense
Function
Encabezado
Encabezado
BReportes
Reporte
Sub
Encrypta
Encrypta (cTexto As String, nLlave As Integer) As String
BLibreria
DISLibreria
Function
EndColNo
EndColNo As Long
CodeSense
Range
Function
EndLineNo
EndLineNo As Long
CodeSense
Range
Function
EnsambleProducto
EnsambleProducto (strArticulo As String, nCantidad As Double, [Id_salida As Long], [tipoMovim As String]) As Boolean
BInventario
Inventario
Function
Entrada
Entrada (nConsec As Long) As Double
BInventario
Inventario
Function
EntradaSalida
EntradaSalida As String
BInventario
Inventario
Function
EnviaComando
EnviaComando (cComando As String)
BEnviroment
Ambiente
Sub
Err
Err As ErrObject
VBA
Information
Function
ErrorOculto
ErrorOculto As Boolean
BQueryBuilder
Query
Function
EsServidor
EsServidor As Boolean
BEnviroment
Ambiente
Function
EscapeChar
EscapeChar As String
CodeSense
Language
Function
EstableceEstiloImpresoraNT
EstableceEstiloImpresoraNT
BImpresora
Impresora
Sub
EstableceFuente
EstableceFuente (strFuente, Size)
BImpresora
Impresora
Sub
EstableceImpresora
EstableceImpresora (strimpresora)
BImpresora
Impresora
Sub
Estacion
Estacion As String
BEnviroment
Ambiente
Function
Estate
Estate As Integer
BEnviroment
Ambiente
Function
EstiloImpresion
EstiloImpresion As String
BImpresora
Impresora
Function
Eventos
Eventos
BImpresora
Impresora
Sub
Exec
Exec
BQueryBuilder
Query
Sub
ExecuteCmd
ExecuteCmd (ByVal lCommand As cmCommand, [ByVal CmdData])
CodeSense
CodeSense
Sub
ExecuteFromFile
ExecuteFromFile (strFile As String)
BQueryBuilder
Query
Sub
Existe
Existe (cDato As String, cCampo As String, cTabla As String, Conexion As ADODB._Connection, [Numeric As BooleanFalso])
BLibreria
DISLibreria
Function
ExisteArchivo
ExisteArchivo (strArchivo) As Boolean
BLibreria
DISLibreria
Function
ExisteCampo
ExisteCampo (cCampo As String, cTabla As String, Connection As ADODB._Connection) As Boolean
BLibreria
DISLibreria
Function
Existen
Existen (Tabla As String, ByVal Ambiente As String) As Boolean
BLibreria
DISLibreria
Function
Exp
Exp (ByVal Number As Double) As Double
VBA
Math
Function
ExpandTabs
ExpandTabs As Boolean
CodeSense
CodeSense
Function
Explain
Explain As Boolean
BReportes
Reporte
Function
FDinero
FDinero As String
BEnviroment
Ambiente
Function
FEspecial
FEspecial As String
BEnviroment
Ambiente
Function
FacturarEnPuntoDeVenta
FacturarEnPuntoDeVenta (nRemision As Long, cCaja As String) As String
BVentas
Ventas
Function
Fast
Fast As Boolean
prjMultiCombo
MultiCombo
Function
FastRst
FastRst (strSql As String, Connection As ADODB._Connection, [Pantalla As BooleanFalso]) As ADODB._Recordset
BLibreria
DISLibreria
Function
FechaDeTrabajo
FechaDeTrabajo (Year As Long, Month As Long) As Date
BLibreria
DISLibreria
Function
FechaFinal
FechaFinal As Date
BImpresora
ParamData
Function
FechaInicial
FechaInicial As Date
BImpresora
ParamData
Function
FechaMov
FechaMov As Date
BInventario
Inventario
Function
FechaSQL
FechaSQL (dDecha, [Connection As ADODB._Connection]) As String
BLibreria
DISLibreria
Function
Fechas
Fechas As Boolean
BImpresora
ParamData
Function
FieldList
FieldList As String
BScripting
SQLanalizer
Function
FieldName
FieldName As String
BQueryBuilder
BFields
Function
FieldX
FieldX As String
BScripting
Relacion
Function
FieldY
FieldY As String
BScripting
Relacion
Function
Fields
Fields As Fields
ADODB
Recordset
Function
FieldsCollection
FieldsCollection As VBA._Collection
BQueryBuilder
Query
Function
FieldsSigmaCollection
FieldsSigmaCollection As VBA._Collection
BQueryBuilder
Query
Function
File
File As String
BQueryBuilder
Query
Function
FileAttr
FileAttr (ByVal FileNumber As Integer, [ByVal ReturnType As Integer1]) As Long
VBA
FileSystem
Function
FileCopy
FileCopy (ByVal Source As String, ByVal Destination As String)
VBA
FileSystem
Sub
FileDateTime
FileDateTime (ByVal PathName As String)
VBA
FileSystem
Function
FileEOF
FileEOF (n As Integer) As Boolean
BLibreria
DISLibreria
Function
FileLen
FileLen (ByVal PathName As String) As Long
VBA
FileSystem
Function
FileReal
FileReal (filename) As Boolean
BLibreria
DISLibreria
Function
FilledBox
FilledBox (bLeft, bTop, bWidth, bHeight, Color)
BImpresora
Impresora
Sub
Filter
Filter
ADODB
Recordset
Function
FinDocumento
FinDocumento
BImpresora
Impresora
Sub
FinMonitor
FinMonitor As Boolean
BusinessMonitor
clsBusinessMonitor
Function
FindMRUList
FindMRUList As String
CodeSense
Globals
Function
FindString
FindString (ByVal strFind As String, [ByVal bAcceptPartial]) As Long
CodeSense
CodeList
Function
FindText
FindText As String
CodeSense
CodeSense
Function
FindWindowLike
FindWindowLike (hWndArray() As Long, ByVal hWndStart As Long, WindowText As String, Classname As String, Id, hText() As String, hClass() As String) As Long
BLibreria
DISLibreria
Function
Fix
Fix (Number)
VBA
Conversion
Function
Flush
Flush
ADODB
Stream
Sub
Fn
Fn (strValue As String) As Double
BLibreria
DISLibreria
Function
FontTitle
FontTitle As String
BReportes
Columna
Function
FontTitleBold
FontTitleBold As Boolean
BReportes
Columna
Function
FontTitleSize
FontTitleSize As Double
BReportes
Columna
Function
FormaAlto
FormaAlto As Double
BImpresora
Impresora
Function
FormaAncho
FormaAncho As Double
BImpresora
Impresora
Function
FormaAyuda
FormaAyuda As String
BEnviroment
Ambiente
Function
FormaBuscaContactos
FormaBuscaContactos
BClientes
Clientes
Sub
FormaDePagos
FormaDePagos (nCobranza As Long, [Modal As BooleanVerdadero])
BCobranza
Cobranza
Sub
FormatCurrency
FormatCurrency (Expression, [ByVal NumDigitsAfterDecimal As Long-1], [ByVal IncludeLeadingDigit As VbTriState = vbUseDefault], [ByVal UseParensForNegativeNumbers As VbTriState = vbUseDefault], [ByVal GroupDigits As VbTriState = vbUseDefault]) As String
VBA
Strings
Function
FormatDateTime
FormatDateTime (Expression, [ByVal NamedFormat As VbDateTimeFormat = vbGeneralDate]) As String
VBA
Strings
Function
FormatNumber
FormatNumber (Expression, [ByVal NumDigitsAfterDecimal As Long-1], [ByVal IncludeLeadingDigit As VbTriState = vbUseDefault], [ByVal UseParensForNegativeNumbers As VbTriState = vbUseDefault], [ByVal GroupDigits As VbTriState = vbUseDefault]) As String
VBA
Strings
Function
FormatPercent
FormatPercent (Expression, [ByVal NumDigitsAfterDecimal As Long-1], [ByVal IncludeLeadingDigit As VbTriState = vbUseDefault], [ByVal UseParensForNegativeNumbers As VbTriState = vbUseDefault], [ByVal GroupDigits As VbTriState = vbUseDefault]) As String
VBA
Strings
Function
FormateaCuenta
FormateaCuenta (cCuenta As String, nNiveles As Long, nNivel1 As Long, nNivel2 As Long, nNivel3 As Long, nNivel4 As Long, nNivel5 As Long) As String
BLibreria
DISLibreria
Function
Formato
Formato (Var, strFormat)
BLibreria
DISLibreria
Function
FormatoDecimal
FormatoDecimal (uValue As Double) As String
BLibreria
DISLibreria
Function
FreeFile
FreeFile ([RangeNumber]) As Integer
VBA
FileSystem
Function
FuenteTransparente
FuenteTransparente (bolTrans)
BImpresora
Impresora
Sub
FunctionCount
FunctionCount As Long
CodeSense
CodeTipMultiFunc
Function
GeneraFunciones
GeneraFunciones (Ambiente As ?)
BLibreria
DISLibreria
Sub
GetASCIIMode
GetASCIIMode
BLibreria
SymbolCS1504
Sub
GetAllBookmarks
GetAllBookmarks (Lines() As Long)
CodeSense
CodeSense
Sub
GetAllSettings
GetAllSettings (ByVal AppName As String, ByVal Section As String)
VBA
Interaction
Function
GetAttr
GetAttr (ByVal PathName As String) As VbFileAttribute
VBA
FileSystem
Function
GetAttrib
GetAttrib (filename) As String
BLibreria
DISLibreria
Function
GetBookmark
GetBookmark (ByVal lLine As Long) As Boolean
CodeSense
CodeSense
Function
GetCTS
GetCTS
BLibreria
SymbolCS1504
Sub
GetChildren
GetChildren As _Recordset
ADODB
Record
Function
GetChunk
GetChunk (ByVal Length As Long)
ADODB
Field
Function
GetCodeType
GetCodeType (nType As Long)
BLibreria
SymbolCS1504
Sub
GetColor
GetColor (ByVal lColorItem As cmColorItem) As Long
CodeSense
CodeSense
Function
GetCommandString
GetCommandString (ByVal lCmd As cmCommand, ByVal bDescription As Boolean) As String
CodeSense
Globals
Function
GetDeviceId
GetDeviceId
BLibreria
SymbolCS1504
Sub
GetDivider
GetDivider (ByVal lLine As Long) As Boolean
CodeSense
CodeSense
Function
GetDllVersion
GetDllVersion
BLibreria
SymbolCS1504
Sub
GetError
GetError As String
BQueryBuilder
Query
Function
GetFileDate
GetFileDate (filename As String) As String
BLibreria
DISLibreria
Function
GetFileExtension
GetFileExtension (filename As String)
BLibreria
DISLibreria
Function
GetFileSize
GetFileSize (filename) As String
BLibreria
DISLibreria
Function
GetFontStyle
GetFontStyle (ByVal lFontStyleItem As cmFontStyleItem) As cmFontStyle
CodeSense
CodeSense
Function
GetHotKeyForCmd
GetHotKeyForCmd (ByVal lCmd As cmCommand, ByVal lNum As Long) As IHotKey
CodeSense
Globals
Function
GetHotKeys
GetHotKeys (HotKeysBuff() As Byte)
CodeSense
Globals
Sub
GetItemData
GetItemData (ByVal lLine As Long) As Long
CodeSense
CodeSense
Function
GetItemText
GetItemText (ByVal ItemIndex As Long) As String
CodeSense
CodeList
Function
GetLanguageDef
GetLanguageDef (ByVal strName As String) As ILanguage
CodeSense
Globals
Function
GetLine
GetLine (ByVal lLine As Long) As String
CodeSense
CodeSense
Function
GetLineLength
GetLineLength (ByVal lLine As Long) As Long
CodeSense
CodeSense
Function
GetLineStyle
GetLineStyle (ByVal lLine As Long) As Long
CodeSense
CodeSense
Function
GetMacro
GetMacro (ByVal lMacro As Long, MacroBuff() As Byte)
CodeSense
Globals
Sub
GetMarginImages
GetMarginImages (ByVal lLine As Long) As Byte
CodeSense
CodeSense
Function
GetNumHotKeysForCmd
GetNumHotKeysForCmd (ByVal lCmd As cmCommand) As Long
CodeSense
Globals
Function
GetObject
GetObject ([PathName], [Class])
VBA
Interaction
Function
GetPacket
GetPacket
BLibreria
SymbolCS1504
Sub
GetProtocol
GetProtocol
BLibreria
SymbolCS1504
Sub
GetRTCMode
GetRTCMode
BLibreria
SymbolCS1504
Sub
GetRows
GetRows ([ByVal Rows As Long-1], [ByVal Start], [ByVal Fields])
ADODB
Recordset
Function
GetSel
GetSel (ByVal bNormalized As Boolean) As IRange
CodeSense
CodeSense
Function
GetSelFromPoint
GetSelFromPoint (ByVal lxClientPos As Long, ByVal lyClientPos As Long) As IPosition
CodeSense
CodeSense
Function
GetSetting
GetSetting (ByVal AppName As String, ByVal Section As String, ByVal Key As String, [ByVal Default]) As String
VBA
Interaction
Function
GetString
GetString ([ByVal StringFormat As StringFormatEnum = adClipString], [ByVal NumRows As Long-1], [ByVal ColumnDelimeter As String], [ByVal RowDelimeter As String], [ByVal NullExpr As String]) As String
ADODB
Recordset
Function
GetSwVersion
GetSwVersion
BLibreria
SymbolCS1504
Sub
GetSystemStatus
GetSystemStatus
BLibreria
SymbolCS1504
Sub
GetTime
GetTime
BLibreria
SymbolCS1504
Sub
GetTopIndex
GetTopIndex (ByVal lView As Long) As Long
CodeSense
CodeSense
Function
GetVisibleLineCount
GetVisibleLineCount (ByVal lView As Long, ByVal bFullyVisible As Boolean) As Long
CodeSense
CodeSense
Function
GetWord
GetWord (ByVal Pos As IPosition) As String
CodeSense
CodeSense
Function
GetWordLength
GetWordLength (ByVal Pos As IPosition, ByVal bLogical As Boolean) As Long
CodeSense
CodeSense
Function
GlobalProps
GlobalProps As Boolean
CodeSense
CodeSense
Function
Group
Group As String
BScripting
SQLanalizer
Function
Grupo
Grupo As Boolean
BReportes
Columna
Function
Grupo3d
Grupo3d As Boolean
BReportes
Columna
Function
GrupoColleccionTotales
GrupoColleccionTotales As VBA._Collection
BReportes
Columna
Function
GrupoColor
GrupoColor As Double
BReportes
Columna
Function
GrupoData
GrupoData As String
BReportes
Columna
Function
GrupoExcluyeColumnaDeTotales
GrupoExcluyeColumnaDeTotales As VBA._Collection
BReportes
Columna
Function
GrupoFont
GrupoFont As String
BReportes
Columna
Function
GrupoFontBold
GrupoFontBold As Boolean
BReportes
Columna
Function
GrupoFontSize
GrupoFontSize As Double
BReportes
Columna
Function
GrupoParameters
GrupoParameters As VBA._Collection
BReportes
Columna
Function
GrupoResultSet
GrupoResultSet As ADODB._Recordset
BReportes
Columna
Function
GrupoSeparador
GrupoSeparador As Boolean
BReportes
Columna
Function
GrupoSql
GrupoSql As String
BReportes
Columna
Function
GrupoTitulo
GrupoTitulo As String
BReportes
Columna
Function
GrupoTotal
GrupoTotal As Double
BReportes
Columna
Function
GrupoTotal3d
GrupoTotal3d As Boolean
BReportes
Columna
Function
GrupoTotalLeyenda
GrupoTotalLeyenda As String
BReportes
Columna
Function
GrupoTotales
GrupoTotales As Boolean
BReportes
Columna
Function
GrupoValue
GrupoValue
BReportes
Columna
Function
GruposyAcumulados
GruposyAcumulados
BReportes
Reporte
Sub
GuardaBitCostos
GuardaBitCostos (Modulo As String, Clave As String, Modo As String, ByVal Ambiente As String, [strClave2 As String])
BLibreria
DISLibreria
Sub
GuardaBitacora
GuardaBitacora (cArticulo As String)
BArticulos
Articulos
Sub
HScrollVisible
HScrollVisible As Boolean
CodeSense
CodeSense
Function
HSplitterPos
HSplitterPos As Long
CodeSense
CodeSense
Function
HelpContext
HelpContext As Long
ADODB
Error
Function
HelpFile
HelpFile As String
BVentas
chmHelpVentas
Function
HideSel
HideSel As Boolean
CodeSense
CodeSense
Function
HighlightEndPos
HighlightEndPos As Long
CodeSense
CodeTipHighlight
Function
HighlightStartPos
HighlightStartPos As Long
CodeSense
CodeTipHighlight
Function
HighlightedLine
HighlightedLine As Long
CodeSense
CodeSense
Function
HitTest
HitTest (ByVal lxClientPos As Long, ByVal lyClientPos As Long, plView As Long) As cmHitTestCode
CodeSense
CodeSense
Function
Horizontal
Horizontal As Boolean
BImpresora
Impresora
Function
Hour
Hour (Time)
VBA
DateTime
Function
IIf
IIf (Expression, TruePart, FalsePart)
VBA
Interaction
Function
IMEStatus
IMEStatus As VbIMEStatus
VBA
Information
Function
IP2Long
IP2Long (strAddress As String) As Long
BLibreria
Ping
Function
IconBag
IconBag As Object
BEnviroment
Ambiente
Function
Id
Id As String
BLibreria
SymbolCS1504
Function
IdX
IdX As Integer
BScripting
Relacion
Function
IdY
IdY As Integer
BScripting
Relacion
Function
Id_salida
Id_salida As Long
BInventario
Inventario
Function
ImageList
ImageList As Object
CodeSense
CodeSense
Function
Imagen1
Imagen1 As Object
BImpresora
Impresora
Function
Imagen2
Imagen2 As Object
BImpresora
Impresora
Function
Imagen3
Imagen3 As Object
BImpresora
Impresora
Function
ImpresoraDeEtiquetas
ImpresoraDeEtiquetas As Object
BEnviroment
Ambiente
Function
ImpresoraDefault
ImpresoraDefault (strImpresora As String) As Object
BLibreria
DISLibreria
Function
ImprimeDocumento
ImprimeDocumento (cDocumento As String, nVenta As Long)
BVentas
Ventas
Sub
ImprimeFormato
ImprimeFormato (Formato As String, nDocumento As Long, Ambiente As Object, Parent As Object, bolPantalla As Boolean)
BScripting
BScript
Sub
ImprimeRenglon
ImprimeRenglon (nRenglon As Double, Imprimir As Boolean)
BReportes
Reporte
Sub
ImprimeReporte
ImprimeReporte ([nColumna As Long])
BReportes
Reporte
Function
ImprimeTotalGeneral
ImprimeTotalGeneral (nRenglon As Double)
BReportes
Reporte
Sub
ImprimeTotalesGrupo
ImprimeTotalesGrupo (nRenglon As Double, Columna As _Columna, [bolImprimir As BooleanVerdadero])
BReportes
Reporte
Sub
InStr
InStr ([Start], [String1], [String2], [ByVal Compare As VbCompareMethod = vbBinaryCompare])
VBA
Strings
Function
InStrB
InStrB ([Start], [String1], [String2], [ByVal Compare As VbCompareMethod = vbBinaryCompare])
VBA
Strings
Function
InStrRev
InStrRev (ByVal StringCheck As String, ByVal StringMatch As String, [ByVal Start As Long-1], [ByVal Compare As VbCompareMethod = vbBinaryCompare]) As Long
VBA
Strings
Function
IniciaDocumento
IniciaDocumento
BImpresora
Impresora
Sub
IniciaMonitor
IniciaMonitor
BusinessMonitor
clsBusinessMonitor
Sub
Init
Init
BLibreria
SymbolCS1504
Sub
InsertFile
InsertFile (ByVal strFileName As String, ByVal InsertPos As IPosition)
CodeSense
CodeSense
Sub
InsertItem
InsertItem (ByVal lIndex As Long, ByVal strAdd As String, [ByVal ImageIndex], [ByVal ItemData]) As Long
CodeSense
CodeList
Function
InsertLine
InsertLine (ByVal lLine As Long, ByVal strLine As String)
CodeSense
CodeSense
Sub
InsertText
InsertText (ByVal strText As String, ByVal InsertPos As IPosition)
CodeSense
CodeSense
Sub
Inserta
Inserta (cInserta As String, cBusca As String, cTarget As String) As String
BLibreria
DISLibreria
Function
InsertaSql
InsertaSql
BReportes
Reporte
Sub
Int
Int (Number)
VBA
Conversion
Function
Internet
Internet (Modulo As String, Clave As String, Modo As String, ByVal Ambiente As String, [strClave2 As String])
BLibreria
DISLibreria
Sub
Interrogate
Interrogate
BLibreria
SymbolCS1504
Sub
Into
Into As String
BQueryBuilder
Query
Function
Inventario
Inventario As Boolean
BEnviroment
Ambiente
Function
InventarioInicial
InventarioInicial As Boolean
BInventario
Inventario
Function
IsArray
IsArray (VarName) As Boolean
VBA
Information
Function
IsConnected
IsConnected As Boolean
BLibreria
DISLibreria
Function
IsDate
IsDate (Expression) As Boolean
VBA
Information
Function
IsEmpty
IsEmpty (Expression) As Boolean
VBA
Information
Function
IsHostSyncRunning
IsHostSyncRunning As Boolean
BLibreria
Ping
Function
IsMissing
IsMissing (ArgName) As Boolean
VBA
Information
Function
IsNull
IsNull (Expression) As Boolean
VBA
Information
Function
IsNumeric
IsNumeric (Expression) As Boolean
VBA
Information
Function
IsObject
IsObject (Expression) As Boolean
VBA
Information
Function
IsPlayingMacro
IsPlayingMacro As Boolean
CodeSense
CodeSense
Function
IsRecordingMacro
IsRecordingMacro As Boolean
CodeSense
CodeSense
Function
IsolationLevel
IsolationLevel As IsolationLevelEnum
ADODB
Connection
Function
ItemCount
ItemCount As Long
CodeSense
CodeList
Function
Join
Join (SourceArray, [Delimiter]) As String
VBA
Strings
Function
Key
Key As String
BLibreria
WsField
Function
Keywords
Keywords As String
CodeSense
Language
Function
Kill
Kill (PathName)
VBA
FileSystem
Sub
LLenaGeneral
LLenaGeneral (strSQL As String, Titulos As VBA._Collection, strIcon As String, [bolSoloUno As BooleanFalso], [cLetter As String]) As ADODB._Recordset
BLIstView
Llena
Function
LOF
LOF (ByVal FileNumber As Integer) As Long
VBA
FileSystem
Function
LandScape
LandScape
BImpresora
Impresora
Sub
Language
Language As String
CodeSense
CodeSense
Function
LastDllError
LastDllError As Long
VBA
ErrObject
Function
LastRec
LastRec (strTabla As String, Connection As ADODB._Connection) As Long
BLibreria
DISLibreria
Function
LastValue
LastValue
BReportes
Value
Function
Lector
Lector As Object
BEnviroment
Ambiente
Function
Len
Len (Expression)
VBA
Strings
Function
LenB
LenB (Expression)
VBA
Strings
Function
LengthOfId
LengthOfId As Long
BLibreria
SymbolCS1504
Function
LengthOfPacketData
LengthOfPacketData As Long
BLibreria
SymbolCS1504
Function
LengthOfRawData
LengthOfRawData As Long
BLibreria
SymbolCS1504
Function
Lenguaje
Lenguaje As String
BEnviroment
Ambiente
Function
Letra
Letra (nNumero, Leyenda, Decimales, [strLeyenda2]) As String
BImpresora
Impresora
Function
LeyendaFin
LeyendaFin As String
BImpresora
ParamData
Function
LeyendaFin2
LeyendaFin2 As String
BImpresora
ParamData
Function
LeyendaIni
LeyendaIni As String
BImpresora
ParamData
Function
LeyendaIni2
LeyendaIni2 As String
BImpresora
ParamData
Function
LiberaCompra
LiberaCompra (rstCompra As ADODB._Recordset)
BCompras
Compras
Sub
Licence
Licence As Boolean
BEnviroment
Ambiente
Function
LineCount
LineCount As Long
CodeSense
CodeSense
Function
LineNo
LineNo As Long
CodeSense
Position
Function
LineNumberStart
LineNumberStart As Long
CodeSense
CodeSense
Function
LineNumberStyle
LineNumberStyle As cmLineNumStyle
CodeSense
CodeSense
Function
LineNumbering
LineNumbering As Boolean
CodeSense
CodeSense
Function
LineSeparator
LineSeparator As LineSeparatorEnum
ADODB
Stream
Function
LineToolTips
LineToolTips As Boolean
CodeSense
CodeSense
Function
Linea
Linea (bLeft0, bTop0, bLeft1, bTop1)
BImpresora
Impresora
Sub
ListView
ListView As Object
BBuscar
Buscar
Function
LittleIconBag
LittleIconBag As Object
BEnviroment
Ambiente
Function
LlenaAFavor
LlenaAFavor ([nAbono As Long])
BLIstView
Llena
Sub
LlenaAlmacenes
LlenaAlmacenes ([nAlmacen As Long])
BLIstView
Llena
Sub
LlenaBancos
LlenaBancos ([cBANCO As String])
BLIstView
Llena
Sub
LlenaCentrosDeCosto
LlenaCentrosDeCosto ([cCtoCto As String])
BLIstView
Llena
Sub
LlenaClients
LlenaClients ([cCliente As String])
BLIstView
Llena
Sub
LlenaCobrads
LlenaCobrads ([cCobrad As String])
BLIstView
Llena
Sub
LlenaCobranza
LlenaCobranza ([nCobranza As Long])
BLIstView
Llena
Sub
LlenaColores
LlenaColores ([cColor As String])
BLIstView
Llena
Sub
LlenaComprasCanceladas
LlenaComprasCanceladas
BLIstView
Llena
Sub
LlenaComprasConfirmadas
LlenaComprasConfirmadas ([nCompra As Long])
BLIstView
Llena
Sub
LlenaComprasPendientes
LlenaComprasPendientes ([nCompra As Long])
BLIstView
Llena
Sub
LlenaConEgresos
LlenaConEgresos ([cConcepto As String])
BLIstView
Llena
Sub
LlenaConIngresos
LlenaConIngresos ([cConcepto As String])
BLIstView
Llena
Sub
LlenaConcxc
LlenaConcxc ([cConcxc As String])
BLIstView
Llena
Sub
LlenaConcxp
LlenaConcxp ([cConcxp As String])
BLIstView
Llena
Sub
LlenaConpres
LlenaConpres ([cConcepto As String])
BLIstView
Llena
Sub
LlenaCotizaciones
LlenaCotizaciones ([nCotizacion As Long])
BLIstView
Llena
Sub
LlenaCuentas
LlenaCuentas ([cCuenta As String])
BLIstView
Llena
Sub
LlenaCuenxpag
LlenaCuenxpag ([nCuenxpag As Long])
BLIstView
Llena
Sub
LlenaDefinicionDePolizas
LlenaDefinicionDePolizas ([cDefinicionDePoliza As String])
BLIstView
Llena
Sub
LlenaDevComp
LlenaDevComp ([nDevolucion As Long])
BLIstView
Llena
Sub
LlenaDevCompPendientes
LlenaDevCompPendientes ([nDevolucion As Long])
BLIstView
Llena
Sub
LlenaDevoluciones
LlenaDevoluciones ([nDevolucion As Long])
BLIstView
Llena
Sub
LlenaDevolucionesPendientes
LlenaDevolucionesPendientes ([nDevolucion As Long])
BLIstView
Llena
Sub
LlenaDistribuciones
LlenaDistribuciones ([nDistribucion As Long], [cEstado As String”PE”], [bolImagen As BooleanFalso])
BLIstView
Llena
Sub
LlenaEntradas
LlenaEntradas ([nEntrada As Long])
BLIstView
Llena
Sub
LlenaEntradasPendientes
LlenaEntradasPendientes ([nEntrada As Long])
BLIstView
Llena
Sub
LlenaEstaciones
LlenaEstaciones ([cEstacion As String])
BLIstView
Llena
Sub
LlenaEtapas
LlenaEtapas ([cEtapa As String])
BLIstView
Llena
Sub
LlenaFacCanceladas
LlenaFacCanceladas
BLIstView
Llena
Sub
LlenaFacturas
LlenaFacturas ([nVenta As Long])
BLIstView
Llena
Sub
LlenaFlujo
LlenaFlujo
BLIstView
Llena
Sub
LlenaFormatos
LlenaFormatos ([cFormato As String])
BLIstView
Llena
Sub
LlenaGruposDeCuentas
LlenaGruposDeCuentas ([cCveGpo As String])
BLIstView
Llena
Sub
LlenaImpuestos
LlenaImpuestos ([cImpuesto As String])
BLIstView
Llena
Sub
LlenaInvFis
LlenaInvFis
BLIstView
Llena
Sub
LlenaLineas
LlenaLineas ([cLinea As String])
BLIstView
Llena
Sub
LlenaMarcas
LlenaMarcas ([cMarca As String])
BLIstView
Llena
Sub
LlenaMedios
LlenaMedios ([cMedio As String])
BLIstView
Llena
Sub
LlenaModelos
LlenaModelos ([cModelo As String])
BLIstView
Llena
Sub
LlenaMonedas
LlenaMonedas ([cMoneda As String])
BLIstView
Llena
Sub
LlenaOP
LlenaOP ([cOP As String])
BLIstView
Llena
Sub
LlenaOrdenes
LlenaOrdenes ([nOrden As Long])
BLIstView
Llena
Sub
LlenaPagos
LlenaPagos ([nAbono As Long])
BLIstView
Llena
Sub
LlenaPerfiles
LlenaPerfiles ([cPerfil As String])
BLIstView
Llena
Sub
LlenaPeriodosContables
LlenaPeriodosContables ([nYear As Long], [nMonth As Long])
BLIstView
Llena
Sub
LlenaPresupuestos
LlenaPresupuestos ([nPresup As Long])
BLIstView
Llena
Sub
LlenaProds
LlenaProds ([cArticulo As String])
BLIstView
Llena
Sub
LlenaProveedores
LlenaProveedores ([cProveedor As String])
BLIstView
Llena
Sub
LlenaRemCanceladas
LlenaRemCanceladas ([EnTicket As BooleanFalso])
BLIstView
Llena
Sub
LlenaRemisiones
LlenaRemisiones ([nVentas As Long], [EnFacturaFalso], [EnTicket As BooleanFalso])
BLIstView
Llena
Sub
LlenaSalidas
LlenaSalidas ([nSalida As Long])
BLIstView
Llena
Sub
LlenaSalidasPendientes
LlenaSalidasPendientes ([nSalida As Long])
BLIstView
Llena
Sub
LlenaSucursales
LlenaSucursales ([cSucursal As String])
BLIstView
Llena
Sub
LlenaTallas
LlenaTallas ([cTalla As String])
BLIstView
Llena
Sub
LlenaTipoMovims
LlenaTipoMovims ([cTipoMovim As String])
BLIstView
Llena
Sub
LlenaTipopends
LlenaTipopends ([cTipopend As String])
BLIstView
Llena
Sub
LlenaTipos
LlenaTipos ([cTipo As String])
BLIstView
Llena
Sub
LlenaTiposDePolizas
LlenaTiposDePolizas ([cTipoPol As String])
BLIstView
Llena
Sub
LlenaTiposProv
LlenaTiposProv ([cTipop As String])
BLIstView
Llena
Sub
LlenaUbicacion
LlenaUbicacion ([cUbicacion As String])
BLIstView
Llena
Sub
LlenaUsuarios
LlenaUsuarios ([cUsuario As String])
BLIstView
Llena
Sub
LlenaVends
LlenaVends ([cVendedor As String])
BLIstView
Llena
Sub
LlenaVentasDeSucursales
LlenaVentasDeSucursales
BLIstView
Llena
Sub
LlenaVentasPendientes
LlenaVentasPendientes ([nVenta As Long])
BLIstView
Llena
Sub
LlenaZonas
LlenaZonas ([cZona As String])
BLIstView
Llena
Sub
Llenaempleados
Llenaempleados ([cEmpleado As String])
BLIstView
Llena
Sub
Load
Load (ByVal Object As Object)
VBA
Global
Sub
LoadFromFile
LoadFromFile (ByVal FileName As String)
ADODB
Stream
Sub
LoadRsFromXML
LoadRsFromXML (fullpath As String) As ADODB._Recordset
BLibreria
DISLibreria
Function
Loc
Loc (ByVal FileNumber As Integer) As Long
VBA
FileSystem
Function
LockType
LockType As LockTypeEnum
ADODB
Recordset
Function
MAPIMessages1
MAPIMessages1 As Object
BEnviroment
Ambiente
Function
MAPISession1
MAPISession1 As Object
BEnviroment
Ambiente
Function
MSComm
MSComm As Object
BEnviroment
Ambiente
Function
MakeDIR
MakeDIR (path As String)
BLibreria
DISLibreria
Sub
MarcaNumero
MarcaNumero (cNumero As String, cPuerto As String)
BLibreria
DISLibreria
Sub
MarshalOptions
MarshalOptions As MarshalOptionsEnum
ADODB
Recordset
Function
Max
Max (nNumero1 As Double, nNumero2 As Double) As Double
BLibreria
DISLibreria
Function
MaxRecords
MaxRecords As Long
ADODB
Recordset
Function
MaximoModuloDeTerminal
MaximoModuloDeTerminal (strModulo As String, strTerminalEstacion As String, Connection As ADODB._Connection) As Long
BLibreria
DISLibreria
Function
Mensaje
Mensaje (nId As Long, Ambiente As Object) As String
BLibreria
DISLibreria
Function
MensajeError
MensajeError As String
BScripting
BScript
Function
Mes
Mes (nMes As Integer) As String
BLibreria
DISLibreria
Function
MesAnterior
MesAnterior (nMes As Integer) As Integer
BLibreria
DISLibreria
Function
MesSiguiente
MesSiguiente (nMes As Integer) As Integer
BLibreria
DISLibreria
Function
Min
Min (nNumero1 As Double, nNumero2 As Double) As Double
BLibreria
DISLibreria
Function
Minute
Minute (Time)
VBA
DateTime
Function
MisMenus
MisMenus As VBA._Collection
BEnviroment
Ambiente
Function
MkDir
MkDir (ByVal Path As String)
VBA
FileSystem
Sub
ModificaAbono
ModificaAbono (nAbono As Long, [bolModalFalso])
BCobranza
Cobranza
Sub
ModificaArticulo
ModificaArticulo (cArticulo As String, [soloConsulta As BooleanFalso])
BArticulos
Articulos
Sub
ModificaCliente
ModificaCliente (cCliente As String, [soloConsulta As BooleanFalso], [bolModal As BooleanFalso], [objControl As Object])
BClientes
Clientes
Sub
ModificaCobranza
ModificaCobranza (nCobranza As Long, [bolModal As BooleanFalso])
BCobranza
Cobranza
Sub
ModificaCompra
ModificaCompra (nCompra As Long)
BCompras
Compras
Sub
ModificaDevolucion
ModificaDevolucion (nDevolucion As Long)
BVentas
Ventas
Sub
ModificaEntrada
ModificaEntrada (nEntrada As Long)
BEntradasSalidas
EntradasSalidas
Sub
ModificaFactura
ModificaFactura (nFactura As Long)
BVentas
Ventas
Sub
ModificaLinea
ModificaLinea (cLinea As String)
BArticulos
Articulos
Sub
ModificaMarca
ModificaMarca (cMarca As String)
BArticulos
Articulos
Sub
ModificaOrden
ModificaOrden (norden As Long)
BOrdenes
Ordenes
Sub
ModificaPedido
ModificaPedido (nPedido As Long)
BPedidos
Pedidos
Sub
ModificaRemision
ModificaRemision (nVenta As Long)
BVentas
Ventas
Sub
ModificaSalida
ModificaSalida (nSalida As Long)
BEntradasSalidas
EntradasSalidas
Sub
ModificaUbicacion
ModificaUbicacion (cUbicacion As String)
BArticulos
Articulos
Sub
ModificaVendedor
ModificaVendedor (cVendedor As String, [soloConsulta As BooleanFalso], [Modal As BooleanFalso])
BClientes
Clientes
Sub
ModificaVentaPendiente
ModificaVentaPendiente (nVenta As Long)
BVentas
Ventas
Sub
ModificarAbono
ModificarAbono (nAbono As Long)
BCuenxpag
Cuenxpag
Sub
Modified
Modified As Boolean
CodeSense
CodeSense
Function
Modifiers1
Modifiers1 As Long
CodeSense
HotKey
Function
Modifiers2
Modifiers2 As Long
CodeSense
HotKey
Function
Moneda
Moneda As String
BEnviroment
Ambiente
Function
Month
Month (Date)
VBA
DateTime
Function
MonthName
MonthName (ByVal Month As Long, [ByVal Abbreviate As BooleanFalso]) As String
VBA
Strings
Function
MoveFile
MoveFile (Source As String, Destination As String)
BLibreria
DISLibreria
Sub
MoveFirst
MoveFirst
ADODB
Recordset
Sub
MoveLast
MoveLast
ADODB
Recordset
Sub
MoveNext
MoveNext
ADODB
Recordset
Sub
MovePrevious
MovePrevious
ADODB
Recordset
Sub
MoveRecord
MoveRecord ([ByVal Source As String], [ByVal Destination As String], [ByVal UserName As String], [ByVal Password As String], [ByVal Options As MoveRecordOptionsEnum = adMoveUnspecified], [ByVal Async As BooleanFalso]) As String
ADODB
Record
Function
MovimientoInventario
MovimientoInventario (strArticulo As String, strClaveAdd As String, dblCantidad As Double, intAlmacen As Integer, strEntradaSalida As String, strTipoMovim As String, lngNumMovim As Long, dFecha As Date, [Id_salida As Long], [id_entrada As Long], [dblCosto As Double], [Kit As Integer])
BInventario
Inventario
Sub
MsgBox
MsgBox (Prompt, [ByVal Buttons As VbMsgBoxStyle = vbOKOnly], [Title], [HelpFile], [Context]) As VbMsgBoxResult
VBA
Interaction
Function
Muestra
Muestra
BCalculator
Calculator
Sub
MuestraAyuda
MuestraAyuda (Parent As Object, Ambiente As BEnviroment._Ambiente)
BScripting
BScript
Sub
MuestraBusqueda
MuestraBusqueda (strFiltro) As String
BBusquedaModelos
Bmodelos
Function
MuestraCobroEncaja
MuestraCobroEncaja
BVentas
Ventas
Sub
MuestraEditor
MuestraEditor ([strFormato As String], [Clasificacion As String], [bolModal As BooleanFalso], [Parent As Object], [Linea As Long])
BIDE
IDE
Sub
MuestraEditorFormas
MuestraEditorFormas ([strForma As String], [bolModal As BooleanFalso], [Linea As Long])
BIDE
IDE
Sub
MuestraPendientes
MuestraPendientes
BClientes
Clientes
Sub
MuestraVentanaDeAyuda
MuestraVentanaDeAyuda (Forma As Object, ByVal Ambiente As Object)
BLibreria
DISLibreria
Sub
MultiLineComments1
MultiLineComments1 As String
CodeSense
Language
Function
MultiLineComments2
MultiLineComments2 As String
CodeSense
Language
Function
MyMessage
MyMessage (strMensaje As String)
BLibreria
DISLibreria
Sub
MyMessage2
MyMessage2 (strMensaje As String, [DefaultButton As Integer1]) As Integer
BLibreria
DISLibreria
Function
MyUser
MyUser As String
BEnviroment
Ambiente
Function
Name
Name As String
BVentas
clsTextBox
Function
NativeError
NativeError As Long
ADODB
Error
Function
NewCS1504
NewCS1504 As _SymbolCS1504
BLibreria
DISLibreria
Function
NewCol
NewCol (cTitulo As String, cData As String, bolTotal As Boolean, [nAncho As Double], [Formato As String]) As _Columna
BReportes
Reporte
Function
NewCollection
NewCollection As VBA._Collection
BLibreria
DISLibreria
Function
NewDrillDown
NewDrillDown As DrillDownDB._DrillDown
BLibreria
DISLibreria
Function
NewFile
NewFile
BLibreria
DISLibreria
Function
NewFso
NewFso As Scripting.IFileSystem3
BLibreria
DISLibreria
Function
NewInforme
NewInforme As Object
BLibreria
DISLibreria
Function
NewPing
NewPing As _Ping
BLibreria
DISLibreria
Function
NewReport
NewReport As _Reporte
BReportes
Reporte
Function
NewSQLAnalizer
NewSQLAnalizer As _SQLanalizer
BScripting
BScript
Function
NewTextData
NewTextData As Object
BLibreria
DISLibreria
Function
NextRecordset
NextRecordset ([RecordsAffected]) As _Recordset
ADODB
Recordset
Function
NivelDeCuenta
NivelDeCuenta (cCuentaNivel1 As String, cCuentaNivel2 As String, cCuentaNivel3 As String, cCuentaNivel4 As String, cCuentaNivel5 As String) As Long
BLibreria
DISLibreria
Function
NoConfirm
NoConfirm As Boolean
BQueryBuilder
APIFile
Function
NoConfirmMakeDir
NoConfirmMakeDir As Boolean
BQueryBuilder
APIFile
Function
NoMovim
NoMovim As String
BInventario
Inventario
Function
Normalize
Normalize
CodeSense
Range
Sub
NormalizeCase
NormalizeCase As Boolean
CodeSense
CodeSense
Function
Now
Now
VBA
DateTime
Function
NuevaCompra
NuevaCompra
BCompras
Compras
Sub
NuevaDevolucion
NuevaDevolucion
BVentas
Ventas
Sub
NuevaEntrada
NuevaEntrada
BEntradasSalidas
EntradasSalidas
Sub
NuevaLinea
NuevaLinea
BArticulos
Articulos
Sub
NuevaMarca
NuevaMarca
BArticulos
Articulos
Sub
NuevaOrden
NuevaOrden
BOrdenes
Ordenes
Sub
NuevaSalida
NuevaSalida
BEntradasSalidas
EntradasSalidas
Sub
NuevaUbicacion
NuevaUbicacion
BArticulos
Articulos
Sub
NuevaVenta
NuevaVenta ([Tipo As String])
BVentas
Ventas
Sub
NuevoAbono
NuevoAbono ([bolModal As BooleanFalso])
BCuenxpag
Cuenxpag
Sub
NuevoAbonoParaCobranza
NuevoAbonoParaCobranza (nCobranza As Long, [nVenta As Long], [Dialogo As BooleanFalso])
BCobranza
Cobranza
Sub
NuevoCargo
NuevoCargo ([bolModal As BooleanFalso])
BCobranza
Cobranza
Sub
NuevoCliente
NuevoCliente ([Clasificacion As String], [objControl As Object], [bolModal As BooleanFalso])
BClientes
Clientes
Sub
NuevoPedido
NuevoPedido
BPedidos
Pedidos
Sub
NuevoProducto
NuevoProducto ([Clasificacion As String], [objControl As Object])
BArticulos
Articulos
Sub
NuevoVendedor
NuevoVendedor ([objControl As Object], [bolModal As BooleanFalso])
BClientes
Clientes
Sub
NumberOfBarCode
NumberOfBarCode As Long
BLibreria
SymbolCS1504
Function
NumericScale
NumericScale As Byte
ADODB
Parameter
Function
ODBC
ODBC As String
BEnviroment
Ambiente
Function
ODBCString
ODBCString As String
BEnviroment
Ambiente
Function
Observ
Observ As String
BImpresora
ParamData
Function
ObtenerCatalogo
ObtenerCatalogo (Connection As ADODB._Connection) As ADOX._Catalog
BImpresora
Impresora
Function
OnTop
OnTop (f As Object)
BLibreria
DISLibreria
Sub
OpenFile
OpenFile (strFile, n As Integer) As Integer
BLibreria
DISLibreria
Function
OpenSchema
OpenSchema (ByVal Schema As SchemaEnum, [ByVal Restrictions], [ByVal SchemaID]) As _Recordset
ADODB
Connection
Function
Operators
Operators As String
CodeSense
Language
Function
OrdenesAutomaticas
OrdenesAutomaticas
BOrdenes
Ordenes
Sub
Order
Order As String
BScripting
SQLanalizer
Function
OriginalValue
OriginalValue
ADODB
Field
Function
Out
Out (cPuerto, cCode)
BLibreria
DISLibreria
Sub
OutFile
OutFile (cFile, cCode)
BLibreria
DISLibreria
Sub
OutLine
OutLine (cPuerto, cCode)
BLibreria
DISLibreria
Sub
Overtype
Overtype As Boolean
CodeSense
CodeSense
Function
OvertypeCaret
OvertypeCaret As Boolean
CodeSense
CodeSense
Function
PCircle
PCircle (bLeft, bTop, bRadius)
BImpresora
Impresora
Sub
PadL
PadL (str, nVeces) As String
BLibreria
DISLibreria
Function
PadR
PadR (str, nVeces) As String
BLibreria
DISLibreria
Function
PageCount
PageCount As Long
ADODB
Recordset
Function
PageSize
PageSize As Long
ADODB
Recordset
Function
PaginaNueva
PaginaNueva
BImpresora
Impresora
Sub
Paginas
Paginas As Long
BImpresora
Impresora
Function
Pantalla
Pantalla As Boolean
BImpresora
Impresora
Function
PapelAncho
PapelAncho As Double
BImpresora
Impresora
Function
PapelLargo
PapelLargo As Double
BImpresora
Impresora
Function
PapelTipo
PapelTipo As Long
BImpresora
Impresora
Function
PaperOrientation
PaperOrientation As Integer
BImpresora
Impresora
Function
Param1
Param1 As Boolean
BImpresora
ParamData
Function
Param2
Param2 As Boolean
BImpresora
ParamData
Function
ParamData
ParamData As _ParamData
BImpresora
Impresora
Function
ParametrosRequeridos
ParametrosRequeridos ([pQueryIni As String], [pLeyendaIni As String], [pQueryFin As String], [pLeyendaFin As String], [pQueryIni2 As String], [pLeyendaIni2 As String], [pQueryFin2 As String], [pLeyendaFin2 As String], [Fechas As BooleanFalso], [pCheck As BooleanFalso], [pCheckValue As BooleanFalso], [pCheckLeyend As String])
BImpresora
ParamData
Sub
Parent
Parent As Object
BClientes
Clientes
Function
ParentURL
ParentURL As String
ADODB
Record
Function
Partition
Partition (Number, Start, Stop, Interval)
VBA
Interaction
Function
PathCollection
PathCollection As VBA._Collection
BQueryBuilder
Query
Function
Perfil
Perfil As String
BQueryBuilder
Paths
Function
Picture
Picture (picSource, ByVal pLeft, ByVal pTop, ByVal pWidth, ByVal pHeight)
BImpresora
Impresora
Sub
PlaySound
PlaySound (cFile)
BLibreria
DISLibreria
Sub
PonLetra
PonLetra (Numero As Double, Leyenda As String, bolDecimales As Boolean, [strMoneda As String]) As String
BLibreria
DISLibreria
Function
PopUp
PopUp (ByVal Text As String) As Long
BVentas
chmHelpVentas
Function
PorSurtir
PorSurtir (strArticulo As String, Connection As ADODB._Connection) As Double
BLibreria
DISLibreria
Function
PortComm
PortComm As Long
BLibreria
SymbolCS1504
Function
Portrait
Portrait
BImpresora
Impresora
Sub
PosFromChar
PosFromChar (ByVal pPos As IPosition) As IRect
CodeSense
CodeSense
Function
PowerDown
PowerDown
BLibreria
SymbolCS1504
Sub
PrCantidad
PrCantidad As Double
BInventario
Inventario
Function
PreciosPorSucursal
PreciosPorSucursal (cArticulo As String)
BArticulos
Articulos
Sub
Precision
Precision As Byte
ADODB
Parameter
Function
Prepara
Prepara (cString As String) As String
BLibreria
DISLibreria
Function
Prepared
Prepared As Boolean
ADODB
Command
Function
Presentaciones
Presentaciones (cArticulo As String)
BArticulos
Articulos
Sub
Preview
Preview (strTipo As String, strCodigo, Ambiente As BEnviroment._Ambiente, Parent As Object, [strProceso As String], [Observaciones As String])
BScripting
BScript
Sub
PrimerDiaDelaSemana
PrimerDiaDelaSemana (dFecha As Date) As Date
BLibreria
DISLibreria
Function
Principal
Principal As Boolean
BQueryBuilder
BTables
Function
PrintContents
PrintContents (ByVal hDC As Long, ByVal lFlags As Long)
CodeSense
CodeSense
Sub
PrintText
PrintText (PrintVar)
BLibreria
DISLibreria
Sub
ProcConfig
ProcConfig As Boolean
BEnviroment
Ambiente
Function
Process
Process As String
BQueryBuilder
Query
Function
ProtectSpreadsheet
ProtectSpreadsheet As Boolean
BExcel
ExcelFile
Function
Proveedores
Proveedores (cArticulo As String)
BArticulos
Articulos
Sub
Provider
Provider As String
ADODB
Connection
Function
Psw
Psw As String
BEnviroment
Ambiente
Function
PublicKey
PublicKey As String
BQueryBuilder
Query
Function
Puerto
Puerto As Long
BEnviroment
Ambiente
Function
QBColor
QBColor (ByVal Color As Integer) As Long
VBA
Information
Function
Query
Query As String
BQueryBuilder
Query
Function
QueryFin
QueryFin As String
BImpresora
ParamData
Function
QueryFin2
QueryFin2 As String
BImpresora
ParamData
Function
QueryIni
QueryIni As String
BImpresora
ParamData
Function
QueryIni2
QueryIni2 As String
BImpresora
ParamData
Function
Question
Question (strMensaje As String, [DefaultButton As Integer1]) As Boolean
BLibreria
DISLibreria
Function
Question2
Question2 (strMensaje As String, [DefaultButton As Integer1]) As Integer
BLibreria
DISLibreria
Function
Quote
Quote (cBlock As String) As String
BImpresora
Impresora
Function
Raise
Raise (ByVal Number As Long, [Source], [Description], [HelpFile], [HelpContext])
VBA
ErrObject
Sub
Random
Random As Double
BImpresora
Impresora
Function
RandomColor
RandomColor As Long
BImpresora
Impresora
Function
Randomize
Randomize ([Number])
VBA
Math
Sub
RawData
RawData As String
BLibreria
SymbolCS1504
Function
Read
Read ([ByVal NumBytes As Long-1])
ADODB
Stream
Function
ReadData
ReadData
BLibreria
SymbolCS1504
Sub
ReadLine
ReadLine (n As Integer) As String
BLibreria
DISLibreria
Function
ReadRawData
ReadRawData
BLibreria
SymbolCS1504
Sub
ReadText
ReadText ([ByVal NumChars As Long-1]) As String
ADODB
Stream
Function
RecordType
RecordType As RecordTypeEnum
ADODB
Record
Function
RecordsAfected
RecordsAfected As Long
BQueryBuilder
Query
Function
Redo
Redo
CodeSense
CodeSense
Sub
RegisterCommand
RegisterCommand (ByVal lCmdId As Long, ByVal strName As String, ByVal strDescription As String)
CodeSense
Globals
Sub
RegisterHotKey
RegisterHotKey (ByVal pHotKey As IHotKey, ByVal lCmd As cmCommand)
CodeSense
Globals
Sub
RegisterLanguage
RegisterLanguage (ByVal strName As String, ByVal LanguageDef As ILanguage)
CodeSense
Globals
Sub
RegistroDeProcesos
RegistroDeProcesos As Boolean
BEnviroment
Ambiente
Function
RegresaFormaXY
RegresaFormaXY (Form As Object, ByVal Ambiente As Object, [strSubForm As String])
BLibreria
DISLibreria
Sub
RegresaLotes
RegresaLotes (nSalida As Long, ByVal Ambiente As Long)
BLibreria
DISLibreria
Sub
Relation
Relation As String
BQueryBuilder
BTables
Function
RelationType
RelationType As String
BQueryBuilder
BTables
Function
RemoteStation
RemoteStation As String
BQueryBuilder
Paths
Function
Remove
Remove (Index)
VBA
Collection
Sub
RemoveDIR
RemoveDIR (path As String)
BLibreria
DISLibreria
Sub
RenameFile
RenameFile (Filename As String, Target As String)
BQueryBuilder
APIFile
Sub
RenameOnCollision
RenameOnCollision As Boolean
BQueryBuilder
APIFile
Function
Reordena
Reordena As Long
BInventario
Inventario
Function
ReplText
ReplText As String
CodeSense
CodeSense
Function
ReplaceMRUList
ReplaceMRUList As String
CodeSense
Globals
Function
ReplacePreserveCase
ReplacePreserveCase As Boolean
CodeSense
CodeSense
Function
ReplaceSel
ReplaceSel (ByVal strText As String)
CodeSense
CodeSense
Sub
ReplaceString
ReplaceString (strSearch As String, strSearchFor As String, strReplaceWith As String)
BLibreria
DISLibreria
Function
Replicate
Replicate (cChar As String, nVeces As Long) As String
BLibreria
DISLibreria
Function
ReporteEnBlanco
ReporteEnBlanco (Ambiente As BEnviroment._Ambiente, [Parent As Object])
BScripting
BScript
Sub
Requery
Requery ([ByVal Options As Long-1])
ADODB
Recordset
Sub
ResetDefaultHotKeys
ResetDefaultHotKeys
CodeSense
Globals
Sub
RestauraPapel
RestauraPapel
BImpresora
Impresora
Sub
Restore
Restore
BLibreria
SymbolCS1504
Sub
Result
Result As Long
BLibreria
SymbolCS1504
Function
ResultSet
ResultSet As ADODB._Recordset
BQueryBuilder
Query
Function
Resync
Resync ([ByVal AffectRecords As AffectEnum = adAffectAll], [ByVal ResyncValues As ResyncEnum = adResyncAllValues])
ADODB
Recordset
Sub
Retrieve
Retrieve
BReportes
Reporte
Sub
RetrieveColumns
RetrieveColumns
BReportes
Reporte
Sub
RetriveQuery
RetriveQuery (strFile As String)
BQueryBuilder
Query
Sub
RetsultString
RetsultString As String
BLibreria
SymbolCS1504
Function
ReturnValue
ReturnValue As Double
BCalculator
Calculator
Function
RigthMargin
RigthMargin As Double
BReportes
Reporte
Function
RmDir
RmDir (ByVal Path As String)
VBA
FileSystem
Sub
Rnd
Rnd ([Number]) As Single
VBA
Math
Function
RollbackTrans
RollbackTrans
ADODB
Connection
Sub
RowDetail
RowDetail As Double
BReportes
Reporte
Function
RowTitulo
RowTitulo As Double
BReportes
Reporte
Function
RowTitulo2
RowTitulo2 As Double
BReportes
Reporte
Function
RowTitulo3
RowTitulo3 As Double
BReportes
Reporte
Function
RstRO
RstRO (strSql As String, Connection As ADODB._Connection, [bolPantalla As BooleanVerdadero]) As ADODB._Recordset
BLibreria
DISLibreria
Function
RunForm
RunForm (strProceso As String, Parent As Object, Ambiente As BEnviroment._Ambiente, [cCodigo], [bolModal As BooleanVerdadero])
BScripting
BScript
Sub
RunProcess
RunProcess (strProceso As String, Parent As Object, Ambiente As BEnviroment._Ambiente, [cCodigo], [anyObject As Object], [ErrorPantalla As BooleanVerdadero], [Timer As BooleanFalso], [EntryPoint As String], [strEvento As String])
BScripting
BScript
Sub
SQL
SQL As String
BScripting
SQLanalizer
Function
SQLReport
SQLReport (reportName As String, Ambiente As BEnviroment._Ambiente)
BScripting
BScript
Sub
SalidaPeps
SalidaPeps (nConsec As Long) As Double
BInventario
Inventario
Function
SalidaPromedio
SalidaPromedio (nConsec As Long) As Double
BInventario
Inventario
Function
SalidaUeps
SalidaUeps (nConsec As Long) As Double
BInventario
Inventario
Function
SalvaFormaXY
SalvaFormaXY (Form As Object, ByVal Ambiente As Object, [strSubForm As String”frmMaster”])
BLibreria
DISLibreria
Sub
SalvaHistCamb
SalvaHistCamb (articulo As String, precio1 As Double, precio2 As Double, precio3 As Double, precio4 As Double, precio5 As Double, precio6 As Double, precio7 As Double, precio8 As Double, precio9 As Double, precio10 As Double, [ByVal Ambiente As Double])
BLibreria
DISLibreria
Sub
SalvaVenta
SalvaVenta (rstVenta As ADODB._Recordset)
BVentas
Ventas
Sub
SaveFile
SaveFile (ByVal strFileName As String, ByVal bClearUndo As Boolean)
CodeSense
CodeSense
Sub
SaveProcess
SaveProcess (cProcess As String)
BQueryBuilder
Query
Sub
SaveQuery
SaveQuery
BQueryBuilder
Query
Sub
SaveSetting
SaveSetting (ByVal AppName As String, ByVal Section As String, ByVal Key As String, ByVal Setting As String)
VBA
Interaction
Sub
SaveToFile
SaveToFile (ByVal FileName As String, [ByVal Options As SaveOptionsEnum = adSaveCreateNotExist])
ADODB
Stream
Sub
Say
Say (y, x, strMensaje)
BImpresora
Impresora
Sub
Sc
Sc As MSScriptControl.IScriptControl
BReportes
Reporte
Function
Sc1
Sc1 As MSScriptControl.IScriptControl
BReportes
Reporte
Function
ScopeKeywords1
ScopeKeywords1 As String
CodeSense
Language
Function
ScopeKeywords2
ScopeKeywords2 As String
CodeSense
Language
Function
ScriptControl1
ScriptControl1 As Object
BEnviroment
Ambiente
Function
SearchCaseSensitive
SearchCaseSensitive As Boolean
CodeSense
CodeSense
Function
SearchRegExp
SearchRegExp As Boolean
CodeSense
CodeSense
Function
SearchWholeWord
SearchWholeWord As Boolean
CodeSense
CodeSense
Function
Second
Second (Time)
VBA
DateTime
Function
Seek
Seek (ByVal KeyValues, [ByVal SeekOption As SeekEnum = adSeekFirstEQ])
ADODB
Recordset
Sub
SelBounds
SelBounds As Boolean
CodeSense
CodeSense
Function
SelLength
SelLength As Long
CodeSense
CodeSense
Function
SelLengthLogical
SelLengthLogical As Long
CodeSense
CodeSense
Function
SelText
SelText As String
CodeSense
CodeSense
Function
SelectLine
SelectLine (ByVal lLine As Long, ByVal bMakeVisible As Boolean)
CodeSense
CodeSense
Sub
SelectedItem
SelectedItem As Long
CodeSense
CodeList
Function
SendSpecialKey
SendSpecialKey (strKey As String)
BLibreria
DISLibreria
Sub
Separador
Separador (Separator As String, strSearch As String, List() As String) As Long
BLibreria
DISLibreria
Function
SeparadorDecimal
SeparadorDecimal As String
BLibreria
DISLibreria
Function
Servidor
Servidor As String
BEnviroment
Ambiente
Function
SetAllBookmarks
SetAllBookmarks (Lines() As Long)
CodeSense
CodeSense
Sub
SetAttr
SetAttr (ByVal PathName As String, ByVal Attributes As VbFileAttribute)
VBA
FileSystem
Sub
SetBookmark
SetBookmark (ByVal lLine As Long, ByVal bVal As Boolean)
CodeSense
CodeSense
Sub
SetCaretPos
SetCaretPos (ByVal lLine As Long, ByVal lCol As Long)
CodeSense
CodeSense
Sub
SetColor
SetColor (ByVal lColorItem As cmColorItem, ByVal crColor As Long)
CodeSense
CodeSense
Sub
SetColumnWidth
SetColumnWidth (FirstColumn As Byte, LastColumn As Byte, WidthValue As Integer)
BExcel
ExcelFile
Function
SetDTR
SetDTR (ByVal nOnOff As Long)
BLibreria
SymbolCS1504
Sub
SetDateTime
SetDateTime (lngYear As Integer, lngMonth As Integer, lngDay As Integer, lngHoras As Integer, lngMinutos As Integer, lngSegundos As Integer)
BLibreria
DISLibreria
Sub
SetDefaults
SetDefaults
BLibreria
SymbolCS1504
Sub
SetDivider
SetDivider (ByVal lLine As Long, ByVal bVal As Boolean)
CodeSense
CodeSense
Sub
SetDlgParent
SetDlgParent (ByVal lhWnd As Long)
CodeSense
CodeSense
Sub
SetEOS
SetEOS
ADODB
Stream
Sub
SetFilePassword
SetFilePassword (PasswordText As String) As Integer
BExcel
ExcelFile
Function
SetFont
SetFont (FontName As String, FontHeight As Integer, FontFormat As FontFormatting) As Integer
BExcel
ExcelFile
Function
SetFontStyle
SetFontStyle (ByVal lFontStyleItem As cmFontStyleItem, ByVal byFontStyle As cmFontStyle)
CodeSense
CodeSense
Sub
SetFooter
SetFooter (FooterText As String) As Integer
BExcel
ExcelFile
Function
SetHeader
SetHeader (HeaderText As String) As Integer
BExcel
ExcelFile
Function
SetHidden
SetHidden (filename As String)
BLibreria
DISLibreria
Sub
SetHotKeys
SetHotKeys (HotKeysBuff() As Byte)
CodeSense
Globals
Sub
SetItemData
SetItemData (ByVal lLine As Long, ByVal lData As Long)
CodeSense
CodeSense
Sub
SetLineStyle
SetLineStyle (ByVal lLine As Long, ByVal lStyle As Long)
CodeSense
CodeSense
Sub
SetMacro
SetMacro (ByVal lMacro As Long, MacroBuff() As Byte)
CodeSense
Globals
Sub
SetMargin
SetMargin (Margin As MarginTypes, MarginValue As Double) As Integer
BExcel
ExcelFile
Function
SetMarginImages
SetMarginImages (ByVal lLine As Long, ByVal byImages As Byte)
CodeSense
CodeSense
Sub
SetNormal
SetNormal (filename As String)
BLibreria
DISLibreria
Sub
SetParam
SetParam (nParam As Long, szString As String, nMaxLength As Long)
BLibreria
SymbolCS1504
Sub
SetReadOnly
SetReadOnly (filename As String)
BLibreria
DISLibreria
Sub
SetRetryCount
SetRetryCount (nRetryCount As Long)
BLibreria
SymbolCS1504
Sub
SetSel
SetSel (ByVal Sel As IRange, ByVal bMakeVisible As Boolean)
CodeSense
CodeSense
Sub
SetSystem
SetSystem (filename As String)
BLibreria
DISLibreria
Sub
SetTime
SetTime
BLibreria
SymbolCS1504
Sub
SetTopIndex
SetTopIndex (ByVal lView As Long, ByVal lLine As Long)
CodeSense
CodeSense
Sub
Sgn
Sgn (Number)
VBA
Math
Function
Shell
Shell (PathName, [ByVal WindowStyle As VbAppWinStyle = vbMinimizedFocus]) As Double
VBA
Interaction
Function
ShellCommand
ShellCommand (strCommand As String, intProperty)
BLibreria
DISLibreria
Sub
ShellRun
ShellRun (hWnd As Long, Operation As String, FileURL As String, [Param As String], [Direc As String], [ShowComand As Long]) As Long
BLibreria
DISLibreria
Function
ShellSortAny
ShellSortAny (vArray, [ByVal SortOrder As SortOrder = SortAscending])
BLibreria
DISLibreria
Sub
ShowData
ShowData
prjMultiCombo
MultiCombo
Sub
SiguienteIdModulo
SiguienteIdModulo (strModulo As String, Connection As ADODB._Connection) As Long
BLibreria
DISLibreria
Function
Silent
Silent As Boolean
BQueryBuilder
APIFile
Function
SimpleProgress
SimpleProgress As Boolean
BQueryBuilder
APIFile
Function
Sin
Sin (ByVal Number As Double) As Double
VBA
Math
Function
SingleLineComments
SingleLineComments As String
CodeSense
Language
Function
SkipLine
SkipLine
ADODB
Stream
Sub
SmoothScrolling
SmoothScrolling As Boolean
CodeSense
CodeSense
Function
SocketCliente
SocketCliente As Object
BEnviroment
Ambiente
Function
SocketClientes
SocketClientes As Object
BEnviroment
Ambiente
Function
SocketServidor
SocketServidor As Object
BEnviroment
Ambiente
Function
SoloRecalculo
SoloRecalculo As Boolean
BInventario
Inventario
Function
SoloSeleccionados
SoloSeleccionados As Boolean
BImpresora
ParamData
Function
SortAscending
SortAscending = 0
BLibreria
SortOrder
Const
SortDescending
SortDescending = 1
BLibreria
SortOrder
Const
SortStyle
SortStyle As cmCodeListSortStyle
CodeSense
CodeList
Function
Sqr
Sqr (ByVal Number As Double) As Double
VBA
Math
Function
Sqr2
Sqr2 (nDato) As Double
BLibreria
DISLibreria
Function
StartColNo
StartColNo As Long
CodeSense
Range
Function
StartLineNo
StartLineNo As Long
CodeSense
Range
Function
StartPolling
StartPolling (ByVal csp2CallBack As Long)
BLibreria
SymbolCS1504
Sub
State
State As ObjectStateEnum
ADODB
Stream
Function
StayInSync
StayInSync As Boolean
ADODB
Recordset
Function
StdDev
StdDev (a) As Double
BLibreria
DISLibreria
Function
StealKeys
StealKeys As Boolean
CodeSense
CodeSense
Function
StopPolling
StopPolling
BLibreria
SymbolCS1504
Sub
StrComp
StrComp (String1, String2, [ByVal Compare As VbCompareMethod = vbBinaryCompare])
VBA
Strings
Function
StrReverse
StrReverse (ByVal Expression As String) As String
VBA
Strings
Function
StringDelims
StringDelims As String
CodeSense
Language
Function
SubPerfil
SubPerfil As String
BQueryBuilder
Paths
Function
Sucursal
Sucursal As String
BEnviroment
Ambiente
Function
Publicado el 4 comentarios

Congreso Anual de Punto de Venta MYBUSINESS POS 2012

 

Esta es la Información que nos ha proporcionado MyBusiness POS para su próximo Evento:

Ya está designada la sede del CONGRESO ANUAL MYBUSINESS POS 2011 !CANCUN!

  • Fecha: Del 19 al 22 de Mayo.
  • Lugar: Hotel Great Parnassus, Cancún, Quintana Roo.
  • Costo:
    • Del 16-Feb al 15 Mar: $ 2,500.00
    • Del 16-Mar al 15 Abr: $ 2,750.00
    • Del 16-Abr al 30 Abr:  $ 3,000.00
    • Precios NETOS por persona con base en  ocupación doble por cuatro días y tres noches, todo incluído en Hotel Great Parnassus.
    • Incluye conferencias de fabricantes y mayoristas, y una licencia de MyBusiness POS para reventa.
  • EL CUPO ES LIMITADO y está diseñado para distribuidores realmente interesados en generar negocio, con obligación a asistir a todas las pláticas y talleres.
  • Depósitos: Banorte…
! RESERVA YA! NO TE QUEDES SIN TU LUGAR.
Publicado el 3 comentarios

Dar Mantenimiento Base de Datos MyBusiness POS 2011

El siguiente post será cómo dar mantenimiento a la base de datos Mybusiness POS 2011, así como lo hacíamos en la version 2006…

Sql_Management_Studio-mybusinesspos