Search results

Hi, I've been reading about dcount for a while now and I cant seem to find a solution to my issues. I have a report ,rptdeliveryreport, that uses a query ,qrydeliveryreport, to filter on user input dates. I have duplicate invoiceno numbers because there are multiple line items on one invoice...

Hi, I have an excel document that uses the bing API to pull distance for zip codes. I have VBA code Function GetDistance(sPCode As String, ePcode As String) As Double Dim t As String Dim re As XMLHTTP t = "http://dev.virtualearth.net/REST/V1/Routes/Driving?o=xml&wp.0=" & sPCode & "&wp.1=" &...

Hi, I have a form using a query as a control source so that is prompts the user for a parameter when they open the form. I also have a listbox that is calling the same query. The issue I am having is when I open the form it will prompt me twice to enter the same parameter...

Greetings, I have a combo box linked to table shipstatus. This table has 2 columns. ShipCode and ShipName. These values are delivered, on hand, received, returned, warehouse. I have another table named manifestdetails and a column labeled shipstatus I would like to create a form where...

Hi, I have a database that pulls images from a shared folder on our network with links. Do you know if it is possible to create a button to email the current record on a form and attach the file it references in the link? The attachment is a pdf signature. I didnt want to include the files in...

Hi, I am receiving this file from a supplier to import as a table. The issue is I cant figure out a good way to display the info for each invoice because there are multiple rows corresponding to each invoice number. I wanted to build some type of form where I could search an invoice number and...

Hi, I am importing data from a supplier. The table has many invoices included and varying items on each invoice. I need to find a way to separate each invoice with all the included items. For example: inv# pieces linedesc amount 11 500 nuts...