Search results

where to put this formula?? the field is date type

Hi Guys now i am very satisfied with what you guide me to make I noticed that every time i try to insert a revenue to my database in the form i keep entering the invoice date manually!! while its already inserted earlier in the sales table in the revenue form i created a combo box which showing...

actually it's Solved, and as you know access is a huge world of opportunities and every thing can be done in multiple ways i'm new to access and managed to create a great database that do everything i want it to be done, with the help of the GREAT PEOPLE in this forum, so Thank you guys

THANK YOU VERY MUCH it worked great now how to add a refresh code to this VBA, so it refresh the form after each form update

see the attachment

i deleted it right now and working on the VBA way i'll reply later with a screen shot Thak you

what do you mean by control?? the table?? and i know that i should choose either one

is this code right Private Sub Form_AfterUpdate() Private Sub YourControlName_AfterUpdate() Dim strSql As String strSql = "UPDATE Sales INNER JOIN Revenues ON (Sales.[Customer]=Revenues.[Customer]) AND (Sales.[Date]=Revenues.[Invioce Date]) SET Sales.[Paid On] = Revenues.[Payment Date]" WHERE...

sorry would you please tell me where to put this CODE?? should i add in place my code?

i did tried to SetWarnings to No But still the messages showing

This is the code used to make the job done UPDATE Sales INNER JOIN Revenues ON (Sales.[Customer]=Revenues.[Customer]) AND (Sales.[Date]=Revenues.[Invioce Date]) SET Sales.[Paid On] = Revenues.[Payment Date] WHERE Sales.[Paid On] Is Null;

the query opened by macro, and the code is VBA how to add both of them??

i used the SQL statement posted earlier

i made the form of revenue to run the query as an after update, so after each insertion of the payment the sales table updated accordingly, But i keep seeing the warning message. where do you suggest to add the VBA code in order to suppress these messages?

where to put the VBA code to affect this query?

i mean is there an option to turn it off completely for this query only??

how to turn the warning message Off that appear when i run the query??

it worked great Thank you:)

UPDATE Sales INNER JOIN Revenues ON Sales.Customer=Revenues.Customer AND Sales.Date=Revenues.Invioce Date SET Sales.Paid On=Revenues.Payment Date WHERE Sales.Paid On Is Null SELECT Sales.id, Sales.Customer, Sales.Discount, Sales.Quantity, [quantity]*(55.5-[discount]) AS Price, Sales.Date...

i did what you told me and got error message syntax error missing operator in query expression ".