Recent content by songofsolon

Brilliant Perfect! Thanks so much.

Maybe I should ask this another way: Is there any way to dynamically adjust pass-through queries based on the value of a control or a stored value in a local table? (When I can't write stored procedures to the Informix db)

Greetings all, I'll try to make this as simple as possible, but please ask for clarification if I'm unclear: *I have one pass-through query to Informix that pulls all available class schedule information. *I have another local query that uses information in a local table to restrict that query...

Per the advice of someone with more common sense than me, I tried compiling the db again, and it fixed the problem. FYI.

Brilliant, folks, thanks so much. I ended up using bits of both suggestions: broke up the queries, per Pat, and used pass-through to access the informix data, per namliam. So far, it seems to work beautifully. I can't thank you both enough.

Greetings all, I have been working over the past year on developing a single-user access app based on data imported three or four times a year from an Informix db. Ideally, this data would be live, and as of this week I finally have the tools at my disposal to make that happen. However, the...

Please forgive me if this has been answered elsewhere, but I can't seem to find the thread that covers it: I have a fairly simple db that has been working perfectly for the last 7-8 months, but now I'm getting variations of the following error messages for all but one of my queries: Compile...

Thank you Ancient One! The lack of a space after the comma delimeter was precisely the problem. Without it, the return for 40 was "3,2,1," before truncating and "3,2," after, so it was deleting the final comma and the character preceding it. Putting the space in fixed it. It would have taken...

Greetings, I have lifted VBA code from the following Knowledge Base Article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;322813 to combine child records in a query. For my application, the SQL then looks like this: SELECT [EVL].[ProsID]...

Thanks very much Pat, the sample db was helpful. It's slow-going, but I think I'm beginning to get a better handle on what I need to do here.

Greetings, I am having a difficult time seeing this problem clearly, so I don't know if what I am asking is impossible or very simple, but I would appreciate any tips. I am working on a scheduling form that involves 3 queries/tables: [EVL] queried student information, [Clavov] available...