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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Legends77

  1. Legends77

    Display Records

    Worked great, thanks!
  2. Legends77

    Display Records

    I have a form (frmvendorshow) with the following fields: vendorname / SAPNumber / Active What I need is to make vendorname a drop down box and once the vedor is selected, the correct SAPNumber and Active to appear. Currently, I keep changing only vendor name and all else stays the same. I...
  3. Legends77

    Insert a Report Footer

    yes... even when I go to properties, I see "Report Header", "Page header", "page footer" but no "report footer".
  4. Legends77

    Insert a Report Footer

    I'm using access 2010. Is there a way to insert a report footer if the header already exists? Everytime I click the reportheader/footer it wants to delete my header. All I want to do is insert the footer.
  5. Legends77

    Excel.... date input mask

    Combo, I have tried several ways with the formula you provided as it looks very promising but having problems. When I put the end "value" of 0159 in cell B1 and the beginning "value" of 0121, the formula returns: -0.0264
  6. Legends77

    Excel.... date input mask

    Mintjulep, Considering the other option, which is to type not only the colon but also "AM" or "PM", I would think it would not be too much of a burden and am going to go forward with that option. However, unfortunately, those using the file are "hunt and peck" typers, therefore, I foresee...
  7. Legends77

    Excel.... date input mask

    What would be the suggested way to calculate a time then? We need to be able to enter a start "time" and end time or something of that fashion, quickly. Reason being, to avoid the users from having to spend time to enter each ":" and "am" or "pm" and have a cell auto calculate the duration...
  8. Legends77

    Excel.... date input mask

    Need to speed up data entry. Currently they have to enter "1" then ":" then "21" then "PM" for 1:21PM and "1",":","59","PM for 1:59PM. This is so the next column can automatically calculate total time of 38min. I was hoping to get it to where they could enter a string like 0121 and 0159 or...
  9. Legends77

    Excel.... date input mask

    I am currently using the following input mask in Access to allow users to input military time: 00:00;0;_ Is there an equal excel input mask for excel? ... I tried using this in excel but says it is not a good mask and I have been searching but no luck with any of the builtin's. Any help is...
  10. Legends77

    Finding "Last" record in excel

    Is there away to find the last record of something in excel? The issue I am having is this... there are multiple rows where data is entered.. I.E. on row 2, color white shows a beginning balance of 300gal and ending balance of 400gal, but then on row 50 white shows a beginning balance of 400gal...
  11. Legends77

    Macros

    Basically, here is the issue..... 1) data is entered into a table via a form. (table = tblticketform) and (form = frmticketinput) 2) what I am trying to do is have a button that when clicked or "on enter" it will Append the data from (tblticketform) to (tblticket) then delete all the data from...
  12. Legends77

    Continuous form and hiding fields

    Think I will leave as is and let them discover this may not be the way to go and deal with it then. but thanks for the suggestios... from what I can tell there are more important items on their "list" that are more function vs "appearance" related that should be higher priority.
  13. Legends77

    Continuous form and hiding fields

    I have a continuous form that I have been asked to modify. On the form, there is a drop down box "Material" where they can select a variety of items such as Sand / Cement / Waste / Pallets / Customer. I used the below which works but it causes issues if the first record is "Sand" but the next...
  14. Legends77

    formatting headings

    I have been asked to find a way to format the labels at the top of a report on an angle vs just straight across. Currently, the only way I know how to do this would be to create a wordart item in word and import it as a picture but wanted to check to see if there is a way to do it inside...
  15. Legends77

    IIF statement help in a query

    Below is my current statement: Gross TimeM: IIf([Product ID]="Scheduled",0,([NetRuntime]+[UnschedDelay])/60) The problem is that due to someone's mess up I need to admend this for an exception for this month only. I need to make a statement that has all the following if [Product ID] =...
See more

Part and Inventory Search

Back
Top