Recent content by vorn666

  1. V

    USers and permissions

    Hi, Can you disable on all forms the ability to add new records, then add a button which prompts for a password which (if correct) alters the add record ability to the form? or edit the locked properties of the required fields if it is an existing record? It's a crude solution but should work fine.
  2. V

    Advice Sought on Best Practice for Database Construction

    Hi Travers, 1. In my opinion splitting the database is a good idea as long as you are moving it over a quick enough network. My original database was slowing down day by day till i split it, it suddenly got a chunk slower but has never slowed since. Like yours sounds it will mine tends to grow...
  3. V

    Auto sizing text.

    Many thanks, that works very nicely.
  4. V

    Hiding fields based on conditions in other fields

    How about: This should work as long as you change record between each record, else you could put it on OnUpdate form the type of staff box. Private Sub Form_Current() With [Headteacherbox1] .Visible = (IIf([Type of staff] = "Headteacher", True, False)) End With With [Headteacherbox2]...
  5. V

    Hiding fields based on conditions in other fields

    How about: This should work as long as you change record between each record, else you could put it on OnUpdate form the type of staff box. Private Sub Form_Current() With [Headteacherbox1] .Visible = (IIf([Type of staff] = "Headteacher", True, False)) End With With [Headteacherbox2]...
  6. V

    Auto sizing text.

    I don't doubt it, however I cannot find it. I am unsure exactly which words I should be searching under as I do not know the correct name for what i am trying to do.
  7. V

    Auto sizing text.

    If you have a text box of a set size how would I code an automatic font size reduction if the text string in it was too long. (It has to shrink or it obscures the box below it). ie if it is over so many characters set size 14, if over even more set size 12 etc. many thanks. This is on a form...
  8. V

    Check box to update date field

    The following should work for an on event action, if thats any help. With Me.DateQuerySolved .Value = (IIf(Me.QueryCompleted = True, Date, "")) End With
  9. V

    Apply Filter in two fields

    Many thanks Peter - works perfectly! John, will look into yours too when I have finished this update, as it looks like i will learn a few things going through that one.
  10. V

    Apply Filter in two fields

    Hi all, I have the following working line of code (Running once a button is pressed in a form) DoCmd.ApplyFilter , "[Site Location] = 'Site A'" However I now need to modify this to search for the text in two fields, both Site Location and Site Location2, to return results if it is found...
See more
Back
Top Bottom