Search results

i need to know how to get the multi value from list box in my form to be used in a query the list box worked great when it was not multi value

i have a form with subform in it, and when i press the save button in the main form it saves only the records in it but it wont save the records in the subform i found on microsoft this code DoCmd.Save acForm, "New Employees Form" how can i use it to save both the main form and subform together

thank u brharrii, u wouldnt imagine how much the help im getting from this forum :D

thanks for ur help guys Brianwarnock it worked great

thanks namliam YourVariable = "text text " YourVariable = YourVariable & "More more" YourVariable = YourVariable & "Even even" YourVariable = YourVariable & "more more" it worked very good

i have this code for calculating the age from birthdate but i want if there is years no months or days appear Public Function CalcAge(Birthdate As Date) As String Dim intYears As Integer, intMonths As Integer, intDays As Integer intMonths = DateDiff("m", Birthdate, Date) intDays =...

it didnt work it gave me error : syntax error

i have a problem with this code it is multiline html paragraph i attached the picture of the code and this is a sample Private Sub Command124_Click() If Me.Text120 = "Air contrasted colon examination for suspected invagination approach" Then Me.REP_DETAIL = "<p>After placement of Foley...

i tried this and it worked the way i needed code: Private Sub Birthdate_AfterUpdate() Me.AGE.Value = DateDiff("yyyy", [Birthdate], Now()) + Int(Format(Now(), "mmdd") < Format([Birthdate], "mmdd")) End Sub

i didnt work. if anybody knows what is the best way to automatic calculate the age in a form

i want to use the AfterUpdate to calculate the age using two textfieds Private Sub Birthdate_AfterUpdate() Me.AGE = DateDiff("yyyy", [Birthdate], Now()) + Int(Format(Now(), "mmdd") < Format([Birthdate], "mmdd")) End Sub but it wont work

i tried but nothing happened in the form i want a standard text to be inserted to the textfield according to what is chosen in combo box

i have a problem with if statement, i have a combo box and a textfield, i wrote the following code: Private Sub Combo107_Click() If Me.Combo107 = "cxr" Then Me.REP_DETAIL = "chest x-ray" ElseIf Me.Combo107 = "ct" Then Me.REP_DETAIL = "ct scan" End If End Sub i compile the code...

i use access 2013 and i can't find setfield in action category, any suggestions

i have a form that contains a combobox and textbox. i want according to combobox choice a fixed template to be populated in the textbox and then can be edited (delete and add more text as needed) without changing the original template

code to set the value equal to the value of textbox in subform

sorry i didnt get it, im new at access and i got it from the internet. so plz how to solve it

is it possible to set 2 control source to a textbox. i have a textbox in a form where it gets the value from subform =[Child9].[Form]![Text25] and i need to save it in a table in field INV_TOTAL

Option Compare Database 'Use database order for string comparisons Option Explicit Global Const CCYID_LL = 0 Global Const CCYID_USD = 1 Function CurrencyFormat(CurrencyID As Integer) As String Select Case CurrencyID Case CCYID_LL CurrencyFormat = "#,##0.00 á.á."...

Hello guys. I have a form that have textbox that calculate total and then i want to convert numbers to words. Iv got the code with function currencytotext but when i set the code source of another textbox to: =currencytotext([inv_total]) i have an error I saw this on internet but i think bcz im...