Search results

  1. 2

    Subform Filter problem. Please Help Me!

    Had wondered about that before Rich, I think I've found a solution that works thou, keeping the field named Date. (It causes alot of other coding problems to rename Date. The filter condition which seems to work ok is: FirstDay = Date - WeekDay(Date, 0) + 1 LastDay = DateAdd("w", 4, FirstDay)...
  2. 2

    Subform Filter problem. Please Help Me!

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

    Newbie auto-run module problem

    try the macro command RunCode. Then in the function name property, enter the name of the procedure or function in your module you wish to run. This should run your module and then carry on with the rest of your macro
  4. 2

    filter subform between two dates without use of query

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

    filtering a subform to display current week

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

    Folders, Paths, Files

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

    Invalid Use of Null Error: Please Help!

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

    Trying to refer to a column in a table but recieve error

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

    Change Table Column Name Within Code ??

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