Search results

Im really impressed. Thanks allot man!

Aaaah you are a genius my friend!!! Well done. Thank you allot this will help me allot, becuase i should be able to apply it to other areas as well. :D:D:D:D:D:D:D:D:D

I tried it quickly, but still does not work. i am currently using: =DLookUp([Forms]![*Capture Orders]![Unit list subform].[Form]![Aermec PO];[Unit list];[Aermec order])

I tried it that way, but it still shows #name? But do you think that is correct the way i have done it?

Thank you allot. I would appreciate it allot. Been trying for more than a month to do this. You will see there is a few inputs i have plaid around with. But at the Quoted Euros field in the Capture Invoice form i want the total values to be displayed of the specific POA number in the Unit list...

I guess it would have worked, but i need to incorperate it in a function that searches that field. What does it mean if it shows <<Expr>> =DLookUp( Forms![*Capture Orders]![Unit list subform].Form![Aermec PO];[Unit list]; «Expr» [Aermec order])

I wont mind sending the access file to you. Would you mind?

Thats correct. I have tried attaching a snip.

The forms are: *Capture orders **Subform under Capture order is: Unit list *Capture invoicing The tables are: *Orders *Unit List *Invoicing The POA reference number is inserted into the Capture order form into the field Aermec O/N. Then all the values are inserted in the unit list subform. The...

Ciao Ciao I am struggling to do something simple, but it seems not it does not want to work. I have two tables, one for invoice and one for values. Both of them has the same referance, the Purchase order number(POA). I do not want to type my values over and over for each table, i only want to...

Aaaah that worked perfectly. I forgot about that. Thank you allot!!!!!!!!!!!!!!!!!!! >DateAdd("m";18; [DeliveryDate] )

Hi vbaInet I did select expression and try playing around with the expression. The closest I got to was DateAdd("m";18; [DeliveryDate] ), but still did nothing. It wont change to red if I change the delivery date lower than the warrantee end date.

Hi, I want a cell in a form to be highlighted when a unit is out of warrantee. At the moment we will deliver a unit on site and then from that date we count 18months for warrantee period. So I have two cells, one called warrantee end date and delivery date. If the 18 months has come to pass...

I tried using conditional formatting based on the date, so I gave it a separate date up to warrantee date more or less. Once that date has been reached it will go red. Ill assume it stays red if I say; [=>19-06-2015]

Thank you spikepl. Can you maybe explain how I do instruct access to use conditional formatting when the time of a specific site is finished?

With queries do I retrieve data and then forms do I input data?

That will actually be perfect! How do I assign the sites(rows) with the function to inform access that it is out of warrantee from order. I like your idea allot more

Good day I'm working for a company that sells refrigeration equipment. Part of my job is to keep track of projects we are doing. Currently we are using excel and it is getting a pain because there is so many data to put in. I want to start doing this in access via forms that the personnel...