Search results

Hi, Thanks to those who have already tried to help me with this one. My problems is trying to filter a subform which contains the following fields [Date] [TimeStart] and [TimeEnd] The [Date] field contains the date in the format 04/04/02. I need to filter the subform by hitting a command...

is it possible to filter a subform which contains the field 'date' into two given dates? I know you can do it using a query and the between statement. But I cant find a way to do this in VBA. Can anybody help me? Code would be very much appreciated Cheers

Hi there, I have a form with a subform displaying 3 fields: date, timestart and timefinish. This is basically a clocking in and out form. What I am trying to achieve (and have got no where with!) is to have a command button, which the user clicks and filters the data in the subform to display...

Hi, Was wondering if anybody knew what code i could use for the following: i)Couting the numbers of files in a folder/folders. ii)Counting the number of folders in a folder. iii)Producing in a textbox a list of files which have recently been modified in a folder. for the three questions...

AddOwner !OwnerCode, !HolidaySector, !BookingReference, !ClassKey, !sitecode, !payment, !area, !forename, !surname, !address I am trying to call the function Addowner and taking across field values from a table. How ever the problem is that some field have no value, thus bringing up an the...

Hi, I am trying to call a function and take a value to the procedure. The value is a field in a table. this is the command AddOwner !OwnerCode, !Holiday Sector OwnerCode and Holiday sector are two fields in a table which I need to take over to the function AddOwner. The problem occurs with...

Hi, How do i change a column name ( or caption) in a table from within VBA? Thanks in advance