Search results

  1. BigHappyDaddy

    How to check that linked table exists?

    Background: In my Access FE, I have created a "linked table" to a file on our AS400 database. I know I can check the MSysObjects table for the linked table name, but sometimes the file actually does not exist on the AS400. The file can be in one of three states. File exists with data. File...
  2. BigHappyDaddy

    Setting Recordsource versus applying a form filter

    I have a question concerning the pros and cons of setting a form's recordsource using a dynamic SQL statement versus setting the form's filter property. My friend's project has a form with multiple sub-forms and within those sub-forms, some have more subforms. He has starting running into...
  3. BigHappyDaddy

    Question AutoExec versus startup form

    First, I have searched this forum and didn't come across any answers to my specific questions, so I apologize if they exist and I missed them...:o I know of two methods of "opening" an Access database. Using the startup form and the AutoExec macro. My questions.... Is there an advantage of...
  4. BigHappyDaddy

    Hello All

    Hi, my name is Jason. I am from Washington state and work in the heavy duty truck industry. I have used Access since the mid 90's as a user / power user. It has only been in the last 12 months that I have dove head first into VBA. During that time I have had numerous questions about Access and...
Top Bottom