Search results
-
A
Access (front-end) connecting to mySQL (back-end)
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... -
A
Scroll To Selected Item On Multiselect Listbox, Access 2003
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... -
A
Running total in query using DSum
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 -... -
A
Populate subform dynamically
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... -
A
Updating field (with Requery? other methods welcome)
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... -
A
Field with tricky lookup in query
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... -
A
Report filtered by form records
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... -
A
Images linked to data
I'm building a report in Access 2003 that links data to images. The problem is like this: Query DATA: ID / Data 1 / Data 2 / Data 3 tbl IMAGES: ID / Image What I'd like is to build a report that, instead of showing Data 1 (actually, Round(Data 1, same for 2-3) shows the corresponding...