Search results for query: *

Thanks everyone! I wanted to have the flexibility of modifying the query if required. Unfortunately, I will have to go through hoops (regular IT turn around time) if I ask our dba to create the query for me.

Thanks jmd. I went through 10 pages of threads here when I searched by "union" and most of them suggested doing the union from a database that has access to both datasources. Thanks so much!

I don't think it can be done (I'm using Crystal XI), so I just linked the tables in MS Access and created union query there. Not my desired method but oh well.

Hello I have a crystal report with data from an Oracle database. I have created a query in MS Access in the exact same structure as the datasource from Oracle and need to do a union query. How do I do that? I can use the "Add Command" but it throws me an error that it can't find the MS...

Thanks so much!

Is there a way to get the record count using pass through query? I am getting data from Sybase, creating a temp pass through query then using that query to insert the records into my local access table. Will I need to re-query the temp pass through query to get the count or is there a way to...

*sigh* Such a futile attempt. That said, I will give up on this one. Thanks captain.

I don't really know if it falls under this category - oh and not to mention I'm not the Symposium tech guy (gal). I just do reporting. Is there any way to have the phone set up so that when the caller disconnects, the agent's phone line remains 'live' for a few seconds then he/she either...

I tried this twice and didn't see a difference: 1. AVG([TotalTime]) where [TotalTime] = [EndTime]-[StartTime] --> This calculates the average of the time difference so if I have: TotalTime of 10 seconds, 20 seconds, 30 seconds, my average should be: 20 seconds. 2. AVG([EndTime]) -...

Thanks JB! We are all converted to 2007. I don't like it much either. As a matter of fact it took me 2 months just to 'get' the whole ribbon thing.

I want to create a (new) accdb file that I can put on a scheduler to autoexec the code to copy and compact various accdb files in different servers. I am stuck at the part of connecting to the database. This is the code I had before: Public Sub doCompact() Dim JRO As JRO.JetEngine Set JRO =...

PHV - You can't do design change in accde, that's right. I did it in the accdb, THEN convert to accde. But when I click on the button on accde I get the error.

Cancel this post. I did the application.followhyperlink and it works now. I still don't get why it won't work the other way though when I copy and paste the path on the hyperlink address on the control's property. Ah well.

Have you tried the TRIM function? Spaces drive me nuts too.

I created an accde file - The form has command buttons with hyperlinks to an executable file (captivate video files for my help files). From the accdb format, I can click on the button and it follows the link no problem but when I create the accde version of the same accdb file, the...

is there not a delay between the real time display and the "REAL" actual time ? I mean isn't the RTD delayed anyway by a few seconds?

Thanks Lisa!!! I re-started fresh again, slowwwwly and it worked!

oh but the form itself is bound to the table. I did bind each control to the appropriate fields.

No I didn't. I just dropped an attachment control on my form.

This is driving me nuts. I have a table with the following fields: MainID --> numeric ID FileAttachment --> attachment type field. In a new form, all I want is to show the different attachments per record. Right now, I only have 1 record that has 3 attachments. 2 command buttons to go...