Search results

Hello everyone I have a field to store the insurance card number according to the companies. Each insurance company has a special pattern in numbering its subscribers' cards as follows: 1. Company A Yyy*xxxxxxxx Yy*xxxxxxxxx Y*xxxxxxx 2. Company B Xxxxxxx*y Xxxxxxx*yyy Xxxxxxxx*yyy 3...

Hi all dears Please help me to run this app. On my machine 64bit system I need it necessarily.

I have an Access database named HTBSD2023 and another HTBSD2024.they contains lots of the same tables, The problem is that I want to link to the first database by importing tables. The problem is that the names of the tables in the two databases are the same, which affects the dependencies of...

In a database for a store, there is a main form and a subform within it. Required: If the user enters an item in the subform and its price is zero, upon leaving the main form the user will be notified that there are one or more items whose prices are zero and that they will be deleted, and the...

Hiii How to alignment the text on a textbox based on the characters entered to it , if English use left alignment if Arabic use right alignment?

Hii all dears I have a form that displays single records of a data. On that form there a list box to show the dates of current patient visits . My question: how to highlight the date (on the listbox) of the current visit of that patient ?

Dears ,, Sometimes I work without connecting to the internet, so I need the help file for Office 2016, as there is no help file for this version except through direct internet connection. How can I get the Office 2016 help file?

hii to all on myForm there two buttons , one "A" for printing MyReport , "B" button for export that report "MyReport" to pdf format . there a label on that report "MyReport" refer to the electronic version of that report "pdf version" like : this is an electronic version that didn't need to...

hiii to all i recently installed office 2016 on my pc , but when try to open mdb file it gives an error . error massage : could any one convert code of that attached file to work on access 2016 ?

hii to all dears i have recently installed office 2016 , 64 bt , as the heading of this threat ( Is There Any Way To Customize The Menu/status/tab Bar Colors in Access 2016? ) , is there a way to change red color of tabs to a blue color ?

hii all dears based on this example i build a seperated filter form (without record source data) , to filter another form , but it does not filter that another form . i use this code : Dim strWhere As String 'The criteria string. Dim lngLen As Long...

Hii all dears How How do I create a combo box to display the caption for the fields of the form source table ?

Hii all dears I have a store db , tblInvoic : -InvoiceID -InvoiceDate -CustomerID -DiscountAmount (Long data-type) tblInvoiceDetails -InvoiceNo -ItemID -ItemPrice -Quantity -ItemDiscount (Percentage) of (ItemPrice multiplied by Quantity). some sellers offer a discount on the total value...

hii al dears i have this expression : PersonA: CLng(nz(Dcount("OrderID";"Q105";"InsurCmpName=13" & " AND [OrderDate]>= #" [FirstDayVal] & "# AND [OrderDate] <=" # [LastDayVal]);0)) Can you hlep me to correct this expression ?

hii dears on main form a textbox ( txt2 ) to gives me the total of subform some field how to requery that textbox ( txt2 ) after user add new item on the sub form without return to the first record on the subform ?

hii all i have a main form with a tab , 9 sub forms i notice navigation between records become slow , then i search for a solution , i find this code : Private Sub ps_Change() Select Case ps.Pages.Item(ps.Value).Name Case "pg1" ' Where sfrm1 is the name of the subform on page 1 If...

Hi dears I have a form on it textbox for dates , it validation rule is between 01/01/2022 and 31/12/2022, i use a popup built-in calender form to select dates . But the validation rule didnot work except when user insert the date by keyboard or using the access popup calendar . How to make...

hiii dears i have a db to collect the services of polyclinic center that handle with insurance companies and thier costumers. - tblBillHead : contains a field companyID (fk connected to tblCompanyData on Pk CompanyID) - tblBillDetails (conjunction table) : contains ServiceNo , BillNo ...

hi to all i use this code but open form with a new record : Private Sub Form_Load() Dim MyFilter As String If CurrentProject.AllForms("MainFrm").IsLoaded Then MyFilter = "Forms![MainFrm]![InsurCmpName]= " & Me.CompnyID Me.Filter = MyFilter Me.FilterOn = True End If End Sub but its go to new...

hi i have a report with group level section , i use this code : Private Sub G1Header_Format(Cancel As Integer, FormatCount As Integer) If Me.InsurCmpName = 3 Then Me.G1Header.ForceNewPage = 1 End If End Sub how to get the page no. of that section exactly not to all the report ?