Search results

I have this funtion set up Function GetAllDate(dt as Date) as Date GetAllDate = DateAdd("s",-1,DateAdd("d",1,DateValue(dt))) End Function i want to call it in my criteria for end dates Heres what I have in my query criteria: Between #1/1/2008# And GetAllDate when i go to run the...

Well it hasnt been the same exact place everytime. but it seems like it basaically looses power. I was half way through a reinstall of windows when it happend so i have no OS on it now. After leaving it for 1.5 hours it seems to be working a little better. Ill know in a few minutes when it...

I have an hp nc8230 laptop. Ive never had any power issues with it before. Well today i decided i was going to reload it. When i get to the xp setup screen the laptop just shuts off. Ive tried about everything. took battery out, different power cord. docking station with different power...

I have a multi line textbox that has data string that are like the following: 07603,5,0930341, 07603,5,0930342, 07603,5,0930343, 07603,5,0930344, What i want to beable to to is what ever value is in my textbox(above data), to save that to a textfile on the mobile scanner. Any help would be...

Im using Visual Studio 2008 Heres what im trying to do. I have a form that has a start button, 2 small text box, 1 multiline textbox, and a finish button Start button just enables all the other textboxes and button to be active. 2 small text box are named txtProduct, and txtRow, multiline...

I am trying to use LEFT in a query. But im not getting it to work. right now in my query i have: LOT2: LEFT(orders.lot,2) Any help would be great.

KRYST51, worked good. thanks.

OK So how would i do that in my formula that i posted?

I have a report Where my detail row is already summed up from my query. So example on of my fields is called SumOfGeneral_Repair. Ok so in my report footer i have all my detail rows summed up again. I also have a textbox that is counting the rows that do not have a zero. So what i have in...

Thanks for the help

whats the formula to do a count including not equal to 0

OR what and where should my formula be?

So What i should do is a count for the detail row for example where they are not Equal to 0 Then add up my numbers and divide by that count number i get?

I have a report, and in the report footer i have averages for different columns within the report. How do i get that average to exclude ZEROS. Example below: 0 0 450 0 0 that average is 75 the way i have it now, and it should be excluding the ZEROS, and the avg should be 450

what does it actually do to the database?

Yes and I cannot find anywhere that the data would be over the size of the field limits. When I commented out the line of code dealing with custname, everything went smooth, but I cannot find anything wrong with any customer in any table that would cause this to error out.

that didnt work, any other tips?

It is erroring out on the bold line, can anyone help on a fix? Do While Not rsSortTemp_In.EOF blnCopyData = True rsSortTemp_Out.AddNew rsSortTemp_Out!TableID = 0 rsSortTemp_Out!ClientCode = Left(rsSortTemp_In!CustID, intClCodeLen) rsSortTemp_Out!CustCode = CInt(Right(rsSortTemp_In!CustID...

I have all the On Error lines commented out, and it is still breaking right away, can you give me a better way to debug, to see what line its bugging on. Thanks

let me know if i did this right. I put a break point on line one and and End Sub, used F5 to step through and it errored out right away.