User Profile

Collapse

Profile Sidebar

Collapse
ischwartz88
ischwartz88
Last Activity: Jul 31 '08, 12:53 PM
Joined: Jul 16 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ischwartz88
    replied to Skipping over Linked tables
    in Access
    Hi. Thanks for the help, however, the script seems to ignore any form of that code. I am not quite sure why. Any suggestions?
    See more | Go to post

      Leave a comment:

    • ischwartz88
      started a topic Skipping over Linked tables
      in Access

      Skipping over Linked tables

      Hi. I have written a script that searches through every field in every table in a given database. It works fine in most databases, however, when I run it in a database with Linked tables, the script crashes when it reaches a Linked table and tried to search through it.

      My code is written below.

      Code:
      Option Compare Database

Sub MK5Search()
GenerateFieldSizeInfo
End Sub

Sub
      ...
      See more | Go to post
      • ischwartz88
        replied to Searching entire database for string
        in Access
        Perfect! Thank you very much. I played around with the code for a bit and I ended up combining my script with yours, and it works perfectly!
        See more | Go to post

          Leave a comment:

        • ischwartz88
          replied to Searching entire database for string
          in Access
          This is a task given to me for my job. It is to find data sensitive to a certain location. The script will be able to be used on any database made in the future; henceforth, creating a script to search every field is the most efficient way to go about this.

          After the script is fully functional on VBA, I plan to translate it into VB and have it read a given database which is inputted by the user....
          See more | Go to post

            Leave a comment:

          • ischwartz88
            replied to Searching entire database for string
            in Access
            OK. I have added much to the Sub. My code now reads as:
            Code:
             
Public Sub GenerateFieldSizeInfo()
    Dim cdb As database
    Dim oTable As TableDef
    Dim oField As field
    Dim rsTable As Recordset
    Dim strSQLTable As String
    Dim iMaxSize As Integer
    Dim iHeadroom As Integer
    Dim iFileNumber As Integer
    Dim strOutputFile As String

    Dim ddb
            ...
            See more | Go to post

              Leave a comment:

            • ischwartz88
              replied to Searching entire database for string
              in Access
              Ah! The code makes sense to me, and I have DAO 3.6 installed and enabled.

              I have attached the code to a button called cmdSearchTheTab les.

              However, it says the IF statement
              Code:
              If fld.Value Like "*MK 5*" Then
              is an invalid operation.

              I tried a few different syntax forms for the line, but it still returned the same error.

              Am I missing something? Do I need to assign a text field to output...
              See more | Go to post

                Leave a comment:

              • ischwartz88
                started a topic Searching entire database for string
                in Access

                Searching entire database for string

                Hi, I am not a computer programmer. I have been learning VBA along the way of making this script. I know Access and SQL.

                I have a very large database with many tables and queries. My goal is to write a script or function that will search the entire database for a certain string (actually two strings).

                I have tried using a series of queries and unioning them together but this is a very scrappy way of doing this. Perhaps...
                See more | Go to post
                No activity results to display
                Show More
                Working...