Search results

  1. M

    Help with Expression [Forms]![Form46]![month]

    [RESOLVED]Help with Expression [Forms]![Form46]![month] Access 2000 I have an “unbound” form with a list box, a text box, and a combo box. The list box’s Row Source Type is a Query. The query’s criteria come from the textbox and a combo on the form. Once the information is entered into...
  2. M

    Change code from "=" to "Like"

    Below is the complete code I am working with; it works fine as long as everything is exact (not case sensitive), I have been working for days trying to code it to be a little more forgiving because of variations in name spelling and middle name / initials, issues (sometimes excluded / sometimes...
  3. M

    Change code from "=" to "Like"

    Is it possible to change the following code from "[Name]='" & Me![subject] to "[Name Like" & Me![subject] Private Sub subject_LostFocus() On Error GoTo Err_Command1777_Click If IsNull(DLookup("[subject]", "[Warrant Log]", "[Name]='" & Me![subject] & "'")) Then Exit Sub End If
  4. M

    Securing Backend like webserver database and linking via odbc or roaming user profile

    Yes, there are several steps however but it is not difficult. Is this a domain user environment? What is the operating system?
  5. M

    Error Handling with Macro

    I currently have a macro that sets the value of several fields on a "lost focus " event; however there is an error that I would like access to ignore, is there any way to have this macro process this function "On Error Resume Next" ? Carbo
View older results
Back
Top Bottom