Search results

I have a continuous form with zip codes listed in each record. I would like to combine all of the zip codes in a single field. I can get it to pull the zip from the current record but not the rest. how would i: [Zip] next record [zip] and so on the number of records can vary from 2 to 10...

I know I posted this below but i thought it might be a bit cluttered so I am cleaning it up and re posting... I have a form with a function that calls an API and returns miles between 2 zip codes. I need to sum the miles but access does not allow summing of a calculated fields. So what I would...

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

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

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

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

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!

Ok guys here i am again with probably a simple problem... I have a form "manafest" and 2 subforms with detailed load information one pick up and one delivery. within the subforms the pick up and deliver locations are designated by zip code. In a seperate table I have latitude and Longitude for...

Hi Guys I am working on a form letter and would like to have a paragraph on the form but in the middle of the text I would like the members name (which is from a field) IE your candidate [member name] has been found worthy to bo initiated into our illustrious order. I can get it to work by...

Hey guys its been some time since I have made any updates to my DB but the time has come to create Ver 2.1. Anyway I have a form with a list of shipments. I would like to calculate the miles between zip codes on seperate records. What i need to do this is to select the zip code from the previous...

Ok guys Heres the skinny... I am working on a form with 2 subforms. The form is to be used as a confirmation print out. Problem is when I try to print the form it only prints (or displays in preview) the parent form and no information of the child forms. As always any input is greatly...

Ok guys new issue.... I have a report with 3 subreports. The totals of the 3 subreports transfer back to the main report and are summed to the right. Now I need to sum down. Example: detail (below works fine) Truck #------Inventory sum-----sublet sum------labor--------------sum...

Ok I asked a similar question on the reports forum but this may be the better location for it..... I have 3 linked tables all linked by a repair order number. The 3 tables are- RO number table which contains the RO number, the customer, and unit number......Inventory parts table which contains...

Ok guys here is what I need to do..... I have 3 queries with different segments of a repair order. all linked by a repair order number. each query may have anywhere from 0-10 entries attached to the repair order. I need a report to give to the customer that shows the totals for a specific time...

Ok guys I have a form with 3 subforms in the main form. all 4 forms (main and 3 subs) have calculations that I would like to total. I do have sums in each subform but not all subforms are used for each entry. When I use all of the fields my grand total works fine but if I don't complete all of...

Hi all very helpfull site!! I am designing a report for my company and I will have a list of odometer readings and I would like to subtract the lowest number from the largest number to get a total miles for the month. How do I select only those 2 values in my report? Thanks in advance. Nate