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...

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...

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...

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...

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?

I want to translate string fields in an MS Access table, mapping them to other strings. Now I do that in a VBA loop, iterating through the table and calling a VBA function to map the new values, But I suspect there may be a way to do it just in SQL. Is there? Suppose I have two tables, like...

Some programs, such as Adobe Acrobat and Yahoo, attach toolbar addins to Microsoft Office applications. When they do that, Access applications often show a "You do not have exclusive use" message during start up as the offending addin tries to switch each form in the application to development...

My company has some data conversion programs written in ACUCOBOL-GT Version 4.3.0. They are started within a DOS command window using the wrun32 program and create their own DOS-like popup windows for screen IO display. These programs work fine and do their jobs well, but whenever the DOS-like...

Whenever someone installs a custom Microsoft Office menu bar plug-in, such as Yahoo! or Adobe, the plug-ins force Access applications into Exclusive mode during start up. As the plug-ins install themselves during each start up they force the application into Exclusive mode, locking out later...