Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Gutierrez
  • Content: Threads
  • Order by date
  1. Gutierrez

    Update Recordset Using Multiple Recordsets

    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 "...
  2. Gutierrez

    Listbox wont Display

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

    Listbox

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

    Multiple Criteria Sum If

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

    Insert new rows based on criteria in VBA

    Hello all ... need your help once again. here is my problem ... I have a worksheet with data in it .. in column"z" i have a number value ... what i would like to do .. is 1) insert a row after a certain criteria is met ie. if column z row 1 = 20 row 2 = 20 row 3 =20 row 4 =30 i would...
  6. Gutierrez

    Vlookup in VBA

    Hello again ... I have been here on TT for just 2 days and have to say its been great ... but i need your help once again. Problem: I need to program a vlookup in code ... currrently have it in a workbook referencing another workbook ... what I need is to run the vlookup and then pass the...
  7. Gutierrez

    Compare 2 columns using VBA

    I have 2 worksheets .. and want to compare worksheet1 column "A" and worksheet2 column "A" if worksheet2 Column "A" is not a match then i would like to copy and paste it to worksheet 3 .. along with a few more columns on that row .. how can this be done? thanks in advance.
  8. Gutierrez

    if then statement use of NULL in a vlookup

    i have an excel worksheet that is returning values using a VLookUp but dont want N/a to appear instead a 0 .. how do i do this ... thanks in advance.

Part and Inventory Search

Back
Top