Search results

Im not sure I know what you mean...

So just for kicks I removed the parameter input from the query and tried and everything works fine. Am I attempting the impossible by generating a report based on a query that requires the user to enter a parameter and trying to count the unique values?

I tried most of the variants for bracket and quotes as I was not sure either. =DCount("[VisionProNo]","qryDeliveryReport") #error

I just double checked. I do have the spelling correct.

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

ugh, i cant believe i forgot to turn reference microsoft xml Thanks!

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=" &...

You mean like a search box? or lookups?

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

I dont think I found what I was looking for from that video. He didnt use any combo boxes.

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

this was spot on, thank you.

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

Much appreciated, apologize for the wrong section. I'll take a look and see if this does the trick!

Thanks for the speedy reply. They could search an inv.# and it would bring back all line items for said invoice. Ending data would be more like this: search inv. 11 result inv# pieces linedesc amount 11 500 nuts $20 11...

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