Recent content by UBfoolin

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

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

Thank you! Worked great!

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

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!

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

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

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

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.

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

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

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

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

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

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