Search results

I need to wite a function that will count the number of field in a record that are not null. I don't want it to count all fields that are not null, just the fields specified in the function's code. The record's index is passed to the function as an argument. The solutions that I think I've...

It worked Thanks (again) :)

This line keeps throwing an error: DLookup("[NoOfStaffRequired]", "Hours", "[DateWorked] = " & WorkedDay) WorkedDay is a variable passed as a Short Date in to the function. It is Declared As Date. The [DateWorked] field in the 'Hours' table contains Short Dates. The error I keep getting...

Solved it (I think) using a very helpful tutorial http://www.fontstuff.com/vba/vbatut01.htm Function MissedHours(StartTime As Date, EndTime As Date, ShiftLength As Integer) Dim Hbefore12 As Date 'Declare variables Dim Hafter12 As Date Dim HoursWorked As Integer If StartTime > EndTime...

:) Thanks. I used 'Recalc' as I think 'Refresh' refreshes the form and everything the form is linked to (such as records), 'Recalc' just recalculates the expresions in the form. It still doesn't like the 'Me' bit, it says it can't find the object called 'Me'. I had to use '=[Form].[Recalc]'

Me.Refresh doesn't work. It thinks it's an object.

sorry, I have a table that records the number of staff required per day, each staff member's ID, start and finish time (just time, not time and date), and the shift type. It is indexed by the date the shift was started. There is a seperate shift-type look-up table that stores each shift type...

I'm new to Access, so please be patient. I'm trying to write an expresion that will work out how many hours were missed from a given shift, using the start and finish times, how long the shift was ment to be, and how many staff showed up compared to how many were ment to. The expression is...

I want to refresh more than one text box after a combo box is updated. The text boxes contain expresions that use the info from the combo box. If the combo box changes, the text boxes need to change. I know that to refresh one text field I put "Refresh([textbox])" in the "After Update" field of...

I'm creating the database on a PC with access installed, but want to query/create reports on another PC that doesn't have MS Access installed (it has access to the .mdb on the network).

does anyone know of a cheap/free 3rd party programme that can query multiple .mdb files (in the same directory) and generate a custom report? It needs to be as user friendly as possible.