Search results

  1. V

    How to stop text labels smearing on forms

    I found a work around. If you put a rectangle down first, and then put the label on top of it, it stops it from smearing! :)
  2. V

    How to stop text labels smearing on forms

    Yea I think that is what it is, as you say the cleartype, tried turning it off and you could use whatever font you liked and it did not smear. It does look totally awful though and very hard on the eyes! So I will just have to make to with MS Sans Serif. It is strange thought that you can use...
  3. V

    How to stop text labels smearing on forms

    Detaching label helps a bit but does not completely cure it. MS Sans Serif or System seem to be the only fonts that seems truly immune, but unfortunately they are not the prettiest. Maybe it has something to do with 'cleartype'?
  4. V

    How to stop text labels smearing on forms

    Running Windows XP 32 and Access 2003. Will try detaching label.
  5. V

    How to stop text labels smearing on forms

    Hi, Is there any way to stop label text on forms from smearing? For some reason the font smears or blurs and generally gets dirty looking over a short period of time using the form. It happens especially if you open up a report etc and maximise it for example and then when you close the report...
  6. V

    Sort ascending on different form fields depending on where form call came from

    Yea i think i understand what you mean about the filter. I got this code from doing it as a macro first and then converting the macro into a module. DoCmd.OpenForm "UpdateJourneys", acNormal, "Call UpdateJourneys Form From Timetable Button", "", , acNormal The Query in red is used to filter...
  7. V

    Sort ascending on different form fields depending on where form call came from

    Thanks! Worked like a charm. '------------------------------------------------------------ ' Timetable_TimetableAllDaysButton ' '------------------------------------------------------------ Function Timetable_TimetableAllDaysButton() On Error GoTo Timetable_TimetableAllDaysButton_Err...
  8. V

    Sort ascending on different form fields depending on where form call came from

    Happy Days! got it working, he he that took awhile! Thanks! It did not like [Day], kept giving me a friday first for some reason, but then i tried it on [Date] instead and it worked perfectly. So just need to add in the filter query to the openform call and that is it done (for now!) Many...
  9. V

    Sort ascending on different form fields depending on where form call came from

    have also tried giving [Day] the full path [Forms]![UpdateJourneys].[Day] but no luck, it just asks for the full path parameter. Need to go and think about this for a while and work out why it is not looking at the [Day] field.
  10. V

    Sort ascending on different form fields depending on where form call came from

    OK I have put this on the on_click event of button Private Sub LookUpJourneysForWeek_Click() stDocName = "UpdateJourneys" DoCmd.OpenForm stDocName, , , stLinkCriteria Me.OrderBy = "[Day] ASC" Me.OrderByOn = True End Sub And it opens the form "UpdateJourneys" form but...
  11. V

    Sort ascending on different form fields depending on where form call came from

    Thanks for the code, however, it gives this error message: "The Object does not contain the automation object 'Me' You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation...
  12. V

    Sort ascending on different form fields depending on where form call came from

    Would really appreciate some help on this, cant seem to find the solution anywhere. I have a database dealing with timetables and transport needs. I have 2 different forms (Timetable and TransportMenu) which call another form (UpdateJourneys) via command buttons which filter info via macros...
Back
Top Bottom