Recent content by Ciprian

Thank you nanscombe and vbaInet for the help with this.

I usually understand code, but the access programing language is still a bit too weird for me. I prefer Excel VBA, C++, mysql But to answer your question this is where it get's stuck .FindFirst "cContractsID = " & Me.ContractNr That's why asked for help in updating the db i posted. After...

Thanks guys, you've got it :) For some reason I can't make it work on my own db so I've attached it here. If you could modify it, that would be great. Thanks

The type is Number. But FactNr is just used in the aforementioned query as criteria.

yes i have and it's not doing anything

Hi and Happy New Year! Like i said in the first post, there are 2 Text boxes. The 1st one is named "FactNr". The 2nd is named "ContractNr". The source of the 2nd one is =DLookUp("[cContractsID]";"[q nr ctr dupa factura]";[FactNr]) [cContractsID] - text field in a table with stores the...

Hi, I'm trying to jump to a record from a textbox. So i have a form [Inserare Contracte] which has the record source the table [tblContracte]. In that form I have 2 textboxes. In the first one [FactNr] i enter the invoice number, then in the second one [ContractNr] i get the Contract...

managed to do it with this =[fiCost]-Sum([fipAmount])

I attached a jpeg showing what i would like to achieve, but for now i took your advise and removed the alternate back color. thanks

Hi, i have a report that shows the status of queried contracts. One of the field shows the amount the client still has to pay, which it does by calculating the difference between the invoice amount and the amount payed. The problem i'm having is that the calculated field does not know how to...

here you go 11I005 and 11I006 are the one which have more lines

i asked a question about a report and yes if someone wants and can help me that's great and i thank him/her for that. i showed u the design of the report which has all the fields, and one of the tables involved in the query used for the report (even though i told you that the field was "text"...

so i guess oki doki means oke bye :)

i can't give you the actual database. if you want and can help me with the code, the info i gave so far should be sufficient

thanks for the help