Search results

I want to convert minutes to hours. I have tried minutes / 60 but this shows incorrect minutes i.e. 165 min = 2hr75min Does anyone no how to do this so the 75 is 45 min. Thanks in advance

I have a form 8cm * 8cm. When I open the form I would like it to appear in the right hand side of the screen instead of the middle. Is this possible!

When tabing from a subform to a sudform the preceding subforms takes the focus from showing the data inputted to showing none, as if you were adding new data. Is it possible to stop this happening as I would like all data shown!

I have a form which contains two subforms. I want to tab from one subform to the other. Can anyone help. I can tab from the subforms to the main form! by using: Forms![frmPrintActivity]![PrintIDNumber].SetFocus

I have a form where I need to enter the same data to the same field for every record ie May-02 to the 'PayMonth' field. Is there a way I could only enter this data once, so it would then cascade to all the other records in the form.

I have a form with a subform. I have set the 'Data Entry' property to 'yes' in the subform, after entering some data, the property will change to 'no' automaticly on the 'Data Entry' property. So all the data entered is visible. Can anyone enlighten me why Access does this, and can I stop it!!

I have data relating to a start date and end date. I want to be able to run a parameter query that will select data relating to the start and end date, but will also allow for cross over months, IE Table data: Start End 28-03 03-04 Parameter entry: 01-04 03-04 = 3 Is...

Is it possible that when you run a parameter query, that if no info is inputted, the query will show all details!

Between DateSerial(Year(Date()),Month(Date())-1,1) And DateSerial(Year(Date()),Month(Date()),0) I am using the above to select the preceding 12 months data, but it does not show the current months details, can this be adapted to do this!

I have a startdate and enddate. I want to calculate the total working days in a selected month ie Startdate Endate Days in February 25-02-02 01-03-02 = 4 Can anyone help!

I have a startdate and enddate. I want to calculate the total working days in a selected month ie Startdate Endate Days in February 25-02-02 01-03-02 = 4 Can anyone help!

I need to identify data filtered by a roling year ie March-01 to March-02. Can anyone help..........

I want to calculate what the following week ending date (Fridays date) would be when given a specific date: ie 13-02-02 = 15-02-02 Also allowing for month end ie last week in February would be 28-02-02 not 01-02-02 Can anyone help.............

Hi. I want to refresh a form, as I tab from a specific field on the form. So the subforms I have on the form are updated. Can anyone help!!!!

I want to calculate what the following week ending date (Fridays date) would be when given a specific date: ie 13-03-02 = 15-03-02 Can anyone help.............

I want to calculate what the following week ending date (Fridays date) would be when given a specific date: ie 13-03-02 = 15-03-02 Can anyone help.............

I need to calculate holiday taken by using time, using this data: StartDate StartTime 22-03 08:00 EndDate Endtime 25-03 16:00 Allowing for weekends. answer............15:00 Can anyone help...........

Can anyone advise what code could be used to select ctiteria, selected in a form from a query, then produce a report relating to the crtiteria ie Month!!

I want to open a report that displays a form with different month options as the criteria to filter the report. Can anyone advise the best way to do this!

I have built an expression, I want it to show 0 as a default value when the calculation is unable to show a value. Can anyone help!!