Page 1 of 3 123 LastLast
Results 1 to 15 of 43

Trying to automate access

  1. #1
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20

    Trying to automate access

    To The Experts,
    I had a computer "whiz" modify a client side webpage I got from the Federal Communications Commission website:
    It's publicly available at - fcc.gov/media/radio/fm-and-tv-propagation-curves
    It runs on my Access 2000 (and old Windows 7 machine) and when given a text file it returns another related file in a text format.
    While it's awkward and slow to use - it works.
    Is there a way to further modify the FCC client side file or maybe program Access to automatically process a list of text files as in the following sample ?
    Currently I format the data into 2 columns first column shows the degrees radiating from a central point and the
    second column has the related Height Above Average Terrain number followed by "m" which stands for meters.
    I can only do one file at a time which leads to hours of screen time when it could be automated. I could make a much larger text file and separate stations by a comma or whatever.
    Any suggestions would be GREATLY appreciated. Thanks


    Station "KABC"
    0 13.7 m 120 89.8 m 240 80.5 m
    1 14.3 m 121 90.5 m 241 80.0 m
    2 15.2 m 122 91.2 m 242 79.5 m
    3 16.1 m 123 92.0 m 243 79.2 m
    4 16.9 m 124 92.7 m 244 79.2 m


    5 17.1 m 125 93.2 m 245 79.2 m
    6 17.7 m 126 93.6 m 246 79.4 m
    7 18.5 m 127 93.9 m 247 79.5 m
    8 19.2 m 128 94.3 m 248 79.5 m
    9 19.7 m 129 94.7 m 249 79.6 m
    10 20.0 m 130 95.2 m 250 79.5 m
    11 20.4 m 131 95.9 m 251 79.3 m
    12 21.0 m 132 96.6 m 252 79.0 m
    13 21.8 m 133 97.5 m 253 78.5 m
    14 22.7 m 134 98.4 m 254 78.2 m
    15 23.6 m 135 99.2 m 255 77.8 m
    16 24.4 m 136 99.8 m 256 77.3 m
    17 25.3 m 137 99.9 m 257 76.6 m
    18 26.1 m 138 99.8 m 258 76.0 m
    19 26.7 m 139 99.7 m 259 75.3 m
    20 27.3 m 140 99.6 m 260 74.7 m
    21 28.3 m 141 99.4 m 261 74.2 m
    22 29.3 m 142 99.2 m 262 73.8 m
    23 30.3 m 143 98.6 m 263 73.4 m
    24 31.2 m 144 97.2 m 264 72.8 m
    25 31.8 m 145 95.5 m 265 72.3 m
    26 32.1 m 146 93.8 m 266 71.8 m
    27 32.3 m 147 92.6 m 267 71.4 m
    28 32.7 m 148 91.9 m 268 70.7 m
    29 33.4 m 149 91.3 m 269 70.0 m
    30 34.2 m 150 90.4 m 270 69.3 m
    31 35.0 m 151 89.2 m 271 68.5 m
    32 35.9 m 152 88.1 m 272 67.7 m
    33 37.0 m 153 87.4 m 273 67.0 m
    34 37.9 m 154 86.7 m 274 66.3 m
    35 38.7 m 155 86.0 m 275 65.6 m
    36 39.2 m 156 84.9 m 276 65.2 m
    37 39.6 m 157 83.4 m 277 64.8 m
    38 40.1 m 158 81.7 m 278 64.4 m
    39 40.5 m 159 80.3 m 279 64.0 m
    40 40.9 m 160 79.6 m 280 63.6 m
    41 41.1 m 161 79.2 m 281 63.2 m
    42 41.1 m 162 79.2 m 282 62.8 m
    43 41.1 m 163 79.2 m 283 62.1 m
    44 41.2 m 164 78.9 m 284 61.3 m
    45 41.5 m 165 78.5 m 285 60.6 m
    46 41.8 m 166 78.5 m 286 59.9 m
    47 41.9 m 167 78.9 m 287 59.4 m
    48 42.3 m 168 79.6 m 288 59.0 m
    49 43.0 m 169 80.3 m 289 58.6 m
    50 43.9 m 170 80.9 m 290 58.0 m
    51 44.8 m 171 80.9 m 291 57.4 m
    52 45.2 m 172 80.1 m 292 56.7 m
    53 45.5 m 173 79.0 m 293 55.8 m
    54 45.7 m 174 77.6 m 294 54.9 m
    55 45.7 m 175 76.2 m 295 54.2 m
    56 45.7 m 176 75.0 m 296 53.4 m
    57 45.9 m 177 74.4 m 297 52.6 m
    58 46.3 m 178 73.8 m 298 51.4 m
    59 46.3 m 179 73.3 m 299 50.3 m
    60 46.3 m 180 73.8 m 300 49.0 m
    61 46.6 m 181 74.2 m 301 48.1 m
    62 47.4 m 182 74.3 m 302 47.4 m
    63 48.5 m 183 73.5 m 303 46.7 m
    64 49.5 m 184 72.8 m 304 45.9 m
    65 50.2 m 185 72.2 m 305 45.2 m
    66 50.7 m 186 71.3 m 306 45.0 m
    67 50.8 m 187 70.0 m 307 45.2 m
    68 50.7 m 188 68.5 m 308 44.9 m
    69 50.4 m 189 67.2 m 309 44.3 m
    70 50.3 m 190 66.0 m 310 43.2 m
    71 50.4 m 191 65.4 m 311 42.2 m
    72 50.8 m 192 65.1 m 312 41.3 m
    73 51.3 m 193 65.3 m 313 40.9 m
    74 51.8 m 194 65.9 m 314 40.5 m
    75 52.4 m 195 66.4 m 315 40.1 m
    76 53.0 m 196 67.1 m 316 39.3 m
    77 53.8 m 197 67.9 m 317 38.3 m
    78 54.8 m 198 68.8 m 318 37.3 m
    79 55.9 m 199 69.7 m 319 36.0 m
    80 57.1 m 200 70.4 m 320 34.7 m
    81 58.5 m 201 71.1 m 321 33.5 m
    82 59.7 m 202 71.6 m 322 32.4 m
    83 60.9 m 203 71.7 m 323 31.1 m
    84 62.0 m 204 71.6 m 324 29.6 m
    85 63.0 m 205 71.6 m 325 28.2 m
    86 64.3 m 206 72.0 m 326 26.8 m
    87 65.6 m 207 72.4 m 327 25.9 m
    88 66.8 m 208 72.2 m 328 25.4 m
    89 67.9 m 209 71.6 m 329 24.9 m
    90 69.1 m 210 70.7 m 330 24.4 m
    91 70.3 m 211 70.2 m 331 23.8 m
    92 71.5 m 212 70.2 m 332 23.1 m
    93 72.4 m 213 70.7 m 333 21.9 m
    94 73.0 m 214 71.6 m 334 20.4 m
    95 73.6 m 215 72.9 m 335 18.9 m
    96 74.4 m 216 74.5 m 336 17.2 m
    97 75.4 m 217 76.0 m 337 15.5 m
    98 76.2 m 218 77.4 m 338 14.0 m
    99 76.8 m 219 78.6 m 339 12.9 m
    100 77.3 m 220 79.8 m 340 12.3 m
    101 77.9 m 221 81.1 m 341 11.8 m
    102 78.8 m 222 82.4 m 342 11.5 m
    103 79.6 m 223 83.6 m 343 11.5 m
    104 80.2 m 224 84.4 m 344 11.5 m
    105 80.7 m 225 84.9 m 345 11.4 m
    106 81.0 m 226 84.9 m 346 11.5 m
    107 81.3 m 227 84.6 m 347 11.4 m
    108 81.7 m 228 83.9 m 348 11.4 m
    109 82.2 m 229 82.9 m 349 11.5 m
    110 82.7 m 230 81.9 m 350 11.9 m
    111 83.3 m 231 81.0 m 351 12.3 m
    112 83.9 m 232 80.4 m 352 12.5 m
    113 84.5 m 233 80.0 m 353 12.8 m
    114 85.1 m 234 79.9 m 354 13.1 m
    115 85.7 m 235 80.2 m 355 13.5 m
    116 86.4 m 236 80.7 m 356 13.2 m
    117 87.2 m 237 81.0 m 357 12.8 m
    118 88.2 m 238 81.1 m 358 12.6 m
    119 89.0 m 239 80.8 m 359 13.1 m,
    Station "KXYZ"
    0 80.7 m 120 79.4 m 240 50.8 m
    1 81.1 m 121 79.5 m 241 50.1 m
    2 81.8 m 122 79.9 m 242 49.5 m
    3 82.8 m 123 80.5 m 243 48.9 m
    etc. etc.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    47,906
    I expect could either further modify the 'client side' file or Access VBA. But we need code to analyze.

    How is page modified? Exactly what did the 'whiz' do? How do you 'give' it a text file?

    If you want to provide files for analysis, follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20

    Input and output from access

    Thanks for your reply June 7. I'm attaching the zip file as it was given to me by the network guy. The INPUT data is a text file like this that goes up to 360 degrees :
    1 255.2 m
    2 250.7 m
    3 246.3 m
    4 244.8 m
    5 245.7 m
    6 249.8 m
    7 256.0 m
    ETC. up to
    360 231.2 m
    It is data from the FCC website (originally they display it in a table) showing terrain elevations looking outward from a point in one degree increments (the left hand column). The right hand column shows Average terrain for each of those degrees. The original FCC client side program would only calculate 1 degree at a time - VERY tedious and time consuming. Now at least it will return a two column Results file in seconds. Access returns a "Target" file that gives a distance in meters for each degree of the compass based on those terrain heights. Then I can calculate the envelope (a rough circle usually) of the FM station. Here's a sample of the Target output :
    1 12074 the second figure is distance traveled by the signal - in this case 12,074 meters or 12.074 kilometers to be exact.
    2 12086
    3 12100
    4 12120
    5 12136
    6 12156
    7 12173
    ETC.
    I am hoping this whole process can be automated further by giving Access a group of input files, each one labelled with the station call sign and then get a group of Output files also labeled with the call signs.
    Let me know what you think - hopefully I the input output part makes sense.
    Thanks again !! Towersignals
    Attached Files Attached Files

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,124
    I briefly looked at your attached database. Much of the "guts" of the calculations can be found in module1. The code seems to be void of any meaningful communication and comments and involves considerable use of arrays and functions. It seems to me ( the uninformed in the subject matter) that much of the preamble to get the data from the site into meaningful and useful format is missing. Without an overall description of the business and the procedures and the code involved, I think you will need someone familiar with FCC regs and the subject matter to be more helpful.
    Even if there was some "test data", it would be an effort to document the existing code for use by someone unfamiliar with details of the process(es).

    This quote from one of the routines has helped me with the advice/comments given above.
    '// Interpolation subroutine, this is a bi-variate surface fitting procedure, refer to the original FCC CURVES program
    '// and to the paper referenced in comments above for details. Sorry about the shortage of comments, but there were
    '// none in the original source.

    '// This has been modified from the original, taking into account the context in which it is being used. It was a full
    '// general-purpose routine, however many of the conditions that had exception-handling could never have occurred given
    '// the limited range of possible values in context. Much of that unnecessary code has been eliminated.
    '
    '// Arguments:
    '
    '// lx Number of columns in table.
    '// ly Number of rows in table.
    '// x Column enumeration values.
    '// y Row enumeration values.
    '// z Data table.
    '// n Number of points to lookup.
    '// u Column values for lookup points.
    '// v Row values for lookup points.
    '// w Return result of lookups


    As a guess I would think the original programmer was an engineer in the field and/or a Fortran programmer. I realize this statement is merely an observation/best guess on my part.

  5. #5
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20
    Orange,
    Thanks for your reply. Yes, the original program was was in Fortran (I have a copy) and the new Javascript client side version found on the FCC website here :
    https://www.fcc.gov/media/radio/fm-and-tv-propagation-curves is a modern update to it that typically works on a 1 INPUT = 1 OUTPUT basis.
    With the modified version and a little work on my part in setting up the input file, Access uses the zipped version and will do all 360 calculations and give me good results.
    All this works offline which is very handy for me. Maybe the problem needs the attention of a Javascript guru then ? I have no idea how Access interfaces with the input data.
    Towersignals

  6. #6
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,124
    Well, I'm not a javascript person, but if you give us more info on the input file, you may get more help.
    Even if you can outline the steps you use/do between signing on to the FCC site; javascript interaction; captured data....

    Your Access materials did not have any tables, but it did have populated arrays. So my thinking is that there was some interface to build the array from your input/extracted data. Again, I'm not familiar with the subject matter nor site etc, so it as more of a "first impression". I do have an interest in helping so any additional material would be useful.
    Good luck.

  7. #7
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20
    Thanks once again - I will set up a working input file and run it through Access with the FCC Curves.zip / .mdb file, get the output file and then post them all later this afternoon/evening.
    Towersignals

  8. #8
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,124
    I did notice several zip files available for download on the FCC site. I don't know how these files are related or if they are relevant to your process.
    Can you tell us how you get that input file? and generally the processing involved?

  9. #9
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20

    Origin of the access input files

    Hello once again,
    The FCC website is huge with many zip files but I mainly use the FM Query function to lookup a relevant station's data. Typically I will search for all stations a certain radial distance from a fixed point by referencing a latitude / longitude pair at the bottom of the main page.
    FYI the FM Query database also contains Canadian stations because of the treaty between the two countries that helps to eliminate cross border interference.This is the main FM Query search page: https://www.fcc.gov/media/radio/fm-query
    From that page I can get more specific data on specific stations like this: https://transition.fcc.gov/fcc-bin/f...t=0&facid=4296 If you follow the link on the right that says Calculate HAAT it generates the data table that is the basis for the INPUT file that Access uses. Right now I have to re-structure that table into 2 columns in a text file format to get the Access program to work.
    At this stage I can do one station at a time but my goal is to have Access process a group of 40 or 50 stations at once. More later on and thanks again. Towersignals

  10. #10
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,355
    Quote Originally Posted by TOWERSIGNALS View Post
    Right now I have to re-structure that table into 2 columns in a text file format to get the Access program to work.
    You could have file picker code to select the input text file and select the folder to put the target file.
    I made a test text file from the data in Post #1 and created this code to change from 6 columns to 2 columns with the call sign at the beginning of each group of readings.
    Obviously, I named the button "cmdParse"
    Code:
    Private Sub cmdParse_Click()
        Dim strIN As String
        Dim strOut As String
        Dim ArrDeg(359) As String
        Dim sPart1 As String
        Dim sPart2 As String
        Dim sPart3 As String
        Dim sStation As String
        Dim RF As Integer
        Dim WF As Integer
        Dim i As Integer
        Dim Arr1 As Integer
        Dim Arr2 As Integer
        Dim Arr3 As Integer
        Dim Pos1 As Integer
        Dim Pos2 As Integer
        Dim Pos3 As Integer
        Dim OK2Print As Boolean
    
        'MUST have a source file AND a Target file.
        If Len(Trim(Me.txtSource & "")) = 0 Or Len(Trim(Me.txtTarget & "")) = 0 Then
            MsgBox "Missing Source or Target text files!!" & vbCrLf & "Please fix"
            Exit Sub
        End If
    
    '------------------------------------------------------------------------------------------'
    ' Should also check to ensure they are also TEXT files (.txt)
    '------------------------------------------------------------------------------------------'
    
    
        ' Open source file
        RF = FreeFile
        Open Me.txtSource For Input As #RF
        ' Open target file
        WF = FreeFile
        Open Me.txtTarget For Output As #WF
    
        'While not end of Source file
        Do While Not EOF(RF)
    
            'read line
            Line Input #RF, strIN
    
            ' Parse line
            If Left(strIN, 7) = "Station" Then
                'only print if read lines  after a call sign
                If OK2Print Then
                    Print #WF, sStation
                    'print the parsed values
                    For i = 0 To UBound(ArrDeg)
                        Print #WF, ArrDeg(i)
                    Next
                    ArrayFilled = False    ' set print flag
                    Erase ArrDeg    'clear affay
                End If
                sStation = strIN
            Else
                OK2Print = True
    
                'get the position of the "m"s
                Pos1 = InStr(strIN, "m") + 1
                Pos2 = InStr(Pos1, strIN, "m") + 1
                Pos3 = InStr(Pos2, strIN, "m")
    
                'get the string to print to file
                sPart1 = Trim(Left(strIN, Pos1))
                sPart2 = Trim(Mid(strIN, Pos1 + 1, Pos2 - Pos1))
                sPart3 = Trim(Mid(strIN, Pos2 + 1, Pos3 - Pos2))
    
                'get the degree order the reading should be at in the array
                Arr1 = Val(Left(sPart1, InStr(sPart1, Chr(176))))
                Arr2 = Val(Left(sPart2, InStr(sPart2, Chr(176))))
                Arr3 = Val(Left(sPart3, InStr(sPart3, Chr(176))))
    
                'replact the degree symbol and add to array
                ArrDeg(Arr1) = Trim(Replace(sPart1, Chr(176), ""))
                ArrDeg(Arr2) = Trim(Replace(sPart2, Chr(176), ""))
                ArrDeg(Arr3) = Trim(Replace(sPart3, Chr(176), ""))
            End If
        Loop
    
        ' at end of input file so print the last station and readings.
        If EOF(RF) Then
            If OK2Print Then
                Print #WF, sStation
                For i = 0 To UBound(ArrDeg)
                    If Len(ArrDeg(i)) > 0 Then
                        Print #WF, ArrDeg(i)
                    End If
                Next
            End If
        End If
    
        'closr the output and input files
        Close #2
        Close #1
    
        MsgBox ("Done")
    
    End Sub






    Quote Originally Posted by TOWERSIGNALS View Post
    At this stage I can do one station at a time but my goal is to have Access process a group of 40 or 50 stations at once. More later on and thanks again. Towersignals
    Not sure what you mean by this. Do you have multiple text files or multiple stations in one (each) text file?
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  11. #11
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20
    Hello Steve and thanks for your reply,
    Here is a "sample" search I would do when locating an area for a new FM station or possibly to move an FM station.
    The starting page is : https://www.fcc.gov/media/radio/fm-query
    The attached HTML page shows the complete data list generated by the FM Query search engine when I asked for all data within a 100 kilometer radius of a latitude/longitude pair. I also save it as a text file so it will import into an Excel spreadsheet where I can delete some of the rows and columns of data that will not be used.
    Once I'm down to the list of licensed stations (LIC), applications (APP), and construction permits to build a station (CPs and others) I can go back to the HTML file and build a list of Calculate HAAT tables. Those become the INPUT files for Access to generate the bearing and distance columns for use in creating the stations "Contour". I attached a sample of a Contour Exhibit used in a project a couple of years back. It's all public information.
    It is a multi-step process and time consuming so wherever I can automate it with the speed of computers that leaves me more time for - fishing !!
    I am not sure what to do with the code you sent but automating the process of converting tables into 2 columns would save a LOT of time. Can it be added to the FCC Curves.zip routine that Access looks at or would it be better to use it separately somehow?
    Thanks once again for your help and from all those in the forum. Code and programming I don't know, but if anyone needs help in licensing and setting up a 2-way radio system (or Commercial AM/FM help) just let me know. John
    Attached Files Attached Files

  12. #12
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,124
    What is it that takes the Four Corners Area 100KM radius data and results in UsefulData?
    "where I can delete some of the rows and columns of data that will not be used."?? What criteria???

    Perhaps you could tell us a little more about the data and how it's used.
    Remember, we are not familiar with the subject matter nor how the data is used.
    Bottom line we don't know your business, so any info would be useful to help put a bigger picture together.

    You have LICensed stations, APPlications and CP construction permits which seems to indicate key components of your business.

    Good luck with your project. I certainly agree with making time for fishing.

  13. #13
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,355
    I had a little about antennas back in the dawn of time when I was in college, but I've slept many times since then (and my brain is like a sieve now) - don't remember anything about antennas now.

    I looked at the "USEFUL DATA.xls" file and managed to add a header so I could understand what the columns were. But, since I don't know/understand what you are doing, it doesn't make much sense right now.

    As I said, I copied the data in Post #1 and pasted it into a text file. Some if the characters might not be correct for some symbols (possible the degree symbol). I would have to have a "real" source text file for testing.
    But here is the code and the Source file for your testing.
    The process might/could be more automated, but I don't know the manual steps you take to get the final product, so can't give a definite answer.
    Attached Files Attached Files
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

  14. #14
    TOWERSIGNALS is offline Novice
    Windows 7 64bit Access 2002
    Join Date
    Sep 2019
    Posts
    20

    Trying to automate access

    Thanks again,
    From the very bottom row of the FOUR CORNERS AREA SEARCH attachment ,I opened the data link to KRPT-FM (on the far left) then opened the Calculate HAAT link
    https://transition.fcc.gov/fcc-bin/haat_calculator?dlat=36&mlat=41&slat=45&ns=1&dlon= 108&mlon=13&slon=23&ew=-1&nradials=360&terdb=0&nad=27&inUSA=1&rcamsl=1802. &erp=6.&.html
    It returned the following table KPRT-FM Calculate HAAT DATA.zip (also in a text version) attached to this reply.
    I will try to get Access to use the file and see if it will re-structure the table into a 2 column format. Typically I have to go through a lengthy process.
    Evidently the modified FCC Curves.zip program could not handle the degree symbol after the bearing numbers 1,2, 3 etc. so I had to remove it in an Excel spreadsheet - one most tedious step that would be nice to eliminate....
    Attached Files Attached Files

  15. #15
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    8,355
    Using "KPRT-FM Calculate HAAT DATA.txt" as a representation of what the data text file format looks like, I modified the parse code. The code could be cleaned up a little more if the file will NOT ever have multiple stations (as in the example in Post #1).

    If you have 15 station text files, the code could be modified to parse ALL of the text files in a directory and write the modified files to a different directory. You could then write/modify code to execute the code for button "cmdBuild" for all of the modified station files.


    Maybe this will at least save you a little time....
    Attached Files Attached Files
    HTH
    -----
    Steve
    --------------------------------
    "Veni, Vidi, Velcro"
    (I came; I saw; I stuck around.)

Page 1 of 3 123 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 05-20-2019, 10:42 AM
  2. automate importing access
    By mcchung52 in forum Access
    Replies: 1
    Last Post: 01-21-2012, 02:20 AM
  3. Automate report on ACCESS
    By Schoolo in forum Database Design
    Replies: 1
    Last Post: 12-18-2011, 02:11 AM
  4. Automate Access Queries
    By andreala in forum Queries
    Replies: 5
    Last Post: 08-23-2011, 06:01 PM
  5. How to automate a access query ... Help me
    By kusamharsha in forum Programming
    Replies: 0
    Last Post: 02-25-2009, 09:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums