Recent content by Jord

Hi, I got it to work. Glad you reminded me to post what I did. Im not sure if this was the most efficient way, but it works. :D Private Sub Command257_Click() Dim dbsMyMap As DAO.Database Dim rstPositions As DAO.Recordset Dim qdf As QueryDef Dim prm As Parameter Dim strURLBeg As String Dim...

Hi, I'm new to crystal reports so please bear with me. I have a new report with a Cross-Tab table showing data and percentage of the total all correctly. I also have a chart from the Cross-Tab which should display the percentages, the chart seems to display correctly but the data labels and...

Ok I have changed the code a little and it works if I change the ("Top10 Closest") to ("Customers") which is a table rather than a Query. Any ideas? Private Sub Command257_Click() Dim dbsMyMap As DAO.Database Dim rstPositions As DAO.Recordset Dim strURLBeg As String Dim strURLEnd As String...

I'm not sure if this helps but could you use =Rank then lookup against the rank to give you the customers in order?

Hi, I'm pretty new to Access & vba so thanks in advance. I have written the following code but get Run-time error '3061': Too few parameters. Expected 1. Private Sub Command257_Click() Dim dbsMyMap As DAO.Database Dim rstPositions As DAO.Recordset Dim strURLBeg As String Dim strURLEnd As...

Anyone got another way around what I want to do if this is a dead end?

Mark Can you be of any help? :confused:

Any thoughts would be appreciated.

Hi Mark, I basically want to create a file like the map.txt (should be.htm but i had to change to enable upload to the site) The code.txt file has some code I was working on (without much succsess). I have now added the "CUSTLAT" & "CUSTLONG" to the query so the dlookup's dont need to be...

Right, I have added the lat, long bits into the sql query now. So I have a query which will give the name, lat, long etc but I need to be able to concatenate those results into a url to send to the ActiveX webbrowser. Thanks in advance

Help, anyone?

Thanks alot for your help so far. I needed all the results to show in the form so what i did was add a continuous form as a sub form, bound to the query as you had suggested. I now need the query results to form a url for use in the browser window in the main form. I have had a look all over...

I'm not on that pc at the moment but i have a browser window within the form which i guess would prevent that? Basically the browser shows some points on Google maps, which is the reason i need to be able to reference the names.

So i know how to bind the form to the query but how can i put the results into text box's or something with a name so i can reference it within some vba that runs from the form? The only solution I knew was Dlookup hence me wanting the table to use to lookup from. *EDIT: I have bound the query...

Can I have a text box showing the results of the query using this method?