Search results

VilaRestal and Pat Hartman, thanks for all the suggestions. I am studying how best option to solve my problem. Thank you.

VilaRestal and Pat Hartman, thank you for responding and helping. sorry VilaResta, I do not quite understand what you say quiz. I have to create a second table join? images of relationships attached. Thank you. Now Hartman, I was a little confused by your explanation, but I think that...

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

vbaInet, thank you for your help, Sorry for being slow to respond, I was without internet. I was able to partially resolve.I put a button on the form to open the report. Thus, it opens directly in Print Preview, subreports showing correctly and also printing correctly. Again, thank you.

Okay, I'll prepare better. I created eight reports using the wizard through eight different queries. Then I created a report with 8 subs using reports created earlier. I'm trying to hide subs when empty, and also not to be blanks. I managed to do this using the following procedures: In the...

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

Paul, Thank you. It worked perfectly. Thank you

pbaldy, How do I put the sql, so I tried but did not work. Syntax error (missing operator). SELECT TblAnalista.NomeDoAnalista, TblEmpresa.NomeDaEmpresa, TblProduto.NomeDoProduto, TblPassosStatus.Passo, Nz([DataReprogramada],[DataProgramada]) AS DataDue, TblPassosStatus.C FROM ((TblAnalista...

pbaldy, thanks for responding. Sorry, I drew up wrong, I'm trying two criteria. I'm trying to dates before today between 15 and 30 days. For example, dates from March 19 until April 4, ie 30 days before until 15 days before today. Thank you.

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

It really is a date. I got it. I just added the name of the subform: DataAnterior = DLookup("[DataRealizada]", "TblPassosStatus", "[CodPassosStatus]=Forms![fFiltros]![subTblPassosStatus]![CodPassosStatus]-1") I'll also try with the code you sent me. Thank you for help.

I tried DLookup, but did not work: DataAnterior = DLookup ("[DataRealizada]", "TblPassosStatus", "[CodPassosStatus] = Forms! [FFiltros]! [CodPassosStatus] -1") Where did I go wrong?

okay. I have a subform with four fields: step, the scheduled date, place and date rescheduled date. By changing the field step, I need to identify the value of the field held the previous record date. Thank you.

okay. I have a subform with four fields: step, the scheduled date, place and date rescheduled date. By changing the field step, I need to identify the value of the field held the previous record date. Thank you.

Yes, thank you

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

pbaldy and Beetle, thanks for responding and helping. Beetle thanks for the tips, It worked perfectly. Thank you.

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= " &...

Nickha, Sorry for being slow to respond, was having problems in my broadband. Actually my problem was a bit complex, but managed to solve by making three appointments, one from the other. I appreciate the help and attention, I will mark as resolved. Again, thank you.

Thank you for responding, for help. I'm trying to make an appointment to make a report by each assessor. I have a form where there is a comboBox with the names of advisors. After selecting a name, I'm trying to open a report with all the companies and products, and won every step of their...