Recent content by Cabrita

Hello, I would like to make a form that the user cannot print the information that the form shows. How can I do that? Thank you so much! Andre

Hi, How can I print code bar in excel? Thank you Andre

Thank you oharab!

Can anyone give an hand? Thank you!

Hello, This is the expression I have built usinf the help in VB, but I get the followinw error message "Type mismatch" If DLookup("[Loja]", "XXX - Utilizador Actual", "[gerente]" = 1) = 2 Then Me.Space1.SourceObject = "A1 - Recebimentos e Descontos" End if any ideas? Thanks Andre

Thanks ZmrAbdulla, I think that can solve my problem, I'll try to to it to work. Best Regards Andre

Hello, I have a form with a bottom and I would like that bottom to look a value on a value on a table and give me a result, something like this: IF [table][field1]=1 then ..... IF [table][flied1]=2 then ... But I don't know how to write it so that it works. Thank you for your help. Andre

Hi, How can I in a form, make two controlBox, to be related on to another, this is: I can one check on of the two boxes, when I click one the other automaticaly unmarkes. Can anyone give me an hand? Best regards, Andre

I started with this query, can anyone give an hand SELECT * FROM Table1 WHERE DATA1=(select max([data1]) from table1 where [data1]>[data2]))) GROUP BY ....; thank you very much

Hello, I want to make a query that is grouped by code-bar field and has to data fields: data1 and data2 Data2 - the grouping field - so it has all values Data1 - in each line has the maximum value but under the value of data2 of the line Table1 cod-bar data1 123 01-01-2004...

Hi Michael Red, Thank you very much for your help, I tryed to develop the query that so that it would not calculate the diference between the first two lines, but it would be interative but I cannot do it, any ideas? Thank you very much andre

Hi MichaelRed, Thank you very much for your insight, but can you please make a more detailed explanation and how can you make this possible in access? My access knowledge has some limitations. Thank you very much. Andre

Hello, I have this kind of data and my problem is: -How can I create a query that will return to me the time that each item was in the store before it was sold. I would be very appreciated if someone could help me. thank you Code Bar Situation Quantity Date 1223232 Buy...

Hi Michael, That's a solution, but it does not solve my problem, because the form still runs but it's not visible. What I need is for the sub-form only runs when I press the botton, because it takes time for the sub-form to load... Any ideas? Thank you Happy new year! Andre

Sorry, but I has a problem with your solution. I have a botton on the principal form when clicked I want to make the sub-form to run, and your solution only works if that botton is inside the sub-form. Do you have any solution? Thank you very much Andre