Search results

set the format for that field to fixed and adjust the decimal places to 2. That should take care of it for you. (thats all in the properties menu.)

OK guys I have one of 2 things I am having issues figuring out. I have the following code that I would like to run in a query but having a problem changing the decleration from for to query: Option Explicit '************************************************************* ' FUNCTION: PrevRecVal()...

I actually need to run 2 functions and they are as follows: '************************************************************** Function PrevRecVal(shipmentlookup As Form, Trans As String, KeyValue, _ zip As String) Dim pZip As DAO.Recordset On Error GoTo Err_PrevRecVal ' The default value...

Ok I think I found an answer to summing my calculated field. But, I now need to combine all of my zip codes from multiple records into one field. IE Record 1 - Zip 17543 Record 2 - Zip 22200 Record 3 - Zip 90210 into a field that looks like "17543 * 22200 * 90210" As always thanks for your...

thats correct they are not stored because the order in which the run is made changes constantly so the miles would change as well. I was trying to figure out some code. I will focus on that route and post my results incase anyone else has the same issue. Thanks for your time!!

shoot me an email if you run into a snag I would be happy to put a sample together for you

Ok I don't know if this is the right way to do it (I am the king of half arsed programing) but I think it would work for you.... Create a "pop up" form with a [date start], [date end], [status]drop down, and [type]drop down. Then create a button with an underlying macro the opens your main...

Yes Yes and Doh Any ideas on what i can do to make this work even if its redoing everything? I just spent $1700 for the API data and really need to be able to sum the miles to get the value.

it would be a variable number. from 2-10 times would be the normal range. and it is continuous I was thinking if I could make the call in the underlying query I would be OK but I have not been able to make that work.

Milesfromdll comes from this Public Declare Function RouteStopPairByParm Lib "batch32.dll" _ (ByVal pStop1 As String, ByVal pStop2 As String, _ ByVal pParams As String, ByVal pErrFile As String, _ ByVal pPath As String, _ ByRef pMiles As Double, _ ByRef pHours As Byte...

so there is no way to sum a calculated field??

That didn't seem to do it either. I did (right or wrong) add a new field ppZip with the control source as Iff(pZip is null, zip, Pzip) and that seems to work. Now I need to get the miles to total at the bottom of my form. Thanks for the help Wayne.

I have a form I need to Sum the milesfromdll field in the footer. The milesfromdll field is calculated by calling an API and returning the number of miles between 2 points. When I try to =Sum([milesfromdll]) All i get is an #error. Any ideas? As always thanks in advance!! Nate

Thanks Wayne, But I still get the same result. In the first field pZip would actually be null since the pZip value comes from the previous record and there is no previous record for the first record to pull from. I have tried: If pZip is null then pZip = Zip If pZip = 0 then Pzip = Zip and...

That would work fine but I'm having issues with the code for that I have tried several ideas but none of them have worked. The first record would be the start of a new shipment so a zero fmile value is correct.

I am calling a DLL from a form in access. in this form I am selecting the zip code from the previous record using the following code: Function PrevRecVal(shipmentlookup As Form, Trans As String, KeyValue, _ Zip As String) Dim pZip As DAO.Recordset On Error GoTo Err_PrevRecVal ' The...

You da man thanks again

Okey Dokey I think it makes sense... Needs to reselect it to "highlight the text"?

The second one was the one I'm looking for. Thanks... But, What is the "anotherControl"? do i need it to select off then back onto the field I want to copy?

Ok guys I am working on an update form where my dispatchers will double click on a number and it copies it to the clipboard and then goes to the next form and double clicks again to paste the data. Is there a way to do this? Thanks again!