Search results

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...

VilaRestal, just added the field "CompanyID" in the Product table. And I did a one to many relationship table company to the table product. I think the logic is the same image that you sent me 5, but with more tables. Thanks for helping.

Friends, I thought it would be the solution to my problem by putting a one to many relationship table technology product to the table, but I have the following problem. When I register a new product, I need to indicate in which technology, and also which company. For example, if the company...

Pat hartan, thanks, I did as you told me. It worked perfectly. Again, thank you.

Friends, as I have attached a table company, a table technology and a junction table to create a many to many. I'm trying to create a form with combobox cascade. I have two buttons, one to search for another company and to check for technology. First I put looking for technology as the...

VilaRestal and Pat Hartman, I managed to solve the problem of relations, in fact, I only need a one to many relationship table technology products for the table. Thank you for helping.