Search results

Whenever I have make-table queries or select queries on larger sets of data (say, 900k+ records), it takes forever. Is there ANYTHING I can do to speed things up?

My problem is that sometimes common functionalities get updated and I don't want to have to sift through a billion other databases that use it to do the same edits

What I am doing is calling these functions in every new db I make: Option Compare Database Option Explicit Public Sub importRemoteModules() Dim varFileRep As String Dim dbRep As DAO.Database Dim doc As DAO.Document varFileRep = "D:\Documents and...

Is this a good way to handle things: -Database that strictly makes tables and inserts them into storage db's -The storage db's that hold the data -A linker-db that link-tables everything in the storage db's that are required for present-day processes and has all relevant queries for...

Yes I am compacting the database. I am just trying to separate everything into a proper reporting structure in terms of frontend/backend/utilities for exporting/queries/etc. The data I deal with is massive, and so make-table queries in one database aren't possible (the data exceeds two gigs easy).

Under Access 2003, what is a good way to separate this? My initial idea: MakeTable.mdb, which creates multiple large tables and stores them in: DataStorage1.mdb And checks the size of each mdb as it does so. If DS1 gets too big, then it will create and start storing the tables in...

Good point -- maybe it is better for me to have the buttons named in a way that corresponds to the row and then dynamically get something listed in another col in that row

Nevermind, figured it out -- just use Application.Caller

I have code that creates a series of buttons and I want to be able to click the first button and have it pass a value to a function, but if I click a different button, it sends a different value, etc. The function would IDEALLY be the following: Sub callsheet(sheetNo as integer)...

Is there any code available that will combine PDFs without the need for Adobe? Say, PDFCreator or something similar? I have PDFCreator installed and can use the code in VBA but have, so far, been unable to successfully figure out any good way to combine one pdf file to another. Any advice would...

1. Things like http://www.articlesnatch.com/Article/The-Document-Database-name-Caused-A-Serious-Error-Ms-Access-Error/1049161 2. No, not constant -- very rare 3. No, I anticipate corruption of some kind 4. Not that I know of 5. Opening the database

The problem is that the types of errors I wish to log are not necessarily form-derived. Some errors with respect to database corruption arise before any forms are even loaded. These are the types of errors I need to catch either beforehand or during the automation so that they do not hold up...

We cannot always tell what is causing the error.

Trying to make an automatic log of databases that crash upon load. Certain db's have forms that load on startup. I am trying to basically make a db that opens all other db's and checks to see if the proper form actually loads. If not, log it as an error.

Ahhh, I see. Argh. :(

If appAcc.CurrentProject.AllForms("Form1").IsLoaded Then MsgBox "OPEN" Else MsgBox "CLOSED" End If

AWF is probably adding the space to prevent spam. teeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeest

I do have that, I was just not posting the full thing for security purposes. But I've used plenty of paths before and I know the one I have is legitimate and fine.

I understand -- I am using the real path Dim appAcc As Access.Application Set appAcc = New Access.Application Dim pathway As String pathway = "\\rootblahblah\source.mdb" appAcc.OpenCurrentDatabase (pathway)

It says I keep referring to an object that is closed or doesn't exist even when the path is correct for "YourPathandFilehere"