Search results

  1. L

    Question split database / multi-user / locking issues

    Under that scenario, open and release very quickly.
  2. L

    Question split database / multi-user / locking issues

    Welcome to the world of unbound forms and record clocking. Unbound forms will aleviate this issue. Having a bound form open, depending on your programs "locking" properties may lock the entire underlying table, as opposed to a "record." Have you set record locking to "omptimistic?" Take a look...
  3. L

    Reserved Error When Seting Focus to Control

    Glad that you, I repeat you, found the error.
  4. L

    Reserved Error When Seting Focus to Control

    Is the control on a subform or main form? Try setting focus to the form first, then the control.
  5. L

    Listbox field displaying field depending on value

    A listbox displays what's in it RowSource. Adjust that to suit your needs.
  6. L

    Question Error 53 : File Not Found

    You code is for selecting multiple files. There code on this site doing what you want, i.e. selecting one file. I found the following right away Those many "f" object properties which can me specified. This should get you started.
  7. L

    Delete records as table updates

    Here's your solution. "CommitTrans and Rollback"
  8. L

    Dropdown, two columns, search both

    Why aren't the names in your combo box sorted? Change the RowSource of the combo box to sort appripriately (alphabetically) by 1st name.
  9. L

    Dropdown, two columns, search both

    It filters like your example, but unless you "dropdown" a partial list is not displayed.
  10. L

    Dropdown, two columns, search both

    That's what it's supposed to do. If you want to see the list use, i.e. part of it. I recall that the number of rows to display is a property of th comboboxname control. If thousands of rows are in the data set, other strategies may be appropriate. me.comboboxname.dropdown on...
  11. L

    Dropdown, two columns, search both

    Set the combo box "Auto Expand" property to "Yes."
  12. L

    Newbie

    Use the Access Report Wizard, selecting a query filtering what you want as the report's record source.
  13. L

    Total row in report from query

    You're reference is probably bad.
  14. L

    Total row in report from query

    You can total in any footer (page, report) in your report. Try in a bound control record source use =Sum([YourPaymentcontrolName]). Note include the brackets.
  15. L

    Dropdown, two columns, search both

    Concantenate with colums in your combo box oe use 2 combo boxes.
  16. L

    Attendance Roster - Few questions (query msg, add one record, auto fill date)

    1) docmd.SetWarnings True or False. False suppresses warning. 2) i would build a temporary table of Sundays, each time the form is opened, and allow the user to pick the correct one via combo box on the form. 3) Each time a visitor name is specified, check the underlying table to see if it...
  17. L

    Comparison operators in a combobox to filter a Form

    I tried to open your attachment, but couldn't. I get a message that it's a php file. It's not clear to me that you mean by "comparison operator." Forms can be filtered by modifying the reocrd source or by setting the form FilterProperty and the For FilterOn property. Either method, you build...
  18. L

    Problem Opening Two .accdb Files At Once

    Have you repaired and compacted your databases?
  19. L

    Access with SQL server slow down

    Do you have any Access tables joined with SQL Server tables? That could be your problem.
Back
Top Bottom