Search results for query: *

tell me if you think this would work?? IDNumbMDRs = Replace(IDNumbs, "US", "00") rsSQL.Open "select PersonnelNbr, PrimarySectorCode, SecondarySectorCode,PrimaryFocusCode from Employee " & vbCrLf & _ "where PersonnelNbr IN(" & IDNumbMDRs & ") ", con 'Updated to...

What I need is a snippet of code (using MS Acess) that will allow me to update one recordset based on another ... here is what i have so far IDNumbMDRs = Replace(IDNumbs, "US", "00") rsSQL.Open "select PersonnelNbr, PrimarySectorCode, SecondarySectorCode,PrimaryFocusCode from Employee "...

Still need help with this one folks ... I actually posted again .. sorry.

Hello All, I think this problem has an easy and obvious solution .. but I just cant figure it out. I have a listbox on a spreadsheet that after the VBA code runs to add items wont display those items .. I can do it by opening another application and then coming back to the Excel worksheet ...

I have a listbox on a worksheet that after i add list items doesnt display ... any help would be appreciated .. i do know that the listbox is populated .. if i minimize sheet and then go back to it .. its there anyway to do this in vba? Public Sub Workbook_Open() ActiveSheet.Cells(6...

ok ... i have data in a spreadsheet ... columns A:T ... with a header row ... data also exist in columns U:Z this also has a header but unimportant ... on anothe sheet in this same workbook .. i have for lack of a better word a summary page ... and as an example ... cell B7 contains the text...

is this in your opinion the best solution ... i was thnking if i could do a sum it .. and the way the logic goes is select the range that has my criteria ... in this example header5 ... then select my criteria 123 , and then use the column heading to select the column in which to sum based on...

Hello all ... I have a spreadsheet "header" that contains some data in it ... range A:T contain data i would liek to sum .. by column ... and range U:Z has some other data that i would like to use as criteria ... ... and the last thing i would like to do is use the column headers as the second...

ok .. but i have 7 columns to get a subtotal for ... also i dont want anything but the subtotal ... and the grand total .. for each column ... what would the code look like to do that???

well i did see the code for subtotals .. but it didnt look quite like i had wanted ... so ... what i have currently looks good ... just need the totals in the middle of the 3 rows created

Geoff ... above is the lastest and greatest code ... thanks again ... but what i want to do now is subtotal each group in the row i created ... can u provide some help .. maybe a code to loop thru and get a start and end ... then summ everything in between?

ok .. that did work great ... but now i need the subtotals .. but for several different columns here is what i have so far ... i would like to subtotal in the cell with the formatting .... all the cells in that group. Dim i As Integer Dim iLastRow As Long Dim newMonthData As...

thanks firefytr .. i will keep that in mind

ok .. that did work great ... but now i need the subtotals .. but for several different columns here is what i have so far ... i would like to subtotal in the cell with the formatting .... all the cells in that group. Dim i As Integer Dim iLastRow As Long Dim newMonthData As...

i did change the code ... it just adds 1 line .. dont know how to change that to 3

Hey Geoff ... got ur code to work .. just one question .. i want to add 3 rows not one .. how would i do that?? here is my code: Dim i As Integer Dim iLastRow As Long Dim newMonthData As Workbook Dim rg As Range Set newMonthData =...

here is the code that i have .. and yes it does it automatically ... how do i incorporate your code to allow just the 3 rows to be added ... i dont need subtotals just yet Dim iLastRow As Long Dim vValue As Variant Dim newMonthData As Workbook Dim rg As Range Set...

Geoff ... ur idea to do a vlookup worked great .. thanks ... now i have no clue on how i would insert the subtotals ... what i would want ideally .. is to after change in grouping ... insert 3 row ... move everything down. dont know if thats the proper way of doing it .. or working from the...

ok .. i follow u ... but how do i do a vlook up ... on a number ... and the lookup is not a number but a formula in other words .. i am looking to make group1 all rows <90 how would u write the vlookup for that?

this is what i think will work .. just need some help figuring it all out ... this is the range to be checked need to set c = to find values that are >90 having trouble with that and then want it to cycle through each cell in range when criteria is met then inser 3 rows above it with...