Search results

Yes, I tried it What I want is: I need the first page to be filled with the same area as the footer then the footer moves to the second page if the report has two pages. The First Picture If the report one page The second Picture if the report Two page i made them by Word

Thanks for your interest When the number of records is less than 17 the report mode is correct But when the number of reports increases, example 17 or higher gives the following error message What I want when the report becomes more than one page, the footer moves to the last page without the...

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

when i try to add the days to new record... add button add nothing until i go to qryMonth_Dates and put the ID manual

Many Thanks My Friend when i try to add to next record i got this error

Thanks for replying Do need another table? If so, be in another table

Hallo arnelgp can u look at this topic is it possible to do that or not?? https://access-programmers.co.uk/forums/showthread.php?t=297784 thanks

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.

Thank you arnelgp so much, your Contribution were of a great help to me.

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

Thanks for your replay your nots are good but what i need is: in the table InputDate the dates for example: 04/09/2016 05/09/2016 8/09/2016 ======= what i need is 6/09/2016 and 07/09/2016 empty i use : on the code Const WeekEnd = "0", WorkDay = "+", holdy = ""Select Case Weekday(d1) Case 6...

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

Thanks Mr CJ London But this does not serve me waiting for mr cronk

I don't know how to do it !!! Could Y please do it in a small db and attach it , Thank y very match

I'm not well versed in Visual Basic programming :) Thanks But How To use this in Form or report? waiting 4 ur answer

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

sxschech Thank you very match

Nothing happened ... I need to change the font to Arial font size 12 cells autofit .. etc ...

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