Search results for query: *

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

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

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.

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.

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

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

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

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.

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

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.

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]...

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.

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.

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

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

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.

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

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.

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

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