Search results for query: *

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

So, the real issue is not how to control the Save As dislog box; the real issue is how to output the report to a PDF with a predetermined filename, without being prompted for the filename? You may wish to check out the ReportToPDF solution created by Stephen Lebans...

Option 3 is a combination of the first two option bits: 1 OR 2 = 3 If I wanted to add option bit 8 to this parameter value, it would be: 1 OR 2 OR 8 = 11 ...so the related part of the connection string would read: Option=11;

Using the sample data you provided, the following ODBC connection string should work to connect your front end to the remote MySQL backend: ODBC; Driver={MySQL ODBC 3.51 Driver}; Server=mysql.frontpos.com; Port=3306; Database=accounts_rms; User=test; Password=testpwd; Option=3; Here are the bit...

Ahhh, that did the trick. Not only do I have more room, but I can do criteria searching/filtering, AND that nasty bug does not manifest itself. I am modifying the field in the production database to type varchar(max) right now. Thank you, SQLDenis. VFP 6? What is that?

genomon, ntext (memo) fields are not searchable with string comparators, and the next largest field type you can use is varchar(8000). mrdenny, The bug seems to be with DAO recordsets in MS Access 2003. ADODB Recordsets do not exhibit this adverse behavior. The catch-22 here is that DAO...