Recent content by fabiobarreto10

Perfect nanscombe, just switched mod11 to mod10, and it worked perfectly. I appreciate the help of all of you. thank you so very much.

Friends, I am trying to create a function to generate checkers two digits of a number (eg, 2012001). This function is working, but for some numbers it returns 3 or 4 digits, I would like help from you to identify where the error is. Any help is welcome. Thank you. Public Function...

Perfect Peter, managed to solve with your tip. Thank you.

friends, I have a form with a textbox and a button that opens a report in accordance with the date placed in the text box. When I put the date 09.28.2012 the report opens with usually only records the date 28/09/2012. When I put the date 01.10.2012 shows no record in the report, but there are...

Friend, I managed to solve. Thank you for your help.

Thank you. I partially understand what you told me. I think I walked a bit by putting a sub in the other. (bd attached) But still not coming out perfectly. Could you tell me otherwise? Thank you.

vbaInet thanks for replying and helping. I am sending the db again with some modifications to better explain. Please open the form (fFilters) in combo Analyst choose "David" and then in the combo "Company" choose "IBM", will show a button labeled "Briefing" click it to open a report with 5...

Gentlemen, I have a table "company" with a one to many relationship with the table "Product". The table "Product" has a ratio of one to many tables with the "Steps" and "Notes." I have a report with three subreports, (1. With the product name and company. 2. Steps and 3. The comments.) In...

Very, very, very thanks. I was trying to solve this problem is more than a week. Worked perfectly. Again, thank you.

Thanks for SQL. I did exactly as you gave me. But, still returning two values ​​for each product, I need only one. Just made ​​a small change in SQL. SELECT tblAnalyst.nameofanalyst, tblCompany.nameofcompany, tblProduct.nameofproduct, tblStep.Date2, Max(tblStep.StepID) AS MaxOfStepID FROM...

Sorry, all the tables are filled correctly and the links are correct as well. Just wanted to know how do the query. Thank you.

Thanks for responding. Yes, of course I have to populate a parent table first. What does this have to query I'm trying to do? Thank you.

friends, I am sending herewith the relationship of four tables. I'm trying to do a query for records with the maximum value of "StepID" of each product, and also with the field "Date2" value. That is, a single record for each product. If the "Date2" empty returns no records. I thought it was...

Trevor, I took the line of code from a model, and was trying to open according as a String instead of integer. Fix and it worked. Thank you.

Friends, I am trying to create a report with many fields and tables of different (but related). As I have many fields, had to do subreports so that the fields to print perfectly. I have a button on a form, and I'm trying to open the report in accordance with each company that is selected in a...