Search results

  1. 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...
  2. 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...
  3. 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
  4. 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
  5. 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...
Back
Top Bottom