Search results

I search for a function to return the age and find http://allenbrowne.com/func-08.html But i want years with months If less than year returned months only ???

Hii all dears I have an Access database with a main form that contains 9 subforms. I created 9 tabs, each containing one subform, and each subform uses a parameter based on the tab it is located on. All the subforms have the same record source and design, but they differ only by a single...

Hi all dears I have a db with extension mde . That was open normally by access 2007 , now i use access 2016 but gives Msg ( This database was created with the 32-bit version of Microsoft Access. Please open it with the 32-bit version of Microsoft Access.) I haven't machine with 2007 HOw to...

Hi all dears I have a db , that was previously opened by access 2007 I have now access 2016 , that couldn't open by. Please help me to change to open by access 2016 . See to the attached files

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