Recent content by Mattcornish

  1. M

    Filter string: between dates

    It runs on the click event of an image. I thought passing it to the format function was validating it?
  2. M

    Filter string: between dates

    Wen this code runs the text hasn't been passed to the value yet
  3. M

    Filter string: between dates

    Not on mine, mine comes out as 14/02/2012 :s
  4. M

    Filter string: between dates

    I am passing a string to a docmd.openform that has the filter string in it Start = Format(Text205.Text, "dd/mm/yy", vbMonday) EndD = Format(Text208.Value, "dd/mm/yy", vbMonday) * If stLinkCriteria = "" Then * * stLinkCriteria = "[Input Date] BETWEEN " & Start & " AND " & EndD Ihave stepped...
  5. M

    On error event, stop close

    Hi all I have used the forms on error event to handle the error when it can't save a form because not all values have been supplied. The standard message is yes for close no for return to form. My yes/no message works for yes (acdataerrcontinue) but can't figure put how to get it to go back...
  6. M

    Bring up attachment box programmatically

    No, if u have a attachment control on a form (the little grey box with icons in denoting an attachment) when u double click it u get the window to add or remove attachments. This is the window I need.
  7. M

    Bring up attachment box programmatically

    Hi Guys Is there a way to get the attachment box window to come up using VBA, I only need the standard window that is associated with the Attachment datatype when you double click the field on a form. Any ideas gratefully recieved
  8. M

    Update a field based on other fields

    Yes i am workin from a form. Due to the nature of the information I am dealing with I can't post the structure but I will do my best to describe it. "project name","date 1", "date 2", "date 3", "status" This is stripped down to the basics there are other fields but they are only to track...
  9. M

    Good practice question

    My database will be in use by about 20 users. I have heard people talk about splitting the front end and having a copy for each. Is this good practice, what determines when to do this and how Cheers
  10. M

    Update a field based on other fields

    Also using access 2007 if that's of any use
  11. M

    Update a field based on other fields

    Ok, I only have 1 table (well there are more but they only contain lookup values) "qualdetails" with fields "sp started", "sp created", "lp created" and so on all set as dates till it gets to the last field "status" (currently blank). I dont know wat normalisation is and as there arnt any...
  12. M

    Update a field based on other fields

    Hi guys My apologies first off as I know this has been covered in other threads but not in the lamens terms I need (my boss asked for a database a week ago and that's the first time I have used one since about 2001). I have a table with about 10 or so dates in. These dates would be entered...
See more
Back
Top Bottom