Search results

Hi pbadly, did you find anything?

Here it is!

I changed the command to do the association only with ids (instead of invoice id to use the record id) and I dont get the error, but still not working. Because it is bit messy check also the screenshots. Thanks again for your patience! (database is 4MB thats why I used wetransfer) STOIXEIA.id...

Oops sorry, only the second one is text. So I put it DoCmd.OpenForm "form2", , , "client_id = " & Me.Parent.client_id & " AND invoice_id = '" & Me.invoice_id & "'" and when I click the button it popups: Enter Parameter Value (for invoice_id) Whatever I put I get: Run-time error '3071': This...

That's my modified code: DoCmd.OpenForm "form2", , , "form2.client_id = '" & Me.Parent.client_id & "' AND form2.subform2.invoice_id = '" & Me.invoice_id & "'" but I get the following error: Run-time error '3075': Syntax error (missing operator) in query expression 'form2.client_id='4' AND...

I made the following. DoCmd.OpenForm "form2", , , "form2.client_id = '" & Me.client_id & "'" AND "form2.subform2.invoice_id = '" & Me.invoice_id & "'" 1. Instead of Me.client_id it should say something like BeforeMe.client_id, because we suppose that the button is on subform1. 2. Is "AND"...

Thanks for your reply. As I understand this link describes how to open second form based on criteria on first form. But I want based on criteria both of subform and form. (Or I dont understand well. I am not good with VBA)

I have a Table table_clients and a connected table (1-->many) table_invoices. I have two forms: form1(table_clients): all clients with subform1(table_invoices): all invoices for every client the form2 and subform2 are the same, just objects are placed differently on page. I want when I have...

I made accde, but the user is still able to delete queries. I want the user not to have any "abilities" on changing anything. Like exe

I am trying to lock the accde file that I ve made so as the user not to be able to change forms or queries, but I cant find any way. Does anyone know how to?

Thank you very very much recyan! It worked like a charm!

Hi I have a large table with many duplicate names, but with different phone numbers. I want to merge them so as each name to be connected to a table with all phones. eg. From Table1 to go to Table_Names and Table_Phones as in picture Any ideas?

I tried it and works fine! I made a query calculating the TotalToPay and another one with the TotalPaid, so everything appears well enough in the report! But,... when someone hasn't paida anything, then the query doesn't return results and the cell Rest=TotalToPay-TotalPaid returns error...

@jzwp22 i tried to make the same calculation in the report, but i get an error. Adding everything in queries and then creating report makes sense, and i will try it tomorrow in the office. @lagbolt the two tables are totally different. the first one describes the service that the client bought...

Hello, I really need help with this I have 3 tables BASIC TOPAY PAID TOPAY and PAID have a field called AMOUNT. They are connected: BASIC.ID=TOPAY.ID BASIC.ID=PAID.ID What I want is to make a report with all information, and also a subtract of sum(TOPAY.AMOUNT) - sum(PAID.AMOUNT) I have...