Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a table of orders with various data such as:
- Order Id
- Date Order
- Zone
- Pack
- Amount
The user selects multiple orders assigning lot numbers, when the user decides, should be stored in an intermediate file (.qvd) repeating this process several times.
When reloading the orders table, you must also load this file (.qvd) in which we already have orders assigned LOTE number, reassign a new batch orders.
LOTE number should automatically generate as a sequence number.
I think the process should be based on use qvd temporary files in which to save the batch number assigned.
Any help is welcome.
Any help??
Firt of all, QV is not intended to save data, is to view data.
I suggest that you assign Lote number wihtin an application, for instance in you ERP and just read data in QV.
But any way, create a variable, a listbox and a button. Select orders in the listbox, assign Lote in the variable and make a macro for saving the QVD file.
Si, si ya lo se que QV es para visualizar, pero tengo que resolver un tema que pasa por una simulación que hago en QV y necesito guardar grupos de datos (Num.Pedidos) asociados un dato generado en la simulación (Lote), es por eso que utilizo QV para resolver esto,
Como realmente no es necesario que sea un QVD, voy a tratar de hacerlo con un excel o fichero de texto, da igual.
La idea de la lista y el botón ya lo tengo hecho, pero la macro no me sale ... si tienes un modelo, te lo agradeceré.
Saludos,
EC