Search results

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...

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...

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...

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'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...

Hey, I've got some custom navigation buttons on both my main form, a subform, and a sub-subform...nested 3 levels deep. They work. Except that the TotalRecs -- "y" of the "x of y" does not get refreshed for the subforms when I change the main record. I want the subforms to recalculate the...

Hi all, I have a typical split database - tables in backend, forms in front end. However, I cannot modify the tables' properties in the backend, even though they are just LINKED to the frontend. ("A query or form bound to the table is open...etc") Furthermore, an .ldb file exists for the...

Hey ya, Take a look at the attachment first. Ok, now here's my problem: I've got some custom navigation buttons on both my main form, a subform, and a sub-subform...(nested 3 levels deep) They work. Except that the "y" of the "x of y" record count, for example, does not get refreshed for...

Basically, I'm getting an 'Invalid Argument' error msg pop up when I try to run a make-table query...the select query runs fine. Has nothing to do with the size of the table (mines 1500 records), or if its linked (mines not).... Same problem as this thread...

(I have seen posts on this before, but never a concrete solution...) I've got a tab control running off my main form (frmStatusDCPs)...for simplicity, two tab pages, each with a subform on it: The first tab, has a subform (frmStatusDCNs) which is linked directly to the main (master-child...

Access reports currently limit you to sorting a maximum of 10 fields...* Is there a way in VBA to sort by more? (I have 11) There is the option that I use a subreport which divide the fields etc...but I'm wondering if theres a workaround to this. Also, sorting the query recordset, doesn't...

Where to start? Ok, I'm looking for feedback/recommendations/ideas on how to go about the following task: I have to create a messaging-service (think MSN messenger) for use within my department. Sounds like a tall task, but I have some ideas as well as some constraints. My forte is...

Hi, I often have need to run queries in sequence, (sometimes as many as 100 in a row). Obviously, I do not want to manually create a macro to do this. This is what I used to do: I'd use QueryDefs.Name to drop the query names into a table QTable... Order QueryName Run 1...

Hi, this is such a simple report....or so it seems Two tables: Table1 Fields - Group, Group Description Table2 Fields - Group, Equipment, Status I have two problems really: 1) This report is potentially huge (35,000+ records). How do I spill over? For example, if Group is the Header, A is...

We, over here in the stone-age, just switched over from Access 97 to Access 2002... I used to have a routine that: Ran a delete query and then an Append query to add updated records to a LINKED table. Reason I did this (and not a MakeTable) was to preserve indexes, keys etc A2002 wont let...

I have data (Bill of Materials) in a table, with this basic structure: Parent Child Level - A 1 A B 2 A C 2 A D 2 B E 3 B F 3 B G 3 C J 3 C K 3 E H 4 F I 4 K L 4 I want to be able to output this in a tree format, eg: A |_______ B |_______ | E | |_______ | |...

Forgive me, I've been away from Access for a few months, roadblocked.... Is there a way I can output the result of a query in a msgbox? Namely, I've got a table with customers. If the new form's customer matches one of the customers in the table. I want to output in my Msgbox ("Found:"...

solved it...ever notice how sometimes when typing it out, a problem and it's answer become clearer to see? maybe it's just me.... [This message has been edited by wrek (edited 08-28-2001).]