Recent content by rchumpitaz

This is the SQL (SELECT tbl_data.ID_REGISTRO, tbl_data.Fecha_Registro, tbl_data.Proveedor, tbl_data.Codigo_SOLTEG, tbl_data.Familia, tbl_data.Titulo, tbl_data.Composicion, tbl_data.Apariencia, tbl_data.Acabados, tbl_data.Descripcion, tbl_data.Observacion, tbl_data.Estampado, tbl_data.Solido...

Sorry, here it is (//drive.google.com/open?id=1xB8K6eHuGjd8pIGwiV11qHTcVszNsqPx) when a field that is compromise in the search is empty it is not show in the results. On purpose I put some incomplete records so as you can check in "tlb_data" there is 5 records but in the "qer_data" theres only...

This is the query (//imgur.com/Y9o0BIK) When I try to make a filter for the field "ACABADOS" and there is no records in it the filter show no results but after some research I think it has to be related with the query criteria (//imgur.com/Y9o0BIK).

Sorry about my little explanation. The code above is the one I'm using for searching records but when the field in the table is empty because is an optional field there is no record show in the even when the textbox is empty. Private Sub SearchFor_Change() 'Create a string (text) variable...

Hello I'm using John Big Booty code in my db for some multi search but when I tried to apply it in another DB in a field that are not neccesary filled by the user the listbox show me no records but only the ones that were fill. How can I correct that? Thank you link to dynamic multi search...

Hi everyone, I'm trying to do this action and after several investigation I found that DoCmd.TransferSpreadsheet do the job, but just one time because when I'm trying to export the data again the data doesn't overwrite in the file and I have to eliminate the archive to generate a new one. Anyway...

I'm starting a project in access for my enterprise and I want to make it the right way so I know this will be the best place to ask. Best regards from Peru,