Search results

  1. F

    Finding Clashes

    Hello, We have a series of Victorian railway arches that we use for clubs, theatre, music gigs, exhibitions etc. It is possible (and likely) that there will be more than one event one one day and each event can take up a different combination of spaces. Due to the nature of our venue I include...
  2. F

    Finding Clashes

    I have a small database that acts as an events diary for our arts venue. I have fields for event name (text), date, and one for each of our spaces (with a check box). I have a query that can tell me if there is more than one event on any one day - but what I would really like is to be able to...
  3. F

    copy one field to another on same form

    I have something similar in a form of mine but I put the code in On Exit instead of the After Update bit of the field and it works fine. Try Me!ChildLastName = Me!LastName there and see if it works. Hope that helps, Fiona
  4. F

    user log

    Hi there, Not sure if this is the kind of thing that you are after but I made some modifications (with a lot of help from a very kind forum member) and it works for me. Check out the code here: http://support.microsoft.com/support/kb/articles/Q183/7/92.ASP Hope the link works! Fiona
  5. F

    Nice and Easy Weekday Question

    Hi there, I'm trying to get my form to generate the weekday from the date entered. I can only get it to display the weekday as a number eg. 1 for Sunday. How can I get it to say "Sunday" instead? Thanks in advance, Fiona
  6. F

    Save or Cancel Prompt

    Thanks Pat, I have moved the code to the before update bit and it works really well. However, there are save and cancel buttons on the form as well and if the user clicks these they get the message box asking them to save the record. Is ther any way I can avoid this? Thanks again, Fiona
  7. F

    Save or Cancel Prompt

    I Expect there is a really simple answer but I am quite new to this so please bear with me. On one of my forms I have put in code that prompts the user to save or cancel the changes on closing. I am using a simple If Me.Dirty statement and I have put it in the On Click property of the Close...
Back
Top Bottom