Search results

Hi All I took this report from the following Post Adding blank rows to a report The report was made by the genius arnelgp What I need is to show the Footer of the report when it is one page and show it on the last page when the report has more than one page While keeping the blank lines...

Hi All Her is A test DB i want to add days from 1 to 10 without the holidays i used a code written by arnelgp at my post her: https://access-programmers.co.uk/forums/showthread.php?t=281672 What I want is to insert the date from 1 to 10 without completing the date for the next employee.

hi all what i need is: show the great value for each group max2 in group3 must be 2 not 5 her is a pic and db

Hi Every one I have a report containing text boxes I want to be moved by the code as shown in the example I use the traditional method Is there another way? Her what i do Private Sub Report_Open(Cancel As Integer) Dim xx xx = 1440 Dim wd wd = 0.22 * xx Dim i For i = 1 To 24 Me("a" & i).Width...

Hi There Hope You Are Good in code below i need to add ElseIf to exception the missing days: Function HolDateType(EmpNumF As Integer, d1 As Date) As String 'On Error Resume Next If OutOfDate = True Then Exit Function Dim rst As DAO.Recordset, SQL As String Dim d2 As Date d2 =...

Hi all I'm not well versed in Visual Basic programming --- i have numbers from 1 to 100 Divided into groups From 1 to 5 6 to 10 11 to 25 etc ... what i need : When I pass No. 1, for example, should gives me" First Basic A No. 2 : First Basic B No. 3 : First Basic C No. 4 : First Basic D No...

Hi all How can I Format The exported to Excel file in the simple i attach?? thanks

Hi all This attach justifying the text as using the justify button in a Word document It works good in English text can any one help me to do the same For Arabic language?? when i wright Arabic in the text it show Inverse text. Thanks

Hi All I have three numbers, and I want the program to choose the minimal value "between the three" .. with exclusion of "zero" value if it one of them .. "If there is 1 zero of the three values, choose the minimal value from the other 2 values .. If there is 2 zero values of the three...

Hi i have a code that shows the days of the week, i want to except Friday and Saturday and not to show them in the report. Function GetNthDay(d As Date, n As Integer) As Date '' Returns a date that is the Nth day of the given month and year GetNthDay = DateSerial(Year(d), Month(d), n) End...

helloooooooooo