Search results

Hello, i have an old ms access database that am stuck with in my work, where am facing an error when the total of multiplication is greater than 22, 000,000. I can not comtact the programmer anymore and need your help. It is access 98.

Hello, i have graduated recently as a pediatrician, and i need clinic software. If anyone interested we can discuss tje points that must be included Thank you.

Hi everyone. i have a navigation form and i added a button for a form that contains a combobox and a listbox, a query showed in listbox and filtered by the combobox. The problem is that the form is working fine alone. But when i added it to the navigation form when i press the navigation button...

hi, i need your help in this issue, i tried searching the net but couldn't solve it. i need to open form1 from form2 and display in unbound textbox a definite title for the form. according to the title i want to hide some fields and unhide others. thanks

hello guys, im trying to make a database for my employes to count their attendance according to the days of the month and then get their salary. i was thinking if there is any idea on how to create a form that show the days of the month and then i can add the names of the attending employes...

i have a table with yes / no field named cleared for checks. i want to make a search form with combo box to query for cleared (yes) and not cleared (no) checks. i tried combo box with values set in it, yes and no. but it didnt work.

i have a single page report, with narrow margins, and every thing is fit to the margins, and i have a header and footer. when i print it i have a white blank page without the header and footer. i searched the forum and google it with no success.

i have a form, in its current function i wrote this code: me.id_pat = forms!pat_info!id_pat but every time i open the form it blinks same as when it refresh, and when i have 2 records in the table, not duplicate, it saves a blank record with the id. i need help !! if there is nothing to do, i...

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

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 =...

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 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 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

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

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...

Hi every one my name is hassan from lebanon. Im new in access and hope to learn much from you Thank you