Search results

Hello again. With the exposed combobox it filters results according to the inserted text, however I have observed a strange behavior. If I insert a word that sequentially matches a record in the combobox, that object does not filter the matching records. However, if I force an incorrect script...

I already notice my error, this statement "Me.ccoEmisor.RowSource = "qryEmisor_Todos"" work incorrectly in event gotfocus but fine in lostfocus. Sorry for disturbing and my english. Regards. EDIT: I forgot to change nivel privacity in youtube, you should can see it now EDIT2: I did upload...

Hi, I have created one example for combobox but it behavior is strange. I uploaded video that is better than 1000 words. I upload mdb file for you analyze and debug error. Thanks in advance. https://youtu.be/t5UaavkN4PU

Yes, no problem. The MAINFORM form, has combobox named 'cboData' that has linked to event AfterUpdate macro 'test.msg'. And command button that open form named 'Form2' Inside this macro, there are two submacros 'msg' and 'open'. Submacro 'msg' show msgbox with test message, and 'open' open...

Ok, I found like do it. I attach database with solution, hope that be useful for someone. Thanks. Regards.

Hi, all. I have two forms, one mainform and another form, form2, that is open from mainform. In mainform, has one combobox and after inserting data, it trigger event executing macro "test" for showing a msgbox. In form2, has another combobox that after inserting data, it trigger event...

Solved, I put screenshot:

I can not order resulta using calcules field of report, for this cause I need sumatory on query for using like group head of report.

Hi, guys. I apologize for my english because is not my native language. I made a query that gathers all the people who have won a prize, each award has a value, that is why each person can be repeated. According to the value of the prize I need get the sum of that baremación to classify people...

I know that use VBA is more efficient but is imposed for other persons. Foro me is more easy to use VBA, too.

Thanks for answering, I tried set format property like you say, but it has a effect not want, I am refering to change of text between lower and upper case when doing click on other control and after doing click on previous control. Why access shows reverse string with last macro of my previous...

Hey, I am new here, my language native is not english, I apologize in advance for my mistakes in grammar. I want emulate, in one macro, this VBA function/sub: Private Sub Tip_KeyPress(KeyAscii As Integer) KeyAscii = Asc(UCase(Chr(KeyAscii))) End Sub With below macro, I got uppcase text...