Recent content by user-hostile

Hi. I'm working with some Access (MS Graph) pie charts on a report. The charts display their data correctly, and so the rowsources are set correctly. However, I'm trying to customize the positioning of the pie slices' datalabels. Here's what I'm trying to do, but it's not quite working: for x...

OOH--you gave me an insight. I actually need ALL the records from my parent table, but if I include the TOP 1 keyword in a _subquery_, the subquery just might return the one record I want. Thanks very much; I'll give it another try. U-H

Thanks, but that doesn't work in my situation. Any other ideas? U-H

Hello. I thought I could handle this one, but I'm just not getting anywhere. My situation is pretty simple: I have two tables, with a one-to-many relationship. Both tables have primary keys, and the primary and foreign keys are set up correctly. Referential integrity is enforced. It's a pretty...

They're all linked tables. I'm going through the larger queries now, and seeing which ones I can simplify...a bunch of them are queries of queries of queries--ouch! Also having the dbas check the indexes. Thanks for the responses. U-H

Thanks for the reply. I'll double check the indexes on the Oracle side. But some of the other guys said they ran the queries via the command line (sqlplus) and they returned their record(s) instantly. So that's why we figured there's something slow about the Oracle Driver for ODBC. The...

Hi. A system at work just migrated the backend from SQL Server (7) to Oracle 10g. The frontend, of course, is Access 2002. There seems to be a real performance hit now when accessing the Oracle data, as compared to the SQL Server data. The new system is using the Oracle Driver for ODBC, not the...

Yes, I finally had a chance to test it myself, and you're right: this code won't make the change an Oracle table's links; it does work with Access linked tables. I tried using another property of the Oracle tbl object: something like "SourceTableName" (tbl.SourceTableName) and changing that...

After your set rst statement, you need to set the cursor: rst.moveLast rst.MoveFirst Then, rst!Tablename will actually contain a value. As for the connection string, I know at some point you need to set this property: tbl.Connect <Connect> is a string value: your connection string. So I...

Hey; I was troubleshooting a database app that I use to perform update/maintenance on other databases. My VBA code does things like modify tables, compact/repair, ShiftKeyBypass, etc. to other "external" databases the user specifies (you input the path name, and the db does the action on the...