Search results

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

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

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

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

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

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

Friends, I am having difficulty creating a relationship of tables in a database. I have a table and another table technology company. For each technology has several companies, and for each company have different technologies. A many to many. I created a join table to resolve this issue, with...

Friends, I have a report with eight subs. I was trying not to show empty sub, and in subreport also part white. Resolved, but to place it can shrink and can expand, for all sections of all subreports also placed time zero for all subreports. In the event when loading the subreport I repeat...

Friends, I have this sql statement: SELECT TblAnalista.NomeDoAnalista, TblEmpresa.NomeDaEmpresa, TblProduto.NomeDoProduto, TblPassosStatus.Passo, Nz([DataReprogramada],[DataProgramada]) AS DataDue, TblPassosStatus.C FROM ((TblAnalista LEFT JOIN TblEmpresa ON...

In VBA, as I refer to a field value from the previous record in a subform.

Gentlemen, I have a form with three combo boxes where one filters out the other. I'm trying to put them in alphabetical order And the ORDER BY is not working. I tried a few: 'Me.combEmpresa.RowSource = "SELECT CodEmpresa, NomeDaEmpresa FROM TblEmpresa WHERE CodAnalista= " &...

Gentlemen, I have a subform with the following fields: name of the step, the scheduled date, place and date rescheduled date. I'm having trouble making a statement in a query that has the following criteria: need to know what the step is smaller than today's date between the date scheduled and...

gentlemen, I have a form with three combos. Analyst, company and product. I'm trying to create a fourth combo to inactive products. That is, the company update the combo, a combo shows the products and another shows inactive products. How do I create a button on the form to send the active...

I have a form with three combos and a subform with the following fields: Step, dataprogramada, and datareprogramada datarealizada. The field step has a list box with 15 steps. I'm trying to include a new record 7 of these 15 steps to populate. Can anyone help me?