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!

  • Congratulations Mike Lewis 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: *

  1. Starrizzo

    Subtracting TIme in Excel

    I have a SS that has the schedules of employees. for example A1 = 4pm-8pm, B1 = 4pm-10pm How would find the total hours worked for the A1 and B1
  2. Starrizzo

    Is there a way to disable disable/enalbe Macro msgbox

    I have a few macros that run in one of my spreadsheets, is there a way to add someting to the code that will make a rule to always have Macros enabled and not have that pop up show at the opening of a document?
  3. Starrizzo

    How can I add sending an email to a button click

    Ok I am a little confused. Im really new to this, but I think i understand the beginning of the code. but when it gets to the server part I am completely stumped.
  4. Starrizzo

    How can I add sending an email to a button click

    I have a form that submits a new record to an Access DB, is therre a way that I can add a macro that after form close it sends me an email stating there has been a change?
  5. Starrizzo

    Trouble saving data from form to access table

    Im really new to this, could someone please give me some example code on how to write an event that saves text from 3 text boxes to a table in access?
  6. Starrizzo

    hOW TO ADD A FORM TO DATA ACCESS PAGE?

    So if i drag the fields onto the DAP from my table, can they be updated that way. I want employees to be able to input information
  7. Starrizzo

    hOW TO ADD A FORM TO DATA ACCESS PAGE?

    I have a page on company intranet that I need to be able to link my existing table to. I can bind my fields but how do I get them to add new records to the table?
  8. Starrizzo

    Excel sheet pastes only as an object

    I have an excel worksheet that is not protected and will only past as an object in a new tab.
  9. Starrizzo

    How do i subtract dates?

    I want to be able to find out how many months a person has worked. Is there a way in excel to find that out. 10/5/02-12/04/05= ???
  10. Starrizzo

    How can I make a formula to gradually add a new cell everyday?

    I am trying to make a formula that adds a new cell everyday
  11. Starrizzo

    Is there a way to protect only certain columns in a table?

    I have a table that has a few columns that i want to protect so they cant be changed. Can this be done?
  12. Starrizzo

    Can i a list of numbers by the last two digits?

    I have a list of account numbers that i need to sort by last two digits of every number. The list is about 5000 long so going through and adding a delimiter is out of the question. Is there any way I can do this??? Example of list: 0025634657 0012265466 0032654465 0065487654
  13. Starrizzo

    How can I sort list of names by last name not first?

    Thanks the delimited worked out just dandy!
  14. Starrizzo

    How can I sort list of names by last name not first?

    I have a column of names but each cell has the first name and the last name in it. is there a way for me to sort the column by the last name not the first?
  15. Starrizzo

    Is there a way to conditional Format a Combo box in a report?

    I have a report that lists all Tardies absences and writeups in a date range. The Combo box has the choice of absence,tardy,write up,verbal. I want to be able to Bold and make the font 1 size bigger on only the write ups. Is there a way of doing this without formatting the whole combo box
  16. Starrizzo

    How can I join 2 Tables to one Report?

    I have 2 tables, One is has write ups and another has Absences and tardies. I need to make a report that will make a list of occurances from both reports by date. How can I do this
  17. Starrizzo

    Can I default my form to open with blank fields?

    When I currently open my form it displays the last record that was entered. I need it to open with all the fields blank so that when users enter in information it doesnt write over the current record.
  18. Starrizzo

    How do i remove Duplicates in an access Query?

    I have a table full of account numbers and most of them are duplicates. How would i build a query to only include the Unique accounts?
  19. Starrizzo

    auto populating a field on a form

    well im sorta new at this and dont know exactly how to use the dlookup.
  20. Starrizzo

    auto populating a field on a form

    I want to be able to type in an employees ID and have the first name and last name field to auto populate on a form. Is there an easy way to do this?

Part and Inventory Search

Back
Top