Search results

  1. C

    sorting missing null values

    thats great works a treat just changed the 0 to date cheers
  2. C

    sorting missing null values

    cheers for that FAST reply would i still be able to sort by 3 things or would it miss all NULL records as i have a requested date column also which always has a date in
  3. C

    sorting missing null values

    Im trying to sort a form on a date. it only has dates put in once a confirmed date is known so when i sort all the blanks come to the top is there a way of sorting excluding null values
  4. C

    Auto select in list

    sorry a long time since i used VBA in access i didnt put the column(0) bit in works now
  5. C

    Auto select in list

    I have a listbox which i select the first value in list with [List1].Selected(0) = True but when i try to retrieve the value selected it doesnt work it either is nothing or the last value i manually selected it does highlight the correct bit though any help please
  6. C

    Setting focus back onto subform

    thanks for all replieswhat i was doing was correct it was just the way i was closing the other form when i used DoCmd.Close everyhting worked fine thank you all
  7. C

    Setting focus back onto subform

    I have a form with a tab control on with a subform on that. When in the subform i press a command button which opens another form which puts information from subform to new form. when i close the form i want the focus to go back onto the subform in the same row as before is this possible any...
  8. C

    Sum of Subform in Mainform

    Im using a calculated filed in the footer then showing that value in the textbox in mainform(bound) which is working fine the only problem is im using it on change Event to update the textbox which shows the last Sum total instead of the new one any help please
View older results
Back
Top Bottom