Search results for query: *

IMO, i would simply modify the SQL ODBC connection for a dynamic datapull, but that's just me... perhaps i should take another look at it. sup up the code like you guys say...test out if cleaner code makes the screen updating sticky. Tek tips Rulez

Thanks for your suggetion Gruuu, this code was inherited to me, and i tried placing the screenupdating and display alerts in the beginning of the sub with no avail. the above code to my guess was created using Excel's macro recorder. I wasn't scoped as a programmer to fix his code, just to...

Hi skip Thank you for your time. Screen updatingisnotworking means excel shows me the activity in sub BU. Aka tab switching, column selecting...etc

Hi team, I have vba sub that gets called from a change in a value of a cell: ie: Private Sub Worksheet_Change(ByVal Target As Range) Application.ScreenUpdating = False If Target.Address = "$C$5" Then nonupdating BU ... end if Where nonupdating is : Option Explicit Public Sub nonupdating()...

Hi Skip, I understand, however how will i populate my table with the data i receive that is already in an array?

Hi Guys, I have an API that fetches data from a URL and posts it into an array format. I would like to have that array write to a table. Questions: Do I need to create the table definition first? How do I place the data from an array format into a table structure? Any guidance would be...

Hi Guys, I have an API that fetches data from a URL and posts it into an array format. I would like to have that array write to a table. Questions: Do I need to create the table definition first? How do I place the data from an array format into a table structure? Any guidance would be...

I have a loop that calls the following proceedure Public Sub sortert(rx As Integer, cx As Integer) ' ' Macro2 Macro ' Dim r As Range Dim sortrange As Range extr = rx + 17 extc = cx + 7 sc = cx + 5 With sortrange = Range(Cells(rx, sc), Cells(extr, sc)) End With With r = Range(Cells(rx, cx)...

Thanks Dhookom, its a special case where its absolutely needed, a one time gift is counted as a down payment(the actual payment) and should also tally into the "total payment" which is also the total pledge

Hi , I have this form where if someone enters a one time payment, i want it to go into the [down payment] column and also the [total payment] column for that user. Any advice? Thanks

hi team, you are right, forms toolbar has no control to change the font. ended up using the active x control ( which was surprisingly easy) which has the font control. I really all your help. Chris

actually Fumei, ignore the previous post, I can select the drop down, and it says view code, which takes me to vb on : Sub DropDown1_Change() End Sub but I cant see anywhere the place to modify the font :(

fumei, ok thanks for confirming. next question is , how do i make it a control control :)

Hi scott, I put in the combo box from the developer tab. Please test this as it does not work. From the developer tab, create a new combo box(non active x). Then put some dummy data in, then select it with right click so its selected (white little circles on the corners) but not activity the...

Hi andy, negative, on that. the combo box comes from straight developer tab > insert > then selecting combo box. I did not use VB to create a custom userform. Chris

Hello, I need to change the font size within a combo box in excel. Not sure this is the right forum but any help would be greatly appreciated. this is not the active x combo box, this is the standard combobox in excel 2007. Thanks

Hi dhookom, I placed the txtCustCount within the lists of the names(detail separator) and i placed the other txt box source to where I count the names(footer). count(name). However it did not work, what do you mean by grouping?

Hi i dont get the above?

Hi Randy No i tried Dcount and it isn't built to work in a report.

Hello All, I have a report that is the following Customer Item amount Chris - Apples - $100 Chris - Oranges - $100 Bobby - Apples - $1000 Jim - Apples - $1000 Total # of people 4 - Total $ 2200 I would like to count distinctly the # of customers. regardless of the # of times they appear...