Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ByteMyzer

    DataView.Sort and DataView.FindRows

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

    a permutation question

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

    Insert BLOB in SQL server

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

    Append Query with 2 Subqueries Runs extremely slow

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

    Office.FileDialog check if one or more files exist

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

    Help with complex DELETE requested

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

    Help with complex DELETE requested

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

    Help with complex DELETE requested

    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 =...
  9. ByteMyzer

    How do I email a report as pdf, snapshot, or xml

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

    How do I email a report as pdf, snapshot, or xml

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

    How do I email a report as pdf, snapshot, or xml

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

    How to Update a form bound to a ADO recordset

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

    How to Update a form bound to a ADO recordset

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

    Multiselect Listbox

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

    Controlling the Save As Dialog Box with VBA

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

    Controlling the Save As Dialog Box with VBA

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

    connecting msccess to remote MySQL

    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;
  18. ByteMyzer

    connecting msccess to remote MySQL

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

    SQL Server 2005, Varchar Field Type returning Null Value (Bug)

    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?
  20. ByteMyzer

    SQL Server 2005, Varchar Field Type returning Null Value (Bug)

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

Part and Inventory Search

Back
Top