Search results

i have access 2019 version

Just i put a field in inventory table for price

I make that Combobox to select product. Combobox settings: Name: cbxProduct RowSource: SELECT ProdID, ProdName, ProdPrice FROM Products ORDER BY ProdName; ControlSource: Product BoundColumn: 1 ColumnCount: 3 ColumnWidths: 0;1;0.25 VBA code in combobox AfterUpdate event: Me!Price =...

Its ok .I made it.Thank you all

Than you.I try that

Thank you for template but i have the same problem for all templates and just ask why

If you have time take a look in my example.I think i cant do all that you tell me.Im not so good in access

How can ubdate a price but have the old prices for older records.Im not input yet a field in "Inventory" named Unit cost

When im going to download a template show me that message.Why

Thank you all

If i understand the strName is equal to txtFirstName or the name of field in table "FirstName"

How can this code put it in module and call it from text box in after update

Good morning from Greece How can i put that code in module and call it when after update a field If Right(txtFirstName, 2) = "ος" Then txtFirstName = Left(txtFirstName, Len(txtFirstName) - 1) & "υ" End If If Right(txtFirstName, 2) = "ης" Then txtFirstName = Left(txtFirstName, Len(txtFirstName)...

Ok i try it.Thank you

I want to make that not only for one name but for all names.Make any name i want to general or accusative.Wher can i put your code.Im not so good with access

Im not understand what you mean

I want if the first name ends with "Η" to make it "ΗΣ" That make it and for other endings in one line of code

I want name conversion to general and accusative.If i write it clear

How can fix it.Thank you for your answeer

Is that the right code for change the end of first name: SET GENIKH = LEFT(firstName,LEN(firstName)-1) & "Υ" WHERE RIGHT(firstName,2)="ΟΣ"; Some words are in Greek