Recent content by Gutierrez

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