Recent content by Everterra

I made it. I put the code inside the form and call the function on the click of the button. Thanks for the help.

Sorry, meanwhile I edited the last post. Now I want to apply the code to a report that opens the last record. As I said in the edited post: "The code runs ok until the end, but not produce a pdf file as expected. Initially the code was used in a form and carrying the value of that form, but...

Thanks darbi. This give me the error: "Expected variable or procedure, not module.":banghead: I have the code in a module converted from a macro. That´s an error too. I was waiting to solve the first error. The code run ok until the end, but not produce a pdf file as expected. Initially...

Please help to correct this code to reuse it on clicking a button. Function EmiteRecibo() On Error GoTo EmiteRecibo_Err Dim strArquivo As String Dim strLocal As String strArquivo = "Recibo" & Me!RecTId & Me!TbEntAbv & ".pdf" 'aponta para a pasta do ficheiro pdf a criar onde...

Thanks again, jdraw. All comments are relevant to me. Yes, I've done research (even in Capterra), but the solutions do not suit our needs. Anyone who understand something about software, thinks they can always do better !! Perhaps not a clean, beautiful, arranged system with automated...

Thanks jdraw for you interest and insight. Since I´m not a native English speaker (I´m from Portugal) I don´t quite understand what is "1 part/line at a time", but maybe, as I understand you are saying that I´m building as I go, step by step or brick by brick - something like this. Yes, that´s...

Thanks, Ranman256. With your help and after much work I did it. :banghead: Now, Step 3. In my bd attached, (Step 2), clicking the button brings the Composition Form. I need to attribute a receipt to that form. How can I did it? Pls see the table schema relations. It's like having two...

I am having trouble finding a solution to this problem. Assign receipts to records in an existing table. In a table, let's say Flow, I have movements of revenues and expenses, and releases monthly quota owners. See the image attached. Step 1 - I already have a form selected with payments...

Many thanks CJ_London. Since I'm working in another task, I will try your code later. I'll return later, too.

I think the query don't have errors. I just want to have something that tells me the action is running. Should I put in that "your sql string here" this: DoCmd.OpenQuery "RecibosT_QCriarRecibo", acViewNormal, acReadOnly or this? INSERT INTO RecibosT ( RecT_FluxoId ) SELECT...

Thanks. So, I can transform the macro in VBA. I want o execute an update query. Can I use that "db.execute and then capture the recordsaffected value to say 'you have updated 2 records' "? What it would be the code?

How to control which messages to see when executing a macro? I have a macro calling an update query but I need only see one message, the second one. I want to turn off the warnings but I want to know the action will be done. "You are about to update 2 row(s)."

In Access 2013 I have a query that join two tables, Conduminium Owners to their possetions (fractions of conduminium). Owners.Own Owners.Vote SumOfTblFracPerc O; P................................No................9,54 F....................................Yes................5,48 L...

Ok, resolved Using a listbox, >Properties >Source >Source line, and using there the Constructor, I mounted a query. For the fist list box to show the Count, the result was: SELECT Count(tbEntidades.tbAssPresente) AS ContaPresentes, tbEntidades.tbAssPresente FROM tbEntidades GROUP BY...

Hello. In Access 2013 I have 2 tables tbAssembleias tbEntities The tbEntities, have a fiel called tbPresent (yes/no) to register the presents in a condominium meeting. Table Name: tbEntities Fields: tbEntId...tbPresent (yes / no)..........tbVotes...