Search results

Hi Im trying to make a loop that refers to my text boxs. Im Using Me!Saturday1.Value Does anyone know of a way where l can just change the number on the Me. using a +1 somehow. For Example Me.Saturday1.value for change to Me.Saturday2.Value the text box names are below. Saturday1 Saturday2...

Yeah have dchecked but goes straight to Current code after going through New record.

Hi I am trying to get a form to open a new record when its opens but the Form current is running after the open and is not opening a new record. just goes to the first record. Here whats in the Current. If Me!Listbox.Value = "Gym" Then Me.Hours.Visible = True Else Me.Hours.Visible = False End...

Thanks That Helped

Hi I am trying to get access window to pop top the front if an event happen get the below code of the internet. Private Declare Function SetForegroundWindow Lib "user32" (ByVal hwnd As Long) As Long Public Function ActivateAccessApp(TargetFullname As String) As Boolean Dim appTarget As...

Thanks Mark that worked

Thanks but that gives the total working days, which l have all ready got. I'm after the working days of each month for a date range

Hi Is there any way of finding out in a query or vba the workdays in each month between to dates. so for example between 01/03/2016 - 10/04/2016 so it gives me a Figure of March has 22 and April has 7 in that time period. i have a piece of VBA that tells me how many work days in total.

The Changing to double worked thank you

I am trying to work out a difference between two time from a form. I have a form the people put the Start Time and End Time Then in my VBA l have the following code. Dim Lvalue As Integer StartTime = [Forms]![Time]![Start] EndTime = [Forms]![Time]![End] Lvalue = DateDiff("n", StartTime...

Just Thought l would say Hi and introduce myself I'm Jay and l know some access programming and have been using this site for a bit and thought it was time to sign up. Jay