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 derfloh 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: ribhead
  • Order by date
  1. ribhead

    Use Default Printer Function?

    I'm trying to use the default printer function but I'm getting an arguement not optional alarm. What is it that I'm missing? Private Sub cmdprint_Click() Call My_Print End Sub Function My_Print(frmblankreport As Form) As Boolean frmblankreport.UseDefaultPrinter = True DoCmd.PrintOut...
  2. ribhead

    Group By Question

    PH, Thanks for the info. Obviously I wasn't aware of it. So if I'm going to be adding values that could possibly be null should I be setting the default value to zero in my table? Zero is different than Null isn't it? Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago...
  3. ribhead

    Group By Question

    PH, Yup this works Great! Thanks! Why do I need the NZ and the ,0 for the sum? If I may ask. Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  4. ribhead

    Group By Question

    Ignore the middle date it is supposed to be 1/4/2005 Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  5. ribhead

    Group By Question

    Here is the Project Query SQL code: SELECT tblprod.Counter, tblprod.Shift, tblprod.[Date entered], tblprod.[Part number], tblprod.Department, tblprod.[Machine area], tblprod.[Hrs running prod], tblprod.[Hrs s/u time] FROM tblprod WHERE (((tblprod.[Date entered]) Between Now() And Now()-90) AND...
  6. ribhead

    Group By Question

    PH I got the same result. This is what I have. SELECT [Date entered],[Shift],[Department],[Machine area],[Part number] ,Sum([Hrs running prod] + [Hrs s/u time]) as [Total Hours Worked] FROM QueryProjects GROUP BY [Date entered],[Shift],[Part number],[Department],[Machine area] ORDER BY [Date...
  7. ribhead

    Group By Question

    I'm trying to get my teams set up hours and production hours for certain jobs called project jobs. I'm trying to get them broken down by the Date entered the Dept. then the work center. I am only getting the Hours of production for one run. If two shifts run the same job on the same day I'm...
  8. ribhead

    Getting rid of zeros in my list box!!

    When I get done putting out all the fires I will give it a shot! Thanks alot PH Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  9. ribhead

    Getting rid of zeros in my list box!!

    PH sorry but I can't remember the exact name but it said Expr<>[Percent of rate]. I keep having to get out of it because people are trying to put in their information. Again sorry for being brief but in the last hour I've got ten thousand problems. I guess that's why the pay me a bit more...
  10. ribhead

    Getting rid of zeros in my list box!!

    PH, I pasted the statement but my field names changed. I tried using the AS statement but got a circular reference type error. The Percentages in the Query looked the same as before no .00% Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  11. ribhead

    Getting rid of zeros in my list box!!

    PH I just copied the SQL view so it will look a bit ugly SELECT tblprod.Counter, tblprod.[Date entered], tblprod.[Time entered], tblprod.Comments, tblprod.Department, tblprod.[Machine area], tblprod.[Clock number], tblprod.Shift, tblprod.[Part number], tblprod.[Op number], tblprod.[Route ID]...
  12. ribhead

    Getting rid of zeros in my list box!!

    PH SELECT * FROM Query2; Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  13. ribhead

    Getting rid of zeros in my list box!!

    PH I have made the number format in the Query match the table (No decimal places) and I'm still getting .00% Thanks for the reply Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  14. ribhead

    Getting rid of zeros in my list box!!

    I have created a list box that is simply pulling in queried information. In this list are basic numbers and percentages. The table has been formatted to have 0 decimal places for the percentages and a Null value for default value. However I am getting .00% and a lot of 0 where no information...
  15. ribhead

    VBA code to kick off logged users before maintenance

    Hello everyone. I have a question/comment on this method. I too have problems with updating my tables(maint) and have to wait until people get off the db. However when I'm in the db running code sometimes I have a person who opens it up while I'm running code and my program crashes. Is...
  16. ribhead

    Missing Reference Question

    PH I unclicked the reference that said "MISSING" and now it seems to be working fine. I guess I thought there was a lot more to it. Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  17. ribhead

    Missing Reference Question

    Howdy, I'm in sort of a bind right now. Our I.T. Dept. "upgraded" our network and now several computers are missing a reference so I cannot use Environ(COMPUTERNAME). The reference that is missing is Microsoft Windows Common Controls-2 6.0. If I know what reference is missing how do I (can...
  18. ribhead

    Horizontal scroll question

    Oh Well thanks anyway Aceman. At least I know not to post the question again. Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago? Rope:No, I'm a frayed knot.
  19. ribhead

    Horizontal scroll question

    I've looked at the column width property. I understand about adding the widths up and making that my listbox width but what happens when you are restricted on space and have to make the listbox width smaller? Isn't that the reason for a horizontal scroll bar? For example I created a listbox...
  20. ribhead

    Horizontal scroll question

    I asked this question a while back but didn't get anything to help. I have created a list box with about 12 columns. My problem is that when I scroll the last column width is huge. How can I correct this issue? Thanks, Rib Bartender:Hey aren't you that rope I threw out an hour ago...

Part and Inventory Search

Back
Top