Search results

pbaldy and DBguy- It looks like the problem was solved. It appears the macro commands provided in Access won't do the job but the the For Loop worked perfect using VBA. Here is the code I used if anyone needs a sample in the future: Count = DLookup("[RepeatCount]", "[RepeatCountTable]") For X...

Thanks everyone for responding quickly. I used Access to covert my macro to visual basic. However, when I attempt to type in DLookup("[RepeatCount]","[RepeatCountTable]") I get Compile error expected: = DBguy- Before the submacro, a set of queries calculates the number of times I need to run...

I am trying to create a macro running a submacro that will repeat the submacro a variable number of times. I am not a programmer so I would like to stay within the macro format rather than code in VBA if possible. The submacro has a query to reduce the number in RepeatCount by 1 each time the...

Isladogs and Arnel, Thank you for your help. I am the only user and all the databases are on one computer. I stopped the autocompact, kept the MaxFileLocks at the default setting, decompiled, checked for to many connections. Not much changed. I downloaded Microsoft SQL Server 2017 Express and...

I have been running Access 2016 for the past 2+ years without much issue. I run the same queries in a macro once a week to process new records. Our records are stored over 10 databases linked with a key field. Most databases are currently around 1GB. There are about 400K records in each...

This looks like a great forum. I wish I found it many years ago. I fell into managing my employer's database in 1995 as one of many duties in a three person company. Over time the database has grown to over 1M records. Now I manage their database as a consultant so I can do other projects. I am...