Recent content by PRMiller

  1. P

    Flag a keyword vba

    What's your table structure look like, and can you give an example of a record where "kick" would appear?
  2. P

    Loop Thru Table and ADD field values?

    What is going wrong? Are you receiving an error message?
  3. P

    Question Relationships

    It typically means the the table is being view by someone else if you are in a networked evironment. If the database is only accessible on your local machine, do you have another copy running? If not, try closing completely out, the opening with the exclusive option.
  4. P

    show table relationships

    Check out this video: http://www.youtube.com/watch?v=4e6Y003KQdo. Also this one, starting at the 2:00 mark: http://www.ehow.co.uk/video_4801732_define-between-microsoft-access-tables.html
  5. P

    Open Exclusively

    I think we need to clarify some terminology. A table will not contain a query or a form. A table is an object in a database, just like a query, form, module and macro. So, is it a database with 1 table, 3 queries and 3 forms? You don't need to right-click to Select, you can just as easily...
  6. P

    Update table

    No problem, glad to help!
  7. P

    Open Exclusively

    No bother at all, glad to help. What version of Access are you using? Are these linked tables?
  8. P

    Open Exclusively

    In the Open dialog box, when you click once on the name of the database to open it, the bottom right-hand corner should have two buttons: "Open" and "Cancel." The right-hand side of the "Open" button should have a down arrow that you can click to view additional Open options, one of which...
  9. P

    .. didn't add 1 records(s) to the table due to key violations

    Move your mouse cursor to hover over the name of the table. If the ControlTip text lists a path in addition to the name of the table, it is linked. What version of Access are you using? In 2010, the a linked table is graphically represented by an arrow on the left of the table pointing to the...
  10. P

    show table relationships

    Arrows... do you mean how to show the one-to-many relationship? Double-click the solid line (#2 in the image in your link) and change the relationship type. That should do it.
  11. P

    Suppress Linked Table Missing Errror and Replace it with custom error message

    LOL Happens to me all the time. You're welcome!
  12. P

    Suppress Linked Table Missing Errror and Replace it with custom error message

    I tested with a DLookup on a table and it did trap the error, but the error generated may vary based on the function you're calling. What is the error number generated on your end? Try replacing "3024" with the error number Access is returning. Private Sub Form_Load() On Error GoTo...
  13. P

    Update table

    I'd say make sure both forms are unbound, then have a Save button that triggers the Add Record event.
  14. P

    Databases and the Internet

    Tried to post a link, but I'm too new of a user. Do a Google search for "ftp data to microsoft access" and you should see an MSDN forum post titled "connect ms access database on a ftp location." This did catch my eye:
  15. P

    Adding Data to blank fields in a table

    How are you entering the data? Directly into the table, or with a form? If with a form, please post the code.
See more
Back
Top Bottom