Search results

  1. B

    [Filter] gives #Name? error

    I'm afraid I'm a little rusty with Access, so this may be obvious. I've got a form that has a text box that is intended to show the user what the filter is set to. I set the ControlSource to ="Filter: " & [Filter] but all it returns is #Name? I know it's worked before, so what's up?
  2. B

    ADO, DAO vs RunSQL

    After a hiatus of a few years I find myself back writing Access applications, so I need to get caught up a bit. First of all help me out with the whole ADO, DAO RunSQL thing. In the past whenever I needed to do any database operations I almost always used straight SQL with DoCmd.RunSQL, e.g...
  3. B

    DefaultValue and Dates

    I'm afraid my Access skills have gotten pretty rusty over the past three or four years, so I hope this question isn't too obvious. I have a form with a text box for entering a date on it and I want the last date that the user entered to become the DefaultValue for that text box. Here is the...
  4. B

    Dealing with warnings from append queries

    I have a process that runs a bunch of Append queries. When Warnings are on you will get a message saying something like "You are about to append X rows? Do you want to continue?" If there is a problem with the append you will get a second message saying "<Your app> can't append all the records...
Back
Top Bottom