Search results for query: *

I've inherited responsibility for an email notification program written in Visual Basic .Net. The program generally works fine for sending emails within our business organization, but it fails when trying to send notifications out to our vendors, outside of our business network. It gives the...

Yes indeed, the medical software that produces the data file uses separate fields for date and time. And why not? Even if I combined them into a single field I would need to separate the date using the DateValue() function in order to GROUP BY date.

Thanks, but that is the "likewise" that I mention as not being supported.

Your example #2 is what I came up with, but unfortunately the "T.DateTime_field = A.DateTime_field" join is not supported in Jet SQL. Likewise, "T.DateTime_field = LastDateTime" is not supported. I think it has something to do with the fact that the "T.DateTime_field" is not part of the GROUP...

> . . .the code you want to modify. I'm not looking to modify my code, I'm looking for a SQL statement to replace my code. But let me give an example that may help illustrate my original post. Suppose I have data like the following: DateTime_Field Several Fields of other data . . ...

> How about... Thanks, but those are just criteria expressions. What I am doing now is using a GROUP BY to separate my data by dates and then looping through, using MAX to choose the latest time within each date. But I feel sure there must be a way to reduce the whole mess to a SQL query that...

I have some data that has multiple records per day, and each record has a timestamp. What I want to do is to select only the last entry for each date. I've already got code to do that, using a code loop, but I feel sure there must be some SQL statement what will do the selection for me. Can...

I am frustrated with a Jet-SQL update query for Microsoft Office 2003. I have some customer delivery records and I need to combine all deliveries to the same customer that occurred on the same day. As a greatly simplified example, suppose my data is like: CustomerNumber DeliveryDate...

Try it! I cut and pasted your code directly when you first posted, and then I tested the results and confirmed that your code, unfortunately, acts upon the ActiveWindow object. You're simply accessing that window through a parent object. But if the window cannot be made active, due to...

Yes, before I posted my original question I did my research and testing. The code from your post just calls the ActiveWindow.DisplayGridLines method, (you can verify that with a macro recording), which only works correctly on worksheets that have been made the active window (using the Activate...

> why are you faffing about with VBA. Go .NET and have proper control over the whole process. If for a job, not a hobby project.

> So prior to saving, make visible and assign this property. Thanks, but the "make visible" is the serious problem. Window manager actions are simply requests--they are not guarenteed to occur. A concurrent process could be hogging the Windows desktop, in which case the "make visible" request...

> YourWorkbookObject.Worksheets("yourSheetName").PageSetup.PrintGridlines = False Thanks, but that is for the PRINTING of grid lines, not for their DISPLAY. The problem I refer to is related to Windows screen display of the Excel worksheets.

I'm coding an Access DB that generates several Excel reports within a single workbook. The users want to have the grid line display turned off (displayed grid lines, not printed) on some of the worksheets. Examples I've found use the ActiveWindow.DisplayGridLines method, but that will not work...

The INNER JOIN's will overlook the records that don't have TIN's, won't it? I need to include ALL records from the constituent tables, matching those which pair up, and also keeping those which don't pair up. What I am doing is creating reconciliation reports, checking data from several...

Upon retesting I see that it does NOT create duplicate keys. However an empty row seems to be coming from somewhere, and I can't seem to extend it to cover additional tables.

Thank you to those who answered my question about Full Joins in Jet SQL, below. What I actually want to do is a bit more complicated, and is described in the test code I have pasted here. Any suggestions on improving the process through clever Jet SQL would be appreciated. Thank you all...

That does it! Lameid's pair of joins, with a check for NULL, does a distinct full join, which is what I want. I've been doing the same as lespaul posted, and then taking distinct records to remove the duplicates. That is probably less efficient since removing the duplicates doubtless involve...

I don't quite follow that. Duplicates are what I don't want. Let me give a simplified example . . . Suppose I have two tables: Table 1: Name, Employee-ID Table 2: Address, Employee-ID I want to join the records from the two tables on Employee-ID, and store them into a third table: Table...

What's the best way to implement a FULL JOIN in Jet SQL? Currently I'm using the distinct union of a LEFT OUTER JOIN and RIGHT OUTER JOIN. Is there a more efficient way?