Recent content by wrek

1) Transferdatabase compacts the newly created db quite fine, it's the existing (Master) db, that balloons. Just for my own edification - instead of the Transferdb, is there a way to create an object directly in another database? (recordset maybe?) or use Transferdb more efficiently...

I have an interesting conundrum on my hands... What I'm trying to do: Through VBA, archive data in ODBC linked tables, into static tables (a one-time snapshot kind of deal). How: (1) In my Archive_Master database, looping through the tables, and for each ODBC linked table (T) (2) Running...

Peter, Smashingly efficient. Thanks. :D

S'been so long since i've been involved in any semblance of coding, its almost embarrassing. Potentially easy one: I need to pass a string (input from a form's textbox) into an array of characters (dimension = the size of the string), for some string handling on a character by character basis...

I have a form with 3 textboxes. Data in any one of them will be used in a query which is run currently through a command button. I want to run the query after the user hits Enter in the textbox after their data. I could use the 'after_Update' event but this activates when focus is lost from...

Hey all, I have a swollen database on our server, with a table in it, that might be linked to, by other people/databases. I cannot compact/repair ("Could not use H:\path\database.mdb; file is already in use.") I cannot open it exclusively ("Another user has the database open, or you do not...

Thank you Pat, It turned out being an aggregate function (groupby) in the underlying query...should've seen that. As for the naming conventions, I agree whole-heartedly -- problem is, I 'took over' this database from it's designer, and renaming all his objects would be a chore and a half...

OK: SQL: SELECT [STATUS - DOCEC].[Update From], [STATUS - DOCEC].Incorporated, [STATUS - DOCEC].[CDOCs Inc Note], [q16 - Display].[ROOT DCP EC], [q16 - Display].[ROOT DCP], [q16 - Display].[ROOT DCN EC], [q16 - Display].[ROOT DCN EC REV], [q16 - Display].DOCUMENT_TYPE, [q16 -...

What I'm trying to do is pretty basic (braincramp): I have two tables Status-DocEC and DocECInfo. On my form, I need fields from BOTH tables...details from the DocECInfo table, as well as fields from the Status table which users will need to edit... Problem: The form wont allow me to update...

If I'm understanding you, I think I do something similar; under criteria in your query: Like "*" & [Forms]![frmBuildQuery]![qryWildcard] & "*"

I have two queries which are data sources for an Excel worksheet... My problem: If I try to refresh the Excel file when the database is OPEN, I get an error msg saying "The database has been placed in a locked state...blah blah" [I'm running Access 02 - never had this problem in previous...

I can interpret your post in three ways: 1) Your 'sub'Forms are not bound to any dataset (not looking up any other data) In this case set the ControlSource for the 'strloan field' in the subform to: =[Forms]![frmLoan1]![strLoanNumber] 2) you need the field to be updateable? in which case...

I'm getting an 'Unknown Jet Error' message, when I try to call this function from a query -- to find the median for a group of values - in an aggregate query. The function has worked before, so this baffles me. Under Field in my query: xMedian...

Kango, I have a db that I use, that has the same functionality...this is how I implement it: Have a main form which has all your design, specifics etc... For the 'changing' data, create an unbound subform. Change the Recordsource and requery every time you have the need to 'switch...

Surjer, Redemption isn't really 'third-party' software...basically it is a .dll file that registers itself as a command component in your registry...I'm under pretty strict IT 'constraints' myself, and I was able to update my registry with the dll...(note, it only works for each LanID and...