Search results

  1. L

    Command Button Spacing

    I'd do it programmatically, that is, setting the left, top and width.
  2. L

    DNSless connection problem

    Back to your first question. Use a form timer to try again, after a certain elapse time, a certain number of times. Post you new question in a new post.
  3. L

    Disable the update on subform if field is not..

    Lock the subform on the main form Load (startup), OnCurrent (moving to a new record) and AfterUpdate (after <controlname> is updated) events based up the <controlname> value.
  4. L

    DNSless connection problem

    You'll get an error on a read or write if you don't have a connection. Test for that error. When to make that test is problematic. I have a database with scores of bound forms and bound subforms. Adding such a test might be a horrendous task, unless I did in porgrammitically with a function on...
  5. L

    Access Beginner trying to consolidate table

    Space delimited tables can be imported into Access.
  6. L

    Making graphs with variable

    I recently saw a Mr. Excel video on pivot tables. It had a very good segment of data slicing. Track that video down and it might give you some ideas. start with this site: http://myexcelonline.com/pivot-table-course.php
  7. L

    Help with Query Filter, Please!

    Multiple DLookups is the culprit. A function with a DAO lookup would be considerably faster. Dlookups are kknown to be glacially slow. Also, you can probably achieve the same result with a "left join" in your query looking up the desired value. From what you've posted, I can't tell you more...
  8. L

    Question Table find and replace

    Are you doing something else with each recordset?
  9. L

    Question Table find and replace

    I thought that the purpose was to change the data, otherwise why do it with your code?
  10. L

    Question Table find and replace

    Don't you need a ".Edit" and a ".Update" when moving through records? Otherwise, I think you have it.
  11. L

    MoveSize - Extended Monitor

    Yes, you can move a form with action initiated by a button. Using 2 monitors to display forms seems to me to be a poor design. I built and used complex form database programs, but have never seen the necessity or utility of using 2 monitors to display them.
  12. L

    Table Design / Insert Subdatasheet = Confusion

    Why won't you do this with a form and subforms?
  13. L

    Opening PDF file in form

    Here's your solution: http://stackoverflow.com/questions/11483237/access-2007-display-pdf-content-on-a-form I found this immediately with Google.
  14. L

    Form Query with tabs as criteria

    If the tabs use the form record source, merely show the appropriate column on the appropriate tab. If each tab has a form and separate record source, filter each tab's (form) record source such that the appropriate column is displayed.
  15. L

    Question Table find and replace

    Use the Replace function, nested in an If in a query, or just 1 at a time.
  16. L

    How to handle them both?

    Assume the index is 1, or append it to the return value.
  17. L

    Filter List Box from other list box selections

    Update the listbox recordset (table or updateable query), not the listbox.
  18. L

    Hide Duplicate record using Query

    Post the 2 tables populated with data in a zip file and I'll do it.
  19. L

    Hide Duplicate record using Query

    You need to isolate the non-duplicate rows. There are a multitude ways of doing this.
  20. L

    Hide Duplicate record using Query

    Group (all displayed columns), alternatively use another query to group duplicate rows .
Back
Top Bottom