Recent content by bigleroy

Kendel, The type of combo box I was using (OLE DB DataCombo Box) does not have the AddItem Method. I switched to a normal combobox and now it works correctly. Thanks, Leroy

I am using a bound combo box to display records. However, only the first record of the recordset is being displayed. How do I display all records? Set cnnProvType = New ADODB.Connection cnnProvType.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist...

I am receiving the following error when I try to connect a database combobox to a SQLServer based recordset. The Error: Run-time error '545': Unable to bind to field or data member: "VendorType" Here is the code I am using Dim cnnProvType As ADODB.Connection Dim recProvType As...

Hi, I'm executing a Stored Procedure with one parameter that will fill a combo box. When I run the program and click on the combo box, first record returned is displayed and the drop down portion of the box appears blank. Private Sub dbcAccountID_Click(Area As Integer) Set cmdAccountID...

Thanks Acron, I combined your function with mine and it worked? You've made me the office hero. =VALUE((MID(REPT(0, 10-LEN(I22))&I22, 1, 9))) Then I can format the cells however I like. Thanks again, Leroy

I tried what you suggested, but the result was "$1.00" no matter what "amount" was in the problematic column. I believe this is because the problematic column is not converting accurately from a text to a number. Is there a way to pad zeros to the left of a decimal in a...

I have been copying reports from a web page. When I paste into excel, every field ends with a space. (ex "19.99 ") This is preventing me from formatting the cells as numbers or currency. I have tried Ctrl + H and it will not recognize the end space. I have also tried the trim...