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

    Mail & PHP form data

    I have a form where an email address is entered, then used with the MAIL command to send the email. Most of the time it works, sometimes it does not. To debug, I use the following 3 commands: Test 1). mail('a@cnn.com','Test1','*'.$return['email'].'*',$hdrs); Test 2)...
  2. UBfoolin

    Can I SELECT *, NOT Col1 FROM Tblname;

    My table has a very large number of columns. Is there a simple way to select ALL of the fields in a query except one of them? Something like: SELECT *, NOT Col1 FROM Tblname; Thanks in advance, Dan
  3. UBfoolin

    0000012345.23 TO 12345.23?

    Thank you! Worked great!
  4. UBfoolin

    0000012345.23 TO 12345.23?

    It seems CAST() can only convert to integers. How can I strip the leading zeros from a varchar field? If I use FORMAT("0000012345.23",2), I get 12,345.23 which would be great if I could stop the comma 1,000s separator. How can I get the result I want, 12345.23? Thanks, Dan
  5. UBfoolin

    Enable macros when opening Excel .xls from VB

    Thank you for taking the time to reply! I cannot use a query. The data is not tabular. I did find that if you are running XP SP2, you can use Application.AutomationSecurity = msoAutomationSecurityForceDisable and the app will not get the dialog box. Alas, we are NOT running SP2!
  6. UBfoolin

    Enable macros when opening Excel .xls from VB

    My app needs to import orders from Excel spreadsheets. There may be 50 .xls files to open at a time. Then I pull the data out and put it into our system. From VB, can I "click" the Enable Macros button on the Excel dialog box automatically? I really don't care if macros run or not but I cannot...
  7. UBfoolin

    form.PrintForm to a .PDF?

    Okay, that works! Thank you. Now, how can I read what the default Windows printer is before I change it? After I print my form, how do I then reset the default Windows printer back to it's original value? Thank you
  8. UBfoolin

    form.PrintForm to a .PDF?

    I am certainly willing to give it a try, but need to know that the CommonDialog works with form.PrintForm. I can not find where it does. Has anyone done this? Thank you
  9. UBfoolin

    form.PrintForm to a .PDF?

    How can I form.PrintForm to a .PDF? Maybe a better question is how do I print a form so that I get the normal Windows print dialog box? If I could get that, I could pick Adobe PDF just as I do for Word, Excel, etc. Thank you for your time.
  10. UBfoolin

    SQL help!!!!

    If I have a table with fields and data like: Key A B C === = = = 111 A B C 222 A E C 333 B A M Is there a way to write a query to move the data from fields A, B and C into a single column named D, grouping by the Key field? Desired result: Key D === = 111 A 111 B 111 C...
  11. UBfoolin

    Help with SELECT

    If I have a table: Key A B C === = = = 111 A B C 222 A E C 333 B A M Is there a way to write a query to move the data from fields A, B and C into a single column named D, grouping by the Key field? Desired result: Key D === = 111 A 111 B 111 C 222 A 222 E 222 C and so...
  12. UBfoolin

    Please help with a query

    I think I may have been unclear in my request above. T2 can have a specific Code1 value several times with various Code2 values. An example: T1 Account Code 123 A 123 B 123 4 123 8 T2 Code1 Code2 B A B Y B...
  13. UBfoolin

    Please help with a query

    I can not figure out how to do this in MySQL 4.0.12. The rule is, in English, if an account has a Code1 then it should not have a Code2. I need to find all of the T1.Code values that break this rule. Table1 (T1) [50,000 accounts; Approx 20 codes per acct] Account Code Table2 (T2) Has 200,000...
  14. UBfoolin

    Data from Excel to VB by column name/header

    My users create Excel worksheets that have a single header row with the field name for each column's data. The fields are NEVER in the same columns from worksheet to worksheet. How can I pull the data from all worksheets, using the field name in the first row, putting each column's data into...
  15. UBfoolin

    VB6 export to & import from Excel (text vs. numeric format cells)

    I can not read data that I have written into Excel from VB, back into VB after it is edited in Excel by the user. It appears that the numeric data is going into Excel as a text cell. It is a CHAR 7 defined field in mySQL. When the cell is edited in Excel, the format changes to numeric and when I...
  16. UBfoolin

    Multi Step Error

    I am having the same type of problem. My field will accept 45 chars of data, but not 46. The field is defined as varchar(100) not null. Have you found a solution? Thanks.
  17. UBfoolin

    Field won't accept data

    I'm running VB6 with mySQL and myODBC. The following is occuring. Field1 is defined as varchar(100) default NULL. 'MYSQL CONNECTION Set cnMySQL = New Connection cnMySQL.ConnectionString = "Driver=(MySQL};Option=0;Port=3306;server=localhost;database=xxxxx;" cnMySQL.Mode =...
  18. UBfoolin

    After ADO rs.AddNew, rs field won't accept data

    I'm running VB6 with mySQL and myODBC. The following is occuring. Field1 is defined as varchar(100) default NULL. 'MYSQL CONNECTION Set cnMySQL = New Connection cnMySQL.ConnectionString = "Driver=(MySQL};Option=0;Port=3306;server=localhost;database=xxxxx;" cnMySQL.Mode =...
  19. UBfoolin

    Best "grid" component for editing recordset with columns NOT in order

    zemp, Thanks so much. You can email me directly at dje60@aol.com. I've been playing with the MSFlexGrid and would really appreciate your test project. Thanks.
  20. UBfoolin

    Best "grid" component for editing recordset with columns NOT in order

    What is the best data "grid" type component to use? My users need to edit, insert and delete records. I am using ADO recordsets pulled from a mySQL data base. It is a hard requirement that I rearrange the order of the columns\fields. When the user sees the grid, the columns need to be...

Part and Inventory Search

Back
Top