Recent content by ByteMyzer

thread732-333932 I realize that this is in reference to an old thread, but since it comes up on a search, and since someone else may have the same question to be answered, here it is: You can not define a sort with multiple fields on a DataView and execute the FindRows method using a key that...

There are 105 permutations of this data that conform to the constraints you outlined: tbl_Output ID Row X Rnk 1 1 2 1 1 2 2 2 1 3 3 1 1 4 3 2 1 5 4 1 1 6 4 2 1 7 5 1 1 8 5 2 2 1 2 1 2 2 2 2 2 3 3 1 2...

For MSSQL, Try changing: .CommandText = "PARAMETERS paramID Long, paramTable Text(255), paramDesc Text(255), paramExtn Text(5), paramFile LongBinary;" & _ "INSERT INTO tblBLOB (FKID, FKTable, BLOBDesc, FileExtn, BLOB) " & _ "SELECT paramID, paramTable, paramDesc, paramExtn, paramFile" ...to...

You might try the following SQL: INSERT INTO HoursWithStatuses ( ssn, calcdate, HoursDate1, Hours1, HoursEndDate1, PrevStatDate, NextStatDate ) SELECT h.ssn, h.calcdate, h.HoursDate1, h.Hours1, h.HoursEndDate1, x.PrevStatDate, n.NextStatDate FROM Work_Hours1 AS h INNER JOIN ( SELECT...

That should be: Set fDialog = Application.FileDialog(msoFileDialogSaveAs)

Hello, JonFer, That will not work, either. You will get a "Could not delete from specified tables" error. If you stay with the original query syntax I provided, you will find it meets the requirement.

Hello, JonFer, You have an incomplete INNER JOIN clause; your query will not work.

You might try something like the following (substitute highlighted text with actual table/field names): DELETE T1.* FROM MyTable T1 WHERE EXISTS ( SELECT T2.ID FROM MyTable T2 WHERE T2.ID < T1.ID AND T2.C10 = T1.C1 AND T2.C9 = T1.C2 AND T2.C8 = T1.C3 AND T2.C7 =...

You're welcome, I'm glad it worked for you :)

You can use the SendObject method (ref: http://msdn.microsoft.com/en-us/library/aa220736(office.11).aspx) For example: DoCmd.SendObject acSendReport, _ "MyReport", _ acFormatRTF, _ "ToReceipient@mymail.com", , , _ "Test Subject", , True

Wow, I didn't even know that Microsoft Access ran in COBOL...

Try: With ISODBC .Open "Provider=sqloledb;" _ & "Data Source=My Server Name;" _ & "Initial Catalog=My Db Name;" _ & "User ID=My Login;" _ & "Password=My Password;" End With Without knowing your SQL Server setup at home, versus your setup at work, I don't have...

Try replacing: rs.Open xsql, ISODBC, adOpenDynamic, adLockOptimistic ...with: With rs .ActiveConnection = ISODBC .CursorLocation = adUseClient .CursorType = adOpenKeyset .LockType = adLockOptimistic .Open xsql End With

The Multiselect property of a listbox refers to Rows, not Columns. What is it that you are trying to accomplish?

If you are aware of the solution by Steven Lebans, ReportToPDF, you should also be aware that creating a PDF from a report is EXACTLY what it is FOR. With his solution, the following statement: ConvertReportToPDF "MyReport", , _ "C:\MyFolder\MyReport.pdf", _ False, _ False ...will...