Recent content by a_ud

It's (mainly) for one user. I've gone for ODBC, and seems to be working now that MS Visual C++ is installed, which is what I wanted. Still I'll keep the details for the alternative method saved. Many Thanks !

Some advice needed here. My question is about systems architecture. My company has a mySQL large database that lives on a server. Unfortunately it's a small company and we don't have a company network, only an Internet connexion to the server, i.e. users with rights have access to the server...

No, there is no classification, my example is just an ilustration to make it clearer but there are no such clear groups. I'd like to know whether Listindex has more properties that I think it has, it's quite a 'niche' command in Access 2003.

I guess I could, but there is an issue with size. The listbox is extremely long (90K items) and also has sth like 6 columns, so most of the screen is already busy. I'll use that if I don't have any other option.

Help appreciated here!! I've got a form with a multiselect listbox (extended) that holds a very long list of items (~90,000): 1 | Apple 2 | Orange 3 | Banana ............... 35313| Corn cob ............... The user can select multiple items (non-sequential) on the listbox, say items 1 and...

In my first post cumulative simply meant the running total of each entry in the table. The 50% comes from: -> Count of 2 records for John (correctly calculated by second field, CountofField1) divided by total number of entries (4 records in total). And so do the 75% [(2+1) /4] and the 100%...

Thanks for the try, Eugin, but I think that doens't work. As it is now, I'm using 'Totals' in the query and I have: [Field1] - [CountofField1] - If I add, for instance, [SumofField1] in the 3rd colum, I'd get a 'Data type mismatch' error message. Either I'm not getting you or you're...

Help needed. I'm stuck with a query that calculates the running total of a simple table like this one: Table: T1Field 1 John Charles Tom John ............ The query (say Q1) should show this: Field 1 -CountofField1 -Cumulative John -...

I've got a subform that needs to be populated dynamically. Pls have a look at the attached DB. It has: 2 main tables, S1 and S2 (3 fields each, TraitA to C for S1, and TraitD to F for S2). A form with a combo where you select one of the fields (say, Trait_A). A subform where I want to show...

Fair enough. The code that populates the form is: Set rs1 = New ADODB.Recordset With rs1 Set .ActiveConnection = oConn .Source = SQL .LockType = adLockOptimistic .CursorType = adOpenKeyset .Open .ActiveConnection = Nothing End With Set Me.Recordset = rs1 Basically...

Help needed, as I don't get a field to update on a form. The structure of my form is: Form F1 (populated by On load event that reads a SQL server database) The form includes 3 tabs: T1 | T2 | T3 T1 includes the field to be updated, let's call it "State" (it's a combo). I'd...

Thanks, the mock up works fine in my tables too (as it should). This is an elegant solution using SQL, and there's probably another one using a function with SELECT ..CASE in a column in the query (but this one is easier).

Hi Xproterg, Thanks for trying, but I'm not sure we're on the same page here. Let's say Table 2 has the following column/values: First / Last / Batch ABC100-ABC120- 1 ABC121-ABC140-2 ABC141- ABC200-3 If you run here your query1...

I need to build a query that (in principle) uses 2 tables: TABLE 1: Person_ID: String (for instance, ABC156) TABLE 2: First : String (1st volunteer in that batch, f.i. ABC100 Last: " (last volunteer in that batch, f.i. ABC120 Batch: Integer ('1') and no...

Help needed!! I've got a report that is called from a form button using: DomCmd.OpenReport "ReportName", , FilterName, WhereCondition, , OpenArgs I'd like to filter the report using the form [VolunteerID] values. The form has a combo, and when the user changes the selection, so does the...